Report page · Cash and bank management
Bank to ledger reconciliation report
A report that shows differences between bank account balances and the balances of their main accounts.
- Used by
- —
- Business process
- —
- Menu item
output:BankLedgerReconciliation- Main table
- —
- Data entity
- —
- Setup steps
- —
Show what matters for
Everyone
1What it is and why
| What it is | A report that shows differences between bank account balances and the balances of their main accounts. |
|---|---|
| What you do here | Used to compare the sum of bank transactions with the general ledger transactions posted to the related bank summary accounts. |
| Example | For example, when a bank transaction was corrected during reconciliation, the report shows two lines: the original transaction and the correction. |
Functional consultant · Solution architect
2Where it fits
| Business process | — |
|---|---|
| Menu path | Cash and bank management › Periodic tasks › Bank to ledger reconciliation report |
| Set up first | — |
| Used next by | — |
| Related pages | — |
End user · Functional consultant
3How to do it
Microsoft's steps
—
Field guide
| Field | What it means | Worked example | Table column |
|---|---|---|---|
| Main account | The main account range; when left empty, only the summary accounts set on the bank accounts are shown.Microsoft Learn ↗ | — | — |
| Include details | Shows transaction lines with voucher, bank balance, ledger balance and difference.Microsoft Learn ↗ | — | — |
| Differences only | Shows only the lines that have reconciliation differences.Microsoft Learn ↗ | — | — |
Functional consultant
4Setup decisions
| Setup step | Recommended value and why | Decision · common mistake · test |
|---|---|---|
| — No setup is made on this page. | ||
Solution architect
5Design impact
| Shared or per company | — |
|---|---|
| Can it be undone | — |
| Feature or country | — |
| If you change it later | — |
Technical architect
6Technical
| Menu item | output:BankLedgerReconciliation Checked in Dynamics 365 |
|---|---|
| Form | SysOperationTemplateForm Checked in Dynamics 365 |
| Table | — |
| Data entities | — |
| Who can open it | — |
| Actions on the page | — |
Developer
7Developer
| Open it directly | https://<your-environment>/?mi=output:BankLedgerReconciliation |
|---|---|
| Integrate with | — |
| Table definition | — |
Everyone
8Sources and checks
- learn.microsoft.com/previous-versions/dynamicsax-2012/appuser-itpro/bank-report-bankledgerreconciliation
- Checked in a working Dynamics 365 system, version 10.0.49: the menu item, form, table and security, the page.