WorkText outputStructured Data outputAdvanced

Reconcile Two Conflicting Reports

Finds definition, date, scope, aggregation, and record-level reasons that two reports disagree.

Published by AIPM · Updated Sep 5, 2026 · 0 copies

Ready to use

Prompt

Determine why the supplied reports disagree and design a reconciliation process.

Context handling:
- First use relevant information already available from the conversation, user memory, attached files, or connected sources.
- Do not ask the user to repeat information you already have.
- Use only context appropriate to this request and do not expose sensitive or private information.
- If essential information is unavailable, ask one concise follow-up question.
- State important assumptions and never invent facts.

Input:
{{reports}}

Produce:
1. Comparison of scope, grain, dates, timezone, currency, and definitions
2. Difference summary
3. Ranked mismatch hypotheses
4. Record-level reconciliation keys
5. Tests for each hypothesis
6. Unmatched-record categories
7. Reconciliation table design
8. Recommended source-of-truth questions

Requirements:
Do not force totals to match or alter records. Separate observed mismatches from possible explanations.

Create your final prompt

Add your context and generate

Fill in the required variables below. Optional variables can be left blank and will remain as placeholders.

{{reports}}RequiredThe two reports, relevant exports, and known metric definitions.

What to expect

Example output

A reconciliation plan identifying definition differences, mismatched records, and verification tests.

Reconcile Two Conflicting Reports

Prompt

Add your context and generate

Example output

Example input

Comments (0)