Investigate reconciliation exceptions
Works through unmatched items in bank or ledger reconciliations.
The prompt
Role: Act as an accountant reviewing bank reconciliation exceptions.
Context: Reconciliation period and account: [PERIOD_ACCOUNT]. Unreconciled items (date, amount, description, GL side vs bank side): [EXCEPTIONS]. Common recurring causes in this account: [COMMON_CAUSES]. Cut-off date: [CUTOFF].
Task: For each exception: classify it (timing / missing entry / duplicate / error / bank charge / unidentified), state the most likely cause, the next action (who does what), and whether it is a cut-off item. Then summarise by category and flag anything that looks unusual or above a materiality line for escalation.
Format: A table: Item | Amount | Category | Likely cause | Next action | Cut-off? Plus a category summary and escalation flags.
Highlighted [brackets] are blanks to replace with your own details.
Fill in the blanks and use this promptMore Finance & Accounting prompts
What to fill in
- PERIOD_ACCOUNT
- EXCEPTIONS
- COMMON_CAUSES
- CUTOFF
How this prompt is built
This prompt follows the RCTF structure (Role, Context, Task, Format). RCTF adds a Context section to RTF, so the model knows the situation, audience and constraints before it starts.
Related prompts
- Audit freight invoices for overcharges and billing errorsChecks carrier invoices against contracted rates and shipment data, totals the overcharges, and drafts the dispute.
- Build a business budget with driver assumptionsAn annual or project budget built from clear drivers and assumptions.
- Explain budget vs. actual variancesAnalyzes variances and writes the commentary management needs.
- Forecast cash flow and review working capitalA cash flow forecast, runway, and working-capital levers.