Guide

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

AccountTypeWhat it holds
Costs in Excess of Billings (underbillings)Other current assetWork earned but not yet billed
Billings in Excess of Costs (overbillings)Other current liabilityBilled ahead of the work
Revenue, WIP adjustmentIncomeThe 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.

AccountHouseDebitCredit
Costs in Excess of BillingsLot 9$27,600
Revenue, WIP adjustmentLot 9$27,600
Revenue, WIP adjustmentLot 14$40,000
Billings in Excess of CostsLot 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

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

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.