BeyondERP.Subscribe

Setup page · Cash and bank management

Reconciliation matching rule sets

A setup page where you group reconciliation matching rules that run in sequence during bank 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
BankReconciliationMatchRuleSet
Main table
BankReconciliationMatchRuleSet
Data entity
BankReconciliationMatchRuleSetEntity
Setup steps
1 on this page
Show what matters for

Everyone

1What it is and why

What it isA setup page where you group reconciliation matching rules that run in sequence during bank reconciliation.
What you do hereUsed to run a whole series of matching rules in one pass instead of one rule at a time.
Example—
Reconciliation matching rule sets 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 processDefine accounting policies › Define banking policies › Establish matching rules for bank reconciliation in Dynamics 365 Finance
Menu pathCash and bank management › Setup › Advanced bank reconciliation setup › Reconciliation matching rule sets
Set up firstReconciliation matching rules Microsoft Learn ↗
Used next byBank accounts Microsoft Learn ↗Bank reconciliation Microsoft Learn ↗
Related pages—

End user · Functional consultant

3How to do it

Step by step, with screenshots

Set up Reconciliation matching rule sets1 screen

Used to run a whole series of matching rules in one pass instead of one rule at a time.

  1. Screen 1

    Create the matching rule set

    Go to Cash and bank management > Setup > Advanced bank reconciliation setup > Reconciliation matching rule sets

    1. Select New, and enter the Matching rule set and Name
    2. In the Matching rules section, select Add and select the Matching rule
    3. Use Up and Down to order the rules
    4. Select Save
    1Matching rule setBEAT-SET
    2NameAtlas demo daily matching
    Matching ruleBEAT-MATCH (Active)
    Create the matching rule set (zoomed on the outlined fields)
    Show the full screenCreate the matching rule set
    page title tab to open what to set or check

Microsoft's steps

  1. Go to Cash and bank management > Setup > Advanced bank reconciliation setup > Reconciliation matching rule sets.
  2. Select New, and enter a name and description.
  3. Add the matching rules in the order they should run.
  4. Select Save.

Source: Microsoft Learn ↗

Field guide

FieldWhat it meansWorked exampleTable column
Matching rule set—BEAT-SET—
Name—Atlas demo daily matchingName
Matching rule—BEAT-MATCH (Active)—

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision · common mistake · test
Set up Reconciliation matching rule sets——

Solution architect

5Design impact

Shared or per companyShared: the same records are used by every legal entity. Microsoft data model ↗
Can it be undone—
Feature or country—
If you change it laterThe rules run top to bottom, and with Reconcile after import the bank account's default set runs as soon as a statement is imported. Microsoft Learn ↗

Technical architect

6Technical

Menu itemBankReconciliationMatchRuleSet Checked in Dynamics 365
FormBankReconciliationMatchRuleSet Checked in Dynamics 365
TableBankReconciliationMatchRuleSetShown as “Reconciliation matching rule sets” in Record infoKey field: SetIdChecked in Dynamics 365
Data entitiesBankReconciliationMatchRuleSetEntityReconciliation matching rule sets Microsoft data model ↗
Who can open itPrivilegesMaintain bank reconciliation matching rule set BankReconciliationMatchRuleSetMaintainView bank reconciliation matching rule set BankReconciliationMatchRuleSetViewDutiesInquire into bank account reconciliation status BankBankAcctReconStatusInquireEnable bank management process BankBankManagementProcessEnable
6 security rolesChief financial officer CompanyChiefFinancialOfficerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerTreasurer PaymTreasurer
Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365

Developer

7Developer

Open it directlyhttps://<your-environment>/?mi=BankReconciliationMatchRuleSet
Integrate withBankReconciliationMatchRuleSetEntity data entity Microsoft data model ↗
Table definitionBankReconciliationMatchRuleSet columns and relations Microsoft data model ↗

Everyone

8Sources and checks