Error 'Final balances do not reconcile!'
I am seeing the error "Final balances do not reconcile!" when trying to record a reconciliation, even though the Reconciliation Progress is showing that the Account reconciles.
The error message: 'Final balances do not reconcile!' will appear after clicking on the Record button, if the opening balances for that bank have been modified, even though the bank appears to be reconciled.
Step 2. Pick Either:
Click on the drop down arrow to select the bank you were trying to reconcile from the drop-down menu, OR
Click on a reconciliation and then click on the View Details button.
Step 3. Deleting Reconciliation
Click on the Reconcile toolbar option
Select the correct bank
Make a note of the list of Payments and Receipts remaining unreconciled in the list
Make a note of the Reconciled Balance, this should be highlighted yellow
Click on the down arrow and select the current financial year
Click on Setup > Opening Balances > Bank Accounts menu options
Make sure the Opening Bank Statement Balances in current year is the same as the previous financial years Reconciled Balance. Opening Bank Statement Balance should match your physical bank statement - if it is incorrect, you can retype it
Make sure that the - Outstanding payments and + Outstanding receipts listed are the same as those listed as still unreconciled in the previous financial year
Step 4. Record all the reconciliations again
Note: If you wish to remove outstanding payments and receipts - these need to be reversed out using the same account code used in the original transaction.