Paste or upload your job list and see over/under billing, earned revenue and gross profit by job in seconds. Then download a ready-to-use Excel WIP schedule with the formulas built in.
Showing example jobs. Replace them with yours, or upload your job cost export.
| Job | Contract value | Est. total cost | Cost to date | Billed to date | Original est. cost (optional) |
|---|
| Job | % complete | Earned revenue | Billed to date | Over / (under) | Est. GP % | Left to bill | Flags |
|---|
Enter your details and the download starts right away. Your job numbers stay in your browser; only these form details are sent.
This calculator uses the cost-to-cost method, the most common way contractors measure percentage of completion:
Add the original estimated cost and it also shows margin fade: how many points of gross profit a job has lost since it was bid.
Over-billed jobs have invoiced ahead of the work. The excess is a liability on the balance sheet (billings in excess of costs), and it often means one job's cash is funding another.
Under-billed jobs have earned revenue that hasn't been invoiced yet (costs in excess of billings). You are financing the owner, and lenders and sureties watch it closely.
A portfolio total can look fine while individual jobs are far off in both directions, which is why WIP has to be read job by job.
No. The calculations run in your browser and your job numbers are never sent to us or stored. If you request a download, only your name, email and company go through the form.
Cost-to-cost percentage of completion, an input method widely used for construction revenue under ASC 606. If your company measures progress differently, the formulas in the Excel file are easy to adjust.
Yes. It has the formulas built in for at least 40 jobs, plus a totals row. Enter contract value, estimated cost, cost to date and billed to date, and the rest calculates.
Export the job cost report to Excel or CSV and upload it. The calculator matches common column names automatically. If you want WIP to update itself from the ERP instead of being rebuilt by hand every month, that's what we build.
We connect Sage Intacct and your other systems to a data warehouse and Power BI, so WIP, job cost and margin by job and project manager update automatically and tie to your general ledger.
See how it works