AI Tools for Work

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

Works well in

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

Step-by-step versions by role

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.