The four numbers a contractor needs for every open job, in the order you calculate them.
Disclosure: Galaxy Forge sells a $49 spreadsheet that implements this method (see the end of the page). This article is complete on its own, and free alternatives exist.
A work-in-progress (WIP) schedule tells you, job by job, how much of the contract you have really earned compared with how much you have billed. Banks, sureties and buyers of a contracting business read it that way, and so should the owner. This is the cost-to-cost method, the most common one for small contractors; your CPA decides which method applies to your business.
A roofing job has a contract of $38,500. Costs to date are $36,000 and the estimate to complete is $2,500, so the revised total cost is $38,500 and the job is 93.5% complete. Earned revenue is $36,000. The contractor has already billed $38,500, so the job is over-billed by $2,500: the customer has paid for work that is still owed.
A bathroom remodel has a contract of $18,500, costs to date of $14,200 and $6,800 still to come. The revised total cost is $21,000, so the job will finish at a loss of $2,500 (-13.5%). Accounting practice is to recognise an expected loss as soon as it is known; show this line to your CPA.
Cost to date comes from the job-cost report in your accounting system plus invoices received but not yet entered. The estimate to complete should come from the person running the job: remaining labour hours priced at the loaded rate, materials still to buy and subcontract work still to be invoiced.
The workbook for this method has the formulas already built and checked, with an example filled in and a PDF guide. It costs $49, one time. View it on Gumroad.
New product, listed 2026-11-05: no sales or reviews yet. Example figures are illustrative. This page is general information, not legal, tax, financial or professional advice.