finance-reconciliation-exception-reportlisted

Reconciles two supplied sources — ledger to sub-ledger, bank to cash book, intercompany pair, processor settlement to billing — at item level, then produces the exception report: every break classified by cause (timing, missing entry, duplicate, FX, cut-off, genuine error), aged, quantified, and given a named owner and an action. Re-derives the match from the supplied data rather than accepting an asserted total, and never books, nets or plugs a difference. Use when two sources of the same balance disagree, when a reconciliation needs preparing or reviewing, when a control account will not tie, or when someone asks what the unreconciled difference consists of. Trigger on 'reconcile these', 'the balance does not tie', 'unreconciled difference', 'break analysis', 'exception report', 'bank rec', 'intercompany mismatch', 'suspense account'. Not for explaining why a reconciled P&L line moved period on period (use finance-month-end-variance-analysis) and not for deciding whether a single expense claim is payable (u
alihusains/enterprise-skills · ★ 0 · AI & Automation · score 73

Install: claude install-skill alihusains/enterprise-skills

# Reconciliation exception report ## Purpose Most reconciliations are presented as a tidy summary with one residual line labelled "difference to investigate", and that line is where the loss lives. This skill inverts the output: the deliverable is the exception list, item by item, each break named, classified by cause, aged, owned and actioned. A reconciliation with a clean summary and an unexplained residual has not been done, it has been formatted. ## Data classification **Confidential.** Reconciliation extracts carry counterparty names, bank details, transaction-level client activity and unpublished balances. **STOP CONDITIONS:** | Trigger | Action | | --- | --- | | Full or partial account numbers, IBANs, sort codes, card PANs, or payment credentials appear in the extract | Stop. Name the category detected without repeating the value. Ask for the file re-supplied with those columns removed or hashed. | | Client- or counterparty-identifiable balances, positions or transactions are pasted | Stop. Ask for a de-identified extract keyed on a reference, not on a name or account. | | Payroll detail at a grain where an individual's pay is derivable | Stop. Ask for it aggregated. | | The request is to net offsetting breaks, write a difference to suspense or P&L, or adjust one side so the two agree | Stop. That is a plug and it conceals a misstatement. Report the break gross, both legs, and escalate to the financial controller. | | The request is to post, approve or release a