Setting up your company file > Enter account opening balances
If you were in business prior to your conversion month, most of your accounts probably already have balances. If you want to produce financial reports that included these balances (such as a balance sheet), or you want to track the balance of accounts with a cumulative balance (such as your bank account), you need to enter these balances.
You can find your account opening balances on a trial balance report, a balance sheet or a profit & loss report prepared for the period immediately prior to your conversion date. You can ask your accountant to prepare these reports.
You may also be able to find your account opening balances using your previous accounting software or paper-based records.
The balances you enter depend on whether your conversion month is also the first month of your financial year. If your conversion month:
is the first month of your financial year, enter the opening balances of your asset, liability and capital accounts only. The opening balances of your income, cost of sales and expense accounts should be zero.
is not the first month of your financial year (for example, if your financial year starts in July but your conversion month is September), enter the opening balances of all your accounts.
You can enter the following amounts as the opening balance of a bank account:
the bank account balance that appears on your balance sheet or trial balance reports as at the day prior to your conversion date. For example, if your conversion date is 1 January 2012, this is the bank account balance as at 31 December 2011.
These reports can be provided by your accountant, or, if you were previously using another accounting software, printed using that software.
the cashbook balance of the account as at the end of the day prior to your conversion date. You can calculate your cashbook balance by taking into account the transactions not yet cleared by your bank as at the conversion date and the balance that appears on your bank statement at that date.
For example, assume that £500 worth of deposits and £1000 worth of payments were unpresented as at your conversion date (that is, they had not appeared on a bank statement). The cashbook balance would be calculated as shown below:
£21,000.00
£20,500.00
To enter opening balances
1
Go to the Setup menu, choose Balances and then Account Opening Balances. The Account Opening Balances window appears.
2
Enter the balances in the Opening Balance column.
3
Check that the amount in the Amount left to be allocated field at the bottom of the window shows £0.00.
If this field displays an amount other than £0.00, check your opening balances again because they are either incomplete or incorrect. However, you can continue the setup process if there is an amount in the Amount left to be allocated field. This amount will be assigned to a special capital account called Historical Balancing.
4

Click to show more information

Top of page