How do I capture opening balances Print E-mail

The first point to recognise is that opening balances do not necessarily need to be captured before you start doing your accounts. Opening balances can be captured at any time, even way in arrears. Since EconoAccounting works on dates, you can easily add in opening balances at your convenience.

The first step to capturing opening balances is to get them from your accountant!
Use the following example.

Balance Sheet as at 1 Mar 2004
Assets -
- Fixtures and fittings R2000
- Bank account account R9000
- Debtors R12000
- -
Total Assets R23000
- -
Liabilities -
- Long term loan R5000
- Creditors R7000
- Retained income R11000
- -
Total Liabilities R23000



Steps in setting up opening balances.
1) Create an account in Chart of Accounts called "Suspense account - Opening balances" - make it an expense. Do note that this account should always be zero, as all credits must always equal all debits. Make sure you have accounts created in the Chart of Accounts for each of the other balance sheet accounts.
2) Choose Cashbook, Bank Account and add in a new transaction - the opening balance. NB - Remember to put in the correct date - i.e. 1 Mar 2004. Allocate it to the correct account.
3) Choose Journals, Edit Journals. Choose "Suspense account - Opening balances".
4) Add a new transaction. Choose the right date - 1 Mar 2004, and capture the amount. The amount must be captured as a NEGATIVE number, i.e. -2000 as it is an Asset. Allocate this to the correct account - in this case Fixtures and Fittings
5) Don't worry about the bank account - that has already been captured. Capture the next transaction ie. -12000 and allocate to Debtors.
6) The Liabilities are then captured. Capture them as a POSITIVE number, ie. 5000 and allocate it to the correct account. 5000 is allocated to Long term loans, 7000 to Creditors and 11000 to Retained Income.

It is done! Check by choosing Reports, Financial statements, and the right dates ie. 1 Mar 2004 to 1 Mar 2004.
The balance sheet should be perfect. If you have made an error, choose Journals Edit Journals, the account "Suspense account - Opening balances" and fix any errors.

Notes:
In this example we have captured debtors as a global figure. Ideally debtors should be captured for each individual customer. This is easily repaired as follows:
Make sure you have individual balances for debtors that exactly adds up to the final debtors figure.
Let us assume that in our example the R12000 is made up of 2 debtors, customer A owes R5000 and B owes R7000. Make sure that both customers have been created.
In Journals, Edit journal, choose "Suspense account - Opening balances" and find the one transacton that refers to Debtors. The current allocation is R12000 to Debtors.
Change the allocation amount to R5000, and choose Customer A as the "supplier/contact" and SAVE. The system will automatically make a second transacton for R7000. Allocate that to DEBTORS and Customer B.

 
Next >


Newsletter

Stay in Touch

Our regular newsletters keep readers up-to-date with hints, tips and product news. Just enter your details to register