A Work in Progress (WIP) report is a fundamental financial accounting schedule utilized by general contractors, specialty trade subcontractors, and project managers to track ongoing job costs against revenue. In long-term project accounting, relying solely on standard cash receipts or progress billing invoices can create dangerous distortions in profitability reporting. By calculating the exact percentage of completion for every contract, a WIP report accurately identifies whether a project is overbilled or underbilled. This transparency helps construction executives avoid cash crunches, satisfy bonding company covenants, maintain accurate balance sheets, and ensure healthy operational cash flow throughout lengthy project lifecycles.
Understanding Work in Progress (WIP) Accounting Fundamentals
In construction and long-term project management, traditional cash basis accounting or simple billed-versus-paid accounting fails to reflect the true financial health of ongoing operations. Because contracts often span multiple months or fiscal years, invoicing milestones rarely align perfectly with the actual labor, materials, and equipment expended on site. A Work in Progress (WIP) report, also referred to as a work in process schedule, solves this operational blind spot by applying the Percentage of Completion (POC) accounting method under Generally Accepted Accounting Principles (GAAP) and ASC 606 revenue recognition guidelines. Successful contractors who master how to get clients as a contractor understand that securing profitable contracts is meaningless if poor job cost controls and miscalculated billings drain company liquidity behind the scenes.
The core mechanism of a WIP schedule relies on the cost-to-cost formula. By dividing the actual costs incurred to date by the total estimated cost at project completion, an accountant determines the true mathematical percentage of completion for that specific job. Multiplying this percentage by the total revised contract value reveals earned revenue—the exact amount of money the contractor has earned the legal right to recognize on the income statement based on physical progress. When actual billings exceed earned revenue, the company has created an overbilling, which represents a short-term liability on the balance sheet for unearned revenue. Conversely, when earned revenue exceeds cumulative billings, an underbilling occurs, creating an asset that indicates the contractor has financed project work ahead of invoicing the property owner.
Failing to monitor these metrics systematically leads to distorted financial statements, erroneous tax calculations, and severe cash flow vulnerabilities. Bonding sureties, commercial lenders, and certified public accountants scrutinize quarterly WIP schedules to verify that working capital figures are genuine rather than inflated by premature billing. The comprehensive breakdown below outlines the essential mathematical columns required in any institutional-grade construction WIP schedule alongside their balance sheet impact and diagnostic red flags.
| WIP Schedule Column | Mathematical Formula / Data Origin | Accounting & Balance Sheet Impact | Operational Function | Diagnostic Red Flag Warning Sign |
|---|---|---|---|---|
| Revised Contract Value | Original Base Contract + Approved Change Orders | Defines total gross revenue ceiling for the project | Establishes baseline contract scope value | Unapproved change order amounts included prematurely |
| Estimated Total Job Cost | Initial Budget Estimate + Revised Cost Adjustments | Calculates anticipated gross profit margin percentage | Determines denominator for completion percentage | Static budget that fails to reflect field cost increases |
| Actual Costs Incurred to Date | General Ledger Job Costing (Labor + Material + Subs) | Direct reduction of cash or increase in accounts payable | Measures capital deployed into physical construction | Unposted subcontractor invoices skewing progress ratio |
| Percentage of Completion (%) | Actual Costs to Date / Estimated Total Job Cost | Drives revenue recognition multiplier under ASC 606 | Quantifies physical progress through financial deployment | Exceeds 100 percent due to unbudgeted cost overruns |
| Earned Revenue to Date | Percentage of Completion x Revised Contract Value | Recognized on Income Statement as legitimate gross revenue | Separates earned income from billed receivables | Diverges dramatically from owner-approved progress milestones |
| Total Billings to Date | Cumulative Invoices Sent to Client (AIA G702/G703) | Debits Accounts Receivable and credits billing suspense | Reflects contractual invoicing issued to project owner | Front-loaded invoicing masking lagging physical progress |
| Overbilling (Liability) | Total Billings to Date – Earned Revenue (When Positive) | Current Liability: Billings in Excess of Costs & Earnings | Identifies cash received before completion milestones | Excessive overbilling spent on general company overhead |
| Underbilling (Asset) | Earned Revenue – Total Billings to Date (When Positive) | Current Asset: Costs & Estimated Earnings in Excess of Billings | Highlights unbilled work funded directly by contractor | Chronic underbilling depleting cash reserves and credit lines |
Step-by-Step Construction of an Accurate WIP Schedule
Constructing an accurate WIP schedule demands seamless collaboration between project managers in the field and accounting personnel in the corporate back office. Many contracting organizations run into difficulty because field supervisors fail to communicate change order delays, material price escalations, or labor inefficiencies until a project reaches substantial completion. In complex trade work where specialized licensing is mandatory—such as navigating general contractor roofing regulations and managing strict building inspection schedules—job delays directly inflate field supervision costs and equipment rental fees. If estimated total costs are not adjusted continuously in the WIP model, the percentage of completion will appear artificially high, causing the company to recognize phantom profits that inevitably disappear at project closeout.
To establish a reliable reporting cycle, accounting teams must extract closed job cost data from the general ledger at the end of each fiscal month. Every direct expense—including union labor, payroll burden, bulk material drops, subcontractor progress draws, and heavy machinery leases—must be fully accrued. Project managers must then review their remaining scope of work to calculate an updated Estimated Cost to Complete (CTC). Adding actual costs to date to the projected cost to complete establishes the new Estimated Total Job Cost. If this sum exceeds the initial project budget, the anticipated profit margin shrinks immediately, alerting leadership to operational inefficiencies before they inflict permanent damage on company cash reserves.
The comparative analysis table below demonstrates how two identical construction projects with different billing cadences produce contrasting balance sheet positions. By examining real-world figures, management teams can visualize how overbilling provides temporary operational cash while underbilling creates an urgent invoicing requirement.
| Project Scenario | Revised Contract | Estimated Total Cost | Costs Incurred to Date | Percent Complete | Earned Revenue | Total Billed to Date | WIP Balance Sheet Adjustment |
|---|---|---|---|---|---|---|---|
| Commercial Office Buildout (Job Alpha) | $1,200,000 | $960,000 | $480,000 | 50.00% | $600,000 | $750,000 | $150,000 Overbilling (Current Liability) |
| Municipal Water Substation (Job Beta) | $2,400,000 | $1,920,000 | $1,440,000 | 75.00% | $1,800,000 | $1,550,000 | $250,000 Underbilling (Current Asset) |
| Industrial Warehouse Expansion (Job Gamma) | $850,000 | $680,000 | $170,000 | 25.00% | $212,500 | $212,500 | $0 Neutral Balance (Fully Invoiced to Date) |
| Retail Plaza Facade Renovation (Job Delta) | $500,000 | $425,000 | $382,500 | 90.00% | $450,000 | $375,000 | $75,000 Underbilling (Current Asset) |
Analyzing WIP Variance and Mitigating Operational Cash Flow Risks
Interpreting a completed WIP report requires looking beyond individual job rows to evaluate company-wide exposure. A pervasive phenomenon known as profit fade or cost fade occurs when project managers consistently underestimate remaining costs. For instance, if a job initially modeled at an 18 percent gross profit margin experiences subcontractor defaults, weather delays, and overtime wage surges, its final cost may increase dramatically. On a monthly WIP report, profit fade manifests as a declining gross margin percentage across successive reporting periods, forcing negative revenue adjustments that can flip an entire quarterly operating statement into a net loss.
Managing overbillings requires extreme financial discipline. While overbilling appears advantageous because it generates upfront cash flow from property owners, this cash represents borrowed capital rather than realized profit. If an executive team uses overbilled funds from a new commercial project to pay past-due vendor balances on a struggling legacy job, the company enters a dangerous liquidity spiral. When the overbilled job reaches its later stages, substantial work remains to be completed with no remaining billing milestones, triggering severe cash shortfalls. Industry best practice mandates maintaining a dedicated liquidity reserve equal to total net overbillings to guarantee adequate working capital through final punch-list completion.
Conversely, excessive underbillings signal chronic administrative inefficiencies in the billing department. Underbillings reveal that a contractor is performing physical work, purchasing steel and lumber, and paying weekly trade payroll without invoicing the client promptly. Common drivers include delayed change order sign-offs, slow architect approvals on American Institute of Architects (AIA) payment applications, or disorganized project management tracking. When bonding surety underwriters evaluate a balance sheet with heavy underbillings, they frequently discount this current asset by 20 to 50 percent, reasoning that unbilled balances frequently turn into disputed claims that require costly litigation or write-downs.
How to Build and Reconcile a Construction WIP Report
A comprehensive operational procedure for assembling contract data, computing percentage of completion, and posting WIP adjustments to the general ledger.
-
Aggregate Current Contract and Change Order Values
Review all active client agreements, incorporating signed contract amendments and approved change orders into the revised total contract value while strictly excluding pending, unapproved claims.
-
Compile Incurred Job Costs from the General Ledger
Extract all direct project expenditures posted through the closing date, ensuring that all payroll burdens, equipment charges, material delivery slips, and subcontractor invoices are accurately accrued.
-
Update Estimated Costs to Complete with Project Managers
Conduct a monthly job review with field superintendents to evaluate remaining labor hours, open purchase commitments, and site conditions to establish a revised, realistic Estimated Cost to Complete.
-
Calculate Percentage of Completion for Every Active Job
Divide actual costs incurred to date by the total revised estimated cost (incurred costs plus remaining cost to complete) to calculate the precise percentage of completion for each project.
-
Determine Earned Revenue and Overbilling or Underbilling Balances
Multiply the completion percentage by the total revised contract value to establish earned revenue, then compare this figure against cumulative billings to date to identify net overbilled or underbilled amounts.
-
Post Month-End Journal Entries and Reconcile with the Balance Sheet
Record adjusting journal entries debiting underbillings (asset) or crediting overbillings (liability) with offsetting adjustments to earned revenue, ensuring the WIP schedule reconciles perfectly with the general ledger.
Frequently Asked Questions (8 Questions Answered)
Q1: What is the primary purpose of a WIP report in construction?
The primary purpose of a Work in Progress report is to align revenue recognition with actual job completion progress under the percentage of completion accounting method. It prevents revenue distortion by identifying whether ongoing projects are overbilled or underbilled, ensuring that financial statements accurately reflect true profitability.
Q2: What is the difference between an overbilling and an underbilling?
An overbilling occurs when cumulative client invoicing exceeds the revenue earned based on physical job costs incurred, creating a current liability representing unearned income. An underbilling happens when earned revenue based on job completion exceeds total invoices sent to date, creating a current asset representing work financed by the contractor.
Q3: Why do bonding companies and banks insist on monthly WIP schedules?
Surety bonding companies and commercial lenders demand monthly WIP reports because traditional balance sheets fail to reveal hidden project losses. A WIP schedule exposes cost overruns, profit fade, and cash flow strain across all active jobs, allowing underwriters to evaluate a contractor’s true working capital and risk profile.
Q4: How often should a contractor update their WIP schedule?
Contractors should update their WIP schedule at the end of every fiscal month as part of the standard financial close. For high-volume or fast-track commercial projects, performing bi-weekly or mid-month WIP reviews helps project managers identify cost deviations before they impact month-end financials.
Q5: What is profit fade and how does a WIP report detect it?
Profit fade is the gradual decline in projected gross profit margin on a contract over time. A WIP report detects profit fade by tracking estimated total costs month over month; if total estimated costs continually rise while the contract value remains unchanged, the reported profit margin progressively shrinks.
Q6: How should unapproved change orders be handled in a WIP report?
Under standard construction accounting principles, unapproved change orders should not be added to the revised contract value because client payment is not legally guaranteed. However, if costs have already been incurred performing the change order work, those costs must be recorded, temporarily dampening reported margins until approved.
Q7: Can a small subcontracting business benefit from a WIP report?
Yes, trade subcontractors such as electricians, plumbers, and HVAC installers benefit significantly from WIP reporting. Even on modest projects, material price volatility and labor delays can quickly turn a profitable contract upside down, making early variance detection essential for survival.
Q8: What journal entries are required to adjust for WIP at month end?
At month end, accountants post adjusting entries to reconcile billings with earned revenue. For net underbillings, debit Costs and Estimated Earnings in Excess of Billings (Asset) and credit Construction Revenue. For net overbillings, debit Construction Revenue and credit Billings in Excess of Costs and Estimated Earnings (Liability).
Final Thoughts & Key Takeaways
Creating and maintaining an accurate WIP report is an essential operational discipline for any contractor aspiring to build a sustainable, financially resilient enterprise. By linking field execution directly to general ledger revenue recognition through the cost-to-cost percentage of completion formula, a WIP schedule eliminates guesswork, exposes margin erosion early, and ensures clean financial audits. Implementing a rigorous monthly WIP review rhythm between project managers, estimators, and financial controllers safeguards company cash reserves, protects bonding capacity, and establishes the operational transparency required to scale profitably in the competitive construction marketplace.