Construction WIP Calculator & Job-Margin Workbench
WIP Calculator is a free ASC 606 cost-to-cost work-in-progress schedule builder and messy-spreadsheet parser for $2M to $50M commercial HVAC, MEP, electrical, plumbing, and general contractors that turns raw QuickBooks or field-software exports into gross underbilling assets (1350), overbilling liabilities (2450), staged-material carve-outs (1360), 100% loss-job reserves (2460), and balanced monthly journal entries in 1 second. Grounded in operational research across 2,242 trade contractors (where progress-billing contractors invoice in a 1-day median vs. 7 days for completion-only billers across n=733 firms), every calculation runs locally in your browser with $0 cost and zero email gates.
| Job # | Project / Customer | Base Contract | Approved COs | Revised EAC Cost | GL Cost to Date | Staged Mat (1360) | Billed to Date | Retainage (1210) | % Comp | Earned Rev | Earned GP | Over / (Under) Position | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 60.0% | $291,000 | $69,840 | |||||||||||
| 75.0% | $465,000 | $93,000 | |||||||||||
| 50.0% | $167,500 | $46,900 | |||||||||||
| 90.0% | $180,000 | $39,600 | |||||||||||
| 50.0% | $120,000 | -$20,000 | Loss Res: $10,000 | ||||||||||
| 0.0% | $0 | $0 | |||||||||||
| Portfolio Gross Totals (6 Jobs) | Rev Contract: $2,155,000 | $1,719,800 | $1,026,160 | $42,000 | $1,197,500 | $115,250 | Job-by-Job | $1,223,500 | $229,340 | 1350: $110,000 · 2450: $84,000 | |||
Balanced QuickBooks WIP Adjusting Journal Entry & TB Targets
| GL Account | Debit | Credit | Audit Memo & Reversal Control |
|---|---|---|---|
| 1350 Costs in Excess of Billings (WIP Asset) | $110,000.00 | Record ending gross underbillings (reverse Day 1 next month) | |
| 4020 WIP Revenue Adjustment - Underbilling Accrual | $110,000.00 | Record ending gross underbillings (reverse Day 1 next month) | |
| 4010 WIP Revenue Adjustment - Overbilling Deferral | $84,000.00 | Defer ending gross overbillings (reverse Day 1 next month) | |
| 2450 Billings in Excess of Costs (WIP Liability) | $84,000.00 | Defer ending gross overbillings (reverse Day 1 next month) | |
| 5900 Provision for Loss Contracts (COGS) | $10,000.00 | Recognize remaining 100% anticipated loss on onerous jobs (reverse Day 1 next month) | |
| 2460 Accrued Loss Provision on Uncompleted Contracts | $10,000.00 | Recognize remaining 100% anticipated loss on onerous jobs (reverse Day 1 next month) | |
| Total Balanced Entry (PASS: Debits = Credits) | $204,000.00 | $204,000.00 | Target TB: 1350 = $110,000.00 · 2450 = $84,000.00 · 2460 = $10,000.00 · 1210 Ret = $115,250.00 |
Seven Real-World WIP Edge Cases That Generic 4-Box Calculators Miss
A four-number toy formula divides whatever sits in QuickBooks cost by an outdated bid budget and calls the gap found money. On real construction books, seven failure patterns distort earned revenue and working capital unless caught before posting; see FASB ASC 606 Revenue Recognition Implementation Q&As for authoritative over-time input-method rules.
| Accounting Edge Case | What Goes Wrong in Basic Spreadsheets | Deterministic Control Built Into This Workbench |
|---|---|---|
| 1. Uninstalled Staged Equipment (1360) | Dropping a $42,000 chiller or switchgear package on Day 1 spikes cost-to-cost completion and manufactures fake earned gross profit before crews turn a wrench. | Carves staged equipment out of installed progress (either held on Balance Sheet Account 1360 or recognized at ASC 606 zero-margin 1:1 pass-through). |
| 2. Onerous / Loss Contracts (2460) | Spreading a $20,000 projected job loss at 50% completion hides $10,000 of known future loss into next quarter. | Applies ASC 605-35 / 606 immediate 100% loss recognition, isolating incremental loss reserve in Account 2460 without double-counting incurred loss. |
| 3. Netting 1350 Against 2450 | Offsetting $100,000 of underbillings against $71,500 of overbillings reports a single +$28,500 line and hides $71,500 of unearned customer obligation from sureties. | Aggregates Gross Asset 1350 and Gross Liability 2450 separately on every schedule, CSV export, and QuickBooks journal entry. |
| 4. Zero-Cost Billed Jobs & GL Leaks | Invoices sync from ServiceTitan, BuildOps, or Housecall Pro while field payroll sits in lump-sum overhead, printing fake 100% margins. | Flags $0-cost billed rows for review (mobilization advance vs. unallocated payroll/AP) and scans QuickBooks exports for Not-Specified COGS leaks. |
| 5. Retainage Mixed Into Underbillings | Leaving 5% to 10% GC retainage inside Trade AR (1200) or lumping it into Underbillings (1350) distorts 90+ day AR aging and surety haircuts. | Tracks contractual retainage separately in Account 1210 until substantial completion release. |
| 6. Unapproved Change Orders | Adding verbal field extras to Revised Contract before a signed CO inflates earned revenue on unapproved scope. | Excludes pending COs from Revised Contract under conservative policy while flagging exposed cost on unsigned work. |
| 7. Intermediate % Rounding Drift | Rounding completion to 56.3% before multiplying a $4,000,000 contract introduces hundreds of dollars of rounding error vs. GL tie-outs. | Uses exact rational BigInt division on integer cents before rounding earned revenue to the nearest cent. |
Adapting Rigid GAAP WIP Rules for $2M to $50M SMB Contractors
Enterprise ERP implementations fail smaller contractors when they demand daily cost-code timesheets on $900 service calls. Practical controller teams split jobs by duration and materiality while keeping the General Ledger 100% tied out every month:
| Operating Dimension | Rigid Big-4 / Enterprise ERP Rule | Practical $2M to $50M SMB Operating Standard |
|---|---|---|
| Job Population Scope | Run cost-to-cost WIP across every ticket regardless of dollar size or 2-day turnaround. | Apply a documented management planning threshold (for example, fixed-price or multi-week jobs above $15,000 to $25,000 crossing month-end); recognize short T&M/service tickets upon completion. |
| Labor Burden Allocation | Real-time union fringe, workers comp class code, and fleet depreciation per timesheet punch. | Allocate bi-weekly field wages + a verified loaded burden multiplier (FICA, WC class rate, benefits) by job hours into 5100/5150; isolate non-billable shop/drive time in 6150. |
| MonthlyEAC Updates | 40-column cost-code re-forecasting across 200 sub-phases every week. | One 30-minute monthly PM WIP huddle reviewing the top 10 to 25 active jobs: actual cost to date, remaining labor/sub ETC, and signed vs. pending change orders. |
| Tax vs. Management Books | Maintain two separate ledgers for GAAP accrual WIP and cash/completed-contract tax filings. | Post one balanced Month-End WIP Journal Entry into dedicated accounts (1350 / 2450 / 4010 / 4020) with a dated Day-1 reversal so monthly accrual financials tie out cleanly and your year-end tax CPA can bridge 4010/4020 in one line. |
Free Downloadable WIP Templates & Deep-Dive Operating Guides
26-Column ASC 606 WIP Schedule CSV
Includes row-by-row Excel formulas, 1360 uninstalled material exclusion, margin-fade bps, and 3 Trial Balance close gates.
Download WIP Template (.csv)Contractor QBO Chart of Accounts (1150-6240)
Exact QBO account numbers and types for clearing (1150-1170), retainage (1210), WIP (1350/2450), and loaded COGS (5100-5400).
Download COA CSV12-Gate FSM-to-QuickBooks Tie-Out Checklist
Step-by-step cutoff, consume-once AP matching, payroll allocation, and WIP reversal checks.
Download 12-Gate CSVSample Messy QBO Export (Test File)
Contains QBO report headers, Total rows, and a $28,450 Not-Specified COGS leak to test drag-and-drop parsing.
Download Sample ExportFrequently Asked Questions
How do you calculate overbilling and underbilling on a construction WIP schedule?
Under the cost-to-cost percentage-of-completion method, divide net installed job costs to date (excluding uninstalled staged materials held in Account 1360) by revised estimated total cost at completion (EAC) to measure progress, and multiply exact rational completion by revised contract value (base contract plus signed change orders) to compute earned revenue. Subtract earned revenue from cumulative progress billings: a positive result is an overbilling liability (Account 2450, Billings in Excess of Costs) and a negative result is an underbilling asset (Account 1350, Costs in Excess of Billings). Always total 1350 and 2450 separately on the Balance Sheet rather than netting them.
Why must uninstalled chillers, switchgear, or rooftop units be carved out of cost-to-cost % complete?
Under FASB ASC 606 input-method guidance, dropping a $42,000 piece of equipment at a yard or jobsite before crew installation does not advance physical construction progress. Leaving that $42,000 inside the cost-to-cost numerator inflates percent complete and pulls forward unearned gross profit. Hold uninstalled equipment in Account 1360 until installed, or apply the ASC 606 zero-margin pass-through method (recognizing earned revenue equal to equipment cost with $0 gross profit).
How are projected loss jobs handled on a WIP schedule?
Under retained construction contract loss guidance (ASC 605-35 / ASC 606 onerous contract testing), the moment revised estimated total cost (EAC) exceeds revised contract value, 100% of the total anticipated contract loss must be recognized immediately in the current accounting period rather than spreading the loss across remaining completion percentage. Any loss not yet absorbed in incurred cost minus earned revenue is booked to an Accrued Contract Loss Reserve (Account 2460).
How should a $2M to $30M contractor on QuickBooks adapt WIP alongside tax reporting?
Keep routine short-duration service tickets out of the WIP schedule using a documented management planning threshold (for example, fixed-price or progress-billed projects crossing month-end above $15,000 to $25,000), track job costs in QuickBooks Projects on an accrual basis, and record WIP into dedicated adjustment accounts (1350, 2450, 4010, and 4020) via a balanced Month-End Adjusting Journal Entry paired with a dated Day-1 reversal. Isolating WIP adjustments in dedicated accounts makes your year-end book-to-tax bridge explicit for your tax CPA (do not assume QuickBooks cash-basis report toggles automatically exclude journal entries without verifying your tax basis).