The beginning balance, the account’s total at the start of the period you’re reviewing, should be treated like a checkpoint. This is the amount that let’s you know that you’re starting with accurate information.
This page will take you through how to fix issues with your beginning balance when reconciling an account for the second or more time.
Before you start
Consider if you've reconciled this account before.
- If not, here's how to fix issues the first time you reconcile an account.
- If you're entirely new to the process, you might want to start with our reconciliation guide.
- If you have, you’re in the right place and you can continue with the steps below.
Step 2: Check your bank statement
Make sure you're reconciling the correct account for the correct month:
- Go to Transactions and select Reconcile (Take me there).
- Select the account that you want to reconcile from the Account ▼ dropdown.
If you have multiple accounts at the same bank, or more than one account of the same type, make sure you're reconciling the right one.
Step 4: Review any discrepancy reports
If anyone has made a change that affects your beginning balance, you'll get a message before you start reconciling.
- Select the We can help you fix it link to open your discrepancy report.
- Review the Change Type in the discrepancy report. Use it to decide if and how to make changes.
- Before editing anything, talk with the user who made the changes - they may have had a good reason to do so.
Once you know you need to make corrections, review each transaction in the report one at a time:
- Review the Change Type column. This tells you what changed.
- Select View if you want to see the historical changes made to the transaction.
Please refer the scenarios below to assess edits based on the Change Type column:
Amount changed
This means someone edited a reconciled transaction or moved it to another account. To fix it:
- Select the transaction to expand the view.
- Select Edit to open the form.
- Adjust the total or change the account as needed.
- Select Save and close.
Unreconciled in register
This means someone unreconciled the transaction. To reconcile it again:
- Go to Transactions, then select Bank transactions (Take me there).
- Select the account you want to reconcile again, then select Go to bank register.
- Select Reconcile.
- Verify the Account you've selected and change it, if required.
- Enter the info from your statement in the Ending balance field and Ending date field. Then, select Start reconciling.
- Review the transactions and select those that match the transactions in your bank statement.
- Once the Difference is A$0.00, select Finish now, then select Done.
Alternatively, to reconcile a transaction manually,
- Go to Transactions and select Chart of accounts (Take me there).
- Select Account history in the Action column of your bank account.
- Select the transaction that has been manually unreconciled.
- Select the box in the tick column until you see an R. This reconciles the transaction manually.
- Select Save.
Reconciled in error
This means someone has already reconciled the transaction by accident. To remove it and add it to your next reconciliation:
- Select the transaction to expand the view.
- Select the box in the tick column until it's blank or you see a C. This removes the transaction from the reconciliation.
- Select Save.
Deleted
This means someone deleted the transaction. If this was an accident, recreate the transaction exactly as it appears on your discrepancy report:
- Select + New.
- Select the correct form (invoice, sales receipt, expense, etc).
- Fill out the form and select Save and close.
- Go to Transactions and select Chart of accounts (Take me there).
- Find the bank or credit card account that you put the transaction into and select Account history.
- Find the recreated transaction and select it to expand the view.
- Select the box in the tick column until you see an R. This manually reconciles the transaction.
- Select Save. The deleted transaction may still be on the list, but the discrepancy difference should change and it won't affect your reconciliation.
After you review everything on the discrepancy report, the Total Discrepancy Difference on the report should be A$0.00. Check the beginning balance again in QuickBooks. It should match the beginning balance on your bank statement. Select Resume reconciling to continue reconciling.
Next steps
Once you know your beginning balance is correct, you can start reconciling your account.
If you’ve still got questions, your accountant will be able to steer you in the right direction. We can also help you find a ProAdvisor if you don't have one.