Transaction page · Cash and bank management

Bank reconciliation

A list page where you create a bank reconciliation for an imported bank statement and open its reconciliation worksheet.

Used by: Accounts payable manager, Auditor, Chief executive officer and 7 more roles
Business process: —
Menu item: BankReconciliationHeader
Main table: BankReconciliationHeader
Data entity: —
Setup steps: —

Show what matters for

Everyone

1What it is and why

What it is	A list page where you create a bank reconciliation for an imported bank statement and open its reconciliation worksheet.
What you do here	Used to match bank statement lines with the bank transactions in Finance and then mark the statement as reconciled.
Example	For example, bank fees or interest that aren't in Finance yet can be marked as New on the worksheet and posted afterwards from the bank statement.

Functional consultant · Solution architect

Business process	—
Menu path	Cash and bank management › Bank statement reconciliation › Bank reconciliation
Set up first	Bank statements Microsoft Learn ↗Reconciliation matching rules Microsoft Learn ↗Transaction code mapping Microsoft Learn ↗Cash and bank management parameters Microsoft Learn ↗
Used next by	Bank statements Microsoft Learn ↗Clear bridged transactions Microsoft Learn ↗
Related pages	—

End user · Functional consultant

Go to Cash and bank management > Bank statement reconciliation > Bank reconciliation.
Select New and select the bank account of the imported statement.
Check the cut-off date, which is the current date unless you change it.
Select Worksheet to open the Bank reconciliation worksheet page.
Select Run matching rules and pick the matching rule sets or rules to run.
To match by hand, select the bank statement transactions and the matching bank transactions, and then select Match.
Select Mark as new for bank-initiated items such as fees or interest.
Select Unmatch to undo a wrong match.
When you're done, mark the worksheet as reconciled.

Field	What it means	Worked example	Table column
Cut-off date	Decides which statement lines and bank transactions are included on the worksheet.Microsoft Learn ↗	—	`CutOffDate`
Correction amount	Shows a small penny difference, within the allowed tolerance, on a matched bank transaction.Microsoft Learn ↗	—	—

Functional consultant

Setup step	Recommended value and why	Decision · common mistake · test
— No setup is made on this page.

Solution architect

Shared or per company	Per company: each legal entity has its own records. Microsoft data model ↗
Can it be undone	—
Feature or country	—
If you change it later	Once a reconciliation is marked as reconciled it can't be undone or edited; unmatched statement lines move to the next reconciliation. Microsoft Learn ↗

Technical architect

Menu item	`BankReconciliationHeader` Checked in Dynamics 365
Form	`BankReconciliationHeader` Checked in Dynamics 365
Table	`BankReconciliationHeader`Shown as “Bank reconciliation journal” in Record infoChecked in Dynamics 365
Data entities	—
Who can open it	PrivilegesMaintain bank reconciliation `BankReconciliationMaintain`View bank reconciliation `BankReconciliationView`DutiesInquire into bank account reconciliation status `BankBankAcctReconStatusInquire`Enable bank management process `BankBankManagementProcessEnable`Review bank management process performance `BankBankManagementProcessPerfReview`Inquire into bank management reference data `BankBankMgmtReferenceDataInquire` 10 security roles Auditor `AuditPolicyManager`Chief executive officer `CompanyChiefExecutiveOfficer`Chief financial officer `CompanyChiefFinancialOfficer`Accounts receivable manager `CustInvoiceAccountsReceivableManager`Accountant `LedgerAccountant`Accounting manager `LedgerAccountingManager`Accounting supervisor `LedgerAccountingSupervisor`Financial controller `LedgerFinancialController`Treasurer `PaymTreasurer`Accounts payable manager `VendInvoiceAccountsPayableManager` Checked in Dynamics 365
Actions on the page	Options: Personalize, Page options, ShareChecked in Dynamics 365

Developer

Open it directly	`https://<your-environment>/?mi=BankReconciliationHeader`
Integrate with	—
Table definition	`BankReconciliationHeader` columns and relations Microsoft data model ↗

Everyone