Most pool builders have never seen a work-in-progress (WIP) schedule, let alone reviewed one monthly. That's not a knock — it's not a report QuickBooks generates on its own, and it's not something a once-a-year CPA relationship tends to produce mid-year when it would actually be useful. But it's the single report that answers a question every pool builder should be able to answer at any moment: is this job ahead of where it should be, or behind?
What a WIP schedule actually shows
A WIP schedule lines up, for every active job, three numbers side by side:
- Contract value — the total the customer agreed to pay
- Costs incurred to date — what you've actually spent on labor, materials, and subs so far
- Billings to date — what you've actually invoiced or drawn from the customer so far
From those three numbers, the schedule calculates whether you're overbilled or underbilled relative to the percentage of work actually completed. Overbilled means you've collected more than the work performed justifies — which feels good in the bank account but is actually a liability, because you owe that work. Underbilled means you've done more work than you've been paid for — which is the far more dangerous position, because you're financing the job out of pocket and may not realize it.
Why backlog alone is misleading
A full backlog looks like security. It isn't, on its own. A job that's 80% complete but only 40% billed is quietly draining cash from the rest of the company — every day it stays that way, you're funding it with money that should be going toward the next job's materials or this month's payroll. Multiply that across 10-15 active jobs and it's easy to see how a company doing real revenue growth can still feel perpetually cash-poor.
This is exactly why job costing pool contractors rely on can't stop at the individual job level — it has to roll up into a WIP view across every active contract at once, so underbilled jobs surface before they become a cash crisis instead of after.
What to do with it once you have it
A WIP schedule isn't just a diagnostic — it's a decision tool. When a job shows up underbilled, the fix is usually straightforward: accelerate the next draw, invoice a completed milestone you haven't billed yet, or in some cases renegotiate the payment schedule going forward. None of that is possible if you don't know the job is underbilled until it's finished and the cash is already gone.
Reviewed monthly across the whole active job list, a WIP schedule turns "the bank balance looks okay" into "here's exactly which three jobs need attention this week, and why."
Where this fits
This continues our series on the specific financial mechanics of running a pool construction company. If tracking billings against costs, job by job, sounds like something your current bookkeeping doesn't do, our outsourced accounting and software build the WIP schedule automatically from your draw and cost data — no manual spreadsheet required. Or schedule a free 30-minute call to see what your own WIP picture looks like.