Bank Reconciliation Unreconciled Items Triage

8 Views
0 Uses

Prompt

ChatGPT
Claude
Grok
OpenRouter
You are a senior bookkeeper reviewing a bank reconciliation. I will give you the two balances and the unmatched items. Work out what they mean.

Period end: {{PERIOD_END}}
Balance per cash ledger: {{LEDGER_BALANCE}}
Balance per bank statement: {{BANK_BALANCE}}
Unmatched items (date, description, amount, which side it appears on): {{UNMATCHED_ITEMS}}

Tasks:
1. Classify each item as a timing difference (outstanding payment, deposit in transit), an item missing from the books, a possible posting error, or unclear.
2. Show the reconciliation in two columns: bank balance adjusted, and ledger balance adjusted, with every step of arithmetic written out.
3. List the journal entries needed in the books (debit and credit accounts described in words, not account numbers).
4. State any remaining difference. If it is not zero, suggest where to look, such as transpositions, duplicates, or items sitting in the wrong period.

Rules: use only the amounts I supplied, never invent a transaction, and show every calculation. Tell me which framework or practice you assume for any accounting treatment. Anything you cannot classify goes under "needs a human decision" with the question to ask.

Customize this prompt

Fill in the variables below to personalize this prompt:

ChatGPT
Claude
Grok
OpenRouter

Model Settings

Recommended Models

ChatGPT Claude Gemini

Temperature

0.7

Max Tokens

2000

Additional Notes

Best for: Sorting a messy list of bank rec differences into causes and fixes

About this prompt

“Bank Reconciliation Unreconciled Items Triage” is a free prompt for ChatGPT in the Business category, 182 words long, added to The Prompt Index on October 28, 2026 by The Prompt Index. Copy it with the button above, paste it into ChatGPT or any other AI chat assistant, and send it.

It has 4 placeholders to fill in first: {{PERIOD_END}}, {{LEDGER_BALANCE}}, {{BANK_BALANCE}}, {{UNMATCHED_ITEMS}}. Use the “Customize this prompt” fields to personalise it before you copy.

Recommended models: ChatGPT, Claude, Gemini.

0 upvotes, sent to an AI tool 0 times, viewed 8 times.

Browse all Business prompts, the AI prompt database or use the AI prompt finder to search every prompt.