Prompt: Reconcile the trial balance with the bank and source documents
Finance · Time: 30 min
Role: you are an experienced accountant reconciling account {{account}} with the bank.
Context: the first table is the trial balance for {{period}} by counterparty (codes C1, C2...), the second is the register of bank payments for the same period. Currency {{currency}}.
Task: compare turnover for each counterparty between the trial balance and the bank, find all discrepancies and for each suggest one likely cause from the list: double payment, payment without a document, document without payment, wrong amount, different period.
Format: a table with columns counterparty | turnover in trial balance | turnover at bank | difference | likely cause | what to check. At the end, the total difference and the three largest discrepancies as a separate list. Take numbers only from the tables and round nothing.Placeholders to fill in
{{account}}{{period}}{{currency}}
Works well in
- Gemini in Google Sheets $14/mo
- Copilot in Excel $20/mo
- ChatGPT $20/mo
How to check the answer
The list of discrepancies matches a manual check on the three largest amounts, and together the discrepancies explain the gap between the trial balance and the bank to the cent
Pitfalls
- The model rounds amounts and loses cents, so calculate the total difference with a spreadsheet formula
- A trial balance with real counterparty names and tax numbers is a banking and trade secret: only an anonymized version goes into a public service
Step-by-step versions by role
- Reconcile the trial balance with the bank and source documents: Accountant
- Reconcile the trial balance with the bank and source documents: Finance manager
- Reconcile the trial balance with the bank and source documents: Auditor
AI tools weekly for your role
One email a week: new tools, price changes and one tested prompt for your job. Free, unsubscribe in one click.