Audit advanced Works with: Any AI

Reconciliation Between Two Data Sources

Table output Has example

Compare systems and explain differences.

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

Help me reconcile two data sources and explain differences. Source A (name, owner, what it measures): [SOURCE_A]. Source B: [SOURCE_B]. Period: [PERIOD]. Totals in each: [TOTALS]. A sample of rows from each with key fields: [SAMPLE_ROWS].

Return tables:
1. Reconciliation bridge: Starting total in A | Adjustment (item and amount) | ... | Ending total compared with B | Unexplained difference.
2. Difference categories: Category (timing, duplicates, missing in one source, different definitions, rounding, currency, filters, test data) | Count of rows | Amount | Example | Evidence.
3. Row-level matching plan: key to match on, steps, and formula or query to find rows in A not in B, B not in A, and amount mismatches.
4. Definition comparison: metric | definition in A | definition in B | impact.
5. Follow-up list: Question | Who can answer | Needed to close the gap.

State a tolerance (absolute and percent) below which differences are accepted, and document that decision. Show the arithmetic for the bridge using my numbers, and never force the bridge to zero with an invented adjustment; leave the remainder as "unexplained".

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.

Reconciliation bridge (fictional, March)
Billing system total: 184,200.00
Less: invoices dated 31 March but posted in April (timing): -6,400.00
Less: duplicate entry of INV-2291: -1,250.00
Add: refunds recorded in the ledger only: +900.00
Adjusted: 177,450.00 | Ledger total: 177,430.00 | Unexplained difference: 20.00 (0.01 percent, within tolerance of 50).
Differences by category: timing 3 rows, duplicates 1 row, definition (the ledger is net of refunds) 12 rows.
Row-level match: join on invoice number; find rows in A not in B with a lookup; compare amounts after rounding to cents.
Follow-up: ask accounting whether 31 March invoices should post in March.

• reconciliation
• bridge