WIP Schedule for Contractors: Columns, Formulas & Free Example

A WIP schedule (work-in-progress schedule) is a monthly report that shows every open construction job, how far along it is, how much revenue you have actually earned, and whether you have billed too much or too little. It is the single most important report in construction accounting, and it is the first thing your surety, bank and CPA ask for.

If your profit and loss statement says one thing and your bank balance says another, a WIP schedule usually explains the gap. In this guide you will learn what goes on a WIP schedule, the formulas behind each column, a complete four-job example, the journal entries it creates, and the red flags bonding companies look for.

WIP schedule for contractors showing percent complete, earned revenue, over billing and under billing formulas

What Is a WIP Schedule in Construction?

Construction jobs run for months, and you bill on a schedule of values, not on the exact work done each day. That means billings and real progress almost never match. A WIP schedule compares the two, job by job, using the percentage-of-completion method.

Each line of the WIP schedule answers four questions:

  • How much of this job is finished?
  • How much revenue have we really earned so far?
  • Have we billed more or less than we earned?
  • Is the job still on track to make the profit we bid?

Short version: the WIP schedule turns your billings into earned revenue, and the difference becomes an over billing (liability) or under billing (asset) on your balance sheet.

Why Your WIP Schedule Matters

  • Accurate profit: without a WIP schedule, revenue equals billings, so front-loaded billing makes profit look higher than it is.
  • Bonding capacity: sureties use your WIP schedule to decide how much work they will bond. Clean, consistent reports can raise your bonding limit.
  • Bank covenants: lenders read over billings and under billings to judge cash flow and risk.
  • Early warning: profit fade shows up on the WIP schedule months before a job closes, while there is still time to fix it.
  • Better bids: real job margins feed back into your estimates and your predetermined overhead rate.

WIP Schedule Columns and Formulas

ColumnWhat it meansFormula
Contract priceOriginal contract plus approved change ordersFrom contract
Total estimated costLatest estimate of all costs to finish the jobCost to date + Cost to complete
Estimated gross profitExpected profit on the full jobContract price − Total estimated cost
Cost to dateAll job costs posted, including accrualsFrom job cost report
Percent completeHow far along the job isCost to date ÷ Total estimated cost
Earned revenueRevenue you have truly earnedContract price × Percent complete
Billed to dateTotal progress billingsFrom AR / billing
Over billingBilled more than earnedBilled to date − Earned revenue
Under billingEarned more than billedEarned revenue − Billed to date
Cost to completeCosts still to comeTotal estimated cost − Cost to date

The cost-to-cost method above is the most common way to measure percent complete. Some contractors use units installed or engineer estimates, but cost-to-cost is easiest to audit and is what most sureties expect on a WIP schedule.

WIP Schedule Example: Four Open Jobs

Here is a WIP schedule for a fictional contractor, Ridgeline Builders, as of October 31, 2026.

JobContractEst. total costCost to date% completeEarned revenueBilled to dateOver / (Under)
101 Oak Street$500,000$400,000$160,00040%$200,000$230,000$30,000
102 Mill Plaza$300,000$240,000$120,00050%$150,000$120,000($30,000)
103 Cedar Clinic$850,000$722,500$578,00080%$680,000$700,000$20,000
104 Pine Remodel$120,000$96,000$24,00025%$30,000$25,000($5,000)
Total$1,770,000$1,458,500$882,000$1,060,000$1,075,000$15,000 net over

Totals: over billings of $50,000 (Jobs 101 and 103) and under billings of $35,000 (Jobs 102 and 104). Ridgeline is $15,000 net over billed, which is healthy: customers are funding the work slightly ahead of cost.

Checking the Math on Job 103

  • Percent complete: $578,000 ÷ $722,500 = 80%
  • Earned revenue: $850,000 × 80% = $680,000
  • Over billing: $700,000 − $680,000 = $20,000
  • Cost to complete: $722,500 − $578,000 = $144,500

Journal Entries from the WIP Schedule

The WIP schedule creates month-end adjusting entries that move revenue from “billed” to “earned.” Most contractors book them gross, one entry for over billings and one for under billings.

Entry 1 – record over billings (Jobs 101 and 103)

AccountDebitCredit
Contract Revenue$50,000.00
Billings in Excess of Costs and Estimated Earnings$50,000.00

Entry 2 – record under billings (Jobs 102 and 104)

AccountDebitCredit
Costs and Estimated Earnings in Excess of Billings$35,000.00
Contract Revenue$35,000.00

Net effect: revenue drops by $15,000, so the income statement shows $1,060,000 of earned revenue instead of $1,075,000 billed. Reverse these entries on the first day of next month and book fresh ones from the new WIP schedule, or adjust the balances to the new totals.

