AI Transaction Match Rules Builder (Bank CSV → Heuristics → Review Checklist)
Quickly generate defensible match rules for bank-to-GL reconciliation and a reviewer checklist, so junior staff can match faster without creating audit risk.
Prompt Overview
Featured AI Partner
Tips For You
- Maintain a vendor alias table and refresh monthly. - Use a scoring column so reviewers can sort candidates. - Store examples of confirmed matches to retrain heuristics. - Lock rules for the close period to preserve auditability.
From Operations TeamNexusAi TechnologyProblem It Solves
Removes guesswork in transaction matching and prevents inconsistent, undocumented criteria that slow reviews and create rework.
Evidence Scoring
Standardizes confidence scoring to speed reviewer decisions.
Tiered Rules
Exact, fuzzy, and composite options for different scenarios.
Reviewer Checklist
Prevents misses and ensures repeatable reviews.
Spreadsheet Ready
Designed to drop into Rows or Excel without rework.
AI Prompt Instructions
Act as: Senior Accounting Reconciliation Specialist creating bank-to-GL matching rules and a reviewer checklist for consistent, auditable matches.
Why this task matters: Clear, documented match rules accelerate reconciliations, reduce back-and-forth during review, and prevent misclassifications that undermine cash accuracy and tax readiness.
Important boundaries:
- Do not assume a match unless criteria are met and explainable.
- Flag partial matches with rationale and next-step evidence requests.
- Align with typical accounting policies: materiality thresholds, cut-off dates, and vendor naming conventions.
User inputs (paste below):
- Bank CSV sample: columns (date, description, amount, reference, counterparty)
- GL export sample: columns (date, account, contact/vendor, doc no, memo, debit, credit)
- Date range, currency, materiality threshold (e.g., $25), and known naming aliases (e.g., “AMZN” → “Amazon”)
Objectives:
1) Propose primary and secondary match rules (exact, fuzzy, composite).
2) Define tie-breakers and conflict resolution steps.
3) Produce a reviewer checklist with evidence tests.
4) Output a rules table that can be implemented in a spreadsheet or Rows formulas.
Analysis workflow:
1) Profile both datasets: date formats, amount signs, common description tokens, recurring vendors.
2) Define rule tiers: Tier 1 (exact amount/date/doc no), Tier 2 (amount ± small variance + alias match), Tier 3 (fuzzy description + running total grouping).
3) Specify handling for splits, batched deposits, merchant fees, FX differences, and reversals/chargebacks.
4) Create tie-breakers: priority order, minimum evidence score, reviewer escalation.
5) Provide examples using the supplied samples and note where human confirmation is required.
Required output format:
- Section A: Rules Table (columns: Rule ID, Rule Name, Criteria, Evidence Score 0–100, Edge Cases, Example)
- Section B: Reviewer Checklist (10–15 items)
- Section C: Implementation Notes (Rows/Excel formula hints; column mappings)
- Section D: Risks & Controls (common pitfalls and prevention)
Quality controls:
- Every rule must be testable with columns provided.
- Include at least 2 controls preventing false positives on duplicates.
Verification checklist:
- Samples validate at least one match per rule tier.
- Tie-breakers produce a single best candidate or escalation.
Final instruction: Produce the output sections with clear tables and bullet points that can be pasted into ChatGPT/Claude/Gemini and then ported into Rows or Excel without modification.
Expected Outcome
Section A – Rules Table: - R1 | Exact Doc Match | bank.amount == gl.amount AND bank.reference == gl.doc_no AND | Score: 100 | Edge: duplicate refs | Example: $425.00, Ref 99821 - R2 | Amount+Alias+Date Window | | Score: 85 | Edge: weekend postings | Example: $59.99, AMZN→Amazon, ±2 days Section B – Reviewer Checklist: - Confirm sign convention, verify weekend date offsets, inspect vendor alias table, review splits over materiality. Section C – Implementation Notes: - Create alias map tab; use INDEX/MATCH or LOOKUP on normalized descriptions; add score column. Section D – Risks & Controls: - Control: no auto-post on scores <80; second review for batched deposits.
Implementation Journey
Draft rules in ChatGPT
Open ChatGPT. Paste small samples of your bank CSV and GL export with date range, materiality, and vendor alias list. Ask ChatGPT to produce the rules table, checklist, and implementation notes as specified. Expect a structured set of match rules and a reviewer checklist.
15 minPrototype in Rows
Create a Rows workbook. Import the bank and GL samples, build columns for alias-normalized descriptions, and implement scoring formulas based on the ChatGPT rules. Expect a sortable candidate list with evidence scores.
25 minOperationalize in your close
Export the Rows-scored candidates to Excel or CSV and attach the reviewer checklist to your month-end binder. Assign reviewers, set a minimum score threshold, and log exceptions for escalation.
20 min
