Account Reconciliation Investigator
Walks an unreconciled balance to its root cause with a structured reconciling-items breakdown and clearing plan.
Prompt
ROLE: You are a reconciliations specialist resolving a balance sheet account that does not tie out. CONTEXT: Account: [ACCOUNT_NAME]. GL balance: [GL_BALANCE]. Supporting source balance (subledger/bank/statement): [SOURCE_BALANCE]. Difference: [DIFFERENCE]. Detail available: [TRANSACTION_DETAIL]. TASK: 1. Restate the reconciliation: GL balance, source balance, and the gap to explain. 2. Categorize candidate reconciling items: timing differences (in-transit, unposted), errors (duplicates, transpositions, wrong account), missing entries, and FX revaluation if applicable. 3. For the provided detail, walk through systematically and attribute amounts to categories until the gap is fully explained or a residual remains. 4. For each reconciling item, state whether it self-clears (timing) or requires a correcting entry. 5. Draft the correcting journal entries needed. OUTPUT FORMAT: (1) Reconciliation summary block. (2) Reconciling items table [Item | Amount | Category | Self-clears or JE]. (3) Proposed correcting entries. (4) Unexplained residual, if any, with next steps. CONSTRAINTS: Do not force a tie-out by plugging—if a residual remains, say so. Show the arithmetic. Distinguish timing from error explicitly. Every correcting entry must balance.
How to use this prompt
- 1
Copy the prompt above and paste it into ChatGPT, Claude, or Gemini — or open it in the visual Studio to edit each part on a canvas and run it with your own key.
- 2
Replace any bracketed placeholders with your specifics. The more concrete your context and constraints, the sharper the result — see the 5-part prompt structure.
- 3
Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.
Techniques in this prompt
Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.
Learn this techniqueRecommended models
Build on this prompt
Open it in the visual Studio to wire it into a full workflow with your own API key — or learn the craft behind prompts like this.
More in Finance & Accounting
Three-Statement Model Architect
Builds a fully integrated three-statement financial model with linked schedules, drivers, and circularity controls.
DCF Valuation With Sensitivity Grid
Produces a defensible discounted cash flow valuation with WACC build, terminal value cross-check, and sensitivity tables.
Month-End Close Checklist Builder
Generates a sequenced, owner-assigned month-end close checklist with cutoffs, dependencies, and review gates.
Variance Analysis Narrative Writer
Turns budget-versus-actual numbers into a crisp executive variance narrative with drivers, materiality, and actions.