You keep building. We’ll prepare your WIP.
Levvigo prepares your monthly WIP schedule from reports you already have, with the journal entries to post and a plain-English walkthrough before you meet your bond agent, surety, or CPA. Monthly from $2,500, one-time from $6,500.
Downloadable construction WIP template. Download it here (Excel).
A WIP report and a P&L are supposed to agree. Total costs to date across every job on the WIP, for the period you’re looking at, should equal cost of revenues on the income statement. Earned revenue on the WIP should equal revenue on the income statement once the over/under billing adjustment is booked. When they don’t agree, the natural instinct is to start hunting job by job. That’s slow, and it’s usually the wrong place to start.
I’ve reconciled a lot of WIP reports to a lot of financial statements. The differences almost always come from a short list of causes. This is where I look, in the order I look.
Start with transactions in your job cost accounts that aren’t attached to a job. Pull each job cost account for the period and look for lines where the job or customer field is blank. A fuel bill that got coded to materials with no job. A subcontractor invoice entered in a hurry. A credit card import that landed in a job cost account and never got assigned. Every one of those shows up in cost of revenues on the P&L and nowhere on the WIP. Fixing this has solved 90 percent of the cost reconciliation problems I’ve run into. If I could only check one thing, this is the thing.
If the unassigned transactions don’t explain the difference, compare the total for cost of revenues on the P&L against the sum of the individual accounts that feed your job cost reports. These should be the same number. It sounds goofy, like it shouldn’t even be possible for them to be different, but it is and I’ve seen it many times. An account gets added to the cost of revenues section of the P&L but never gets included in the job cost report setup. Or an account that is really overhead gets pulled into job cost reporting. Or someone reclassified an account mid-year and the two reports now disagree about where it lives. Lay the account lists side by side and the odd one out usually jumps off the page.
Take a few deep breaths first. Then make sure that everything you are treating as revenue is actually revenue, and everything you’re treating as billings is actually billings.
Here is why that matters. When you create an invoice in an accounting system, you create a billing. The accounting system assumes that invoice equals revenue earned, because in most industries it does. Not in construction. Revenue on a contract is earned as the work is performed, which is why the WIP calculates it from percent complete rather than from what you’ve invoiced. The revenue line on your P&L, before you book the over/under billing adjustment, is really your billings. Earned revenue is billings plus underbillings minus overbillings.
Many, many times I’ve been deep in a WIP report, stuck on revenues not tying, only to realize that what I’d been calling revenue was actually billings. Or the other way around. The difference I was chasing was the over/under billing adjustment itself. This is an easy mistake to make, especially when you’ve been in the weeds for a few hours and every column is starting to look the same. Label your columns clearly and recheck what each one holds before you go hunting anywhere else.
If revenue and billings are straight and it still doesn’t tie, check your beginning balances for over and underbillings. The adjusting journal entry you book each period is the change in those balances, so it is only right if the starting point is right. Pull the balance sheet accounts for costs and estimated earnings in excess of billings and billings in excess of costs and estimated earnings as of the end of the prior period, and compare them to the prior period’s WIP. If someone booked a manual entry to one of those accounts, or last period’s adjustment got posted twice, or never got posted at all, your entry this period will be off by exactly that amount and revenue will never tie no matter how many times you rerun the report.
The key is discipline. Identify the job cost accounts on your P&L and use them only for job costs. Nothing gets coded to those accounts without a job attached, and nothing that isn’t a job cost gets coded there at all. If a transaction doesn’t belong to a job, it doesn’t belong in a job cost account. That one rule removes most of the reconciling work before it starts.
Have a plan for indirect costs. Small tools, fuel, equipment, shop labor, supervision and the rest have to go somewhere, and if you decide where every month on the fly, you’ll get a different answer every month. Draft a job costing accounting policy. Write down which costs are direct, which are indirect, how the indirect costs get allocated to jobs, and which accounts each one lands in. This may sound like busywork. It isn’t. Do the thinking once, now, and the WIP will tie faster every month after. If you need help drafting one, call me.
If your WIP report doesn’t tie to your P&L, I can help you find the difference and put a repeatable monthly process in place. See Levvigo’s WIP preparation services, or schedule a call with me to talk through your WIP reconciliation and job costing.

Bryce Wisan, CPA, CCIFP
Founder & Chief
Bryce has spent 15+ years in construction accounting and founded Levvigo to give contractors an outsourced, construction-trained accounting team, business operations support, and practical AI implementation.
© Levvigo 2026. All rights reserved.