Taming Uncategorized Income and Expense in QuickBooks Cleanups
When "I'll categorize it later" takes over the file
You open a new QuickBooks Online file and run a quick P&L. Halfway down, two lines jump out at you:
- Uncategorized Income: $187,420
- Uncategorized Expense: $96,305
The client says, "Oh, that's just stuff from the bank feed. I was going to go back and fix it. But my bank is reconciled every month."
You already know what that means: the bank might be reconciled, but the books are not. Those two accounts are where good financials go to die.
Heavy use of Uncategorized Income and Uncategorized Expense is one of the clearest signs that a file is not tax-ready, not advisory-ready, and not even close to management-ready. It tells you two things immediately:
- A big chunk of the year hasn't been properly coded.
- You can't trust the P&L or the tax story until this is dealt with.
This is why strong cleanup firms treat uncategorized accounts as a diagnostic signal, not just an annoyance. You want a systematic way to see how bad it is, how far it goes back, and whether there's still a balance sitting there at period end.
Where this problem hides inside QuickBooks Online
In QBO, this mess is deceptively simple. It's usually just two standard accounts in the Chart of Accounts:
- Uncategorized Income (type: Income)
- Uncategorized Expense (type: Expense)
The real story is in the transaction detail.
The fastest way to see the scope:
- Run Transaction Detail by Account for your diagnostic period (say, the last fiscal year).
- Filter the report to only these two accounts.
- Include all transaction types and make sure you see: Date, Transaction Type, Num/Ref, Amount, Memo/Description.
Now you start to see patterns:
- 180 bank feed expenses dumped into Uncategorized Expense over 12 months.
- 40 deposits sitting in Uncategorized Income, many with no memo.
- A year-end P&L that still shows a $25,000 balance in Uncategorized Expense.
Typical red flags:
- More than a couple dozen items in either account for the year.
- Large total dollar amounts flowing through these accounts.
- Any non-zero balance in either account at year end.
- Recurring patterns (e.g., all Amazon charges, all Stripe deposits) that never got rules.
- Journal entries posted directly to Uncategorized Income/Expense.
If you only have 2 minutes, run a P&L for the year and scan for Uncategorized Income/Expense. If either line is non-zero, drill down immediately and export that detail for your cleanup scope.
A concrete example:
- Diagnostic period: 1/1/2024–12/31/2024
- Uncategorized Expense: 180 transactions totaling $96,305, year-end balance $12,450
- Uncategorized Income: 40 transactions totaling $187,420, year-end balance $187,420
On paper, the client "made" $187k of income they can't explain and has nearly $100k of expenses that might be COGS, payroll, owner draws, or who knows what. You can't sign off on anything with that sitting there.
What happens if you just live with it
The damage inside your numbers
Leaving heavy uncategorized activity in place does more than just make the P&L look sloppy.
- Revenue is wrong. Deposits in Uncategorized Income might be loans, owner contributions, sales tax collected, or true revenue. Each has a different tax and advisory implication.
- Expenses are misclassified or missing. Uncategorized Expense often hides COGS, payroll, subcontractors, fixed assets, or personal spending. That affects margins, KPIs, and taxable income.
- Period-end balances lie. A non-zero balance in these accounts at year end means the P&L is incomplete by definition. You can't claim the year is closed.
- Trend analysis is useless. If 20–30% of activity is uncategorized, any month-over-month or year-over-year comparison is noise.
For tax work, this is brutal. You either:
- Overstate income (loans and transfers treated as revenue), or
- Understate income (true sales left in limbo), or
- Misclassify key deductions (e.g., capitalizable assets expensed, or personal expenses deducted).
The damage in client conversations
From the client's perspective, uncategorized accounts create confusion and mistrust:
- They see a big profit but no cash and don't understand why.
- They see "Uncategorized" on reports and assume the books are still a work-in-progress.
- You end up having the same painful conversation every year: "We need you to help us categorize these 200+ items before we can finish."
It also destroys your ability to scope and price confidently. If you don't quantify uncategorized activity up front, you underquote the cleanup and then eat hours trying to untangle a year's worth of bank feed dumping.
A practical way to clean this up
A good firm doesn't just "fix what's obvious". You want a repeatable process:
-
Quantify the problem.
- Run Transaction Detail by Account for the last fiscal year (or your diagnostic period) filtered to Uncategorized Income and Uncategorized Expense.
- Note transaction counts, total amounts, and period-end balances for each.
-
Segment by type and pattern.
- Group by Payee/Vendor and Memo.
- Identify obvious patterns: Amazon, Stripe, payroll processors, loan deposits, owner transfers.
-
Decide your materiality and thresholds.
- For small, immaterial items (e.g., a handful of <$50 charges), you may batch-code to a reasonable expense category with documentation.
- For large or recurring items, you pause and get client input.
-
Reclassify systematically.
- Use Reclassify Transactions (Accountant tools) where possible.
- For deposits, split between revenue, sales tax, fees, and transfers as needed.
- For expenses, separate business vs personal, COGS vs operating, and capitalizable items.
-
Clear the period-end balance.
- Your goal: zero balance in both accounts at year end.
- If you must leave a small balance temporarily (e.g., open questions), document it and set a clear follow-up date.
-
Lock in guardrails.
- Create bank rules for recurring patterns.
- Train the client: "Uncategorized is a parking lot for this week, not a permanent home."
Tools like CleanupOwl can do the first part for you: count the transactions, total the dollars, and tell you whether those accounts are above your firm’s thresholds or still carry a balance at period end. That way you walk into the engagement already knowing whether you’re dealing with 8 stragglers or 220 orphans.
Turning this into a standard diagnostic habit
The key is to stop treating uncategorized accounts as a surprise and start treating them as a standard checkpoint.
- Add "Uncategorized Income/Expense review" to your initial diagnostic checklist.
- Define firm-level thresholds: e.g., more than 20 items or more than $5,000 total in either account triggers a deeper review.
- Document your decision: what you reclassified, what you left, and why.
This is also where a diagnostic tool like CleanupOwl fits nicely into your workflow. Before you quote or start, it can scan the file and hand you a simple summary: transaction counts, total uncategorized dollars, and whether there’s a non-zero year-end balance. You decide how far back to go and how much to clean based on your engagement scope.
Be explicit in your engagement letters about how far back you will clean uncategorized activity (e.g., current tax year only) and what you consider immaterial. For closed years already filed, document any uncategorized balances you inherit and how you’ll treat them going forward.
The patterns you'll keep seeing in client files
| Situation | What you see in QBO | Risk if you shrug it off |
|---|---|---|
| Light, current-year use | 3–5 small items in each account, all in the last month, zero balance at year end | Minimal; quick review and reclass, then move on. |
| Bank feed dumping all year | 180 expenses and 40 deposits in uncategorized accounts, large totals, non-zero balances | P&L and tax return are unreliable; major cleanup and client interviews needed. |
| Old balances from prior bookkeeper | A few large entries from 2–3 years ago, still sitting in Uncategorized Income/Expense | Prior-year returns may be wrong; need to assess whether to amend or reclass prospectively. |
| Mixed personal and business spending | Hundreds of small charges in Uncategorized Expense, many from personal vendors | High risk of improper deductions; requires owner draw vs expense decisions and strong documentation. |
| Loans and transfers in income | Large loan proceeds and owner contributions posted to Uncategorized Income | Overstated revenue and taxable income; advisory KPIs and lender reports are misleading. |
Your reaction should scale with the size and nature of the problem. A handful of small, recent items is a quick tidy-up. Hundreds of transactions or six-figure totals in uncategorized accounts means you’re in full diagnostic and cleanup mode, with clear communication to the client about scope and timing.
Never zero out large Uncategorized Income/Expense balances with a single plug entry just to "clean things up" without understanding the underlying transactions. For closed tax years, coordinate with whoever filed the returns before making reclasses that could create mismatches.
Making this part of your cleanup playbook
Uncategorized Income and Uncategorized Expense are not just ugly lines on a P&L; they’re a bright red indicator of how much work stands between you and reliable numbers. Treating them as a formal diagnostic checkpoint protects your firm, your client, and your sanity.
When every cleanup starts with: "How many uncategorized transactions are there? How many dollars? Is there a year-end balance?", you stop getting blindsided halfway through the job. You can scope accurately, prioritize the right conversations, and decide what’s in and out of this engagement.
If you’re a business owner reading this, this is exactly the kind of question you can ask your accountant: "Are you checking how much is sitting in Uncategorized Income and Expense, and making sure those are cleared before you file my taxes?" A tool like CleanupOwl can give them that answer in seconds, but the important thing is that someone is asking the question.
Build this into your standard workflow, document your thresholds, and insist that uncategorized accounts hit zero at year end for any period you’re signing your name to. That’s the difference between "we did some bookkeeping" and we stand behind these numbers.
Ready to run deeper QuickBooks diagnostics?
Use CleanupOwl to automatically flag issues like this before you quote or start your next cleanup project.
Start Free Trial