statement-reconciliation

$npx mdskill add Significant-Gravitas/skills-catalog/statement-reconciliation

A reconciliation explains every difference between two records for one account and one period. It does not force them to agree.

SKILL.md

.github/skills/statement-reconciliationView on GitHub ↗
---
name: "statement-reconciliation"
description: "Reconcile a bank or card statement to a ledger with control totals, matched items, timing differences, and owned exceptions."
triggers: ["reconcile statement", "bank reconciliation", "card reconciliation", "statement mismatch", "unmatched transactions"]
version: "1"
---

# Statement reconciliation

A reconciliation explains every difference between two records for one account
and one period. It does not force them to agree.

## Set the controls

Record the entity, account, currency, statement period, statement opening and
closing balances, ledger opening and closing balances, and export cutoff. Keep
pending and posted items separate. Confirm the sign convention before matching.

## Match in passes

1. Match exact amount, date, and reference.
2. Match known timing differences within a stated date window.
3. Match batches only when their components sum exactly and the source gives a
   shared reference.
4. Review fees, interest, refunds, reversals, transfers, and foreign-currency
   settlements separately.
5. Leave every uncertain pair unmatched.

Never match on amount alone when duplicates exist. Keep a link or row identifier
for both sides of every match.

## Return the reconciliation

Show:

- opening balance on both records;
- total debits and credits or charges and payments;
- closing balance on both records;
- matched count and value;
- valid timing differences with dates;
- statement-only and ledger-only items;
- duplicates or possible duplicates;
- unexplained difference.

Use the equation that fits the account and show it in the report. A complete
result has an unexplained difference of zero. If it does not, label it open and
assign each item an owner and next step.

## Safety rules

Do not create, delete, merge, or edit transactions. Do not propose an adjusting
entry unless the source and approved policy support it; present it as a draft
for accountant review. Escalate unknown withdrawals, changed bank details,
duplicate payments, large or repeated differences, and suspected fraud at once.

More from Significant-Gravitas/skills-catalog

SkillDescription
account-health-and-qbrsUse when a support account wobbles or a quarterly business review looms: read the health signals, run the success plan, and prep the review from evidence.
accounts-receivable-follow-upReview open receivables and draft factual, staged payment follow-ups without inventing status or contacting a customer.
ad-copy-variantsWrite ad variants that each test one idea, within platform limits and supported claims.
alex-getting-startedUse on the first conversation with Alex, or whenever their memory has no product preferences yet: learn what the user is building and who for, where specs, roadmap and numbers live, who decides dates and scope, and get them to a first real product deliverable.
alliance-co-commercializationUse when a strategic alliance needs joint selling governance: operating model, joint targeting, steering prep, and milestone accountability.
anika-getting-startedUse on the first conversation with Anika, or whenever their memory has no partnership preferences yet: learn which partners and alliances the user owns, what motion they run, and get one real partner read on screen in the same session.
assure-partner-led-deliveryUse when partners deliver client work in your name: own the in-flight book, run the weekly delivery review, and rescue engagements before clients feel it.
automate-finance-reportingUse to connect a number source, map an export into the finance ledger, or QA a sheet: the column mapping, the dedupe key, the load summary, and the checks that must pass before a read ships.
billing-refunds-and-exceptionsUse when money is on the table: verify the charge, check the policy, and stage a refund or exception draft that stops at the owner's yes.
board-and-investor-metrics-briefPrepare a concise board or investor metrics brief with definitions, sources, comparisons, drivers, risks, and decisions needed.