Ledger 2011

Financial Transaction Software

At Maia Company, we tired of complex, expensive financial software, so one of our engineers, using Microsoft® Access®, wrote a simple and highly functional financial transaction ledger for us. This simple to understand and use software, shown below, supports multiple accounts and loans, transfers between accounts, recurring transactions, and weekly, biweekly, semimonthly, monthly budgets, and more.

Screen shot of Ledger 2011

Give it a try and e-mail us your feedback.

Installing Ledger 2011

Already have Microsoft Access installed

  1. If you have Microsoft® Access® 2010 installed on your computer, download ledgerAccess.msi and save it to your hard drive.
  2. After saving ledgerAccess.msi to your hard drive, double click on it to install Ledger 2011.

Don’t have Microsoft Access installed

  1. If you do not have Microsoft® Access® installed on your computer, you must downloand and install the Microsoft Access Runtime.
  2. Download ledgerRuntime.msi and save it to your hard drive.
  3. After saving ledgerRuntime.msi to your hard drive, double click on it to install Ledger 2011.

Eliminating the Annoying Security Warning

Each time you start Ledger you may see a security warning generated by Microsoft Access. You can eliminate this warning by causing Access to trust the Ledger database. We apologize that the steps to eliminate the warning are such a hassle.

  1. Start Ledger.
  2. Click "File" on the ribbon.
  3. Near the bottom of the window, click the "Options" link.
  4. Click the "Trust Center" link.
  5. Click the "Trust Center Settings..." button.
  6. Click the "Trusted Locations" link.
  7. Click the "Add new location..." button.
  8. Use the "Browse..." button to find your Documents folder on the computer’s hard drive.
  9. Click "Ok"
  10. Click "Ok" again
  11. Click "Ok" once more

Entering Financial Transactions

  1. Start Ledger.
  2. Click the "Accounts" tab and create an account.
  3. Click the "Transactions" tab. Enter your financial transactions.
  4. Click the "Main" tab and then the "Budget" button. Choose the budget period, starting date, accounts, and categories you wish to track in your budget. Click the "Budget Report" button.

Database Design

Here is the design of Ledger shown as an entity relationship diagram (ERD).

Entity relationship diagram of the Ledger database design

Here is the design of Ledger shown as a Unified Modeling Language (UML) class diagram.

UML class diagram of the Ledger database design
Copyright © 2011, Maia L.L.C.  All rights reserved.

Maia L.L.C. and its employees have used their best efforts in preparing this article.  These efforts include the development, research, and testing of the theories and computer programs in this article to determine their correctness.  Maia L.L.C. makes no warranty of any kind, expressed or implied, with regard to these programs or the documentation contained in this article.  Maia L.L.C. shall not be liable in any event for incidental or consequential damages in connection with, or arising out of, the furnishing, performance, or use of these programs.