WorkText outputStructured Data outputAdvanced
Reconcile Two Conflicting Reports
Finds definition, date, scope, aggregation, and record-level reasons that two reports disagree. Why it matters: a ready draft saves you from a blank page.
Scanned · no issuesReady 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.
The two reports, relevant exports, and known metric definitions.
What to expect
Example output
A reconciliation plan identifying definition differences, mismatched records, and verification tests.
Example context
Example input
Attach both reports and any available metric definitions.
Data analysis and analytics prompts
More in this series
- SQL Result Narrative — ChatGPT Prompt
- Stakeholder Question Map — ChatGPT Prompt
- Survey Analysis Summary — ChatGPT Prompt
- Event Tracking Plan — ChatGPT Prompt
- Find Anomalies in My Spreadsheet
- Find Themes in User Feedback
- Create a Data Dictionary from a Dataset
- Turn a Dashboard into an Executive Narrative
- Metric Anomaly Investigation — ChatGPT Prompt
- Self-Serve BI Guide Outline — ChatGPT Prompt
- Board Metrics Appendix Notes — ChatGPT Prompt
- Cohort Analysis Explanation — ChatGPT Prompt
Keep exploring
Related prompts
Discussion
Comments (0)
Sign in to leave a comment.
Loading comments…