The Construction WIP Schedule: How to Read It, With an Example

work in progress schedule

A work in process (WIP) schedule is a monthly report that shows, job by job, how much each contract is worth, how much it has cost so far, how much revenue you’ve earned, how much you’ve billed and how much profit you expect to make. It tells you which jobs are making money, which are slipping, and whether your billing is ahead of or behind the work. Banks and sureties rely on it to decide on credit lines and bonding.

It’s also called the work in progress schedule or the contracts in progress schedule. Whatever the name, it should be updated every month and tie to your financial statements.

What’s on a WIP schedule

Each job gets one row. The columns that matter most:

  • Contract amount, including approved change orders
  • Estimated total cost, updated each month by the project manager
  • Cost to date from job costing
  • Percent complete: cost to date divided by estimated total cost
  • Earned revenue: contract amount times percent complete
  • Billed to date
  • Over or under billing: billed to date minus earned revenue
  • Estimated gross profit for the whole job, and gross profit earned to date
  • Cost to complete and backlog: the work and revenue still ahead

Don’t trust the system’s cost to complete

Most accounting systems figure cost to complete as the budget minus cost to date. Put a $10,000 drywall budget in, spend $8,000, and the system says $2,000 is left. That’s just math. If the job is only 30% done, your project manager may tell you $6,000 is left. That’s why we update the WIP with each project manager every month instead of accepting what the system says.

A sample WIP schedule

An example with two jobs (numbers are for illustration):

Job AJob B
Contract amount$1,000,000$600,000
Estimated total cost$850,000$480,000
Cost to date$425,000$360,000
Percent complete50%75%
Earned revenue$500,000$450,000
Billed to date$550,000$400,000
Over (under) billed$50,000 over($50,000) under
Estimated gross profit$150,000 (15%)$120,000 (20%)
Gross profit to date$75,000$90,000

Add the two jobs together and billings match earned revenue exactly, so the company looks fine. Job by job, it isn’t: Job A has billed $50,000 ahead of the work, and Job B is $50,000 behind. That’s why the WIP is read one row at a time.

Want to try it with your own jobs? Download our free WIP schedule template (Excel). Job A and Job B are filled in, and the formulas do the math for every job you add.

How to read over and under billings

Overbilling means you’ve billed more than you’ve earned. It shows on the balance sheet as a liability, because you owe the customer that work. A little is normal and helps cash flow, but the cash should still be in the bank. Spending overbillings on overhead or other jobs is how contractors get into trouble.

One of our clients overbills aggressively so the owner’s money funds more of the job early, instead of the company’s cash or credit line. It works, but the bank watches whether those overbillings are collected and whether the cash is still there.

Underbilling means you’ve done more work than you’ve billed. It shows as an asset, but it’s a warning sign: a change order that hasn’t been approved, a billing that slipped, or costs running higher than the estimate. Underbillings that sit for months often turn into lost profit.

Underbilling is also a cash problem. Say you bought $100,000 of materials but have only billed $80,000: you’re $20,000 short until you bill it, even on a profitable job.

To check one job quickly, try our Over/Under Billing Calculator.

Watch for profit fade

Fade is when a job’s expected margin shrinks as it moves along. Say Job B’s estimated total cost rises next month from $480,000 to $520,000. Its expected profit drops from $120,000 to $80,000, and the profit already reported on the job falls by about $34,600 that month. A WIP updated every month shows this early, while there’s still time to price change orders, push back on a supplier or fix the schedule. One reviewed once a year shows it when it’s too late.

Change orders on the WIP

We work with a New York City contractor on several projects for a large public institution. Turnover and slow approvals on the owner’s side mean change orders often wait months. The WIP shows what happens to the company’s results if those change orders are approved late or not at all, so the owner can decide which work to keep going on and where to push for approval.

This is common on large general contractor and public work. The work starts before the change order is approved, and the owner may approve it late, for less, or not at all. The WIP shows what that risk does to your results.

Why banks and sureties want your WIP

Lenders and sureties use the WIP to see whether your jobs make money, whether your billing is backed by cash, and how much work you have ahead. A WIP that ties to your financial statements every month builds credibility, which helps when you need a bigger credit line or bonding line. See how we help with bank lines and bonding.

How we help

We build and update the WIP every month as part of your monthly financial reporting, review it with you and your project managers, and use the backlog to forecast cash and earnings. Learn more about construction accounting, the difference between the WIP and construction in progress accounting, and how to raise your margins on commercial work. Or see all our construction services. See how we work with general contractors and subcontractors.

FAQs

What is a WIP schedule in construction?

A monthly report that shows each job’s contract amount, costs, percent complete, earned revenue, billings and expected profit.

What is overbilling?

Billing more than you’ve earned on a job. It’s a liability on the balance sheet, and the cash should be kept, not spent.

What is underbilling?

Earning more than you’ve billed. It’s an asset, but often a sign of unapproved change orders, late billing or cost overruns.

How often should a contractor update the WIP?

Every month, with the financial statements, using updated cost-to-complete estimates from the project managers.

Why do sureties ask for a WIP?

To judge whether your jobs are profitable, whether billing is backed by cash, and how much work you can take on.

Facebook
Twitter
LinkedIn
WhatsApp
Picture of Alan G. Lefkowitz, CPA
Alan G. Lefkowitz, CPA

Alan G. Lefkowitz, CPA, founded CFO Strategies in 2009 and has 46 years of business experience across financial services, construction and real estate. He spent more than 10 years as CFO of mid-sized construction and real estate companies, overseeing the finances of major New York projects including the Yankee Stadium and the Goldman Sachs office tower.