Two reports with different totals reconciled line by line
Explains why two reports that should agree, such as a sales dashboard and the accounts ledger, or a CRM count and a billing count, show different totals, and walks the gap down to named causes with amounts. Use it before a review meeting when two teams bring different numbers for the same thing.
The output this prompt produced, unedited.
The prompt
What to give
Report A: its name, source system, total and how it is built: [paste]
Report B: its name, source system, total and how it is built: [paste]
The period and the filters each uses: [e.g. October, India only, excluding test orders]
Sample rows from each, with IDs where possible: [paste]
Any known rule differences: [e.g. finance counts revenue on delivery, the dashboard on order]
Check each of these in order
Period boundaries: time zone, cut-off time, order date or payment date.
Scope: regions, channels, test records, internal accounts, cancelled items.
Definitions: gross or net, with or without tax, shipping and discounts.
Timing: refunds, returns or credit notes booked in a different period.
Duplicates and missing records: IDs in one report but not the other.
Currency, rounding and unit differences.
Output format
A bridge: Report A total, then one line per difference with its amount, ending at Report B total.
| Difference | Amount | Cause | Which report is right for this use | Owner |
One written definition both teams can adopt, in two sentences.
Any gap left unexplained, with the next query to run.
Guardrails
Never force the bridge to balance; show the unexplained amount honestly.
report reconciliationnumbers do not matchdata mismatchdashboard vs financemetric definitiondata audit
How to run this
Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.
The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.