Type four figures, get the per-job columns a surety-ready WIP schedule carries — plus a preview of what this job looks like inside WIPwise. Computed on your device, nothing sent anywhere.
Single-job view — assumes no retainage or change orders.
This is a single job. Your real book has dozens.
WIPwise builds the whole multi-job schedule and surety package from QuickBooks Online, automatically.
Join the waitlistThis uses the cost-to-cost percentage-of-completion method: percent complete is cost to date divided by estimated total cost, and earned revenue is contract value times percent complete. Over or (under) billed is billed to date minus earned revenue — a positive number means you've billed ahead of the work (a liability), a parenthesized number means you've done work you haven't billed for yet (an asset). From the same four numbers it also derives cost to complete, remaining backlog, and estimated gross margin — the per-job columns a surety-ready WIP schedule carries — and flags any single job whose overbilling reaches 15% of its contract, the concentration level bonding companies watch.
Two edge cases the naive formula gets wrong: if the estimated cost to complete ever exceeds the contract value, accounting rules require recognizing the entire estimated loss immediately — not spreading it across percent complete. And if cost to date ever exceeds the estimate, the estimate itself is out of date; trusting the ratio at that point would only compound the error, so this calculator flags it instead of showing a number above 100%.