Study guide
7.4 Matching Rule Sets, Reconciliation Execution & Reversals
Microsoft Certified: Dynamics 365 Finance Functional Consultant Associate MB-310
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: MB-310 Exam Overview & Financial Architecture
1.1 MB-310 Exam Structure, Skills Measured & Consultant Role 1.2 Dynamics 365 Finance Architecture, Legal Entities & Global Address Book 1.3 Hands-on Lab Strategy & Preparation Framework
2 Chapter 2: Chart of Accounts & Main Accounts
2.1 Designing Chart of Accounts & Main Account Types 2.2 Main Account Categories & Ledger Account Aliases 2.3 Balance Control Accounts & Year-End Opening Account Setup 2.4 Legal Entity Overrides for Main Accounts & Dimensions
3 Chapter 3: Financial Dimensions & Account Structures
3.1 Custom & Entity-Backed Financial Dimensions 3.2 Financial Tags: Limits, Storage & Ledger Settlement Use 3.3 Account Structures, Segment Criteria & Activation 3.4 Advanced Rules & Advanced Rule Structures 3.5 Derived Dimensions & Dimension Default Templates
4 Chapter 4: Ledgers, Calendars & Currencies
4.1 Fiscal Calendars, Period Statuses & Module Access Control 4.2 Posting Layers, Multi-GAAP Reporting & the Ledger Form 4.3 Currency Exchange Types, Rate Providers & Triangulation 4.4 Accounting & Reporting Currencies (Dual-Currency Architecture) 4.5 Foreign Currency Revaluation & Revaluation Posting Profiles
5 Chapter 5: General Ledger Journals & Allocations
5.1 Journal Names & Voucher Number Sequences 5.2 Journal Control & Posting Restriction Rules 5.3 Journal Entry, the One-Voucher Rule, Validation & Posting 5.4 Reversals, Storno Corrections & Excel Integration 5.5 Ledger Allocation Rules & the Four Allocation Methods 5.6 Allocation Processing & Periodic (Recurring) Journals
6 Chapter 6: Intercompany Accounting & Settlements
6.1 Intercompany Accounting Setup & Due-To / Due-From Postings 6.2 Intercompany Journal Processing & Multi-Company Vouchers 6.3 Ledger Settlements Configuration & Processing
7 Chapter 7: Cash and Bank Management
7.1 Bank Groups, Bank Accounts & Ledger Integration 7.2 Payment Formats, Bank FX Revaluation & Shared Payment Setup 7.3 Manual vs. Advanced Bank Reconciliation & Statement Formats 7.4 Matching Rule Sets, Reconciliation Execution & Reversals 7.5 Cash Flow Forecasting Setup & Automation 7.6 Customer and Vendor Netting
8 Chapter 8: Periodic Closing & Financial Consolidations
8.1 Financial Period Close Workspace, Closing Roles & Schedules 8.2 Year-End Close Configuration & General Ledger Balance Carryforward 8.3 Consolidations Online: Legal Entity Setup, COA Mapping & Currency Translation 8.4 Import Consolidations & Intercompany Elimination Rules
9 Chapter 9: Sales Tax & Withholding Tax
9.1 Sales Tax Engine Hierarchy, Authorities & Settlement Periods 9.2 Ledger Posting Groups, Sales Tax Codes & Calculation Methods 9.3 Sales Tax Groups, Item Sales Tax Groups & Tax Exemptions 9.4 Sales Tax Adjustments and Settle and Post Sales Tax 9.5 Withholding Tax & US 1099 Vendor Reporting
10 Chapter 10: Accounts Receivable Setup & Invoicing
10.1 Customer Master, Customer Groups & Shared Customers 10.2 Customer Posting Profiles & Account Code Precedence 10.3 Free Text Invoices, Recurring Invoice Templates & AR Charges 10.4 Sales Order Invoicing, Billing Classifications & Prepayments 10.5 Customer Payment Methods, Payment Processing & Customer Bank Accounts
11 Chapter 11: Credit Management & Collections
11.1 Credit Management Architecture & Customer Credit Groups 11.2 Risk Scoring, Credit Limits, Blocking Rules & Credit Holds 11.3 Aging Definitions, Collections Workspace & Customer Pools 11.4 Collection Letter Sequences & Interest Notes 11.5 Customer Write-Offs, Bad Debt & Write-Off Reversals
12 Chapter 12: Subscription Billing & Revenue Deferrals
12.1 Recurring Contract Billing, Billing Schedules & Milestones 12.2 Deferral Principles, Deferral Defaults & Schedule Calculation Methods 12.3 Recognition Processing, Expense Deferrals & Modifying Schedules 12.4 Multiple Element Revenue Allocation (MEA / ASC 606)
13 Chapter 13: Accounts Payable & Invoice Processing
13.1 Shared Vendors, Global Address Book & Vendor Groups 13.2 Vendor Posting Profiles, AP Parameters & Vendor Bank Accounts 13.3 Invoice Matching Setup (2-Way, 3-Way), Tolerances & Exceptions 13.4 Vendor Invoicing Methods, Journals & Invoice Automation
14 Chapter 14: Vendor Payments & Expense Management
14.1 Methods of Payment & the Vendor Payment Proposal Engine 14.2 Generating Payments, Centralized Payments & Check Lifecycle 14.3 Expense Management Configuration, Categories & Policies 14.4 Expense Reports Processing, Mobile Receipts & Intercompany Expenses
15 Chapter 15: Budgeting & Budget Control
15.1 Budget Models, Budget Codes & Allocation Terms 15.2 Budget Register Entries, Workflows & Budget vs. Actual 15.3 Budget Transfer Rules & Processing Budget Transfers 15.4 Budget Control Configuration, Cycles, Rules & Budget Groups 15.5 Budget Funds Available, Over-Budget Permissions & Document Budget Check 15.6 Budget Planning Framework, Organization Hierarchies & Planning Processes 15.7 Budget Plans, Scenarios, Allocations & Generating Register Entries
16 Chapter 16: Fixed Assets Configuration & Transactions
16.1 Fixed Asset Groups, Asset Records & Group/Book Mapping 16.2 Depreciation Profiles: Methods & Conventions 16.3 Fixed Asset Books, Derived Books & Posting Profiles 16.4 Fixed Asset Acquisition Pathways 16.5 Depreciation Proposals, Multi-Company Runs & Fixed Asset Budgets 16.6 Fixed Asset Disposals: Sale, Scrap & Disposal Accounting 16.7 Fixed Asset Splits, Transfers & Reclassification 16.8 Asset Leasing (IFRS 16 / ASC 842)
7.4 Matching Rule Sets, Reconciliation Execution & Reversals
Key Takeaways Explain This Topic AI
A matching rule defines the fields, date tolerance, and amount tolerance used to pair a bank statement line with a bank document line.
Matching rule sets run rules in sequence, typically from strictest to loosest, so exact matches are consumed before fuzzy rules run.
Checks need a wide date tolerance because the issue date and the bank clearing date differ by days or weeks.
Reconciliation can generate missing ledger entries for bank-side items such as interest and fees, and a completed reconciliation can be undone before the period is closed.
Last updated: August 2026
7.4 Matching Rule Sets, Reconciliation Execution & Reversals
Quick Summary: This section covers the Advanced Bank Reconciliation matching engine: how rules and rule sets are ordered, how tolerances handle timing differences, how unmatched bank-side items become new ledger entries, and how to reverse a completed reconciliation.
1. Reconciliation Matching Rules & Matching Rule Sets
Reconciliation Matching Rules define the algorithmic logic used by the ABR engine to pair imported statement lines with internal D365 bank subledger transactions.
Navigation
Path: Cash and bank management > Setup > Advanced bank reconciliation setup > Reconciliation matching rules +---------------------------------------------------------------------------------------------------------+
- | Reconciliation Matching Rule Configuration |
- +---------------------------------------------------------------------------------------------------------+
- | Rule Name: RULE-CHK-EXACT Matching Action: [ Match with bank document ] |
- | Statement Line Type: Debit (Customer/Vendor) Step Sequence: 10 |
- +---------------------------------------------------------------------------------------------------------+
- | MATCHING CRITERIA CRITERIA DEFINITION: |
- | +---------------------------------------------------------------------------------------------------+ |
- | | Criterion 1: Amount Match --> Difference allowed = $0.00 (Exact Amount) | |
- | | Criterion 2: Document Number --> Statement Reference matches D365 Check / Document Number | |
- | | Criterion 3: Date Tolerance --> Statement Date is within -2 to +5 days of D365 Trans Date | |
- | | Criterion 4: Bank Trans Type --> D365 Bank Trans Type equals mapped Bank Statement Code | |
- | +---------------------------------------------------------------------------------------------------+ |
- +---------------------------------------------------------------------------------------------------------+
- Matching Rule Actions
Rule Action Functional Purpose Real-World Use Case
Match with bank document Pairs open imported statement lines with un-reconciled D365 bank subledger transactions. Standard check clearance, customer ACH deposits, outbound vendor wires.
Clear reversal statement lines Automatically pairs and clears offsetting entries that exist purely on the bank statement. Intraday bank correction where bank erroneously debits $500 and immediately credits $500 on statement.
Mark as new transaction Automatically creates and posts a new General Ledger voucher and bank subledger line during reconciliation. Monthly bank service charges, wire transfer fees, interest earned, merchant card processing fees.
Matching Rule Sets Hierarchy
Rules are sequenced inside Reconciliation matching rule sets ( Advanced bank reconciliation setup > Reconciliation matching rule sets ). When the automatic matching process executes, it evaluates rules in strict numerical sequence:
Sequence 10 (High Precision): Check Number Exact Match + Exact Amount + Date within 3 days.
Sequence 20 (Reference Match): End-to-End Remittance ID Match + Exact Amount + Date within 5 days.
Sequence 30 (Amount & Date Match): Exact Amount + Date within 1 day (for routine automated recurring debits).
Sequence 40 (Auto-Generate Charges): External Bank Code NCHG / FEE -> Action: Mark as new transaction -> Auto-post to Account 618500 (Bank Fees Expense).
2. Reconciliation Execution, Manual Matching & Reversals
Once an electronic statement is imported, treasury accountants execute the reconciliation workflow via the Bank reconciliation worksheet ( Cash and bank management > Bank statement reconciliation > Bank statements ). +---------------------------------------------------------------------------------------------------------+
- | Bank Reconciliation Worksheet Architecture |
- +---------------------------------------------------------------------------------------------------------+
- | Statement: STMT-2026-08 | Bank Account: OPER-USD | Statement Date: 08/31/2026 |
- | Opening Balance: $1,250,000.00 | Ending Balance: $1,420,500.00 | Unreconciled Difference: $0.00 |
- | |
- | LEFT PANE: Electronic Statement Lines RIGHT PANE: D365 Bank Subledger Documents |
- | +-------------------------------------------------+ +----------------------------------------------+ |
- | | Date | Ref | Code | Amount | Status | | Date | Vch | Doc# | Amount | Status | |
- | | ---- | --- | ---- | ---------- | -------------- | | ---- | --- | ---- | ---------- | ----------- | |
- | | 8/28 | 101 | CHK | -$4,200.00 | Matched (Rule) | <-> | 8/26 | 088 | 101 | -$4,200.00 | Matched | |
- | | 8/30 | EFT | NTRF | +$15,000.00| Matched (Rule) | <-> | 8/29 | 092 | EFT | +$15,000.00| Matched | |
- | | 8/31 | FEE | NCHG | -$85.00 | New Trans Auto | ──> | [ Auto-Generated Voucher: Dr 618500 / Cr Bank] | |
- | | 8/31 | DEP | MISC | +$1,200.00 | Unmatched | | 8/31 | 099 | DEP | +$1,200.00 | Unmatched | |
- | +-------------------------------------------------+ +----------------------------------------------+ |
- | |
- | ACTIONS: [ Run Matching Rules ] [ Match Manually ] [ Unmatch ] [ Mark as Reconciled ] |
- +---------------------------------------------------------------------------------------------------------+
- Step-by-Step Reconciliation Lifecycle
Import Statement: Import CAMT.053 / MT940 / BAI2 file via Electronic Reporting / DMF.
Run Automatic Matching: Click Run matching rules , select the active Rule Set, and execute. The engine matches eligible lines and updates line status to Matched .
Perform Manual Matching: For exception lines (e.g., 1:Many deposit where one bank deposit of $10,000 matches three customer payment vouchers of $5,000, $3,000, and $2,000):
Select the statement line in the left grid.
Select the corresponding subledger documents in the right grid.
Click Match manually .
Generate Missing Transactions: For unmatched bank fees or interest not handled by automation rules, select the line, click Generate new transaction , specify the journal name and expense account, and post the adjustment voucher.
Validate & Mark as Reconciled: Verify that the Unreconciled difference equals 0.00 and click Mark as reconciled .
Reversing Reconciled Statements (Unreconcile)
If an error is discovered after a statement has been marked as reconciled (e.g., incorrect manual match):
Open the reconciled statement in Bank statement reconciliation > Bank statements .
Click Unreconcile bank statement in the Action Pane.
D365 Finance reverses the reconciliation status, restores all matched bank subledger documents to open un-cleared status, and automatically reverses any General Ledger adjustment vouchers created during the reconciliation run.
3. Exam Traps & Real-World Best Practices
Warning
Exam Trap: Automatic Bank Fee Generation vs. Manual Journal Entry An exam question may describe a monthly bank statement containing a $150 wire fee that was never recorded in D365. The question asks for the most efficient, compliant way to resolve the difference. The trap option suggests exiting the reconciliation screen, creating a General Journal in GL, posting the fee, and re-opening the reconciliation. The correct solution is configuring a Reconciliation Matching Rule with the action Mark as new transaction (or clicking Generate new transaction directly on the reconciliation worksheet) to post the voucher seamlessly within the reconciliation session.
Important
Consultant Pro-Tip: Date Tolerance in Matching Rules In commercial banking, checks issued on Friday may not clear the recipient's bank until Tuesday of the following week (a 4-day lag). When configuring matching rules for check clearing, always specify a Transaction date tolerance (e.g., -1 to +7 days ) to prevent high rates of false-unmatched check exceptions.