A construction work-in-progress report, usually called a WIP report or WIP schedule, brings together each job's contract amount, cost forecast, costs incurred, earned revenue, and billings as of a reporting date. It helps you see the job's expected profit and whether billings are ahead of or behind the revenue earned.
That matters while the work is still underway. A job can look profitable in the accounting system because some costs haven't been posted or the remaining work has been underestimated. A useful WIP combines the books with current information from the people managing the project.
Formats vary, but the report needs enough detail to explain how each job's numbers were calculated. The main fields are:
Keep a change order record alongside the schedule. Pending changes need attention, but a request isn't automatically an approved increase in the contract price. Have your controller or CPA review their accounting treatment.
For a contract that qualifies for revenue recognition over time, cost-to-cost may be an appropriate way to measure progress. It compares costs incurred with the current total estimated cost. It isn't the required method for every contract, and some costs may need adjustments so spending doesn't overstate the work performed.
Assume a $1,000,000 contract has $300,000 of costs incurred and $450,000 of estimated costs remaining. In this simplified example, all incurred costs reflect progress and no adjustments are needed. Total estimated cost is $750,000, so the job is 40% complete: $300,000 divided by $750,000.
At 40% complete, cumulative earned revenue is $400,000. If cumulative billings are $350,000, the job is underbilled by $50,000. The expected final gross profit is $250,000: the $1,000,000 contract amount less $750,000 of total estimated cost.
The $50,000 underbilling doesn't tell you what is immediately billable or how much cash has been collected. Check the contract's billing terms and the reason for the difference.
An underbilling means earned revenue exceeds billings. It can reflect the contract's billing schedule, a delayed pay application, or unresolved changes. Find out why it exists and what needs to happen next. Don't assume every underbilling is a missed invoice.
An overbilling means billings exceed earned revenue. It doesn't prove that the customer has paid. If the money has been collected, remember that part of it supports work you still have to perform.
Overbilling doesn't cause profit fade. Profit fade is a decline in the job's estimated profit. Rising costs, rework, or additional work without enough recovery can reduce that forecast. Billing timing alone doesn't make the job more or less profitable.
Balance sheet presentation also needs review. A conditional right to payment may be a contract asset, while an unconditional right is a receivable. Use the WIP to support the accounting; don't assume every balance belongs in the same account just because the schedule labels it an underbilling.
A WIP is a dated report. Its usefulness depends on the cutoff, completeness of the costs, and quality of the forecast. Build WIP preparation into the monthly close, and revisit a job sooner when something material changes.
Project managers need to update the work remaining and expected costs. Accounting needs to capture incurred costs through the cutoff, review the contract information, and reconcile the schedule. Include appropriate job costs and burden once; adding the same expense through more than one allocation distorts progress and profit.
When tying WIP to the P&L, distinguish cumulative earned revenue from revenue earned in the current period. Use opening balances and include jobs completed during the period so the reconciliation explains the full period's revenue.
A controlled spreadsheet can work. Construction accounting software can also support the process, depending on its features and setup. Neither fixes an outdated cost forecast or missing information by itself.
The value of regular WIP reviews comes from the questions and follow-up. Which jobs have lost expected profit since last month? Which cost forecasts haven't changed even though the work has? Which billing differences need action, and who owns that action?
Bring accounting and project management into the discussion. Explain material changes, assign follow-up, and check what happened at the next review. Use receivables, payables, and a cash forecast alongside the WIP when planning cash needs.
Sureties and lenders often request WIP and other supporting schedules. Their requirements vary, and a clean report doesn't guarantee bonding or credit. It gives them a better basis for assessing the business.
If your team needs a dependable monthly WIP process, Levvigo helps contractors with job costing, WIP preparation, financial reporting, and accounting-team training. For the preparation process, see our step-by-step WIP guide. Learn more about our outsourced construction accounting.
Book a call with Levvigo to talk through your WIP and reporting needs. You can also request an Excel WIP template.
A construction work-in-progress report, usually called a WIP report or WIP schedule, brings together each job's contract amount, cost forecast, costs incurred, earned revenue, and billings as of a reporting date. It helps you see the job's expected profit and whether billings are ahead of or behind the revenue earned.
That matters while the work is still underway. A job can look profitable in the accounting system because some costs haven't been posted or the remaining work has been underestimated. A useful WIP combines the books with current information from the people managing the project.
Formats vary, but the report needs enough detail to explain how each job's numbers were calculated. The main fields are:
Keep a change order record alongside the schedule. Pending changes need attention, but a request isn't automatically an approved increase in the contract price. Have your controller or CPA review their accounting treatment.
For a contract that qualifies for revenue recognition over time, cost-to-cost may be an appropriate way to measure progress. It compares costs incurred with the current total estimated cost. It isn't the required method for every contract, and some costs may need adjustments so spending doesn't overstate the work performed.
Assume a $1,000,000 contract has $300,000 of costs incurred and $450,000 of estimated costs remaining. In this simplified example, all incurred costs reflect progress and no adjustments are needed. Total estimated cost is $750,000, so the job is 40% complete: $300,000 divided by $750,000.
At 40% complete, cumulative earned revenue is $400,000. If cumulative billings are $350,000, the job is underbilled by $50,000. The expected final gross profit is $250,000: the $1,000,000 contract amount less $750,000 of total estimated cost.
The $50,000 underbilling doesn't tell you what is immediately billable or how much cash has been collected. Check the contract's billing terms and the reason for the difference.
An underbilling means earned revenue exceeds billings. It can reflect the contract's billing schedule, a delayed pay application, or unresolved changes. Find out why it exists and what needs to happen next. Don't assume every underbilling is a missed invoice.
An overbilling means billings exceed earned revenue. It doesn't prove that the customer has paid. If the money has been collected, remember that part of it supports work you still have to perform.
Overbilling doesn't cause profit fade. Profit fade is a decline in the job's estimated profit. Rising costs, rework, or additional work without enough recovery can reduce that forecast. Billing timing alone doesn't make the job more or less profitable.
Balance sheet presentation also needs review. A conditional right to payment may be a contract asset, while an unconditional right is a receivable. Use the WIP to support the accounting; don't assume every balance belongs in the same account just because the schedule labels it an underbilling.
A WIP is a dated report. Its usefulness depends on the cutoff, completeness of the costs, and quality of the forecast. Build WIP preparation into the monthly close, and revisit a job sooner when something material changes.
Project managers need to update the work remaining and expected costs. Accounting needs to capture incurred costs through the cutoff, review the contract information, and reconcile the schedule. Include appropriate job costs and burden once; adding the same expense through more than one allocation distorts progress and profit.
When tying WIP to the P&L, distinguish cumulative earned revenue from revenue earned in the current period. Use opening balances and include jobs completed during the period so the reconciliation explains the full period's revenue.
A controlled spreadsheet can work. Construction accounting software can also support the process, depending on its features and setup. Neither fixes an outdated cost forecast or missing information by itself.
The value of regular WIP reviews comes from the questions and follow-up. Which jobs have lost expected profit since last month? Which cost forecasts haven't changed even though the work has? Which billing differences need action, and who owns that action?
Bring accounting and project management into the discussion. Explain material changes, assign follow-up, and check what happened at the next review. Use receivables, payables, and a cash forecast alongside the WIP when planning cash needs.
Sureties and lenders often request WIP and other supporting schedules. Their requirements vary, and a clean report doesn't guarantee bonding or credit. It gives them a better basis for assessing the business.
If your team needs a dependable monthly WIP process, Levvigo helps contractors with job costing, WIP preparation, financial reporting, and accounting-team training. For the preparation process, see our step-by-step WIP guide. Learn more about our outsourced construction accounting.
Book a call with Levvigo to talk through your WIP and reporting needs. You can also request an Excel WIP template.