top of page

WIP Reporting for Electrical Contractors: Catching Over- and Under-Billing Before It Hurts Cash Flow

2 days ago
6 min read
Electrical contractor wearing a white hard hat inspecting an electrical control panel, with a colleague in the foreground.

For many electrical contractors, the WIP schedule is something the accountant builds for the bonding agent once a quarter. That timing is a problem, because by the time an under-billed job shows up on the report, the cash gap has already landed. Firms that pull WIP straight from live job cost data, often through commercial electrical contractor software, can spot billing gaps while there's still time to fix the next pay application. This guide covers how to read a WIP schedule and what it's telling you about each job.

If you've ever looked at a WIP report and thought, "I know this matters, but I'm not sure what it's saying," this one's for you.

What a WIP Schedule Is and Why Sureties Care

A work-in-progress (WIP) schedule is a snapshot of every open contract. For each job, it compares how much work you've actually done with how much you've billed.

That comparison matters because construction revenue doesn't follow invoices neatly. You might bill heavily early on a job, or fall behind on billing while your crews are working hard. The WIP schedule shows the real financial position of each job, not just what's gone out on invoices.

Sureties, banks, and CPAs all rely on it. Your bonding capacity depends partly on whether your WIP shows jobs that are profitable, billed correctly, and on track. A sloppy WIP can limit how much work you're allowed to bid, even when the business is doing fine.

But the most important reader of your WIP should be you.

The Core Columns Explained

Most WIP schedules use the percentage-of-completion method, usually calculated cost-to-cost. Here are the columns you'll see and what they mean:

●       Contract value: The total contract amount, including approved change orders.

●       Estimated total cost: What you currently expect the whole job to cost. This is the most important number on the sheet, and the easiest to get wrong.

●       Cost to date: What you've actually spent so far.

●       Percent complete: Cost to date divided by estimated total cost.

●       Earned revenue: Contract value times percent complete. This is the revenue you've earned based on progress.

●       Billed to date: What you've actually invoiced.

●       Over- or under-billing: The difference between billed to date and earned revenue.

A worked example

Say you have a $2.4 million tenant improvement job. You estimated it would cost $2 million, which leaves $400,000 in gross profit.

So far you've spent $900,000.

●       Percent complete: $900,000 ÷ $2,000,000 = 45%

●       Earned revenue: $2,400,000 × 45% = $1,080,000

Scenario A: You've billed $1,250,000. You're over-billed by $170,000.

Scenario B: You've billed $950,000. You're under-billed by $130,000.

Same job, same work done, very different stories.

Over-Billing vs. Under-Billing

What over-billing means, and when it's a risk

Over-billing means you've invoiced more than you've earned. On the balance sheet, it shows up as a liability, because you owe the customer work you've already been paid for.

A moderate amount of over-billing isn't necessarily bad. Many electrical contractors front-load billing to cover gear purchases and early labor, and positive cash flow on a job is a good thing.

It becomes a risk when:

●       The cash from over-billing gets spent on overhead or other jobs instead of staying available to finish this one.

●       The over-billing is hiding a cost problem, because invoices ran ahead while the real costs haven't shown up yet.

●       It's so large that a surety starts asking whether you're borrowing from future work to fund today.

The classic trap: a contractor over-bills early, spends the cash, and then has a job that costs money to finish with little left to bill. That's how a company can be busy and still run out of cash.

What under-billing means, and why it's often a warning sign

Under-billing means you've done more work than you've invoiced. It shows up as an asset, but it's an asset you haven't collected.

Sometimes there's a simple reason. A pay application went out late, or a change order hasn't been approved yet. Those are timing issues and usually fix themselves.

Often, though, under-billing is an early sign of fade. Fade happens when a job's profit shrinks as it goes. The most common cause is costs running higher than estimated while the estimated total cost on the WIP hasn't been updated. Costs are coming in faster than the job's progress justifies, and the WIP shows that gap as under-billing.

Sureties tend to watch under-billings closely for exactly this reason.

Electrical Jobs That Commonly Skew WIP

A few situations in electrical work distort WIP more than others:

