Enter account opening balances
Table of Contents
Account opening balances are the balances of your accounts as of the first day of your conversion month.
NOTE : Do you need to complete this task?
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.
Opening bank account balances
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 January 1, 2025, this is the bank account balance as of December 31, 2024.
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 (in transit) and $1000 worth of payments (uncashed checks) 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 follows:
To enter opening balances
- Go to the Setup menu, choose Balances and then Account Opening Balances. The Account Opening Balances window appears.
- Enter the balances in the Opening Balance column.
NOTE : Enter opening balances as positive numbers
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.
- 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. - Click OK.
Opening balances are meant to define the balances as of your conversion month/year that will 'tie into' your customer, vendor and job opening balances. Customer and Vendor balances can be entered as a summary entry or as individual amounts for each open transaction. If your conversion month is January 2025, you can still enter open invoices or bills, even if those transaction are from a prior fiscal year. You can NOT, however, enter sales and purchases not tied to your opening balances before the start of the conversion month and year.