Expense Reconciliation
Finds the gap between what was claimed and what was evidenced, before someone else does.
Inputs
- Mailbox, through Email, for receipts, card statements and claim confirmations
- A claims export the user supplies, through Excel
references/config.md for the period, the materiality threshold and the policy rules to check
Procedure
- Load the claims export. If none is supplied, say so and stop: reconciliation without the
claim side is not reconciliation, it is a receipt hunt. Offer that instead.
- Gather evidence from the mailbox over the period: receipts, invoices, card statements.
- Match each claim to evidence on amount, date within the config tolerance, and merchant.
Record the match confidence as exact, probable or none.
- Classify every row:
Matched, Amount differs, No receipt, Receipt with no claim,
Possible duplicate.
- Check policy only against the rules written in config. Never invent a policy rule.
- Write
/Documents/Cowork/output/expense-recon-<period>.xlsx, unmatched rows first.
- Draft one chaser per claimant covering all their gaps in a single message, not one per row.
Output
| Claim ref | Claimant | Date | Amount | Merchant | Evidence | Match | Status | Policy flag | Source |
Then: counts by status, total value unmatched, claimants to chase, drafts prepared.
Definition of done
Every claim carries a status, every unmatched row says why, and every claimant with a gap has one
drafted message.
A clean reconciliation is the best outcome. If everything matches, say that in one line with
the totals. Do not manufacture a policy flag to show effort.
When there is no data
- No claims export: stop and say what is needed.
- Mailbox evidence missing for a period: state the window actually covered. Never present a
partial period as complete.
- A statement is a PDF you cannot parse: list it as unread evidence rather than ignoring it.
Boundaries
- Draft, never send. Chasers are drafts.
- Never approve, reject or adjust a claim. Never state a reimbursable amount as final.
- The expense system and the finance ledger are the source of truth. This reads mail.
- Never share a claimant's detail with anyone but the user and that claimant.
Self-check
- Does every unmatched row name the missing evidence?
- Is every policy flag traceable to a rule in config?
- One chaser per claimant, not one per row?
- If it all matched, did I say so plainly?
1---2name: expense-reconciliation3description: Reconciles submitted expense claims against the receipts and statements sitting in the mailbox, lists what is missing or unmatched, and drafts the chaser to each claimant. Use when the user asks to reconcile expenses, check expense claims, find missing receipts, chase expense documentation, or prepare the expense pack before a close.4metadata:5 source: https://skillmd.com/skills/kesslernity/expense-reconciliation6---78# Expense Reconciliation910Finds the gap between what was claimed and what was evidenced, before someone else does.1112## Inputs13- Mailbox, through **Email**, for receipts, card statements and claim confirmations14- A claims export the user supplies, through **Excel**15- `references/config.md` for the period, the materiality threshold and the policy rules to check1617## Procedure181. **Load the claims export.** If none is supplied, say so and stop: reconciliation without the19 claim side is not reconciliation, it is a receipt hunt. Offer that instead.202. **Gather evidence** from the mailbox over the period: receipts, invoices, card statements.213. **Match** each claim to evidence on amount, date within the config tolerance, and merchant.22 Record the match confidence as exact, probable or none.234. **Classify every row**: `Matched`, `Amount differs`, `No receipt`, `Receipt with no claim`,24 `Possible duplicate`.255. **Check policy** only against the rules written in config. Never invent a policy rule.266. **Write** `/Documents/Cowork/output/expense-recon-<period>.xlsx`, unmatched rows first.277. **Draft one chaser per claimant** covering all their gaps in a single message, not one per row.2829## Output30| Claim ref | Claimant | Date | Amount | Merchant | Evidence | Match | Status | Policy flag | Source |3132Then: counts by status, total value unmatched, claimants to chase, drafts prepared.3334## Definition of done35Every claim carries a status, every unmatched row says why, and every claimant with a gap has one36drafted message.3738**A clean reconciliation is the best outcome.** If everything matches, say that in one line with39the totals. Do not manufacture a policy flag to show effort.4041## When there is no data42- No claims export: stop and say what is needed.43- Mailbox evidence missing for a period: state the window actually covered. Never present a44 partial period as complete.45- A statement is a PDF you cannot parse: list it as unread evidence rather than ignoring it.4647## Boundaries48- **Draft, never send.** Chasers are drafts.49- Never approve, reject or adjust a claim. Never state a reimbursable amount as final.50- The expense system and the finance ledger are the source of truth. This reads mail.51- Never share a claimant's detail with anyone but the user and that claimant.5253## Self-check54- Does every unmatched row name the missing evidence?55- Is every policy flag traceable to a rule in config?56- One chaser per claimant, not one per row?57- If it all matched, did I say so plainly?