Troubleshooting Bank Reconciliation
Often, transaction dates differ from posting dates, which means the bank reconciliation report doesn't match the balance sheet.
The Bank Account Reconciliation Mismatch Report highlights common reasons why the bank balance (on the balance sheet) doesn't match the calculated book balance (in bank reconciliation).
This report lists:
- Transactions that display in bank reconciliation but not on the balance sheet.
- Transactions that display on the balance sheet but not in bank reconciliation.
- Transactions where the balance sheet's amount doesn't match the bank reconciliation's amount. For example, a check that debits a checking account or deposit that credits a checking account. Transactions using checking accounts for one bank but different bank accounts.
To access this report, when reconciling transactions, click Balance Sheet Mismatch Report.