A construction WIP report is only as useful as the numbers behind it. If job costs are missing or the cost-to-finish estimate is stale, the report can overstate earned revenue and hide a shrinking margin.
Preparing the report means getting accounting and project management to agree on the contract value, costs, remaining work, and billings for each job. The value of a WIP report comes from that review and the decisions it supports. Repeating last month's estimates in a new spreadsheet won't tell you much.
This guide explains the preparation process regardless of your accounting software. For a complete worked example with source reports, an Excel template, journal entries, and an answer key, use How to Prepare a WIP Report from QuickBooks Online.
Choose the reporting cutoff and use it for every job. Close the job-cost records for that period, including incurred costs that still need to be accrued. Payroll, materials, subcontractors, equipment costs, and applicable job overhead need to reach the correct jobs.
For each job, gather:
Keep the original contract value separate from change orders. For a straightforward fixed-price job, the current contract value starts with the original price plus approved changes. Keep pending or disputed changes visible separately, and review their accounting treatment before including them in the revenue calculation.
The estimated total cost is the amount already incurred plus the amount still needed to finish. It is not just the remaining cost.
Estimated total job cost = costs incurred to date + estimated cost to finish.
Review the remaining cost with the project manager. Include open commitments and the expected labor, materials, equipment, subcontractor work, and other costs still ahead of the job.
The steps here use cost-to-cost for a contract that qualifies for revenue recognition over time under ASC 606, with costs that appropriately reflect progress. It is a common construction method, but the accounting needs to fit the contract and the work performed.
Percentage complete = costs that measure progress to date ÷ estimated total costs for that progress measure.
For a straightforward job with no special adjustments, $400,000 of incurred costs against an $800,000 total cost estimate means the job is 50% complete.
Significant materials purchased but not installed, abnormal waste, or other costs that don't represent progress may require different treatment. Have those items reviewed before applying the formula. If incurred costs exceed the old estimate while work remains, update the forecast rather than letting an outdated denominator produce a misleading result.
For the straightforward example, multiply the current contract value by the percentage complete:
Earned revenue to date = current contract value × percentage complete.
A $1 million contract at 50% complete has $500,000 of earned revenue to date. With $400,000 of costs incurred, gross profit to date is $100,000. The expected final gross profit is $200,000, based on the $1 million contract value less the $800,000 total cost forecast.
Those figures depend on a supportable price and cost forecast. When estimated costs or contract consideration change, the cumulative calculation and the current-period adjustment need to reflect that change.
Keep the same $1 million contract and $400,000 of costs incurred, but suppose the project manager now expects $600,000 of work remaining. Estimated total cost rises from $800,000 to $1 million. Expected final gross profit falls from $200,000 to zero.
The updated cost-to-cost calculation is $400,000 divided by $1 million, or 40% complete. Cumulative earned revenue becomes $400,000, and cumulative gross profit is zero. Leaving the old estimate in place would overstate cumulative revenue and gross profit by $100,000.
The work already performed has not disappeared. The forecast changed, and that changes the accounting measure of progress. Document why the remaining cost increased and review the effect before closing the month.
If earned revenue exceeds billings, the difference is an underbilling. If billings exceed earned revenue, the difference is an overbilling. Use cumulative gross billings, before subtracting retainage or customer payments. Track collections separately.
Using the original $800,000 total cost estimate, $500,000 earned less $450,000 billed produces a $50,000 underbilling. If the same job had billed $550,000 instead, it would be overbilled by $50,000.
Find out why the difference exists. An underbilling may reflect contractual billing timing, an approval delay, a missed invoice, or an overstated revenue estimate. It doesn't automatically mean the full balance can be billed immediately.
An overbilling can help cash flow once it is collected, but the contractor still needs to fund the remaining work. Overbilling does not cause profit fade. Profit fade is a decline in the job's estimated profitability, usually explained by changes in costs, scope, or expected contract revenue.
Keep separate columns for original contract value, approved changes, and current contract value. Show incurred costs, estimated cost to finish, and estimated total cost alongside percentage complete, earned revenue, gross billings, and the underbilling or overbilling. Include forecast gross profit so the margin is visible too.
Using the original estimate, the example job would show:
Identify the job and reporting date clearly. Use consistent cost definitions across the schedule, and keep notes supporting material estimate changes so the team can explain what moved from the prior report.
You can download Levvigo’s construction WIP schedule template for Excel to organize the inputs and calculations. The separate QBO exercise shows how to populate it from source reports.
Check the costs and billings against the accounting records using the same cutoff. Include completed jobs relevant to the reporting period in the supporting schedules so closing a job doesn't make its activity disappear from the reconciliation.
A WIP usually shows activity from the beginning of each job. Your P&L covers a month or year to date. If a job has $500,000 of cumulative earned revenue and $350,000 was recognized through the prior year-end, its current-year revenue is $150,000. Apply the same period comparison to costs.
For a continuing job, the change in cumulative earned revenue generally determines revenue for the period. Use the opening balances to connect the cumulative job schedule to the monthly or year-to-date financial statements. Check the resulting contract asset and liability balances as well.
The WIP and financial statements should tell the same story. If they don't, resolve the difference before treating the report as finished. The process for tying your WIP report to the P&L is part of preparing the schedule.
Compare cumulative earned revenue with cumulative billings job by job to establish the required ending underbilling and overbilling balances. Calculate the entry from the balances already recorded in those accounts, including any earlier WIP adjustments. Post only the difference, then rerun the financial statements and verify revenue, job costs, and the separate asset and liability balances.
An overbilled job has not necessarily produced cash. The customer may not have paid, and retainage may still be withheld. An underbilled job may include earned revenue that cannot yet be invoiced or collected.
Review the WIP with receivables, expected collections, retainage, and upcoming payments. That gives you a better basis for assessing whether the jobs will help fund next month’s payroll or require more working capital.
Review job costs, remaining work, change orders, billing positions, and margin changes with project management each month. Assign someone to resolve missing costs, update estimates, and follow up on billing issues. Record the reasons for significant changes.
Software can help calculate and compile the schedule. The project team still needs to supply a realistic cost forecast, and accounting needs to reconcile the results. That review gives owners, lenders, and sureties a more useful report than formulas alone.
Levvigo works with contractors on job costing, WIP preparation, and financial reporting. If getting the schedule finished and reconciled becomes a scramble every month, we can help your team build a process it can maintain. Learn more about our outsourced construction accounting.
If your team needs help preparing and reconciling the schedule, learn about our WIP preparation services.
Book a call with Levvigo to talk through your WIP preparation and accounting needs.