What is a WIP report and why does my construction company need one?
A Work-in-Progress report is a schedule of every active job showing four numbers that matter. The contract amount, total estimated cost, costs incurred to date, and revenue billed to date. From those numbers you calculate percentage complete, earned revenue, and whether each job is overbilled or underbilled.
Percentage complete is usually figured using the cost-to-cost method. Actual costs to date divided by total estimated costs. If you’ve spent $300,000 on a job with $1,000,000 in estimated costs, you’re 30% complete. Earned revenue is that percentage multiplied by the contract amount. If the contract is $1,300,000 and you’re 30% complete, you’ve earned $390,000.
Then you compare earned revenue to what you’ve actually billed. If you’ve billed $450,000 but only earned $390,000, you’re overbilled by $60,000. If you’ve billed $350,000 on the same job, you’re underbilled by $40,000. Both scenarios tell you something important.
Overbilled jobs mean you’ve collected money for work not yet performed. That’s cash you have now but owe in performance later. Spend it on other things and you’ll have a cash crunch when the remaining work needs to get done. Underbilled jobs mean you’re financing the project with your own money. Work has been completed but not yet invoiced, which ties up cash and strains working capital.
Bonding companies require WIP reports. If you want surety bonds for public work or larger private projects, the bonding agent will ask for a current WIP schedule along with your financial statements. They’re evaluating whether you can complete the backlog without running out of cash. No WIP, no bond.
Banks require them too. Construction lines of credit and project financing typically come with ongoing WIP reporting requirements. Your lender wants to see the same picture the bonding company does. Whether your billing is keeping pace with the work.
For internal use, the WIP report catches problems while you can still do something about them. A job trending over budget shows up as costs exceeding the estimated percentage. Billing falling behind shows up as an underbilled position. Catching this at 40% complete gives you time to adjust. Finding out at closeout means the money is already gone.
The WIP also drives proper percentage-of-completion accounting on your financial statements. Without it, your P&L shows whatever happened to get billed and paid in a given month, which has nothing to do with actual profitability by job. Clean construction job costing is what makes a WIP report possible in the first place. You can’t produce an accurate schedule if costs aren’t being coded to the right jobs as they hit your books.
Most contractors who come to Pasadena bookkeepers asking for help with bonding or bank reporting actually need the underlying job cost structure fixed first. Once that’s in place, the WIP report falls out of the system every month without a scramble.
Pasadena's Small Business Bookkeeper
The Next Step:
A 15-Minute Call
Tell us where your books stand today. We'll ask a few questions, share how we can help, and give you a clear quote.
More Questions
How do I track warranty work costs for my electrical contracting business?
Set up a separate job or project specifically for warranty callbacks and code all labor, materials, and travel time to it. Treating warranty as its own cost bucket shows you the true expense and lets you price it into future bids.
Read answerHow should a general contractor track subcontractor costs by project?
Every sub payment needs to be coded to a specific job and tracked against the original bid. Monitor variances throughout the project to catch overruns early, and collect W-9s upfront so 1099s aren't a scramble in January.
Read answerHow do I prepare for a California sales tax audit as a contractor?
Preparing for a CDTFA audit as a California contractor means organizing material purchase records, resale certificates, use tax accruals, and documentation showing how each material was used. California treats contractors as consumers of materials they install, which creates specific audit exposure most contractors don't understand until the notice arrives.
Read answerHow should a plumbing company set up QuickBooks for job tracking?
Use QuickBooks Online Plus or Advanced so you can access the Projects feature. Create a project for every job, set up service items for the types of work you do, and use classes to track crews or trucks. The setup takes effort upfront but it's what makes job profitability visible.
Read answerWhat is progress billing and how does it work for general contractors?
Progress billing means invoicing the owner in stages based on how much of the work you've completed, not at project end. Each pay application breaks down work completed to date, retainage withheld, and the net amount due for that period.
Read answerHow do contractors account for retainage in their books?
Track retainage in a separate balance sheet account instead of regular AR. When you bill with retention withheld, split the entry between AR for the payable portion and Retention Receivable for the withheld amount. Release the retention to AR when the project closes out.
Read answer
