QuickBooks cleanup for home builders: the order that works
A cleanup that only categorizes bank lines leaves a builder with balanced books and no job cost. Here is the order, with the construction steps added.
Short answer: Clean up a builder's QuickBooks Online file in this order: back up, fix the chart of accounts, reconcile every bank, card and loan account, clear the Uncategorized accounts, empty Undeposited Funds, zero out Opening Balance Equity, match payroll and sales tax liabilities, then do the construction work: rebuild houses and cost codes, recode costs, split out retainage and deposits and build a WIP schedule. Lock the period last.
Generic cleanup is a third of the job
General cleanup checklists, including Intuit's, cover bank feeds, reconciliations, categorizing and tax preparation. That gets books that balance. A builder also needs books that answer "what did each house cost?", and that takes extra steps. Intuit lists preparing for a loan, tax season and a surprising profit and loss as reasons to start a cleanup. For a builder, a lender request and a bad year-end are the common triggers.
Steps 1 to 7: make the file trustworthy
An accounting firm's published QuickBooks Online checklist gives the order, and the order matters because fixing steps out of sequence means redoing them. Start from the last point you can trust, usually your last filed return or last reconciled month.
- Back up and gather. Export the company file and collect statements for every account, loan statements, payroll reports, sales tax returns and your last filed return.
- Clean the chart of accounts. Merge duplicates, make unused accounts inactive and fix accounts of the wrong type, such as a loan set up as an expense. Compare to the builder chart of accounts.
- Reconcile every bank, card and loan account, oldest month first, to a $0.00 difference.
- Clear the bank feed and the Uncategorized accounts. Watch for downloaded deposits added as new income when they should match an invoice payment already recorded, which counts the sale twice.
- Empty Undeposited Funds. Group payments into deposits that match the bank. Old balances are often duplicates.
- Zero out Opening Balance Equity. Make each opening balance match its statement, then move the rest to the correct equity account. Equity should tie to your last filed return.
- Match payroll and sales tax liabilities to your payroll provider and filed returns.
Want your books cleaned up and kept clean? Request a Relationship Assessment.
Steps 8 to 10: make it a builder's file
- Rebuild houses and cost codes. Every active and recently closed house set up as a customer and project, with one cost code list. See cost codes and classes vs projects.
- Recode costs to the right house. Move sub invoices, lumber, rentals and fuel posted to a generic materials account onto the house they belong to. This is the slow step and the one that produces job cost you can trust. Look for bills entered twice or never, and deposits posted straight to income.
- Split out retainage, deposits and the WIP. Retainage receivable and payable in their own accounts, customer deposits as a liability, change orders on the contract, then build the WIP schedule. See retainage, deposits and the WIP schedule example.
A contractor-focused cleanup guide describes the end state as one where the sum of your house costs equals what the general ledger says and where the balance sheet survives a lender reading it closely. Then lock the period with a closing date so it stays clean.
What to do each month so it stays clean
- Close monthly. See the month-end close checklist.
- Run the signs your books are wrong check.
- Use a bank rule only when the vendor always goes to the same account. Never for a cost that varies by house.
When to bring in help
Forced reconciliations, a year or more of uncategorized bank lines, returns filed from numbers that do not match the file and a file converted from Desktop with balances that did not carry over are signs the job is larger than a weekend. This page is general guidance, not tax advice.
How we help
Our team does builder cleanups end to end: the clean-file steps, then houses, cost codes, retainage and a WIP schedule your lender can read. 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 QuickBooks, 12 steps for bookkeeping clean up
- SDO CPA, QuickBooks Online cleanup checklist
- FinTruction, Construction bookkeeping cleanup and catch-up for contractors
Common questions
What order should I clean up QuickBooks Online in?
Chart of accounts, then reconcile every account, then Uncategorized, then Undeposited Funds, then Opening Balance Equity, then payroll and sales tax liabilities, and lock the period last.
Why is a builder's cleanup different?
Balanced books do not tell you what each house cost. A builder also needs houses and cost codes rebuilt, costs recoded to houses, retainage and deposits split out and a WIP schedule.
What is Opening Balance Equity?
A placeholder account QuickBooks uses for starting balances. It should end at zero once the balances are correct and moved to the right equity account.
What is Undeposited Funds?
An account that holds customer payments until you record the bank deposit. Old balances are often payments recorded twice.
How long does a cleanup take?
It depends on months behind, number of accounts and transaction volume.
Can you clean up our file?
Yes. Our team does construction-specific cleanups, starting with a review of your file.
Related
- Signs your builder books are wrong
- Builder chart of accounts
- Month-end close checklist for builders
- QuickBooks and Buildertrend or JobTread cleanup
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.