Perfect Match Criteria for Bank Reconciliation
| Criterion | Logic | Notes |
|---|---|---|
| Reference ID in Narration + Amount Aligned | Bank narration contains the ledger ReferenceID AND BankAmount = JEAmount (±0.01) | Strongest perfect match; confirms linkage and exact financial alignment |
| Narration Equals Line Item Text + Amount Aligned | Bank narration exactly equals ledger LineItemText AND BankAmount = JEAmount (±0.01) | Strong match; descriptive consistency plus exact financial alignment |
| Reference ID in Narration | Bank narration contains the ledger ReferenceID (amount alignment not required) | Moderate match; relies on reference linkage only |
| No Match Logic | None of the above conditions are satisfied | Candidate discarded; not considered a perfect match |
Notes
Perfect matches are ranked per BankTransactionID using MatchStrength, amount alignment, date proximity, and JournalSequenceID tie-breaker. Only the top-ranked match per transaction is retained in MLPerfectMatch.
