A Reliable WIP Starts Before Month-End: How Better Data Leads to Better Business Decisions

The most dangerous WIP is not one that is obviously wrong. It is one that looks right. A work-in-progress (WIP) schedule can give construction leaders an early view of project profitability, cash flow, billing position, and emerging risks, but only if the data and judgments behind it are reliable. Although WIP is often viewed as a month-end accounting report, its accuracy is built throughout the life of each project with disciplined cost capture, forecasting, billing, and collaboration between accounting and operations. A reliable WIP doesn't create project performance. It reveals it. The question for leadership is simple: Can you trust the information behind your WIP?

For a typical cost-to-cost WIP schedule, four critical inputs drive most of the key calculations: projected contract value, projected total cost, job-to-date cost, and job-to-date billings. Percent complete, earned revenue, gross profit, and overbillings or underbillings are then derived from those inputs. If even one is incomplete, outdated, or unsupported, the WIP can become misleading.

Some inputs come directly from accounting records, while others depend heavily on informed management judgment. Reliable estimates require accounting and project teams to work together, combining financial data with insight into labor productivity, remaining labor hours, committed and expected costs, subcontractor performance, procurement issues, pending change orders, and changing field conditions. The calculations may be straightforward, but the quality of the information and judgments behind them is not.

Construction companies sometimes assume that because the WIP calculates automatically, it must be accurate. In reality, the formulas may be correct while the underlying data is not. Missing payroll, invoices recorded in the wrong period, misclassified costs, or outdated estimates can all distort percentage of completion, recognized revenue, gross profit, and a project's billing position. Perhaps most concerning, an inaccurate WIP can look perfectly reasonable. The formulas work. The numbers fall within an expected range. Yet the conclusions management draws from them may be entirely wrong, allowing problems to remain hidden until they are more difficult and costly to correct.

Consider a project reported as 55% complete when a week of payroll, several subcontractor invoices, and a material delivery have not yet been posted. Those missing costs can distort current reporting even if they were already included in the total cost forecast. However, if the missing activity also reveals lower labor productivity, unexpected subcontractor exposure, or other costs not reflected in the latest forecast, expected margin may be overstated as well. By the time those issues surface in the following month's WIP, management may have lost valuable time to address them.

The real cost of an inaccurate WIP is not simply an audit adjustment or a misstated financial statement. It is the business decisions made because management believed the numbers were right. An unreliable WIP can influence staffing decisions, equipment purchases, bidding strategy, cash flow planning, incentive compensation, bonding capacity, lending relationships, and other strategic decisions that affect the company's growth and profitability.

Imagine a contractor whose WIP shows several large projects outperforming expectations. Based on those results, management pursues additional work, adds field personnel, and commits capital to equipment to support anticipated growth. Two months later, delayed costs, revised estimates, and unresolved change orders reveal those same projects were less profitable than reported. The company has already acted on unreliable information, and correcting the WIP is far less costly than recovering from the business decisions it influenced.

Most of these issues are preventable. A reliable WIP isn't the result of a better spreadsheet. It's the result of better processes. Accounting and project management must work together so the financial data and estimates reflect current project conditions rather than simply rolling forward prior assumptions.

Eight Questions Leadership Should Ask Before Trusting the WIP

Before finalizing the WIP, leadership should be able to answer "yes" to the following questions:

  1. Have all labor, material, equipment, subcontractor, and other project costs been recorded or appropriately accrued?
  2. Have costs been coded to the correct jobs, phases, and cost codes?
  3. Does the job cost subledger reconcile to the general ledger?
  4. Have projected costs to complete been updated with project managers using current production rates, remaining labor hours, committed costs, subcontractor performance, procurement issues, and known project risks?
  5. Have approved change orders been included, and have pending change orders been evaluated to determine whether and how they should be reflected in the current estimate?
  6. Do job billings agree to the underlying pay applications or invoices; does the accounts receivable subledger reconcile to the general ledger; and have rejected or delayed billings been investigated?
  7. Have significant overbillings and underbillings been analyzed to understand the underlying operational or billing cause?
  8. Have margin gain or fade, significant shifts in percent complete, or unexpected changes in billing position been investigated before closing the period?

Margin movement deserves particular attention. A single month's margin fade may be explainable, but a pattern of fade across projects, project managers, estimators, customers, or types of work can point to a broader operating issue. Strong WIP reviews do more than identify the change. They ask when it began, what caused it, whether the forecast reflects current field performance, and what management can still do about it.

A review like this transforms month-end close from a compliance exercise into meaningful management control. Supporting records are an important part of that process and should be reconciled before the WIP is finalized. The accounts payable and accounts receivable subledgers should reconcile to the general ledger, significant vendor and subcontractor statements should be reviewed for unrecorded or disputed amounts, billed-to-date amounts should agree to underlying pay applications or invoices, and payroll and related accruals should be appropriately supported. Accurate accounting records are the foundation of a reliable WIP, and disciplined reconciliations often separate dependable reporting from costly surprises.

Every contractor wants timely financial information, but speed and accuracy should not be treated as competing objectives. A faster close provides little value if key costs, estimates, or billings are incomplete, while a perfectly accurate WIP delivered too late also loses value. The goal is a disciplined close that produces decision-ready information while leadership still has time to act on it.

An accurate WIP does more than satisfy your CPA, banker, or surety. It gives leadership confidence that the financial story reflects what is actually happening in the field and provides the visibility needed to identify risks early, challenge assumptions, respond before margins erode, and make better decisions about individual projects and the business as a whole.

The quality of your WIP is determined long before month-end. When the underlying data is complete and current and forecasts reflect informed project-level judgment, the WIP becomes more than a financial report. At month-end, the question should not simply be whether the spreadsheet is finished. It should be whether leadership trusts the forecasts, costs, billings, and judgments behind it enough to make the next business decision.

Download