LedgerLite Quick Start


After downloading LedgerLite.exe double-click on the icon to start the program.



(NOTE: If nothing happens when you click the download link try the right mouse button and select Save link as from the pop-up menu. If you get a message saying it cannot be downloaded securely click on the down-arrow and select Keep or Keep Anyway. If you still have difficulty please see the LedgerLite FAQ page.)


The first time you run LedgerLite the database file LedgerLite.LLD gets created automatically in the same folder as you've located the program. This could be on your desktop if that's where you saved LedgerLite. If not it's probably in your download folder.



Contents


Enter Your Company Name

Maintain the Chart of Accounts

Post an Entry

View an Account

Create a Cashbook

Make an Entry in a Cashbook

Reconcile a Cashbook with a Bank Statement

View or Print a Balance Sheet

Change the Layout of the Balance Sheet

View or Print an Income Statement

Change the Layout of the Income Statement

View or Print a Graph





Enter Your Company Name


Go to the File menu and select Configure. Then click on the Global tab. Enter your company name in the Company Name field. (This is the name that will appear at the top of each printed report.) Then click on the OK button.






Maintain the Chart of Accounts


Go to the Maintain menu and select Accounts. You will notice that a rudimentary chart of accounts has already been created for you. To add a new account use the <Insert> key on your keyboard.


In the Type field enter A, L, P, I or E or double-click to select it from a list. This indicates which of the five basic account types this account belongs to.


In the Code field enter the abbreviation you wish to use to identify this account. This abbreviation is used to select the account from a drop-down list in other parts of the program and can be any alphabetic or numeric code (including the numeric codes that are often used to identify and classify accounts in many other accounting systems.)


Enter the full name of the account in the Name field. This is the name that is used to identify the account when it appears on the printed reports including the balance sheet and the income statement.


Optionally enter a description of the account in the Description field. This is to remind you of the purpose for the account.


To edit the details of an account click on the field you wish to edit and then click it a second time (as distinct from a double-click.)


To delete an account hold down the <Ctrl> key and press the <Delete> key.






Post an Entry


Click on Entries in the dark blue navigation area on the left. This will take you to the Entries screen.


To begin a new entry click on the New button at the bottom. The screen will switch to New Entry mode. This is displayed in the bottom left corner of the screen.


Enter the date for the entry in the Date field at the top. Then select the first account from the drop-down list labelled Account.


You will notice that a new line appears at the top of the grid. The grid is used for viewing only. All data must be entered using the fields at the top of the screen above the grid.


Next enter the details in the Description field, the amount in the Amount field and indicate if it is a Debit or Credit.


Press the <Enter> key to go to the next line (or click on the blank line at the bottom of the grid) and repeat the process. When you are finished click on the Save button to save the entry to the database. You will not be able to save an entry unless the total debits equal the total credits.


To edit an entry click on the Edit button to switch the screen to Edit Mode. Then click on the line in the grid that you wish to alter. When you are finished click on the Save button to save the changes to the database. Click Cancel to discard any changes. Click Delete to delete the entire entry from the database.






View an Account


Click on Accounts in the dark blue navigation area on the left. This will take you to the Accounts screen.


Select the account you wish to view from the drop-down list. The entries for the selected account appear in the grid.


To view the entire entry double-click on it in the grid. This will take you directly to the Entries screen and display the entire entry. You can then double-click on a line in the entry grid to get back to the Accounts screen and view the account for that line.






Create a Cashbook


Go to the Maintain menu and select Cashbooks. To add a new cashbook use the <Insert> key on your keyboard.


In the Account field enter the abbreviation of the account you wish to associate with this cashbook or double-click to select it from a list. (Note that any cashbook you create must be associated with a general ledger account for it to appear in the drop-down list on the Cashbooks screen.)


In the Abbrev field enter the abbreviation you wish to use to identify this cashbook. Often this will be the same as the abbreviation of the account with which the cashbook is associated but it can be different.


Enter the name of the cashbook in the Name field. Again this will likely be the same as the name of the associated account but this is not necessarily so.


Optionally enter a description of the cashbook in the Description field. This is to remind you of the purpose for the cashbook.


To edit the details of a cashbook click on the field you wish to edit and then click it a second time (as distinct from a double-click.)


To delete a cashbook hold down the <Ctrl> key and press the <Delete> key.






Make an Entry in a Cashbook


Click on Cashbooks in the dark blue navigation area on the left. This will take you to the Cashbooks screen.


Select the cashbook you wish to make an entry into from the drop-down list. The entries for the selected cashbook appear in the grid.


To begin a new entry click on the New button at the bottom. The screen will switch to New Entry mode.


