Review time is lost when the same measure appears in different reports with different formulas, reporting grains or source fields and no clear owner sign-off route.
KPIs, Definitions & Data Quality
Metric Reconciliation Pack
A metric reconciliation workbook comparing the same measure across recurring reports, including differences in formula, detail, source fields and sign-off.
Metric reconciliation workbookOpen image
Rendered from the included Excel reconciliation workbook after the five report values and tolerance counts were verified.
Metric reconciliation
Formula and source differences traced before figures are discussed.
Metric disagreements can be resolved before review because the report versions, variance reasons and sign-off actions are visible together.
Useful forReporting ownersPerformance teamsFinance managersMetric owners
Which version of the metric should be used, why do reports differ, what sits outside tolerance and who signs off the agreed definition?
An Excel reconciliation workbook comparing five report versions, formulas, reporting grains, source fields, variance reasons and owner sign-off actions.
How the work fits together
The same measure is compared across reports before one definition is agreed.
Formula, timing and source differences are set out beside each other, with an owner and a clear point for sign-off.
01Source
What the work starts with
- Five report versions of open item rate
- Numerator, denominator and formula records
- Source field and reporting detail register
02Prepare
How it is prepared
- Completed Excel reconciliation workbook
- Calculated value and tolerance verification
- Owner sign-off and follow-up route
03Check
Checks applied
- Five reported values recalculated
- Three versions outside +/-0.2pp tolerance
- Two open owner sign-offs
04Output
What the review receives
- Report comparison table
- Variance explanation route
- Owner sign-off queue and reference decision
05Handover
Notes for the next update
- Management pack definition held as reference
- Reopened-item and reporting-grain actions retained
- Build assertions and workbook retained
- Excel
- CSV report records
- Metric definition
- Reconciliation checks
- Metric reconciliation
- Formula comparison
- Source field mapping
- Owner sign-off
Metric disagreements can be resolved before review because the report versions, variance reasons and sign-off actions are visible together.
Built from a non-client example dataset. No protected data is used.
Resolving the difference
Reports stop arguing over the number and start comparing the rule behind it.
Compare the formulas, source fields, timing rules and owners behind the same measure in different reports.
- 01
The same measure is compared across reports so formula, timing and source differences can be discussed before review.
- 02
Checks separate matched metrics from formula mismatches, source mismatches and missing sign-off items.
- 03
Owner sign-off and any definition changes are recorded with the agreed output.
Points to resolve
Where formulas, source fields or reporting periods disagree.
Five recurring reports are compared against the agreed reference definition.
Three report values sit outside the agreed variance tolerance and need explanation.
Two owners need to confirm treatment before the definition is carried forward.
Comparison record
The report versions, calculation notes and limits included in the review.
What is included
- Report comparison
- Formula comparison
- Reporting grain review
- Source mapping
- Variance explanation
- Owner sign-off
- Follow-up note
What it can start from
- Five report versions
- Metric definition
- Source field mapping
- Validation checks
- Owner sign-off queue
What this example does not claim
- The reconciliation covers one metric across five report versions rather than a full metric catalogue.
- The reference definition and +/-0.2 percentage-point tolerance require metric-owner agreement.
- The workbook records inspected source rows and is not connected to live report sources.
Definitions pack overview
KPI Dictionary and Reporting Definitions Pack
- What is difficult now
- Reports lose trust when a shared KPI name hides different calculations, unclear source fields, assumptions or ownership.
- What the work helps decide
- Which KPI definitions are agreed, which need review and which downstream reports move when source fields or calculation rules change?
- KPI dictionary
- Reporting definitions
- Source mapping
Data quality review overview
Data Quality Checks
- What is difficult now
- Reports become unreliable when missing owners, duplicates, stale files, invalid periods and unmatched references surface during review.
- What the work helps decide
- Can this data be used in the report, what failed, how severe is it, who owns the fix and which output is affected?
- Quality check
- Failed record review
- Source confidence
Data issue triage register
Data Issue Triage Register
- What is difficult now
- Data issues become hard to resolve when intake notes, severity, impacted reports, source owners, fix status and retest outcomes sit in separate places.
- What the work helps decide
- Which issue blocks a report, who owns the source fix, what has been retested and what limitation needs to be carried into review?
- Data issue triage
- Impacted report
- Retest status
Next step
Resolve metric differences before review.
Start with the measures people dispute or the failed checks that need clearer ownership before reporting.