After you post a bank reconciliation, you can review the completed reconciliation to verify balances and investigate matched transactions. Use posted bank statements in Business Central to support period-end reviews, compare reconciliation history, and provide evidence for an audit.
Choose the page or report that fits your task.
| Task | Page or report |
|---|---|
| Find completed reconciliations for a bank account or period. | Bank Account Statement List |
| Review the balances, statement lines, and applied entries for one reconciliation. | Bank Account Statement |
| Filter, group, and compare posted statement information. | Analysis mode on Bank Account Statement List |
| Print or save a detailed record of a completed reconciliation. | Bank Account Statement report (1407) |
Note
This article describes statements posted from the Bank Acc. Reconciliation page. If you use the Bank Rec. Worksheet page in a North American version, follow the guidance in View the posted bank account reconciliations.
Review a completed reconciliation
Use the Bank Account Statement List page to find posted reconciliations and open their details.
- Select Search (Alt+Q) in the upper-right corner, enter Bank Account Statement List, and then select the related link.
- Filter Bank Account No. and Statement Date to find the account and period that you want to review.
- Open the statement that you want to review.
- Compare Balance Last Statement, Statement Ending Balance, and Statement Date with the statement from your bank.
- Review the statement lines, including Transaction Date, Description, Statement Amount, Applied Amount, and Difference.
- Select an Applied Amount value to review the bank account or check ledger entries matched to that line.
The Total Balance field combines the balance from the last statement with the statement line amounts. The Total Difference field shows the sum of the differences between statement amounts and applied amounts.
Analyze posted statement history
Use analysis mode on the Bank Account Statement List page to compare the available statement information without changing the posted data. For example, you can review ending balances over time for one bank account or group statements by bank account for a period-end review.
To use analysis mode, you need the DATA ANALYSIS - EXEC permission set or equivalent permissions. Learn more about access and analysis features in Analyze list page and query data using the data analysis feature.
- Open the Bank Account Statement List page.
- Filter the list to the bank account and statement date range that you want to analyze.
- Select Enter analysis mode [Screenshot of the Analysis Mode icon.].
- In the Columns pane, include Bank Account No., Bank Account Name, Statement No., Statement Date, Balance Last Statement, and Statement Ending Balance.
- Drag the Bank Account No. column heading to the Row Groups part, and sort Statement Date to review statements in date order.
- Compare the individual statement balances to identify changes that you want to investigate.
- Select Leave analysis mode, and open a statement to review its lines and applied entries.
Compare ending balances as individual statement values, not as a sum across periods. An ending balance isn't the amount of activity in a period. Keep bank accounts separate, especially when they use different currencies.
The list contains statement-level information. To investigate individual transactions or outstanding entries, open the statement or run the report.
Print or save a completed reconciliation
Use the Bank Account Statement report to document a completed reconciliation. The standard report includes statement balances, general ledger balance information, and statement lines. You can also include details of outstanding bank transactions and checks.
- On the Bank Account Statement List page, select the statement that you want to document.
- Select Print.
- Check the Bank Account No. and Statement No. filters on the report request page.
- Turn on Print Outstanding Transactions if you want to include details of outstanding transactions and checks.
- Select Preview to review the report.
- Select Print to print the report, or select Send to to save it as a PDF file.
Your organization can configure a different report for the Print action, so the available options can differ.
Outstanding transactions can help explain the difference between the bank statement balance and the bank account balance. For example, a payment might be recorded in Business Central before it appears on the statement from your bank. A statement can be reconciled even though some bank account ledger entries remain outstanding.
For historical reviews, consider how later reconciliations and backdated entries affect outstanding-entry details. Learn more about report behavior and limitations in Find outstanding transactions in previous periods.
Learn more about saving report output in Run and print reports.
Correct an error in a posted reconciliation
If your review identifies an error, you can undo the posted reconciliation and correct it before posting again. The Undo action deletes the posted statement and creates a new bank reconciliation. Learn more about the process and its limitations in Undo a bank account reconciliation.
Related information
Reconcile bank accounts
Manage and reconcile your bank accounts
Ad-hoc analysis of finance data