Bank Reconciliation Review: Why Doesn't My Balance Match?

Find reasons for a difference between books and bank.

Added October 15, 2026. Written with AI assistance and checked for clarity and placeholders; not reviewed by a lawyer, accountant, clinician or other professional. How these prompts are made

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

Help me investigate a bank reconciliation difference. Bank statement balance and date: [BANK_BALANCE]. Book balance: [BOOK_BALANCE]. Outstanding cheques or payments: [OUTSTANDING_ITEMS]. Deposits in transit: [DEPOSITS_IN_TRANSIT]. Bank fees and interest not yet recorded: [FEES_AND_INTEREST].

Compute the adjusted bank balance and adjusted book balance with the arithmetic and show the remaining difference. Suggest checks in order: transposed digits (difference divisible by 9), a duplicate entry (difference equals a transaction), a missing entry (difference equals a bank line), wrong sign, wrong date cut-off, and bank errors. Make a checklist for tracing and a table of items found. Provide a way to record the reconciliation and a monthly routine.

Use only my figures. This is a bookkeeping aid, not accounting advice.

Add a worked example: bank 10,450, outstanding cheques 1,200, deposit in transit 600 gives adjusted bank 9,850; books 9,894 minus bank fee 25 and plus interest 4 gives 9,873; a 23 difference that suggests a transposition (difference divisible by 9 would be a clue) or a missing entry to trace.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

Rate this prompt

Related prompts