An When you're reconciling a bank account, an out of balance amount tells you that something isn't quite right. So you need to work out what's gone wrong. Start by checking whether it's with the current bank reconciliation.
Here's some things things to look out for.did you
The out of balance will be caused by a problem in your current reconciliation or a previous reconciliation.
|UI Text Box|
Get expert help resolving out of balance reconciliations - invite your bookkeeper or accountant into your online file so they can investigate the issue and fix it. See Invite a user to an online file.
|title||To check where the out of balance occurred|
Follow the steps below to determine if your out of balance is caused by your current reconciliation or a previous reconciliation.
- Enter the Bank Statement Date as the same date as your Last Reconciled Date.
- Enter your Closing Statement Balance as the Closing balance on your Last Reconciled Date. (You may need to check your previous bank statement)
- Deselect all transactions from the Mark Cleared Transactions section.
- If there is no Out of Balance, the problem is with your current reconciliation. If there is an Out of Balance you'll need to check your previous reconciliations as a previously reconciled transaction may have been changed or deleted.
did you record all bank charges and bank interest entries that appear on the bank statement? If not, you need to record them and select them for reconciliation
|title||Check current reconciliation|
Check your current reconciliation
Here are some things to look out for:
- did you set up a bank account and carry over an opening balance? If so, have you performed an initial bank reconciliation?
- did you type the correct figure in the Closing Statement Balance field? You need to type the closing balance from your bank statement, not the opening balance.
- did you enter the correct date (that of the closing balance from your bank statement) in the Bank Statement Date field? An incorrect date may prevent some transactions from appearing in the list.
- did you select all the transactions that appear on the bank statement? If not, some transactions might not have been accounted for in the reconciled balance.
did you select, by mistake, a transaction that didn’t appear on your bank statement? If yes, you need to deselect this transaction.
|title||Check previous reconciliations|
Check previous reconciliations
- Go to the Reports menu and click Index to Reports.
- From the Banking section click Reconciliation Report.
- Enter the date of your previously reconciled bank reconciliation.
- Work back until you find a month where the out of balance is zero ($0.00). This identifies that the suspect transaction(s) will have occurred in the following month.
- Identify which transaction(s) are causing the out of balance by comparing the Reconciliation Report with the corresponding bank statement.
- Correct the transaction(s) causing the out of balance.
- Re-reconcile the corrected transaction(s).
- Repeat with each subsequent reconciliation until no more out of balances are found.
If no reports balance it is possible you have changed your account opening balance. You might need to restore an early backup to check the account's original opening balance.
If you've checked the above and you're still out of balance, then the problem may be with a prior period that you've already reconciled.
If you've deleted or reversed a previously reconciled transaction, re-enter it and then select it in the Reconcile Accounts window when performing the reconciliation.
Alternatively you can undo a bank reconciliation. When you undo a reconciliation, all transactions for that period return to an unreconciled status.