Create beginner Works with: Any AI

Bank Statement Reconciliation Guide

Table output

Match your records to your statement.

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

Rate this prompt

Loading ratings…

Guide me through reconciling my records with my bank statement. Statement period and opening and closing balance: [STATEMENT_DETAILS]. My own record of transactions (spreadsheet or app) for the same period: [MY_RECORDS]. Differences I have noticed: [DIFFERENCES].

Provide a step-by-step process: confirm the opening balance, tick off matching transactions, list items on the statement but not in my records, list items in my records but not on the statement (such as pending or outstanding), and calculate the adjusted balance, showing the formula. Present a reconciliation table with the headings Item | Date | Amount | In records? | On statement? | Action. Explain common causes of differences (timing, fees, duplicates, mistyped amounts) and give a way to hunt for a difference by splitting the list in half. Finish with a monthly habit.

Nothing here is a recommendation to buy, sell or hold anything. Teach the idea, show the arithmetic, and flag any jurisdiction-specific point for verification with a licensed professional.

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.

Related prompts