How to fix bank reconciliation issues

Use this article to fix the Bank Reconciliation when it's out of balance

Missing transactions

1. Check that you entered the correct Statement Date.

Search for the transaction

1. Go to Activity in the bank account.
2. Enter a From and To date that covers the transaction date.
3. Select Search.
4. Check the Reconciled column if the transaction appears.

Correct the transaction

1. Change the transaction date if Sage Accounting shows the transaction under an incorrect date.
2. Select Save.
3. Check the activity in your other bank accounts.
4. Delete and re-enter the transaction if you entered it against the wrong account.
5. Enter all transactions up to the statement end date before reconciling the bank account.

The difference isn’t zero

1. Check the Statement End Balance.
2. Enter the correct amount if the balance doesn’t match your bank statement.
3. Select Apply.
4. Confirm that the difference shows zero.

Check reconciled transactions

1. Confirm that you reconciled the correct transactions.
2. Clear the Reconciled checkbox if you reconciled a transaction in error.
3. Check the values of your reconciled transactions.
4. Clear the Reconciled checkbox if a transaction has the wrong value.

Correct transaction values

1. Select Save for Later.
2. Return to the account Activity.
3. Select the transaction and correct the value.

Correct the opening balance

1. Select Settings if this is your first reconciliation.
2. Select Opening Balances.
3. Select Bank.
4. Select the correct bank account.
5. Update the debit or credit field if the opening balance is incorrect.
6. Select Save.
7. Return to the Reconciliation.
8. Confirm that the difference shows zero.