Prompt Almanac

Audit intermediate Works with: Any AI

SQL Report Totals Reconciliation Check

Table output

Build a set of reconciliation queries and a comparison table to prove a SQL report matches its source, with explanations for any gaps.

Open in ChatGPTOpen in Claude

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.

Rate this prompt

Loading ratings…

I need to prove that the totals in a SQL-based report match the source system. Report name: [REPORT_NAME]. The report query is: [QUERY]. The source figures I am comparing against (from an accounting system, finance export or business owner) are: [SOURCE_FIGURES]. Reporting period: [PERIOD]. Database: [DATABASE_TYPE].

Create: 1) A reconciliation plan in numbered steps from the highest level (grand total) down to detail (by month, by category, by customer), stopping when the difference is found. 2) The matching SQL queries for each step, simple enough to read at a glance. 3) A reconciliation table template with the columns Level, Report figure, Source figure, Difference, Difference as a percentage of the source, Explained?, and Explanation. 4) A list of the usual causes of differences for this kind of report: cut-off dates, cancelled or voided rows, currency and rounding, duplicates, late postings, test data, filtered statuses. Rank them by how likely each is for my situation. 5) Rules for tolerances: what difference is acceptable, written as a suggestion for the owner to confirm.

Rules: do not claim that figures match; you have no access to my data. Show the arithmetic whenever you calculate a difference from numbers I pasted. Mark any accounting or tax treatment [VERIFY] with finance, because this is analysis help and not accounting advice. Use a read-only connection and keep a dated record of queries run.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

Related prompts