Where the fact lives, who owns it, what proves completion, and what happens if it fails.
Every row is a decision somebody has to make and record. Where a row cannot be completed, that gap is the next piece of work — and it is also the decision an automation would otherwise make on your behalf, silently.
| The fact | Where the fact lives | Who owns it | What proves completion | What happens if it fails |
|---|---|---|---|---|
| Customer identity | Customer record system | Named owner of the record | One record, with its source and creation time | A second record for the same customer is queued for merge, not created silently |
| Contact and billing details | Customer record system | Named owner of the record | The change is dated and attributed to a person | A change that does not reach the accounting system returns to that owner with the failure attached |
| Agreed price and terms | The accepted quote version | Named owner of the deal | An order that names the quote version it accepted | An order with no matching quote version is held for review before it can be invoiced |
| Order status | Order system | Operations lead | A status the customer would recognise, set by the step that caused it | A status older than its review date appears on the daily list, next to its owner |
| Fulfilment evidence | Order system | Operations lead | A completion record attached to the order — not a message about it | Work marked complete without evidence is reopened, not invoiced |
| Invoice and payment | Accounting system | Finance | Payment reconciled against the order it belongs to | Past terms assigns a named follow-up owner, not an automated reminder |
The three matching rules the sheet depends on
- Two customer records are the same customer when they share the agreed stable customer or account identifier
- Which identifier that is gets decided for this business and recorded here. A similar name at a similar address is an ambiguous match, not a match, and is not treated as one.
- An ambiguous match goes to a named owner, not to an automatic merge
- Both records are shown side by side, the owner explicitly selects which becomes the master, the merge is logged and the history from both is retained on the surviving record.
- Corrections are made in the authoritative system
- Copies held downstream carry a stated update rule — when they refresh, and how far behind they may acceptably run. Corrections flow outward from the authoritative record, so there is no second place where the truth is changed independently.
Illustrative sample. Every row answers the same four questions, and the answers shown here are written to demonstrate the format rather than to prescribe a policy — a real sheet records what this business decides. A row that cannot be answered is a decision waiting to be made by somebody, deliberately or otherwise.