ResolveOpsThe same label can describe different measures
An order report and an invoice report may both call a column “sales.” One counts the order when it is placed; the other counts the invoice when it is issued. Canceled orders and late invoices affect them differently, even when both reports work as designed.
Before comparing totals, write down the event each report measures and the decision it supports. Include the source record, date field, eligible statuses and treatment of credits or returns. The team may need two named measures with a reconciliation between them.
Match records before totals
Choose one period and match records using a stable identifier. Retain each report's value and period beside the source record so the cause of a difference remains visible.
One missing transaction and one duplicate of the same amount can cancel each other out in a total. Check which records are included as well as whether the sums agree.
| Difference | Check | Keep with the reconciliation |
|---|---|---|
| Record missing from one report | Extraction time, eligibility filters and transaction status | The source identifier and the rule that included or excluded it |
| Same record, different period | Order, invoice and posting dates; time-zone boundaries | The date field used by each report |
| Same record, different amount | Credits, tax, currency conversion and manual adjustments | The calculation and any adjustment reference |
| Record appears more than once | Join cardinality and duplicated source or transfer records | The rows that created the duplicate |
Keep unexplained differences open
Classify an item only when the evidence supports the explanation. If a source record is missing or the adjustment cannot be traced, keep the item on an unresolved list with a responsible person. Do not label it a timing difference merely because it may clear next month.
If an authorized balancing adjustment is needed, retain its reason, approval and reference separately from the reconciliation findings. Making totals agree does not explain the underlying difference. Accounting decisions remain with the people responsible for them.
Maintain the definition with the report
Save the source fields, filters and timing rules with the query or report instructions. Name the role that can approve a definition change and the person responsible for implementing it. A technical edit can change the meaning of a metric even when its label stays the same.
Repeat the check on another period that includes a known exception. Keep the sample and expected differences as a test for later changes to the report.