ACC-009 adds $16,000.
Meridian Works appears only in August. An added ID describes the file difference; it does not prove a newly acquired customer.
THE DIFFERENCE IS IN THE DETAILS
Two reports. A clearer picture.
Find what changed, what’s missing, and what needs a second look.
New here? Follow a complete comparison with source evidence.
Comparison setup
Updates automaticallyComparison results
Sample dataA WORKED EXAMPLE · FICTIONAL DATA
A higher total. One record worth checking.
A July-to-August revenue comparison: 8 before records and 9 after records, matched by Account ID. This example always uses the built-in sample, independently of any files selected above.
JULY$116,000
AUGUST$145,000
REPORTED CHANGE+$29,000
Every contribution has a place.
The four groups below reconcile to the reported change. Unchanged IDs contribute zero. Duplicate rows remain in the totals.
Changed unique IDs+$11,000
Added IDs+$16,000
Missing IDs−$5,000
Duplicate ID groups+$7,000
ACC-008 contributes −$5,000.
Common Ground is absent from August. Check source scope and timing before describing the missing record as customer churn.
ACC-007 needs a second look.
Cedar Group has one $7,000 row in July and two identical $7,000 rows in August. The summed contribution is +$7,000. The tool flags it and keeps both rows.
See all 9 ID contributions and source record numbers
| ID | Status | July | August | Change | July rows | August rows |
|---|---|---|---|---|---|---|
| ACC-001 | Changed | $28,000 | $36,000 | +$8,000 | 1 | 1 |
| ACC-002 | Changed | $22,000 | $26,000 | +$4,000 | 2 | 2 |
| ACC-003 | Changed | $18,000 | $15,000 | −$3,000 | 3 | 3 |
| ACC-004 | Unchanged | $15,000 | $15,000 | $0 | 4 | 4 |
| ACC-005 | Changed | $12,000 | $14,000 | +$2,000 | 5 | 5 |
| ACC-006 | Unchanged | $9,000 | $9,000 | $0 | 6 | 6 |
| ACC-007 | Duplicate ID | $7,000 | $14,000 | +$7,000 | 7 | 7, 8 |
| ACC-008 | Missing | $5,000 | $0 | −$5,000 | 8 | Absent |
| ACC-009 | Added | $0 | $16,000 | +$16,000 | Absent | 9 |
A SUMMARY YOU CAN DEFEND
Reported revenue increased $29,000, from $116,000 to $145,000. One added ID, one missing ID and changes to existing IDs explain the movement. Of the increase, $7,000 comes from a duplicate ID group that needs source review; the other contributions net to $22,000. Verify the repeated row before interpreting the increase as business growth.
Loading or inspecting this sample replaces the current comparison with fictional reports. Nothing is uploaded, deleted from your files or automatically corrected.+25%116,000 → 145,000
What drove the change?
Largest contributions to revenue
All 7 contributions reconcile to +29,000.
THE READOUT
An increase, with a story behind it.
Revenue moved from 116,000 to 145,000 (+29,000; +25% relative to the absolute prior total). 1 added IDs, 1 missing IDs, and 4 uniquely matched IDs with changed fields. Largest contribution: ACC-009, +16,000. 1 IDs need duplicate review; all duplicate rows are included in totals. These are arithmetic contributions, not proven business causes.
Calculated from your records
!
A quick data check before you share
1 duplicate ID group may affect the totals. Review the source rows before drawing conclusions.