Keep each row to the few fields that make the comparison meaningful. The goal is a glanceable history, not a full project ledger. These are the metadata to capture per completed job.
- Job / project name
- A short label so each row is identifiable, e.g. 'Spring 2026 website refresh' or 'Q1 brand photo shoot.' One row per completed, fully billed job.
- Date estimated
- When you sent the original quote or estimate. Useful for seeing whether your accuracy is improving over time as you log more jobs.
- Estimated amount
- The figure you originally quoted the client, taken from the accepted estimate. Enter it manually; this is the 'before' number in the comparison.
- Finally-billed amount
- The total you actually invoiced when the job closed, including any approved add-ons. This is the 'after' number that reveals the gap.
- Variance
- The difference between estimated and finally-billed, recorded as both a dollar amount and a rough percentage, e.g. +$1,200 / +30% or -$400 / -8%.
- Reason for the gap
- One line explaining why it moved: scope growth, extra revisions, a discount you gave, an underestimate of hours, or a change the client requested.
- Attached estimate & invoice
- Links to the accepted quote document and the final invoice for that job, so both figures are verifiable from the row.