●       Front-loaded gear purchases. Switchgear, panels, and transformers can make up a large share of job cost, and they often arrive early. Cost-to-cost percent complete will jump, which can make a job look further along than it really is in labor terms. Some firms handle gear separately in their WIP for this reason.

●       Unapproved change orders. Your crews are pulling wire for added circuits, but the change order is still sitting with the GC. The cost is in, but the contract value isn't, so the job looks worse than it is.

●       Labor productivity slips on rough-in. If rough-in is taking 20% more hours than estimated and nobody updates the cost-to-complete, the WIP won't show the problem until it's too late to fix.

●       Long-lead materials. Delays in gear delivery can stall a job and leave costs and billing out of sync for months.

Connecting WIP to AIA Billing and Retainage

Most commercial electrical contractors bill using the AIA G702/G703 forms. The G703 schedule of values breaks the contract into line items, and each pay application shows percent complete by line.

WIP and AIA billing should tell a consistent story. If the WIP says a job is 45% complete but your pay applications claim 60%, that's a gap worth understanding before the GC or the surety points it out.

Retainage adds another layer. On most commercial jobs, a portion of each payment is held back until the end of the project or a set milestone. Retainage percentages vary by contract and state, so track it separately. Retainage receivable is real money, but it's not money you can count on for this month's payroll.

When pay applications are generated from the same job cost data that feeds the WIP, these numbers stay in sync without someone rebuilding spreadsheets every month.

Keeping Cost-to-Complete Honest

Every WIP schedule depends on the estimated total cost. If that number is wrong, every other column is wrong too.

Here's what happens when the estimate is updated. Back to the $2.4 million job: say the PM admits rough-in is running behind and the job will now cost $2.15 million, not $2 million.

●       Percent complete: $900,000 ÷ $2,150,000 = about 41.9%

●       Earned revenue: $2,400,000 × 41.9% = about $1,004,700

●       Projected gross profit drops from $400,000 to $250,000.

That's not fun to see. But it's far better to see it at 42% complete than at 95%, when there's nothing left to do about it.

A few habits keep cost-to-complete honest:

●       Monthly PM reviews. Every PM should update cost-to-complete on every job, every month. No "we'll catch up at the end."

●       Labor units vs. budget. Track installed units, such as feet of conduit, devices, or fixtures, against budgeted hours. This is where productivity problems show up first.

●       Committed costs. Include POs and subcontracts that are committed but not yet invoiced. Otherwise you're only seeing part of the cost.

●       No sandbagging, no optimism. PMs sometimes hold back bad news, hoping to make it up later. Build a culture where an early warning is rewarded, not punished.

A Monthly WIP Review Routine

Here's a simple routine many electrical contractors use:

  1. Close job costs on time. Get labor, materials, and subcontractor costs posted within the first few days of the month.

  2. PMs update cost-to-complete. Each PM reviews their jobs and updates estimated total cost with notes explaining any changes.

  3. Accounting runs the WIP. Calculate percent complete, earned revenue, and over- or under-billing for every job.

  4. Flag the outliers. Look for large over- or under-billings, jobs where profit dropped since last month, and change orders still pending.

  5. Meet for 30 to 60 minutes. Owner, CFO or controller, and PMs walk through the flagged jobs. What's driving it? What's the fix?

  6. Adjust billing. Use what you learned to shape the next round of pay applications.

The Bottom Line

A WIP schedule isn't just a report for your bonding agent. It's the clearest early warning system an electrical contractor has. Over-billing tells you where cash might be at risk. Under-billing often tells you where profit is quietly shrinking. And an honest cost-to-complete tells you both while there's still time to act.

Review it monthly, keep the estimates current, and you'll catch problems on paper before they become problems in your bank account.

Thanks for signing up

© 2026 Project Manager Templates

Contact us on contact@projectmanagertemplate.com

Our network provides end-to-end support for project leaders, from downloadable industry-standard templates to in-depth technical guides and the latest PM software insights. Explore our specialized hubs to scale your PMO and drive strategic value in 2026

bottom of page