Enter the date for the entry in the Date field at the bottom. Then enter the details in the Description field, the amount in the Amount field and indicate if it is a Deposit or Withdrawal. Select an account from the Ledger Account drop-down list only if you wish to automatically create a corresponding double-entry in the general ledger. Indicate if this entry has appeared on the bank statement by putting a tick in the check box next to On Statement. Finally save this entry to the database by clicking on the Save button or pressing the <Enter> key on your keyboard.


To edit an entry click on the Edit button to switch the screen to Edit Mode. When you are finished click on the Save button to save the changes to the database. Click Cancel to discard any changes. Click Delete to delete the entire entry from the database.


IMPORTANT NOTES


When you select an account from the Ledger Account drop-down list a corresponding double-entry is automatically posted to the ledger and linked to this entry in the cashbook. If you make any changes to this entry in the cashbook the double-entry in the ledger is automatically updated to reflect the changes. If you delete the entry from the cashbook the ledger double-entry is also deleted automatically.


Note that the converse does not apply. In other words if you edit or delete the double-entry in the ledger no changes are automatically made to the cashbook entry. This is important because it allows for flexibility in editing the general ledger without affecting the cashbook and its reconciliation to a bank statement.


Note also that it is not required to specify a Ledger Account when making a cashbook entry. In this case no ledger double-entry is posted. This is useful for example when setting up a new cashbook and you wish to enter the opening balance to match the balance shown on the bank statement.






Reconcile a Cashbook with a Bank Statement


Click on Cashbooks in the dark blue navigation area on the left. This will take you to the Cashbooks screen.


Select the cashbook you wish to reconcile with from the drop-down list. The entries for the selected cashbook appear in the grid.


For those entries in the cashbook which have matching transactions on the bank statement put a tick in the check box next to On Statement. (You can toggle this on and off for an entry by double-clicking on it in the grid.)


For those transactions on the bank statement which do not have a matching entry in the cashbook create a new entry in the cashbook and put a tick in the check box next to On Statement.


The amount next to Statement Balance at the top of the screen after the arrow (-->) is the closing statement balance. This should match the closing balance shown on the bank statement.


The amounts next to Cashbook Balance are the opening and closing balances of the cashbook including unreconciled entries (Entries which do not have a tick next to On Statement.) The amounts next to Account Balance are the opening and closing balances of the associated ledger account.





View or Print a Balance Sheet


Click on Balance in the dark blue navigation area on the left. This will take you to the Balance Sheet screen.


Enter the date of the balance sheet in the As At field at the bottom.


Click on the Print button to display a preview. To print click on the printer icon at the top.






Change the Layout of the Balance Sheet


Click on Balance in the dark blue navigation area on the left. This will take you to the Balance Sheet screen.


The balance sheet (A, L and P) accounts are shown in the tree view along with the other elements used on the balance sheet including headings, groups, subtotals, totals and a special Retained Earnings element. You can change the order of the elements by dragging and dropping them. To include an account or the Retained Earnings element in a group drag and drop it onto the group.


To create a new heading, group or subtotal click on the Heading, Group or Subtotal buttons to the right of the tree view. To rename an element click on the Edit button. To delete an element click on the Delete button.






View or Print an Income Statement


Click on Income in the dark blue navigation area on the left. This will take you to the Income Statement screen.


Enter the begin and end dates of the income statement in the Begin Period and End Period fields at the bottom. These can be turned on or off by putting or removing a tick in the check box above each field. If you do not specify a begin date then the income statement will include all entries in the ledger from the earliest entered date. If you do not specify an end date then all entries in the ledger up to the latest entered date will be included.


Click on the Print button to display a preview. To print it click on the printer icon at the top.






Change the Layout of the Income Statement


Click on Income in the dark blue navigation area on the left. This will take you to the Income Statement screen.


The income statement (I and E) accounts are shown in the tree view along with the other elements used on the income statement including headings, groups, subtotals, totals and a special Net Income element. You can change the order of the elements by dragging and dropping them. To include an account in a group drag and drop it onto the group. (The Net Income element cannot be moved from the last position. It must always remain at the bottom.)


To create a new heading, group or subtotal click on the Heading, Group or Subtotal buttons to the right of the tree view. To rename an element click on the Edit button. To delete an element click on the Delete button.






View or Print a Graph


Click on Graph in the dark blue navigation area on the left. This will take you to the Graph screen.


Enter the begin and end dates of the period to include in the graph in the Begin Period and End Period fields at the bottom. These can be turned on or off by putting or removing a tick in the check box above each field. If you do not specify a begin date then the graph will include all entries in the ledger from the earliest entered date. If you do not specify an end date then all entries in the ledger up to the latest entered date will be included.


Click on the Display button to display the graph. The graph will update dynamically as entries are posted to the ledger on either this or other workstations enabling you to see at a glance the key indicators of your business as they change in real time.


Click on the Print button to display a preview. To print it click on the printer icon at the top.