Match receipts to transactions

Reconciliation is the work of comparing two lists that should agree and finding where they do not. It is genuinely tedious, genuinely important, and almost entirely mechanical up to the point where judgement is needed.

The trick is to automate the comparison and keep the judgement.

Get both sides reachable

Connect QuickBooks and Gmail from Integrations. The transactions are in the accounting system; the receipts are mostly in email, which is why this needs both.

If your receipts live somewhere else, the shape of the playbook is unchanged and the connector differs.

Ask for the gaps, not the matches

The output you want is short. A report confirming that 180 transactions matched their receipts is a report nobody reads.

Every Monday at 8am, reconcile last week's card transactions against
receipts in my mail.

Report only the exceptions, in three groups:
  NO RECEIPT       a transaction with nothing attached
  NO TRANSACTION   a receipt with no matching charge
  AMOUNT DIFFERS   both exist and disagree, with both figures

For each, give the date, the merchant, the amount, and a link to the
receipt if there is one.

Match on merchant and amount within a day or two either side, because
settlement dates move. Say when you matched something loosely so I can
check it.

If everything reconciled, say so and stop.

"Say when you matched something loosely" is the line that keeps this honest. A reconciliation that silently accepts near-matches will quietly pair the wrong coffee shop charge with the wrong receipt and report a clean week. You want the fuzzy matches visible, because those are the only ones that can be wrong in a way the totals will not reveal.

Expect the first run to be noisy

Recurring subscriptions that never email a receipt, and a merchant whose statement name bears no relation to their trading name, will both show up immediately.

Neither is a bug. Both are one line in the prompt:

These are known and do not need a receipt: [list].
This merchant appears on statements as X and emails receipts as Y.

Every week the exception list gets shorter for a while, then stabilises at the genuinely missing ones.

Keep the judgement

Do not have it mark things reconciled in the accounting system. The value here is a short, accurate list of what a person needs to look at, and handing over the write as well removes the review that makes the list trustworthy.

What good looks like

Monday morning brings a list of six things instead of an afternoon of matching, and the six are genuinely unresolved rather than artefacts of naming.

The number to watch is the loose-match count. If it grows, your merchants have changed how they bill, and the prompt needs updating before the report starts being confidently wrong.