7.4 Matching Rule Sets, Reconciliation Execution & Reversals
Key Takeaways
- 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.
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 Account618500(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.
A treasury department imports a daily ISO 20022 CAMT.053 electronic bank statement into Dynamics 365 Finance. The statement includes an unexpected $75 international wire transfer service fee with bank transaction code 'NCHG'. The company wants the system to automatically generate and post the General Ledger expense voucher for this fee during the automated reconciliation run. How should the Functional Consultant configure this requirement?
An accountant reconciles an electronic bank statement in Advanced Bank Reconciliation and clicks 'Mark as reconciled'. The following day, the corporate treasurer notices that a $12,000 customer deposit was matched against an incorrect customer receipt voucher. How should the accountant correct this reconciliation error?
An organization is configuring Advanced Bank Reconciliation matching rules for physical checks issued from their operating account. Due to mail and bank processing delays, checks typically clear the bank between 2 and 6 days after the check issuance date in D365 Finance. Which rule configuration prevents these checks from failing automated matching?