WIP Report Checklist for Contractors
Your CPA, bond agent, or surety has asked for a WIP report. Or you've decided you need one and you're having someone prepare it. Either way, the person preparing it needs information from you first, and most of it is information only you and your team have.
This checklist tells you what to gather. You don't need to know how a WIP report is calculated to use it. You need to know your jobs. Getting these items together before the work starts means the WIP gets done faster and the numbers are ones you can stand behind. The download is two pages, and the second page shows the four numbers for one sample job.
Download the WIP report checklist (Word)
If the report itself is new to you, start with What is a Construction WIP Report?
The four numbers needed for every job
A WIP report is built from four numbers for each job, all as of the same date.
- Contract amount. What the customer has agreed to pay, including approved change orders.
- Total estimated job costs. What you now expect the whole job to cost, from start to finish.
- Job costs to date. What you have spent on the job so far.
- Billings to date. What you have invoiced the customer so far.
Everything else on the report is calculated from those four. Your preparer does that part.
Pick the date
Ask your preparer what date the WIP should be as of. It's usually the last day of a month, a quarter, or your year. Everything on this list should be as of that date.
Make a list of your jobs
List every job that was in progress on that date. Add any job you finished during the year, even if it's closed and paid. A job name or number for each one is enough.
From the people who run your jobs
These items come from operations and estimating, meaning the owner, your project managers, and your estimator. They're the people who know what was sold and what the job will cost.
Contract amount. For each job, the signed contract amount plus every change order the customer has approved.
Pending change orders. List these separately. A pending change order is extra work you've priced or started that the customer hasn't signed off on yet. Write down the amount and whether the work has started.
Total estimated job costs. This is the most important number on the list, and it has to come from someone who knows the job. It's the total you now expect to spend on the job from start to finish, including what you've already spent. Start with the cost estimate you bid the job from. Add the cost of approved change orders. Then adjust for what you've learned since, like work that's running over, savings when you bought out the job, or price increases.
You don't need to work out how much is left to spend. Your preparer calculates that from the total.
If an estimate hasn't been updated since the bid, say so. An honest rough number from the project manager is more useful than an old budget passed off as current.
From your books
These items come from whoever keeps your books, whether that's a bookkeeper, a controller, or an outside accountant.
Job costs to date. A report showing costs by job through the date. Before you run it, make sure the bills and payroll through that date have been entered and that each cost has a job on it. If you know some costs aren't assigned to jobs, tell your preparer. They can help sort it out, but only if they know about it.
Billings to date. A report showing what you've invoiced on each job through the date, including any retainage the customer is holding.
Financial statements. A profit and loss statement and a balance sheet as of the date. Your preparer uses these to make sure the WIP agrees with your books.
Your last WIP report. If one was prepared before, include it. If this is your first, include last year's financial statements or tax return from your CPA.
Things to tell your preparer
Some of the most useful information isn't in any report. Tell your preparer about any of these.
- Jobs you think are losing money
- Disputes or claims with a customer
- Work you've finished but haven't billed
- Bills from subcontractors or suppliers that you know are coming but haven't received
- Jobs that have stopped or been delayed
If you can't find something
Send what you have and say what's missing. Don't hold everything back until it's perfect, and don't fill a gap with a number you wouldn't defend. Your preparer has seen incomplete records before and can tell you what matters most.
If you need someone to prepare it
Levvigo prepares monthly and year-end WIP schedules from reports you already have. We walk you through the results in plain English before you meet with your bond agent, surety, or CPA. Learn about our WIP preparation services.
Common questions
Who prepares a WIP report?
Some contractors prepare it in house. Many have their CPA or an outside construction accountant prepare it. Whoever does it needs the information on this checklist from you.
Why does my bond agent or surety want a WIP report?
It shows how each job is doing and whether the profit on your financial statements will hold up once the jobs are finished. We cover the common situations in When Contractors Need a WIP Report.
What if my estimates haven't been updated since the bid?
That's common. Go through the open jobs one at a time with the project manager and ask what has changed since the bid. Tell your preparer which jobs you're least sure about.
How long does it take to gather all of this?
It depends on how current your books and estimates are. The job list, contracts, and billings are usually quick. Total estimated job costs take the longest, because someone has to think through each job.
What is total estimated job cost?
It's the total you expect to spend on a job from the first day to the last, including what you've already spent. It starts as the cost estimate you bid the job from, and it should be updated as the job changes. It is not the contract amount, and it is not the amount you have left to spend.
Do I need to include jobs that are already finished?
Yes, if they finished during the year the WIP covers. A finished job still has revenue and cost for the year, and your preparer needs it to make the WIP agree with your books.
Do I include change orders the customer hasn't signed yet?
List them separately from the approved ones, with the amount and whether the work has started. Don't add them to the contract amount yourself. Your preparer will decide how to handle them.
What if my costs aren't tracked by job?
Tell your preparer before they start. A WIP needs costs by job, so someone will have to go back through the bills and payroll and assign them. That's more work, and it's better for everyone to know at the beginning.
What date should my WIP report be as of?
Use the date the person asking for it gives you. It's usually the end of a month, a quarter, or your year. If nobody has given you a date, ask before you gather anything.
How often will my bond agent or surety ask for a WIP report?
At least at year-end, and sometimes quarterly or when you ask for a larger bond. Ask your bond agent what they expect so it doesn't catch you off guard.
Can my bookkeeper put this information together?
Your bookkeeper can pull the costs, the billings, and the financial statements. Contract amounts and total estimated job costs have to come from the people who run the jobs. Your bookkeeper can collect those numbers but shouldn't be the one coming up with them.
What happens if the numbers I send are wrong?
The report will show profit that isn't there, or miss a job that's losing money. Your bond agent and surety rely on the WIP, so one that turns out to be wrong costs you credibility with them when the job finishes. If you aren't sure about a number, say so when you send it.