Profit Fade and Profit Gain

Profit fade happens when a job’s estimated gross profit shrinks over time. A good WIP schedule tracks the original estimate next to the current one so you can see it.

Job 103 Cedar ClinicAt bidOct 31, 2026
Contract price$850,000$850,000
Total estimated cost$680,000$722,500
Estimated gross profit$170,000$127,500
Gross margin20%15%
Profit fade$42,500

A $42,500 fade on one job is a signal to review labor productivity, change orders that were never billed, and material price increases. If the WIP schedule ever shows estimated costs above the contract price, record the full expected loss immediately.

How to Build a WIP Schedule Each Month

  1. Close job costs. Post all payroll, materials and equipment costs, and accrue subcontractor work done but not invoiced.
  2. Update contract values. Add every approved change order. Leave out unapproved ones, or treat them conservatively.
  3. Get cost-to-complete from project managers. This is the most important input on the WIP schedule. Old estimates create fake profit.
  4. Pull billings to date. Include retainage in billings; don’t net it out.
  5. Calculate each column. Use the formulas above in a spreadsheet or your construction software.
  6. Book the over and under billing entries. Post them on the last day of the month.
  7. Review with your team. Look at fade, big under billings and jobs that have not moved.

Modern construction accounting software can generate a WIP schedule automatically, but the cost-to-complete numbers still need a human review every month.

How to Set Up a WIP Schedule Template in Excel or Google Sheets

You do not need expensive software to start. A simple spreadsheet works for most small and mid-size contractors. Set up one row per open job and these columns, left to right:

  1. Job number and name
  2. Contract price (original + approved change orders)
  3. Total estimated cost (from the project manager)
  4. Estimated gross profit = contract price − total estimated cost
  5. Cost to date (from the job cost report, including accruals)
  6. Percent complete = cost to date ÷ total estimated cost
  7. Earned revenue = contract price × percent complete
  8. Billed to date (including retainage)
  9. Over billing = MAX(billed − earned, 0)
  10. Under billing = MAX(earned − billed, 0)
  11. Cost to complete = total estimated cost − cost to date
  12. Gross profit to date = earned revenue − cost to date

Add a total row at the bottom and two check cells: total over billings should equal the “Billings in Excess” balance in your general ledger, and total under billings should equal the “Costs in Excess” balance. If those checks do not match, something was missed in the month-end entries.

Lock the formula columns so only the input columns (contract price, estimated cost, cost to date and billed to date) can be changed. Save a copy each month with the date in the file name. That history becomes your audit trail and makes it easy to spot profit fade from month to month.

Who Should Prepare and Review It?

In most companies the bookkeeper or controller prepares the numbers, but the project managers own the cost-to-complete estimates. The owner should review the final version every month. A 30-minute “WIP meeting” where each PM explains changes on their jobs is one of the best habits a growing contractor can build.

If you do not have a controller in-house, an outsourced construction bookkeeper can collect the PM estimates, build the report, book the entries and walk you through the results. That gives you controller-level reporting without the full-time salary.

WIP Schedule Red Flags Sureties and Banks Watch

Red flagWhy it worries them
Large or growing under billingsPossible cost overruns or slow billing; cash is tied up
Heavy over billings on one jobCash may be used to fund other jobs
Profit fade across many jobsEstimating or field productivity problem
Percent complete stuck for monthsEstimates are not being updated
WIP does not tie to the general ledgerBooks cannot be trusted
Gross profit jumps at job closeoutEarlier WIP schedules understated costs or revenue

Common WIP Schedule Mistakes

  • Using percent billed instead of percent complete.
  • Forgetting accrued subcontractor and payroll costs, which understates percent complete.
  • Leaving the original estimate in place for months.
  • Including unapproved change orders in contract price.
  • Not tying the WIP schedule totals to the balance sheet accounts.
  • Only building the WIP schedule at year-end for the CPA.

Strong billing habits also help. Our guide to construction accounts receivable covers billing on time and collecting retainage.

Does a Small Contractor Need a WIP Schedule?

If you have jobs that last more than a month, use progress billing, or need bonding or a line of credit, yes. Even a simple spreadsheet WIP schedule will show you which jobs really make money. Larger contractors are also generally required to use the percentage-of-completion method for long-term contracts on their tax returns; see IRS Publication 538 and talk to your CPA about which method applies to you.

WIP Report vs. Job Cost Report: What Is the Difference?

A job cost report tells you what you have spent on each job by cost code: labor, materials, equipment, subcontractors and overhead. It looks backward. The work-in-progress report takes those same costs, adds your latest estimate of what is left to spend, and uses both to calculate earned revenue and expected profit. It looks forward.

