Choose the comparison before calculating the difference.
An estimate, approved budget, contract value, invoice and payment describe different states. Do not subtract unlike figures and label the result a loss. Choose a baseline for the same scope, time period, quantity, currency and tax basis, and explain why it is the relevant comparison.
Keep actual expenditure, unpaid liability, forecast cost and opportunity cost in separate columns. An approved ceiling is not money paid. A disputed invoice is not automatically an economic loss. A reduced asset value needs a different method from a construction-cost reconciliation.
Keep one row per work item.
| Column | What belongs there |
|---|---|
| Item and entity | Stable work-item ID, project/phase and contracting or paying entity. |
| Baseline | Quantity, unit rate, amount and controlling source for the compared scope. |
| Authorized change | Scope difference, approval status, price and any ceiling or conditions. |
| Billing and cash | Invoice lines, certified amount, payment allocation and unpaid balance, kept distinct. |
| Offsets | Credits, refunds, recoveries and avoided cost, with the reason and source. |
| Working variance | Like-for-like difference, with calculations and assumptions exposed. |
| Causal and legal status | Explanation tested, alternatives, disputed amount and adviser questions. |
Link each number to a source location and retain the calculation. Match change orders, invoices and payments instead of adding them together: they may be different records of the same work. If one invoice or payment spans several items, record the allocation basis and retain any unallocated amount separately. Split mixed items where a portion is new owner scope and a portion may be rework.
Explain the arithmetic without overselling it.
Illustrative example, not a damages model: all figures are CAD, cover the same period and scope, and use the same tax basis. The like-for-like baseline is $100,000. Agreed new scope is $12,000. Allocated payments made are $125,000, followed by a $5,000 cash refund received that is not already netted in that payment total. Net cash outflow is $120,000; the scope-adjusted baseline is $112,000; the working variance is $8,000.
That $8,000 is a question to explain, not a recoverable claim. A credit applied against an unpaid balance would not, by itself, reduce cash already paid. Check timing, quantities, taxes, refunds already netted, unpaid work and whether the comparison omits another legitimate scope change. Then test which events contributed to any unexplained portion. A legal adviser and, when needed, a qualified accounting or valuation professional can assess the proper measure.
Check the traps that make a total look larger.
- Do not count a change order and its invoice as two costs.
- Do not subtract a credit twice because it appears on both a statement and an invoice.
- Keep tax-inclusive and tax-exclusive figures consistent; do not assume tax recoverability.
- Separate paid amounts from commitments, retainage, forecasts and disputed balances.
- Do not attribute an entire overrun to one event when several causes remain plausible.
- Keep currency conversion dates, rates and rounding methods explicit.
- Separate cost to repair from a claimed reduction in value where they describe overlapping effects.
Use ranges with reasons, not precision without support.
When the record is incomplete, label the affected amount and the missing discriminator. A low and high scenario should correspond to explicit assumptions, not a confidence percentage invented by the reviewer. Keep unquantified issues outside the numerical total until a defensible basis is available.
For owners and family offices, reconcile at the legal-entity and project level before producing a portfolio view. The entity that paid, the entity with a contractual right and the entity bearing a claimed loss may not be the same. Counsel should resolve rights, standing and recoverability.
Protect the legal clock outside the spreadsheet.
Do not wait for a complete loss model before asking qualified counsel about limitation periods, contractual notices, insurance notifications or other deadlines. Keep an event and notice register with sources and ask counsel to confirm the relevant dates and required steps. Do not assume a records request, complaint, discussion or payment pauses a deadline.
Cyberdile’s record work does not determine legal rights, extend a deadline, provide a valuation opinion or guarantee recovery. The ledger gives advisers a checkable starting point and identifies the next record that would change the amount or explanation.