A failed refresh should leave an honest report
Try a local reporting refresh with reconciliation, source versions and deliberate input failures. The last checked sample stays available.
Invented demonstration. These records, procedures, approvals and results describe a fictional example, not a client delivery.
A report needs to show what it contains, when its source was read and whether the latest refresh succeeded. This local example uses selected bills from the invented invoice ledger.
Try a candidate batch and compare the output with its source control total. A failed or stale candidate leaves the last checked output intact. The readable walkthrough explains the same checks without running them.
Fixed fixture clock: . This sample covers selected invented bills, not the full materials-cost figure on the homepage.
The initial sample reconciles at the fixed fixture clock.
Last checked output
| Source record | Amount |
|---|---|
| BILL-7731 | $3,412.50 |
| BILL-7719 | $1,184.00 |
| BILL-7740 | $915.00 |
| Checked row total | $5,511.50 |
| Source control total | $5,511.50 |
Matching totals establish reconciliation within this sample. They do not resolve whether two different bills describe the same purchase.
Read the refresh walkthrough
- Read a complete candidate with its source identity, reporting period and timestamp.
- Check schema, unique record IDs, valid amounts and agreement with the source control total.
- Compare its timestamp with the fixed fixture clock and the last accepted output.
- Replace the entire displayed output only after every check passes. Show a failed attempt separately.
- Valid next batch
- All source rows reconcile. The complete new sample replaced the previous output.
- Duplicate record ID
- Duplicate source record ID; the output was not replaced. Last checked output retained.
- Corrupt amount
- A source record has an invalid identity or amount. Last checked output retained.
- Stale source
- The candidate is stale or outside the fixture clock. Last checked output retained.
- Changed schema
- The schema or reporting period does not match this example. Last checked output retained.
- Missing reporting period
- The schema or reporting period does not match this example. Last checked output retained.
- Reconciliation mismatch
- The rows do not reconcile with the source control total. Last checked output retained.