Setup page · Cash and bank management

Reconciliation matching rules

A setup page where you define the criteria that match bank statement lines with bank transactions during reconciliation.

Used by: Chief financial officer, Accountant, Accounting manager and 3 more roles
Business process: Establish matching rules for bank reconciliation in Dynamics 365 Finance
Menu item: BankReconciliationMatchRule
Main table: BankReconciliationMatchRule
Data entity: BankReconciliationMatchingRuleEntity
Setup steps: 1 on this page

Show what matters for

Everyone

1What it is and why

What it is	A setup page where you define the criteria that match bank statement lines with bank transactions during reconciliation.
What you do here	Used to automate reconciliation between Finance bank transactions and bank statement transactions.
Example	For example, a Generate voucher rule posts bank interest and fee lines from the statement straight to the general ledger.

Reconciliation matching rules page in Dynamics 365 — The page in a working Dynamics 365 system. page title tab to open what to set or check

Functional consultant · Solution architect

2Where it fits

Business process	Define accounting policies › Define banking policies › Establish matching rules for bank reconciliation in Dynamics 365 Finance
Menu path	Cash and bank management › Setup › Advanced bank reconciliation setup › Reconciliation matching rules
Set up first	—
Used next by	Reconciliation matching rule sets Microsoft Learn ↗
Related pages	Cash and bank management parameters Microsoft Learn ↗

End user · Functional consultant

3How to do it

Step by step, with screenshots

Set up Reconciliation matching rules1 screen

Used to automate reconciliation between Finance bank transactions and bank statement transactions.

Screen 1
Create the matching rule
Go to Cash and bank management > Setup > Advanced bank reconciliation setup > Reconciliation matching rules
1. Select New, and enter the Matching rule and Name
2. Choose the Action
3. In Step 1, select the basic criteria such as Match amount and Match date
4. Save the rule, then select Activate
1Matching rule BEAT-MATCH
2Name Atlas demo amount and date
3Action Match with bank document
4Match amount Selected
5Match date Selected
6Active Yes
Show the full screen
page title tab to open what to set or check

1Matching rule	BEAT-MATCH
2Name	Atlas demo amount and date
3Action	Match with bank document
4Match amount	Selected
5Match date	Selected
6Active	Yes

Microsoft's steps

Go to Cash and bank management > Setup > Advanced bank reconciliation setup > Reconciliation matching rules.
Select New, and enter a name and description.
In the Actions field group, choose the action the rule performs.
In the Matching type field, choose how records are matched.
Define the selection criteria on the step FastTabs for the action.
Select Save.
Select Activate.

Source: Microsoft Learn ↗

Field guide

Field	What it means	Worked example	Table column
Actions	What the rule does, such as matching with a bank document or generating a voucher.Microsoft Learn ↗	—	—
Matching type	How records are matched.Microsoft Learn ↗	—	—
Matching rule	—	BEAT-MATCH	—
Name	—	Atlas demo amount and date	`Name`
Action	—	Match with bank document	—
Match amount	—	Selected	—
Match date	—	Selected	—
Active	—	Yes	—

Functional consultant

4Setup decisions

Setup step	Recommended value and why	Decision · common mistake · test
Set up Reconciliation matching rules	—	—

Solution architect

5Design impact

Shared or per company	Shared: the same records are used by every legal entity. Microsoft data model ↗
Can it be undone	—
Feature or country	—
If you change it later	Validation settings in Cash and bank management parameters override the settings on matching rules. Microsoft Learn ↗

Technical architect

6Technical

Menu item	`BankReconciliationMatchRule` Checked in Dynamics 365
Form	`BankReconciliationMatchRule` Checked in Dynamics 365
Table	`BankReconciliationMatchRule`Shown as “Reconciliation matching rules” in Record infoKey field: RuleIdChecked in Dynamics 365
Data entities	`BankReconciliationMatchingRuleEntity`Reconciliation matching rules Microsoft data model ↗
Who can open it	PrivilegesMaintain bank reconciliation matching rule `BankReconciliationMatchRuleMaintain`View bank reconciliation matching rule `BankReconciliationMatchRuleView`DutiesInquire into bank account reconciliation status `BankBankAcctReconStatusInquire`Enable bank management process `BankBankManagementProcessEnable` 6 security roles Chief financial officer `CompanyChiefFinancialOfficer`Accountant `LedgerAccountant`Accounting manager `LedgerAccountingManager`Accounting supervisor `LedgerAccountingSupervisor`Financial controller `LedgerFinancialController`Treasurer `PaymTreasurer` Checked in Dynamics 365
Actions on the page	Options: Personalize, Page options, ShareChecked in Dynamics 365

Developer

7Developer

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