NetSuite WIP Reporting and Over/Under Billing for Contractors
Contractors run WIP reporting and over/under billing in NetSuite with BlueCollar Projects, a Built for NetSuite construction SuiteApp. BlueCollar Projects pulls revised contract values, budgets, commitments, actual job costs, and progress billings into one live WIP schedule, calculates earned revenue by percent complete, and posts monthly over/under billing adjustments directly to the NetSuite general ledger.
Why Native NetSuite Struggles With Construction Over/Under Billing
Standard NetSuite project accounting and Advanced Revenue Management (ARM) were built for software companies, milestone consulting, and time-and-materials services. When a general contractor or specialty subcontractor tries to run percentage-of-completion accounting in uncustomized NetSuite, three gaps surface at month-end:
- Disconnected contract, budget, and commitment records: Native NetSuite does not combine original cost-code estimates, approved owner change orders, open subcontractor commitments, and progress billings into a single construction WIP view. That is why many controllers end up exporting trial balances to Excel, a workflow we break down in our guide on why WIP reporting breaks in spreadsheets.
- Forecasted cost at completion (EAC) is not tied to cost codes: Accurate cost-to-cost percent complete requires comparing actual cost to date against a live Estimated Cost at Completion (EAC) that accounts for uncommitted budget and open subcontracts by cost code.
- No automated over/under billing balance sheet reclassification: In construction accounting, the variance between cumulative progress billings (such as AIA G702 and G703 pay applications) and earned revenue must be reclassified each month onto the balance sheet as either Billings in Excess of Cost and Earnings (overbilling) or Cost and Earnings in Excess of Billings (underbilling). Without a construction SuiteApp, accounting teams have to calculate and book these journal entries by hand for every active job.
If your team is looking for a foundational primer on WIP terminology before diving into the NetSuite mechanics below, read what is a WIP report in construction.
Core WIP Metrics Tracked per Job in BlueCollar Projects
Inside NetSuite construction software powered by BlueCollar Projects, every active project and contract rolls up the exact metrics construction controllers, CPAs, and surety underwriters expect on a monthly WIP schedule.
| WIP Metric | Formula or Source in NetSuite + BlueCollar Projects | Financial Statement Impact | Why Controllers Watch It |
|---|---|---|---|
| Revised Contract Value | Original contract value + approved owner change orders | Baseline for total contract revenue | Confirms all signed change orders are included before calculating earned revenue |
| Original & Current Budget | Baseline cost estimate + approved budget transfers and change order cost budgets by cost code | Baseline for projected gross margin | Separates initial estimating assumptions from approved scope growth |
| Actual Cost to Date | Posted vendor bills, subcontractor bills, materials, equipment, and field job costs by cost code | Direct job cost on the P&L | Drives the numerator of the cost-to-cost percent complete formula |
| Committed Cost | Open purchase orders and subcontracts not yet billed into AP | Off-balance-sheet commitment exposure | Prevents understating remaining cost when subcontracts are signed but unbilled |
| Estimated Cost at Completion (EAC) | Actual Cost to Date + Estimated Cost to Complete (CTC), informed by open commitments | Determines total expected job cost | A rising EAC immediately reduces percent complete and earned revenue |
| Percent Complete | Actual Cost to Date / Estimated Cost at Completion (EAC) | Drives period revenue recognition | Measures true physical and financial progress on cost-to-cost contracts |
| Earned Revenue to Date | Percent Complete * Revised Contract Value | Recognized contract revenue on the P&L | Represents the revenue the contractor has actually earned through work performed |
| Billed to Date | Cumulative posted customer progress invoices and AIA billings (before retainage withholding) | Trade AR + Retainage Receivable | Shows total progress draws sent to the owner to date |
| Overbilling (Billings in Excess of Cost and Earnings) | Billed to Date - Earned Revenue to Date (when Billed > Earned) | Current Liability on the Balance Sheet | Indicates front-loaded billing; protects cash flow but defers unearned revenue |
| Underbilling (Cost and Earnings in Excess of Billings) | Earned Revenue to Date - Billed to Date (when Earned > Billed) | Current Asset on the Balance Sheet | Flags unbilled work, slow draw approvals, or unapproved change orders eating margin |
| Projected Gross Profit & Margin | Revised Contract Value - Estimated Cost at Completion (EAC) (and / Revised Contract Value) | Forecasted gross profit at closeout | Highlights profit fade early enough for project management to intervene |
How to Fix Over/Under Billing Reporting in NetSuite With BlueCollar Projects
BlueCollar Projects replaces manual spreadsheet reconciliations with a structured five-step monthly WIP and over/under billing workflow inside NetSuite:
- Capture actual job costs and commitments by cost code: Every purchase order, subcontract, subcontractor bill (including retainage payable), and material receipt is tagged to a BlueCollar project and cost code. For a deeper look at cost-code structure, see our NetSuite construction job costing guide.
- Update Estimated Cost at Completion (EAC) with project managers: Project managers and controllers review each active job in BlueCollar Projects, comparing original budget, approved changes, committed costs, and actual cost to date to set the Cost to Complete (CTC) and resulting EAC.
- Calculate percent complete and earned revenue: BlueCollar Projects computes Actual Cost to Date / EAC for each contract, multiplies percent complete by the revised contract value, and compares earned revenue to cumulative progress billings.
- Post over/under billing and revenue recognition journal entries: At month-end, the revenue recognition tool in BlueCollar Projects posts the adjustment between billed revenue and earned revenue directly to the NetSuite general ledger:
- When a job is overbilled (Billed to Date > Earned Revenue): NetSuite debits Construction Revenue (reducing recognized revenue down to earned revenue) and credits Billings in Excess of Cost and Earnings (current liability).
- When a job is underbilled (Earned Revenue > Billed to Date): NetSuite debits Cost and Earnings in Excess of Billings (current asset) and credits Construction Revenue (recognizing earned but unbilled revenue).
- Entries can be configured to auto-reverse on the first day of the following accounting period or post on a net-change basis, keeping the WIP report and the NetSuite Balance Sheet in lockstep.
- Lock the period and publish surety-ready WIP schedules: Once journal entries are posted, controllers can filter the WIP schedule by subsidiary, project manager, job status, or customer, and tie the totals directly to the NetSuite Trial Balance.
Connecting Field Budgets From Procore and Financial Operations Oversight
For contractors whose project managers run jobs in Procore while accounting runs in NetSuite, WIP accuracy depends on keeping field budgets and change orders aligned between both systems. With our NetSuite Procore integration (the Procore Connector by BlueCollar), projects, cost codes, budgets, prime contracts, approved change orders, commitments, and subcontractor invoices sync from Procore into NetSuite, while owner progress invoices and payments sync back to Procore. Accounting runs the WIP report in NetSuite using field numbers that already match Procore.
BlueCollar Cloud Solutions works with 90+ construction contractors on NetSuite. BlueCollar Projects is a Built for NetSuite SuiteApp with no separate infrastructure, and our team is made up of former NetSuite employees and construction finance practitioners. For contractors who also want hands-on accounting help closing the books and reviewing monthly WIP schedules, our construction financial operations team works directly inside your NetSuite environment.
Frequently Asked Questions
How do you calculate over/under billing on a construction WIP report in NetSuite?
First, calculate percent complete by dividing actual job cost to date by estimated total cost at completion (EAC). Multiply percent complete by the revised contract value to get earned revenue to date. Compare earned revenue to cumulative progress billings to date: if billings exceed earned revenue, the contract is overbilled (a current liability); if earned revenue exceeds billings, the contract is underbilled (a current asset). BlueCollar Projects runs this calculation per contract inside NetSuite.
Can NetSuite run construction WIP reports without exporting to Excel?
Yes, when paired with BlueCollar Projects, a Built for NetSuite construction SuiteApp. While native NetSuite lacks a single construction WIP schedule that combines original budgets, approved change orders, open commitments, actual job costs, and progress billings, BlueCollar Projects tracks all of those metrics on the NetSuite project record and generates live WIP reports directly inside NetSuite.
Where do overbilling and underbilling post on a contractor's NetSuite balance sheet?
Overbilling posts to a current liability account commonly titled Billings in Excess of Cost and Earnings (or Contract Liabilities under ASC 606). Underbilling posts to a current asset account commonly titled Cost and Earnings in Excess of Billings (or Contract Assets). BlueCollar Projects generates the monthly revenue recognition and over/under billing journal entries in NetSuite so the general ledger ties directly to the WIP schedule.
How do change orders and subcontractor commitments affect NetSuite WIP reporting?
Approved owner change orders increase the revised contract value and update the current cost budget on the job. Subcontracts and purchase orders establish committed cost before vendor bills arrive, which informs the project manager's forecasted cost at completion (EAC). When an approved change order or commitment updates in BlueCollar Projects (or syncs from Procore via the Procore Connector by BlueCollar), the WIP report reflects the updated contract value, budget, and projected margin.
What is the difference between native NetSuite revenue recognition and BlueCollar Projects WIP?
Native NetSuite Advanced Revenue Management (ARM) and SuiteProjects are built primarily for software subscriptions, milestone deliverables, and time-and-materials services. Construction contractors require cost-to-cost percent complete calculations tied to CSI or custom cost codes, subcontractor commitments, retainage, and monthly over/under billing balance sheet reclassifications. BlueCollar Projects adds construction-specific WIP and over/under billing workflows directly inside NetSuite.
Related Reading
- What is a WIP report in construction
- Why WIP reporting breaks in spreadsheets
- NetSuite schedule of values and AIA billing
- NetSuite retainage tracking for contractors
- NetSuite construction job costing guide
- NetSuite Procore integration
- Construction project accounting in NetSuite
- NetSuite construction software
Ready to replace spreadsheet WIP reconciliations with live NetSuite WIP and over/under billing?
Talk to our team
