Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Month-End Bank Reconciliation Memo

    1

    Turns bank and ledger balances plus unmatched items into a two-sided reconciliation, book-side entries only, and an evidence list for review.

    Free

    1 useSecurity scanned
    Month-End Bank Reconciliation Memo

    Month-End Bank Reconciliation Memo

    Example session with this skill installed

    Please prepare the September month-end bank reconciliation memo for the client file.
    Client: Birch Example Co. (fictional). Period ending September 30, 2026. Operating account ending 4417.
    Bank statement ending balance: $42,315.75
    General ledger cash balance: $39,112.10

    Unmatched items

    • Check #2214 to Sample Freight, $3,400.00, written Sept 29, not yet on the bank statement.
    • Check #2219 to Example Janitorial, $615.25, written Sept 30, not yet on the bank statement.
    • Deposit of $1,980.00 recorded in the books Sept 30, not on the statement (night drop).
    • Bank service fee $45.00 on the statement, not in the books.
    • Interest credited $8.40, not in the books.
    • Check #2201 to a supplier recorded in the books as $927.00; it cleared the bank as $972.00; the supplier invoice says $972.00.
    • ACH credit of $1,250.00 on Sept 24, reference "ACH CREDIT REF 88231" — nobody knows what it is yet.
    • Read your context and instructions
    • Compiled the month-end bank reconciliation

    BANK RECONCILIATION MEMO — Birch Example Co. — account ending 4417 — September 30, 2026
    Currency: $ as supplied (confirm USD)

    RECONCILIATION SUMMARY

    Bank balance: 42,315.75; GL cash: 39,112.10
    Adjusted bank: 40,280.50; adjusted books: 40,280.50 (provisional)
    Status: Arithmetic agrees; reconciliation provisional. The ACH credit REF 88231 is unidentified and held in suspense pending evidence.

    BANK SIDE

    Starting statement balance: 42,315.75
    Check #2214, Sample Freight. Bank-side timing: outstanding check, written Sept 29.
    42,315.75 − 3,400.00 = 38,915.75
    Check #2219, Example Janitorial. Bank-side timing: outstanding check, written Sept 30.
    38,915.75 − 615.25 = 38,300.50
    Night-drop deposit. Bank-side timing: deposit in transit, recorded in books Sept 30.
    38,300.50 + 1,980.00 = 40,280.50
    Adjusted bank balance: 40,280.50

    BOOK SIDE

    Starting GL cash balance: 39,112.10
    Bank service fee. Book-side: on the statement, not in the books.
    39,112.10 − 45.00 = 39,067.10
    Interest credited. Book-side: not in the books.
    39,067.10 + 8.40 = 39,075.50
    Check #2201, supplier. Book-side recording error on a payment.
    Recorded amount: 927.00. Correct amount: 972.00 (cleared amount and supplier invoice).
    Cash adjustment = recorded − correct = 927.00 − 972.00 = −45.00
    The payment was recorded too low by 45.00, so book cash decreases by 45.00.
    39,075.50 − 45.00 = 39,030.50
    ACH CREDIT REF 88231, Sept 24. Unidentified bank credit.
    This is a provisional cash/suspense adjustment pending evidence. Its amount and credit direction are supplied. Its absence from the GL is implied by its listing as unmatched and needs confirmation.
    39,030.50 + 1,250.00 = 40,280.50 (provisional)
    Adjusted book balance: 40,280.50 (provisional)

    DIFFERENCE

    40,280.50 − 40,280.50 = 0.00
    Status: Arithmetic agrees; reconciliation provisional.

    Unresolved items and missing inputs

    • ACH CREDIT REF 88231, 1,250.00. The source and purpose are unknown. It is held in suspense and is not revenue.
    • Check #2201: the original offsetting account was not supplied.
    • Currency code: "$" was supplied. Confirm USD.
    • Item check: all 7 unmatched items appear once. There are 3 bank-side timing items, 3 book-side items and 1 unidentified item. No duplicates were flagged.

    Follow-up

    • Get the bank's ACH detail for REF 88231 (originator name, company ID, addenda). Then match it against open receivables, expected refunds, transfers, and loan or grant receipts.
    • Confirm that Checks #2214 and #2219 are recorded in the September GL at the amounts stated. Then trace them to October clearing.
    • Trace the 1,980.00 night-drop deposit to its early-October bank credit and check that the dates support September cutoff.
    • Pull the original GL entry for Check #2201 to identify the debited account and the reason for the transposition (927 vs 972).
    • Confirm that the 8.40 interest appears as a credit on the September statement.

    PROPOSED JOURNAL ENTRIES (BOOK SIDE ONLY; NOT POSTED)

    JE-1 (bank service fee)
    Dr Bank service fees 45.00
    Cr Cash — operating (4417) 45.00
    Totals: debits 45.00 = credits 45.00

    JE-2 (interest credited)
    Dr Cash — operating (4417) 8.40
    Cr Interest income 8.40
    Totals: debits 8.40 = credits 8.40

    JE-3 (Check #2201 correction)
    Dr [original offsetting account — confirm] 45.00
    Cr Cash — operating (4417) 45.00
    Totals: debits 45.00 = credits 45.00

    JE-4 (ACH CREDIT REF 88231)
    PENDING EVIDENCE — provisional; not revenue or expense.
    Dr Cash — operating (4417) 1,250.00
    Cr Suspense — unidentified receipts 1,250.00
    Totals: debits 1,250.00 = credits 1,250.00

    No entries are proposed for the timing items (Checks #2214 and #2219, the night-drop deposit). There are no bank errors identified.

    EVIDENCE NEEDED BEFORE POSTING

    JE-1: The September statement fee line is missing (described, not supplied). Verify the GL omission and the fee expense account.
    JE-2: The September statement interest line is missing (described, not supplied). Verify the GL omission and the interest income account.
    JE-3: The following are missing:
    - the original GL entry for Check #2201
    - the bank clearing image or detail showing 972.00
    - a copy of the supplier invoice (cited, not supplied)
    The offsetting account must be confirmed. It is likely the original AP or expense account, but this is unverified.
    JE-4: The following are missing:
    - bank ACH detail for REF 88231
    - source documentation identifying the payer and purpose
    - confirmation that the credit is absent from the GL
    Final classification out of suspense requires evidence and the responsible accountant's approval.

    REVIEW AND SIGN-OFF

    Prepared by: __________________ Date: __________________
    Reviewed by (responsible accountant): __________________ Date: __________________

    Note: A zero difference does not by itself establish completeness. The reviewer must verify the account, date and currency alignment, cutoff, classifications, arithmetic and evidence before posting or signing (see references/checklist.md).

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Builds a client-file reconciliation memo comparing adjusted bank cash with adjusted general-ledger (GL) cash, with arithmetic shown line by line. Classifies unmatched items and proposes book-side entries with supporting evidence requirements. Leaves preparation and review sign-off to the responsible humans. Uses US terminology without claiming UK or Australian requirements.

    Built and tested by AI Professions, where we test AI on real professional tasks. Before this skill was written, we locked a 5-criterion rubric and a fictional test input. Then Claude Opus 5.5, Claude Sonnet 5, Claude Fable 5.1 each ran it 3 times, and a model from another family (GPT-6 Astra) graded every run.

    Test results (English, current version v1.0): Claude Opus 5.5: 5.0 of 5 · Claude Sonnet 5: 5.0 of 5 · Claude Fable 5.1: 5.0 of 5. Full transcripts and verdicts are public: prompt-benchmark on GitHub.

    What you give it

    • Entity placeholder, account identifier (last four digits only), period-end date, and currency.
    • Bank statement ending balance and GL cash balance for that account and date.
    • Every unmatched item: reference, date, description, amount, and whether it appears only on the statement, only in the books, or in both at different amounts.
    • For recording errors: payment or receipt, recorded amount, supported correct amount, and original entry or offsetting account if known.
    • Available supporting records and any known bank errors, duplicates, or cutoff concerns.

    Ask once for all missing or conflicting inputs together. If proceeding without them, list them under Difference; never infer figures, dates, currency, or unsupported classifications. If a starting balance or necessary item amount is missing, show only calculable subtotals and mark the reconciliation incomplete.

    Also available

    • Spanish, French (France) and Brazilian Portuguese versions adapted to local practice, not translated: skill page · GitHub
    • Claude Code plugin: /plugin marketplace add aiprofessions/claude-skills

    Important

    The skill produces drafts. A licensed or responsible professional checks every output before use. Do not paste client, patient or personal data into tools your organization has not approved.

    Free under CC BY 4.0. Credit: AI Professions (aiprofessions.ai).

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Finance & Accounting.

    Requires manual input of balances and items. Only uses US accounting terminology. Does not verify the validity of supplied evidence. Masking is limited to the last four digits of account numbers.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    1 use

    Times used to date

    Free to use

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 25 days ago

    • Free with an Agensi account

    Permissions

    No special permissions declared or detected

    Listed25 days ago

    What's inside

    Frequently Asked Questions

    The skill automates the heavy lifting of calculating adjusted balances and classifying transactions into timing differences versus book errors. It solves the common problem of 'plugging' numbers by forcing arithmetic validation and flagging unresolved variances as suspense items rather than guessing their treatment.

    This skill is a specialized prompt-based logic set designed for text-centric AI interfaces such as Claude, ChatGPT, or Cursor. It functions as a standalone workflow within these agents and does not require any external database connections or API integrations.

    No complex installation is required; you simply input your period-end data and unmatched transaction list directly into your preferred AI interface using the skill's framework. The process is manual-paste by design to maintain a high level of security and data control.

    You will receive the full logic framework and standardized input/output templates for the reconciliation memo. This includes the automated classification engine, the journal entry generator, and the evidence requirement checklist for audit readiness.

    The skill is built on US GAAP terminology and standard two-sided reconciliation logic. While the fundamental math is universal, it does not currently support specific international tax requirements or regional accounting standards like those used in the UK or Australia.

    New in Finance & Accounting

    Free