← ClaudeAtlas

reconcilelisted

Compare every balance-carrying account's book balance to its statement balance, month by month, stating the difference for every account including the zeros. Use after the backlog is categorized and the adjusting entries are in, before declaring a period closed.
median-labs/close-the-books · ★ 1 · AI & Automation · score 74
Install: claude install-skill median-labs/close-the-books
# Reconcile The check that makes the books an assertion about the world rather than an internally consistent story. A trial balance that foots proves the bookkeeping is arithmetically sound. Reconciliation proves it matches the bank. ## Hard gates - **State the difference for every account, including the zeros.** A report listing only the problems hides every account nobody looked at. The zeros are the evidence. - **Where there is no statement, say "cannot check" and why.** Never 0.00. An unchecked account and a checked account that agrees are not the same thing and must never render the same. - **Never plug.** If an account is out by 41.18, the report says 41.18. An entry written to make that disappear is the single clearest sign of books that cannot be trusted. - **A reconciliation you cannot reproduce is not one.** Every difference names the statement it was measured against. ## Run it ``` python3 bin/books.py reconcile --profile profiles/mine.local.json --from 2025-01-01 --to 2025-12-31 ``` One row per account per month: book balance, statement balance, difference, and the statement it used. Two summary lists come out of it, and they are different problems: - **Unreconciled**: a real difference. Something is missing, duplicated or mis-dated. Work these. - **Unchecked**: no statement for that account-month. Get the statement, or record why it does not exist. ## Working a difference Look in this order, because this is roughly the frequency order: