Updated November 2026

WIP schedule calculator

Percent complete, earned revenue, and over/(under) billing for one job from five inputs — the GAAP cost-to-cost method, the same engine Footing runs on every job in a schedule.

Calculator

$

Signed contract value before change orders.

$

Signed and approved only. Leave blank for none.

$

Your current forecast of all costs to finish the job.

$

Job-to-date costs on the books.

$

Job-to-date invoices issued, including retention.

Result

Fill in the contract, estimated total cost, costs to date, and billings to date. Change orders are optional.

This is one job. A schedule is every job, every month, footed.

Footing runs this math for every active job from the reports QuickBooks already exports, then produces the surety-format PDF and the month-end journal entry.

How the numbers are computed

Percent complete is costs to date divided by the revised estimate (original estimate plus approved commitment change orders), capped at 100%. The method is cost-to-cost: progress is measured by money spent, not by inspection or billing.

Revenue earned is percent complete times the revised contract (original contract plus approved change orders). It is what GAAP says you have earned so far, whether or not you have invoiced it.

Over/(under) billing is billings to date minus revenue earned. Positive means you have billed ahead of the work: a liability, billings in excess of costs and estimated earnings. Negative means you have done work you haven't billed: a contract asset, costs and estimated earnings in excess of billings. The month-end journal entry books that difference and reverses it the next period.

Estimated cost to complete is the revised estimate minus costs to date. If costs already exceed the estimate the job is flagged over budget and percent complete stays at 100% until the forecast is updated. That flag, and the trend of estimated gross profit against the original, is what a surety underwriter reads first.

What this calculator leaves out

Retention, current-period splits, backlog, and gain/(fade) against the original estimate need more than five inputs and a prior period to compare to. They are all on the schedule in Footing; the free template covers the one-job math in a spreadsheet you can keep.