Statement Matching and Reconciliation

Here are the extracted rows from a bank or custodian statement, parsed offline. Confirm every row has a date, a description, and an amount. Flag any row where a number looks mis read: an amount with no decimal, a date out of range, a payee that looks truncated. Then tell me the extracted closing total so I can check it against the printed statement total before we match anything.

Match each transaction in the extracted statement to a line in the ledger I loaded. Match on amount first, then date within {{TOLERANCE_DAYS}} days, then reference. Return a table of matched lines (statement line, ledger line, what tied them), then a separate list of every statement line with no ledger match and every ledger line with no statement match. Do not force a match you are not sure of. End with the count: matched, unmatched statement lines, unmatched ledger lines, and confirm they sum to the totals on both sides.

Scan the statement for likely duplicate transactions: same or near same amount, same payee, within {{WINDOW}} days. List each suspected pair with the reason it looks like a duplicate and the reference on each. Do not assume a duplicate, flag each pair for my review.

For every unmatched line, classify it: timing difference (a match exists in the other set within {{TOLERANCE_DAYS}} days, just outside the period), true break (no match anywhere), or unclear. For each timing difference, show the candidate matching line so I can confirm it. Leave only genuine breaks on the true break list.

List every transaction that appears on exactly one side, the statement or the ledger, not both. Give amount, date, and payee for each, sorted by amount largest first, and state which side it is missing from. These are the one sided items I work first.

Produce a break report from the matching. Section one: summary (total lines, matched, breaks, total dollar value of breaks). Section two: a table of every break with amount, date, payee, type (duplicate, timing, missing, amount mismatch), and a one line suggested next step. Mask every account and routing number to the last four digits. Keep matched plus broken equal to the totals from prompt 02.

Find pairs that match on payee and date but differ in amount by less than {{CENTS}} cents or less than {{PERCENT}} percent. List each with the exact difference and a likely cause (bank fee, FX, rounding). Keep these near matches separate from true mismatches so I can set the tolerance myself.

Some statement lines are in {{CURRENCY}}. Match them to the ledger using the rate I provide ({{RATE}}, or a rate column in the file). On every cross currency match, show the original amount, the converted amount, and the rate used. Flag any line where the implied rate is more than {{PERCENT}} percent off the rate I gave.

Prove the reconciliation foots. Opening balance plus matched activity plus or minus identified breaks should equal the closing balance on the statement. Show the arithmetic line by line. If it does not foot, tell me the exact gap. Do not round it away.

Save the matching rules we settled on (tolerance days, cents tolerance, duplicate window, currency handling) as a short standard I can paste at the start of next month's run. Then give me the one line extraction command and the order of prompts to run, so next close is a checklist, not a rebuild.