You need both. If the job cost report is wrong, every number on the work-in-progress report is wrong too. That is why accurate coding of timecards, purchase orders and subcontractor pay apps matters so much. Many contractors run the job cost report first, fix miscoded items, and only then roll the numbers forward.

How Change Orders Affect Percent Complete

Change orders change both the contract price and the estimated cost. If you add the extra cost but forget to add the approved change order to the contract, the job looks less profitable than it is. If you add the change order revenue but not the extra cost, the job looks better than it is.

  • Approved change orders: add both the revenue and the estimated cost in the same month.
  • Pending change orders: include the cost you expect to spend, but only include revenue you are confident you will collect. Many contractors leave pending revenue out completely.
  • Disputed change orders: leave the revenue out and note the amount separately so your surety knows about the possible upside.

Example: Job 102 gets an approved $25,000 change order with $20,000 of added cost. Contract price becomes $325,000 and total estimated cost becomes $260,000. With $120,000 spent, percent complete drops from 50% to about 46.2%, and earned revenue becomes roughly $150,000. Small changes like this add up fast across a full backlog.

Where Retainage Fits

Retainage is usually 5% to 10% of each progress bill that the owner holds until the job is finished. On the work-in-progress report, billings to date should include the full billed amount, including retainage, because the retainage is still revenue you have billed. On the balance sheet, retainage receivable is usually shown separately from regular accounts receivable.

Do not reduce billings to date by retainage. Doing that makes every job look under billed and can make your financials look weaker than they really are.

Using Your Backlog Report to Manage Cash Flow

The report is not just for the CPA. Owners and project managers can use it every month to make better cash decisions:

  • Bill your under billings. If a job is under billed, check whether you missed billing a completed phase or approved change order.
  • Protect your over billings. Cash from over billed jobs is money you still owe in future work. Do not treat it as profit.
  • Plan payroll and equipment. Cost to complete tells you how much labor and material is still ahead.
  • Know your backlog. Contract price minus earned revenue equals remaining backlog, a key number for bonding and growth planning.

In the example above, Ridgeline has $710,000 of backlog ($1,770,000 contract value − $1,060,000 earned revenue) and $576,500 of costs still to come. That is a quick view of the next few months of work.

The Closed Jobs Schedule

Sureties often ask for a closed jobs schedule along with the open jobs report. It lists jobs finished during the year, with the original estimated profit and the final actual profit. A pattern of jobs that finish close to the original estimate builds trust in your estimating. A pattern of big fades, or big gains at the end, tells the surety your monthly numbers were not reliable.

Keep the closed jobs list in the same spreadsheet or software so you can compare at a glance. It also helps when you look at your overhead rate and markup for next year’s bids.

WIP Schedule Tips From the Field

  • Build the WIP schedule on the same business day every month so trends are easy to compare.
  • Never let accounting change a PM’s cost-to-complete without a conversation; ownership of the estimate keeps it honest.
  • Flag any job where percent complete moved less than 5% in a month but costs kept coming in.
  • Show the prior month’s gross profit next to the current one on each line so fade is visible at a glance.
  • Share a one-page summary with your surety every quarter, even if they only require it once a year. Regular updates build trust and can help when you need a bigger bond.

These habits take very little time once the WIP schedule template is set up, and they turn the report from a compliance chore into a tool for running the business.

Get a Monthly WIP Schedule Without the Headache

Payroll Construction Services builds your WIP schedule every month, books the over and under billing entries, and ties everything to your balance sheet, so your surety and bank get numbers they trust. See our construction bookkeeping and construction accounting services, or contact us for a free review.

WIP Schedule FAQs

What does WIP stand for in construction?

WIP stands for work in progress. A WIP schedule lists every open job and compares earned revenue to billings using percent complete.

How often should a WIP schedule be prepared?

Monthly is best practice. At minimum, prepare one every quarter and at year-end for your CPA, surety and bank.

Is over billing good or bad?

Moderate over billing is usually healthy because customers are funding the work. Very large over billings can hide cash problems if the money is spent on other jobs.

What is the difference between percent complete and percent billed?

Percent complete is based on costs incurred against total estimated costs. Percent billed is billings divided by contract price. The WIP schedule uses percent complete.

Can I build a WIP schedule in QuickBooks?

QuickBooks does not create a full WIP schedule on its own, but you can export job cost and billing reports to a spreadsheet or use an add-on built for contractors.

Final Thoughts

A WIP schedule is how contractors see the truth about every open job. Update cost-to-complete monthly, calculate percent complete from costs, book over and under billings, and watch for profit fade. Do that consistently and your financials, bonding and bids all get stronger.

1 thought on “WIP Schedule for Contractors: Columns, Formulas & Free Example”

  1. Pingback: Over Billing vs. Under Billing: Easy Guide + 3 Proven Examples

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top