Bank Reconciliation Out of Balance
Table of Contents
Troubleshooting Out Of Balance Bank Reconciliation
The First step is to find out if it is a previous reconciliation or the current reconciliation that is Out of Balance
- Enter the last successfully reconciled balance (from the PREVIOUS BANK STATEMENT'S ending balance)
- Enter the last successful reconciliation date
- Do not mark any transaction as cleared
- Are you out of balance?
Previous Reconciliation is Out of Balance
Did you change the opening balance of the bank account? Go to the Setup > Opening Balances screen and check that the opening balance for the relevant bank account agrees with the Cash Book balance as of the Conversion Date
Have any previously reconciled transactions been changed or deleted? This would cause the transaction to become unreconciled. An edited transaction will reappear on your current reconciliation as unreconciled. Any deleted transaction will have to be re-entered.
Use the reconciliation report to determine what month the out of balance issue started to figure out what transaction was edited or deleted:
- Go to your top menu bar and select Reports > Index to Reports.
- Select the Banking tab at the top.
- Select the Reconciliation Report and click the Customize button.
- At the top of the Report Customization window set the Accounts field to the specific account you are reconciling.
- Set the Select by field to List of Recorded Statement Dates.
- Set the Statement Date field to a previous reconciliation.
- Display the report.
- Compare the Expected Balance on Statement to the balance that it should be according to your statement.
- Go back statement date by statement date to figure out which period the issue started.
This will help you to determine what transaction became unreconciled based on the date it started. If a transaction was deleted you will need to re-enter it. After it has been re-entered or after you identify the transaction that became unreconciled you can usually just do your next reconciliation as your normally would with the extra step of checking off the the transaction that previously became unreconciled
If you are still having trouble you can undo the bank reconciliations back to the last point that it did balance and then redo them.
Previous Reconciliation is NOT Out of Balance
If you are not out of balance for the previous reconciliation the problem is with the CURRENT reconciliation. Check for bank fees, direct debits, un-entered (forgotten) transactions, duplicate entries, or transactions that may have been incorrectly entered. You should also check for any errors on the bank statement.
- At the bottom of the reconcile window verify that your total Deposits and Withdrawals in AccountEdge match the total deposits and withdrawals on your bank statement.
-
Check for any future dated transactions
- Go to the Reconcile Accounts window
- Enter a future date
- Check to see if there are any incorrectly dated transactions
-
Look for missing Check IDs
- Run a Bank Register Report
- Customize the report just for withdrawals
- Sort the report by ID# in the filter
- Check for any missing check numbers
-
Look for missing Deposits
- Run a Bank Register Report
- Customize the report to display just deposits
- Sort the Report by ID# in the filter
- Check for any missing CR numbers
Tip: If the Out of Balance amount is divisible by 9, an amount has been transposed. (Example: $78.32 was entered as $87.32). This is the “Rule of 9”.