Setting up your company file > Enter account opening balances
Account opening balances are the balances of your accounts as of the first day of your conversion month.
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 software or paper-based records.
The balances you enter depend on whether your conversion month is also the first month of your fiscal year. If your conversion month:
is the first month of your fiscal year, enter the opening balances of your asset, liability, and equity accounts only. The opening balances of your income, cost of sales, and expense accounts should be zero.
is not the first month of your fiscal year (for example, if your fiscal year starts in January but your conversion month is July), enter the opening balances of all your accounts.
You can enter either of 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 of the day prior to your conversion date. For example, if your conversion date is 1 January 2013, this is the bank account balance as of 31 December 2012.
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 of 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 of 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 not present as of your conversion date (that is, they had not appeared on a bank statement). The cashbook balance would be calculated as shown below:
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.
Don’t, for example, enter your liability account balances as negative numbers. Enter negative amounts only if accounts truly have negative balances. As a rule, these will be asset accounts that record accumulated depreciation.
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. The amount will be assigned to a special equity account called Historical Balancing.
4

Click to show more information

Top of page