9.3 Work-in-Progress (WIP) Schedule & Over/Under-Billing
Key Takeaways
Under ASC Topic 606, a construction performance obligation that meets an over-time criterion is recognized with a measure of progress that faithfully depicts performance; cost-to-cost is a common input method, not an automatic method for every contract.
The standard 10-column WIP schedule reconciles contract price, estimated total costs, actual costs to date, percentage complete, earned revenue, and cumulative billings for every active contract.
When cumulative billings exceed recognized revenue for a contract, the resulting contract liability is commonly called an over-billing; billing and cash collection are separate events.
When recognized revenue exceeds cumulative billings for a contract, the resulting contract asset is commonly called an under-billing. It can arise from billing timing or contractual conditions, but unsupported change orders and cost overruns do not by themselves create recognizable revenue.
Month-end entries reconcile billing records with revenue recognized under the contractor's accounting policy; the exact entry depends on the ledger design, prior balances, and whether billings are recorded directly to revenue or to a separate contra/contract account.
Work-in-Progress (WIP) Schedule & Over/Under-Billing
Core Concept: A Work-in-Progress (WIP) schedule is a central management and underwriting tool. For performance obligations recognized over time, it reconciles the selected measure of progress, recognized revenue, estimated costs, and contract billings. Billing or cash receipts alone do not measure ASC 606 revenue.
The Role of the Work-in-Progress (WIP) Schedule
Contractors frequently experience cash windfalls while losing money, or experience cash shortages while generating healthy profits. This disconnect occurs because construction billing milestones rarely align with physical cost expenditure:
- Under Cash-Basis Accounting, income is recognized only when cash is received and expenses when paid. This creates wild distortions, making a contractor appear highly profitable after an advance mobilization deposit even though substantial labor and material liabilities remain unperformed.
- Under Billing-Basis Accounting, revenue is recognized when invoices are submitted to project owners. This allows a contractor who front-loads the schedule of values (AIA Document G703) to manufacture artificial paper profits that evaporate as the project finishes.
- When an ASC 606 performance obligation qualifies for over-time recognition, revenue follows a measure of progress that faithfully depicts performance. Cost-to-cost—qualifying costs incurred divided by estimated qualifying total costs—is a common input method, but costs that do not depict progress may need to be excluded or adjusted.
The 10-Column Architecture of the Standard WIP Schedule
Every comprehensive contractor WIP schedule maintains a standard 10-column layout for each active job:
- Revised Contract Price: Original contract sum plus fully executed and approved change orders. Unapproved change orders and disputed claims are excluded from revenue until legally authorized.
- Estimated Total Costs at Completion: Original bid budget plus authorized change order costs and updated bottom-up re-estimates of remaining expenditures.
- Actual Costs Incurred to Date: Cumulative direct costs (labor, material, subcontract, equipment, direct overhead) posted to the job cost ledger through the reporting date.
- Estimated Cost to Complete: The projected remaining expenditures required to achieve final completion and punch list sign-off: .
- Projected Total Cost: Column 3 plus Column 4. Must be re-evaluated monthly by project managers.
- Percentage of Completion (Cost-to-Cost):
- Earned Revenue to Date: The true GAAP revenue earned through physical performance:
- Total Cumulative Billings to Date: The total gross dollar amount billed to the owner through approved pay applications (matching Line 4 of AIA Document G702), regardless of whether cash has been received.
- Billings in Excess of Costs & Estimated Earnings (Over-Billings): Calculated when Total Billings exceed Earned Revenue: .
- Costs & Estimated Earnings in Excess of Billings (Under-Billings): Calculated when Earned Revenue exceeds Total Billings: .
Over-Billings: Billings in Excess of Costs and Estimated Earnings
When a contractor bills an owner more than the earned revenue justified by physical completion, an Over-Billing exists:
- Balance Sheet Classification: Current Liability.
- Economic Reality: The contractor has billed for work that has not yet been physically completed. The excess billing represents client funds held by the contractor to finance upcoming labor and material obligations.
- Billing-Ahead Effect: Contractual billing milestones, deposits, stored materials, or an approved schedule of values can cause billings to exceed recognized revenue and support working capital. Artificially front-loading values can mislead the owner, create late-project cash strain, and violate contract certifications.
- The Cash Trap Hazard: If management treats over-billings as earned cash profit and withdraws dividends or funds losses on other failing jobs, the business enters a fatal cash trap. When the over-billed project reaches 80% to 100% completion, the remaining physical work must be executed with minimal remaining billing power, precipitating a liquidity collapse.
Under-Billings: Costs and Estimated Earnings in Excess of Billings
When earned revenue based on physical completion exceeds the cumulative amounts billed to the client, an Under-Billing exists:
- Balance Sheet Classification: Current Asset.
- Economic Reality: The contractor has performed work on site and incurred direct costs that have not yet been invoiced to the owner.
- Underwriting Red Flags: While an asset on paper, sureties and lenders view chronic or large under-billings with extreme caution because under-billings do not pay payroll.
- The Four Primary Causes of Under-Billings:
- Sluggish Billing Administration: Project managers submitting AIA G702 pay applications late or failing to bill for completed work before monthly cut-off dates.
- Unapproved Change Orders: The contractor expends field labor and materials on extra work directed by the owner before formal written change orders are executed, incurring costs that cannot yet be billed.
- Unbilled Stored Materials or Subcontractor Retainage: Legitimate timing lags between vendor delivery and contractual billing milestones.
- Concealed Job Cost Overruns (Profit Fade): If a project manager incurs cost overruns but fails to increase Column 5 (Projected Total Costs), the cost-to-cost formula falsely inflates the percentage complete, generating "phantom" earned revenue that can never be billed.
Profit Fade and Contract Re-Estimates
Profit Fade is the gradual erosion of projected contract gross profit as a project matures. It occurs when project managers maintain optimistic, static cost budgets despite field cost overruns.
For example, if a $1,000,000 project has an initial cost estimate of $800,000 ($200,000 profit), but unexpected underground rock increases true total costs to $950,000, failing to update the cost-to-complete overstates early progress and profit. Expected losses are evaluated under the applicable U.S. GAAP loss guidance; they should not be deferred merely because billing or physical completion has not caught up.
Month-End Adjusting Journal Entries for Revenue Recognition
To produce accurate financial statements, the ledger must distinguish cumulative billings from revenue recognized under the contractor's ASC 606 policy.
Illustrative Period-End Adjustments
If the accounting system initially credits all billings to revenue, an over-billed position may require a debit to Construction Revenue and a credit to a Contract Liability; an under-billed position may require a debit to a Contract Asset and a credit to Construction Revenue. Systems that record billings in a separate contra or contract account use different entries. Always adjust from opening balances and current-period activity rather than posting the cumulative WIP balance again.
Comprehensive Multi-Job WIP Schedule Table
| Job # & Name | (1) Contract Price | (2) Estimated Total Cost | (3) Costs Incurred to Date | (4) Estimated Cost to Complete | (5) Projected Total Cost | (6) % Complete | (7) Earned Revenue | (8) Cumulative Billings | (9) Over-Billings (Liability) | (10) Under-Billings (Asset) |
|---|---|---|---|---|---|---|---|---|---|---|
| #101 Office Park | $1,500,000 | $1,200,000 | $600,000 | $600,000 | $1,200,000 | 50.0% | $750,000 | $820,000 | $70,000 | $0 |
| #102 Civic Library | $2,200,000 | $1,760,000 | $440,000 | $1,320,000 | $1,760,000 | 25.0% | $550,000 | $480,000 | $0 | $70,000 |
| #103 Health Clinic | $800,000 | $640,000 | $512,000 | $128,000 | $640,000 | 80.0% | $640,000 | $710,000 | $70,000 | $0 |
| #104 Retail Center | $1,100,000 | $880,000 | $220,000 | $660,000 | $880,000 | 25.0% | $275,000 | $250,000 | $0 | $25,000 |
| Portfolio Totals | $5,600,000 | $4,480,000 | $1,772,000 | $2,708,000 | $4,480,000 | — | $2,215,000 | $2,260,000 | $140,000 | $95,000 |
Net Portfolio Position:
- Total Gross Billings: $2,260,000
- Total Recognized Revenue: $2,215,000
- Net Over-Billing: $2,260,000 - $2,215,000 = $45,000 (gross contract liabilities of $140,000 less gross contract assets of $95,000).
A $45,000 debit to revenue and credit to contract liability is correct only in the simplified case where the ledger began with no related balance and credited all current billings directly to revenue. The actual adjusting entry must account for opening contract-asset and contract-liability balances and the system's billing entries.
On the audited balance sheet, the $140,000 in gross over-billings appears under Current Liabilities and the $95,000 in gross under-billings appears under Current Assets; GAAP prohibits netting these balances across unrelated contracts.
A Florida building contractor is managing an educational facility project with an approved contract price of $2,400,000 and total estimated costs at completion of $1,920,000. As of the end of the month, the job cost ledger shows actual costs incurred to date of $576,000, while cumulative billing applications approved on AIA Document G702 total $810,000. Under the percentage-of-completion method (cost-to-cost), what amount of over-billing or under-billing must be reported on the balance sheet, and in which section?
$90,000 Under-Billing classified as a Current Asset.
$90,000 Over-Billing classified as Long-Term Debt.
$120,000 Under-Billing classified as a Current Asset.
$90,000 Over-Billing classified as a Current Liability.
A Florida surety underwriter reviewing an annual financial statement for a commercial contractor observes that the balance sheet carries $520,000 in 'Costs and Estimated Earnings in Excess of Billings' (Under-Billings) against total working capital of $680,000. Why does this large under-billing position raise serious concerns during surety prequalification?
Under-billings represent unearned deferred income that artificially deflates the contractor's income tax liability.
A large contract-asset balance concentrates working capital in amounts that are not yet unconditional receivables and therefore require scrutiny of billing conditions, collectibility, estimate accuracy, and approved scope.
Under-billings indicate excessive advance customer payments that could trigger immediate Florida Construction Industry Licensing Board disciplinary action.
Under-billings demonstrate that the contractor is heavily front-loading the schedule of values on AIA Document G703.
Assume a simplified ledger with no opening contract-asset or contract-liability balance in which all current billings were credited directly to revenue. Cumulative billings are $3,150,000 and cost-to-cost recognized revenue is $2,890,000. Which entry adjusts that simplified ledger?
Debit Construction Revenue $260,000; Credit Billings in Excess of Costs and Estimated Earnings $260,000.
Debit Billings in Excess of Costs and Estimated Earnings $260,000; Credit Construction Revenue $260,000.
Debit Costs and Estimated Earnings in Excess of Billings $260,000; Credit Construction Revenue $260,000.
Debit Construction Work in Progress $260,000; Credit Accounts Receivable $260,000.
Sections you finish are checked off in the contents.