Free Excel templates

A free WIP schedule template in Excel, cost to cost

The year-end work-in-progress schedule of a fictional general contractor, job by job, cost to cost: percent complete, revenue earned, gross profit to date, overbillings, underbillings and the provision for loss, with the fade analysis, the pay application and the statements behind it.

Across the contractor's jobs, contract value is $70,396,000 and cost to date $46,056,000. Cost to cost gives $49,043,204 of revenue earned against $48,785,000 billed: $337,500 overbilled, $595,704 underbilled, and a $99,000 provision for loss on the job that will lose money.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 181 free models.

WIP_Schedule_Template.xlsx (46 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This model goes with The Construction Accountant, which explains the method behind it, chapter by chapter.

Get the book on Google Play →

Or the DRM-free PDF, $19.99 →

Want every model at once?

The Financial Model Library: all 182 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).

Get the Library, $79 →

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

What is in the file

7 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.

Loss
Fade
Billing
Payroll
Overhead
Statements
Checks

What the worked case returns

MeasureValue
Contract value, all jobs$70,396,000
Estimated total cost$66,172,000
Cost to date$46,056,000
Billed to date$48,785,000
Revenue earned to date$49,043,204
Gross profit to date$2,888,204
Provision for loss$99,000
Overbilled (billings in excess)$337,500
Underbilled (costs in excess)$595,704
Cost to complete$20,116,000

Percent complete is cost to date over estimated total cost, with uninstalled materials taken out of cost so they do not inflate progress. A job expected to lose money books the whole loss at once, not in proportion to progress. Change an estimate on WIP and the fade, the statements and the checks move with it.

How to use it on your own case

  1. Enter each job's contract value, estimated total cost, cost to date and billings on WIP.
  2. Enter uninstalled materials included in cost, so percent complete is not overstated.
  3. Read revenue earned, gross profit to date, over and underbillings and any loss provision.
  4. Check the fade sheet for margins that slipped since the last year end, then read the statements.

Questions people ask about it

What is a WIP schedule?

A work-in-progress schedule lists every open construction contract with its contract value, estimated cost, cost to date and billings, and computes the revenue earned under the percentage-of-completion method and the over or underbilling on each job.

What is the difference between overbilling and underbilling?

A job is overbilled when billings exceed the revenue earned to date, a liability on the balance sheet. It is underbilled when revenue earned exceeds billings, an asset. Sureties and banks read large underbillings as a warning sign.

How is percent complete calculated?

Under the cost-to-cost method, percent complete is cost incurred to date divided by the current estimate of total cost, excluding costs such as uninstalled materials that do not measure progress.

Is this template really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

The free workbooks of The Construction Accountant go further: the full companion set, blank models and the worked cases of the book.

See the book and its free files →

Other free templates

This template goes with The Construction Accountant. See the book.