1) Module HUD
- Module #: 11 / 13
- Time: 30–45 min
- Outcome: “After this, you can decide whether to clean up your current QBO file or rebuild, and you’ll have a step-by-step triage plan either way.”
- Prereqs: [Module 10 — Monthly Close in QBO]
- Stop here if: your books are mostly clean, reconciliations are current, and you only need minor recoding + a few workflow fixes.
- Level tags used in this module: ✅ Baseline / 🛠️ Operator Upgrade / ⚠️ Advanced
2) Answer Box (snippet block)
- What it is (2 lines)
A cleanup/rebuild decision framework plus a practical cleanup playbook.
You’ll stop “tweaking forever” and either fix the file fast or start fresh cleanly. - When to use it (2–4 bullets)
- Your reports are unreliable or constantly changing
- You have duplicates, uncategorized, or broken A/R and A/P
- Bank reconciliations are behind (or never done)
- You want job costing and your current file can’t support it
- The common mistakeS (1-2 line)
Trying to “fix everything” without a plan, then giving up halfway and staying messy forever. - The fixES (1-2 line)
Triage first: reconcile, stop duplicates, fix A/R and A/P, then standardize categories and job assignment.
3) The mental model (keep short)
- You don’t “clean up QBO.” You clean up workflows and inputs.
- Reconcile first. Everything else builds on that.
- Fix duplication at the source (Match vs Add), not by recoding symptoms.
- Decide cleanup vs rebuild based on severity + time horizon, not pride.
- A rebuild is a controlled reset, not a punishment. (Sometimes it’s the best money you can spend.)
4) Do this in QBO (step-by-step)
Step 1 — Decide: cleanup or rebuild (✅ Baseline)
- Run three quick diagnostics:
- Profit and Loss (last full month)
- Balance Sheet (as of last month end)
- Accounts Receivable Aging Summary and Accounts Payable Aging Summary (today)
- Score your file (simple decision rules):
- If bank/credit card reconciliations are current and A/R & A/P are believable → CLEANUP
- If reconciliations are months behind, duplicates are everywhere, and A/R/A/P are a mess → REBUILD (or heavy cleanup)
- Rebuild triggers (any 2 = strongly consider rebuild):
- You can’t reconcile because balances are wildly off
- Duplicate income/expenses are common
- A/R is negative or nonsensical and nobody knows why
- You have a bloated Chart of accounts and inconsistent items
- You don’t trust any month’s reports enough to make a decision
Stop here marker:
If it’s clearly a cleanup (not a rebuild), do the cleanup steps below and stop.
Dry truth: If you’re 18 months behind on reconciliations, you don’t need “tips.” You need a plan and a calendar.
Step 2 — Cleanup playbook (🛠️ Operator Upgrade)
Phase A: Stop the bleeding (do first)
- Fix the bank feed workflow:
- Go to Banking
- Commit to Match first
- Identify why duplicates are happening (manual entry + bank Add, or bills + bank Add)
- Choose one method per transaction type
- Clear Undeposited Funds:
- Go to + New → Bank deposit
- Clear old payments correctly into the bank account
- Kill “Uncategorized” momentum:
- Go to Reports → Profit and Loss
- Click Uncategorized lines and recode the biggest 20 first
Pro tip: Fixing the top 20 transactions often fixes 80% of the “my reports suck” problem.
Phase B: Reconcile everything you can
- Reconcile checking:
- Accounting → Reconcile
- Reconcile credit cards:
- Accounting → Reconcile
- If you can’t reconcile due to missing months:
- Reconcile in chunks (oldest to newest), don’t jump around
Warning: Reconciling “to make it zero” by forcing adjustments is how you hide problems, not solve them.
Phase C: Fix A/R and A/P integrity
- Fix A/R:
- Reports → Accounts Receivable Aging Summary
- Identify old/open invoices that should be paid/voided
- Fix misapplied payments (payments not linked to invoices)
- Fix A/P:
- Reports → Accounts Payable Aging Summary
- Identify old bills that are duplicates or already paid outside QBO
- Fix vendor credits that weren’t applied correctly
Phase D: Standardize structure (only after the file is stable)
- Simplify Chart of accounts:
- In Accounting → Chart of accounts, set junk accounts to Inactive
- Rename/merge carefully (don’t delete history)
- Standardize Products and services:
- Go to Sales → Products and services
- Merge/rename duplicates (Water Heater Replace vs WH Replace)
- Keep the list tight and consistent
- If using jobs, repair job assignment:
- Go to Projects
- Ensure every active job exists and is named consistently
- Assign job costs to the right Project going forward
Stop here marker:
If last month can be closed cleanly (reconciled + believable reports), stop. Then work backward only if you need historical comparisons.
Step 3 — Rebuild playbook (⚠️ Advanced)
- Decide the cutover date:
- Typically start fresh at the beginning of a month/quarter
- Export what you need (minimum viable history):
- Customer list
- Vendor list
- Products and services list (cleaned)
- Open A/R (unpaid invoices)
- Open A/P (unpaid bills)
- Start a new QBO file or new company (implementation depends on your setup)
- Rebuild using Modules 2–6:
- Setup basics
- Simple COA
- Bank feeds workflow
- Items setup
- Progress billing/deposits workflow
- Bring forward only what matters:
- Open invoices and open bills
- Beginning balances (with CPA guidance)
Warning: A rebuild without a new workflow is just a fresh file that will be messy again by May.
5) Real-world example (mandatory)
Your file has:
- Checking not reconciled in 8 months
- Duplicates from Banking Add + manual bills
- A/R shows -$3,200 (negative)
Decision: rebuild or heavy cleanup.
You choose cleanup:
- First you stop duplicates (match-first)
- Then you clear Undeposited Funds
- Then you reconcile checking month-by-month
- Then you fix A/R by reapplying payments to invoices
Result: reports stop changing every time someone clicks around.
6) Run this report now (mandatory checkpoint)
- Report name: Balance Sheet
- Filters/settings:
- Go to Reports → Balance Sheet
- Date = today
- Click Run report
- What “good” looks like:
- Bank balances match reconciled statements
- A/R and A/P are believable (not negative without a real reason)
- No giant “mystery” balances hanging around (like old Undeposited Funds)
- What “broken” looks like:
- Bank balances don’t match reality
- A/R or A/P is negative
- Liability/clearing accounts are bloated and old
- One fix if broken:
- If bank balances are off: do Accounting → Reconcile for that account and trace missing/duplicate transactions.
7) Lab (do it on your file)
- [PASS/FAIL] You ran Profit and Loss (last full month)
- [PASS/FAIL] You ran Balance Sheet (today)
- [PASS/FAIL] You ran Accounts Receivable Aging Summary and Accounts Payable Aging Summary
- [PASS/FAIL] You chose cleanup vs rebuild and wrote why
- [PASS/FAIL] You identified the #1 cause of duplicates (workflow)
- [PASS/FAIL] You cleared old Undeposited Funds if it’s bloated
- [PASS/FAIL] You reconciled at least one bank or credit card account
- [PASS/FAIL] You fixed at least 10 Uncategorized transactions
- [PASS/FAIL] You can produce a believable last-month Profit and Loss
8) Knowledge check (3 questions)
- What are the first two things you fix in a messy file (before anything else)?
- Name two “rebuild triggers” that justify starting fresh.
- Why is stopping duplicates at the bank feed workflow level better than recoding after the fact?
9) Next + Related
- Previous: [Module 10 — Monthly Close in QBO]
- Next: [Module 12 — Problems Hub (index page)]
- Related modules (2–3)
- [Module 4 — Bank Feeds]
- [Module 6 — Progress Billing, Deposits, Retainers]
- [Module 13 — Glossary + Cheatsheets]
- Don’t do this warnings
- Don’t start “renaming everything” before reconciliations are current. That’s cosmetic chaos.
- Don’t delete transactions to make reports look better. Fix the workflow and the truth follows.
- Don’t rebuild without changing habits. That’s just moving the mess to a new address.
- Don’t chase perfect history if you only need clean numbers going forward.
Fast now = slow forever.
FAQ (short)
Should I clean up or rebuild my QBO file?
If reconciliations and A/R/A/P are believable, cleanup. If they’re broken and duplicates are widespread, rebuild (or heavy cleanup) is usually faster.
What’s the fastest “cleanup win”?
Stop duplicates (Match first), clear Undeposited Funds, and recode the biggest Uncategorized transactions.
Do I have to fix old years?
Not always. Get last month clean first, then work backward only if you need historical comparisons or taxes require it.
How do I know if duplicates are the problem?
Expenses look too high, vendors show twice, and your bank feed shows items you already entered as bills/expenses.
Can a CPA fix this faster than me?
Often yes—if you give them a clear plan and a clean workflow going forward. Otherwise they’ll just bill you to chase symptoms.