How to post the WIP journal entry in QuickBooks Online
Your WIP schedule says which houses are over or under billed. This is how the result gets into the books each month, and how to reverse it.
Short answer: To book WIP in QuickBooks Online, post a journal entry dated the last day of the month for each house's over or under billing from your WIP schedule. Debit an asset account, Costs in Excess of Billings, for under billing. Credit a liability account, Billings in Excess of Costs, for over billing. The other side is a revenue adjustment. Reverse it the next month.
Why the entry exists
In QuickBooks Online, revenue follows your invoices. On a house billed by draws or milestones, invoices rarely match the work done. A WIP schedule calculates what you have earned on each house. The WIP journal entry moves the books from what you billed to what you earned, so the monthly profit and loss shows progress and the balance sheet shows over and under billing. It does not change the invoices.
Set up three accounts first
| Account | Type | What it holds |
|---|---|---|
| Costs in Excess of Billings (underbillings) | Other current asset | Work earned but not yet billed |
| Billings in Excess of Costs (overbillings) | Other current liability | Billed ahead of the work |
| Revenue, WIP adjustment | Income | The offset that moves revenue to match percent complete |
Some firms put overbillings in a current asset type for sorting. The liability treatment matches how the balance is described in construction accounting. Ask your CPA which they want.
The entry, with a made-up example
These numbers are made up. Lot 14 has earned $300,000 and billed $340,000, so it is over billed $40,000. Lot 9 has earned $297,600 and billed $270,000, so it is under billed $27,600. Post one journal entry dated the last day of the month, with the house on each line.
| Account | House | Debit | Credit |
|---|---|---|---|
| Costs in Excess of Billings | Lot 9 | $27,600 | |
| Revenue, WIP adjustment | Lot 9 | $27,600 | |
| Revenue, WIP adjustment | Lot 14 | $40,000 | |
| Billings in Excess of Costs | Lot 14 | $40,000 |
The net effect on revenue is a $12,400 reduction for the month, which is what the two houses earned less than they billed. Because the house is on each line, a project report shows each house at earned revenue, not billed revenue.
Reverse it on the first day of the next month
The balances are only true on the last day of the month. If you leave the entry in place, next month's invoices stack on top of it and revenue is counted twice. Intuit's Reverse option creates a new entry that swaps the debits and credits and is dated the first day of the month after the original. Then you post the new month's entry from the new WIP schedule. Post every month, or the profit and loss will jump around.
Where this goes wrong
- A stale estimated total cost. The entry is only as good as percent complete, which is cost to date divided by the current estimated total cost. See how over and under billing is calculated.
- Costs missing from the month. A sub bill that arrives after close makes the house look less complete than it is. Accrue or hold the close. See the month-end close checklist.
- Netting houses. One total hides which house is over billed and which is under billed. Keep a line for each house.
- No reversal. Always reverse, then post fresh.
- Editing closed periods. Set a closing date, then correct with a new entry.
Who should post it
Intuit advises creating journal entries as a last resort or with your accountant's help. A WIP entry is a routine, valid use, but have your CPA confirm the accounts, the method and how it ties to your tax return before you start. This page is general guidance, not tax advice.
How we help
Our team builds the WIP schedule each month and posts and reverses the entry, so the profit and loss and balance sheet match the work on each house. Our founder reviews every close. We quote a flat monthly price for each builder, starting at $1,500 a month, with typical engagements between $2,500 and $8,500 a month. Start with a $1,500 Margin Review for written findings. See job costing, construction bookkeeping, pricing or request a Relationship Assessment.
Sources
- Intuit, Reverse or delete a journal entry (reversal is dated the first day of the following month)
- MyBuilderCPA, Posting WIP in QuickBooks: how to record and reverse your work-in-progress journal entry (May 29, 2025)
- FinTruction, Construction WIP schedule template: month-end adjusting entries for over and under billings
- Procore, The Essential Guide to Construction Work in Progress (WIP)
Common questions
What is the WIP journal entry in QuickBooks Online?
A month-end journal entry that moves revenue from what you billed to what you earned, using the over and under billing from your WIP schedule. It is reversed on the first day of the next month.
Which accounts do I debit and credit for under billing?
Debit Costs in Excess of Billings, an asset, and credit a revenue adjustment account, tagged to the house.
Which accounts do I debit and credit for over billing?
Debit the revenue adjustment account and credit Billings in Excess of Costs, a liability, tagged to the house.
Do I need to reverse the WIP entry?
Yes. The balance is only true on the last day of the month, so reverse it on the first day of the next month and post a new entry from the new WIP schedule.
Does the WIP entry change my invoices?
No. Invoices stay as they are. The entry only adjusts revenue and the balance sheet to match earned revenue.
Should I post this myself?
Intuit advises journal entries as a last resort or with an accountant. Have your CPA confirm the accounts and method first.
Related
- What is a WIP schedule?
- WIP over and under billing for builders
- WIP schedule example for a custom home builder
- Month-end close checklist for builders
- Glossary: over billing vs under billing
- WIP schedules service
By John Mos, Founder. Updated . We do not give tax or legal advice. Please ask your CPA or attorney.
See where your margin goes, house by house.
Tell us about your homes and your books. If we are a fit, we start with a $1,500 Margin Review: written findings and a fixed quote in 10 business days, credited to your onboarding fee if you sign up.