Summary
Description
An opening balance is the balance in your bank account on the day you start using Accounting.
It can also be the balance of a new bank account you have just opened.
Opening balances can be entered at the same time as creating a bank account or added later from the Settings.
Before you start
- Check your Accounts Start Date is correct by going to More, Business Settings, Accounting dates and VAT.
- Create your bank accounts, including any loan and credit card accounts. See how to add or edit a bank account here.
- Gather your bank statements and a list of any bank transactions that do not yet appear on your bank statement. This could be uncleared cheques or recent payments or receipts.
What you need to know
The purpose of the opening balance is to make sure the bank balance shown in Accounting matches the balance in your actual bank account before you start adding more transactions.
Getting your opening balance correct will help to make sure that you can reconcile your bank account successfully from now on.
- Use the amount from your bank statement on the day before you started using Accounting
- The date you use for your opening balance must be before the date set as your Accounts Start date, usually the day before
- Don't use the amount from your trial balance as this may include transactions not yet reflected on your bank statement
- Enter a positive bank balance as a Receipt (Debit)
Enter a negative bank balance for overdrafts, loans and credit cards as a Payment (Credit)
Resolution
Enter the opening balance
- Go to More, then Business Settings.
- In the Opening Balances section, select Bank.
- Check the Accounts Start Date is correct.
- If it isn’t correct, click the date. Then change it as required and click Save.
- Enter the details of the opening balance.
- Date - the date must be before your Accounts Start Date. Ideally the day before.
- Type - choose whether your balance is a Debit (positive amount) or a Credit (negative or overdrawn amount)
- Click Save.
An opening balance transaction shows on your bank activity, ready to be reconciled.
Adjust the opening balance
If you've made a mistake and entered the opening balance incorrectly, you can adjust it.
If you haven't reconciled your opening balance, simply go to the Settings and change the amount or use the bin icon to delete it.
If you have reconciled the opening balance, you can't amend it. Delete the opening balance instead and re-enter it.
Delete a reconciled opening balance
- From Banking, select the relevant bank account.
- From the Activity tab, select the tick box to the left the transactions you want to delete.
- A toolbar now appears above the list.
- From the toolbar, select the Delete icon.
Reconcile an opening balance
We recommend that you reconcile your opening balance straight away. This makes sure that your bank balance is correct and matches the opening balance from your bank statement when you do your first reconciliation.
- From Banking, open the relevant bank account.
- Select Reconcile.
- Enter the following information:
- Statement Date: Change this to the date of your opening balance. This is usually your Accounting Start Date. This will filter out any subsequent transactions and make it easier to find your opening balance transactions.
- Statement End Balance: Enter the total amount of your opening balance.
- Reference: This is just label for the reconciliation. If you use Opening Balance this will distinguish it from other reconciliations.
- Choose Apply.
- You will then see your opening balance. Select Reconcile next to the transaction.
- To complete the reconciliation, select Finish.
- To print details of the reconciliation, click Print.