I think the work-in-progress (WIP) schedule is the most important financial report a contractor prepares. After more than 15 years in construction accounting, much of it as an audit partner working only with contractors, I haven't found another report that tells an owner as much about the business.
Many contractors only prepare a WIP when a bank, surety, or CPA asks for one. If nobody is asking you for one, I'd still prepare one at year-end. You'll learn things about your jobs and your processes that the financial statements won't show you.
For every open job you need the contract amount including approved change orders, the costs to date, the estimated cost to finish, and the amount billed.
Getting those numbers together shows you how well accounting and project management are working. If costs are landing on the wrong jobs or invoices are being entered late, you find out when you try to pin down what a job has cost. If your project managers aren't keeping their estimates to complete current, you find out when you ask for them. If accounting and the project manager have different contract amounts, usually because of change orders, that comes out too.
I've seen contractors where accounting reports one margin on a job and the project manager expects a different one. That's a problem no matter which number is right. Preparing the WIP makes the two sides settle on one number.
I wrote more about this in Your WIP schedule is a diagnostic, not just a report.
Your income statement reports the profit recorded so far. The WIP tells you whether that profit holds up once you account for what it will cost to finish the work.
Take a $2 million job budgeted at $1.6 million of cost, a 20% margin. Halfway through you've spent $800,000 and the job looks 50% complete. Then the project manager tells you it will take another $1 million to finish. Total cost is now $1.8 million. The expected profit has dropped from $400,000 to $200,000, the margin is 10%, and the job is 44% complete instead of 50%. If you recognize revenue on percentage of completion, the revenue you've already recorded on that job is about $111,000 too high.
Your income statement can look fine while that is happening on several jobs. The WIP shows you, job by job, the expected profit, how the margin has moved since the original estimate, and whether billings are ahead of or behind the revenue earned.
A profitable contractor can still run short of cash, because costs, billings, and collections don't happen at the same time. The WIP shows you two of those timing differences.
A job is underbilled when you've earned more revenue than you've billed. Sometimes that's the billing terms or the timing of a milestone. Sometimes it's a change order that hasn't been approved, or a project manager who is late getting billing information to accounting. You can't collect what you haven't billed, so every underbilling is worth a question.
A job is overbilled when you've billed more than you've earned. That helps cash today, but you still owe the work. A company with large overbillings can look flush when much of that cash is needed to finish the jobs. I covered this in A Job Can Be 40% Profitable and Still Sink the Company.
The WIP won't tell you when customers will pay or when your bills come due. Read alongside receivables, payables, and the commitments remaining on your jobs, it gives you what you need to build a cash forecast.
Monthly is better. A monthly WIP gives you time to act while a job is still open. But if you aren't preparing one at all, year-end is the easiest place to start. You're already closing the books, pulling information together for your CPA, and thinking about next year.
Expect the first one to turn up problems. Job costs may need cleanup. Your project managers may need a set process for updating their estimates. Accounting and operations may need to talk more often. Finding those things is the reason to do it, and fixing them is what makes a monthly WIP possible next year.
If you want to prepare it yourself, start with our step-by-step guide to preparing a WIP report and the free Excel WIP template.
If you'd rather have help, Levvigo prepares year-end and monthly WIP schedules from reports you already have. Learn about our WIP preparation services.