Reconciliation and Discrepancy Hunting prompts for Accountant
Ready-to-use AI prompts for reconciliation and discrepancy hunting — written for Accountant and easy to paste into ChatGPT, Claude or Gemini.
When you need reconciliation and discrepancy hunting done, these accountant prompts give you a fill-in-the-blanks starting point covering reconciliation, bookkeeping, audit. Fill in fields like account, period, amount and paste the result into ChatGPT, Claude, or Gemini.
Find why the reconciliation is off
You are a staff accountant helping troubleshoot a reconciliation. Account: [account]. Period: [period]. Book balance: [amount]. Statement balance: [amount]. Difference: [amount].
Transactions:
<data>
[transactions]
</data>
Work through the usual suspects in order and tell me which the numbers actually support: timing differences, transposition errors (check whether the difference is divisible by 9), duplicated entries, sign errors (difference divisible by 2), missing fees or interest, FX differences, and items posted to the wrong period or account.
Output: the most likely explanation with the arithmetic that supports it, the specific transactions to inspect, and the journal entry to correct it if confirmed. Say clearly when the data provided is insufficient to conclude.
Build a reconciliation procedure
Act as a controller documenting a repeatable process. We reconcile [account type] in [system] every [frequency]. Current pain points: [pain points]. Team: [team].
Write a step-by-step procedure a new hire could follow: source documents to pull, matching order, tolerance thresholds and who approves exceptions above them, how to document unmatched items, sign-off and review, and the evidence to retain for audit.
Add a short list of the errors this process is specifically designed to catch, and the ones it will not catch (so we know the residual risk). Flag any step where segregation of duties matters. Present as a numbered procedure plus a one-page checklist version.
Write the Excel or formula logic
You are an Excel and spreadsheet expert working with an accountant. My data: [data]. What I need: [desired output].
Give me the formula (Excel [version] / Google Sheets), written to be readable rather than clever, with each part explained in one line. If a helper column makes it simpler and more auditable, use one and say why.
Then tell me: how the formula behaves on blanks, text-formatted numbers, duplicates, and dates stored as strings — the four things that break accounting spreadsheets. Include one test row I can use to confirm it works before I trust it on the full file.
How to use this prompt
Fill in the blanks. Type your details into each highlighted field of this reconciliation and discrepancy hunting prompt — fields like account, period, amount — and it rewrites itself live.
Copy the prompt. Press Copy prompt to put the finished reconciliation and discrepancy hunting prompt on your clipboard.
Paste into your AI model. Paste it into ChatGPT, Claude, Gemini, or any chat LLM to get your reconciliation and discrepancy hunting result.
Review and iterate. Read the response as a accountant would, then adjust fields like account, period, amount and re-run to sharpen it.
Fill-in fields explained
account
Your account.
period
Your period.
amount
Your amount.
transactions
paste both sides, or the unmatched items
account type
Your account type.
system
Your system.
frequency
Your frequency.
pain points
Your pain points.
team
who does it and their experience level
data
describe columns and sheets, with a sample of 5 rows
desired output
e.g. flag statement lines with no matching ledger entry within 3 days and 2 dollars
version
Your version.
Frequently asked
Which AI models does the Reconciliation and Discrepancy Hunting prompt work with?
The Reconciliation and Discrepancy Hunting prompts for Accountant are plain-text and model-agnostic — paste them into ChatGPT (GPT-4o), Claude, Gemini, Llama, or any other chat model.
How do I customize the Reconciliation and Discrepancy Hunting prompt for my own use?
Fill in the 12 labelled fields (account, period, amount, …) before copying, or edit the [bracketed] text after you paste.
Are the Reconciliation and Discrepancy Hunting prompts for Accountant free to use?
Yes. Every Reconciliation and Discrepancy Hunting prompt here is free to copy and reuse, including for commercial and client work, with no sign-up.