How to Find and Fix Uncategorized Transactions in QuickBooks Online

If you've ever opened a client's QuickBooks Online file and immediately felt your stomach drop, there's a good chance uncategorized transactions were the reason. They're everywhere. They're in every single file I've ever touched. And after five years as a Lead Bookkeeper at Intuit QuickBooks Live — managing 15 to 30 client files at a time — I can tell you that uncategorized transactions in QBO are the single most common cleanup task you'll face as a bookkeeper.

They're also one of the most misunderstood. I've seen bookkeepers delete them, ignore them, or mass-recategorize them without thinking — and every one of those approaches creates bigger problems down the road.

So let's break this down properly. What uncategorized transactions actually are, where they hide, how to find every last one of them, and how to fix them without blowing up your client's books.

What Are Uncategorized Transactions in QBO?

When a transaction comes into QuickBooks Online through a bank feed and nobody tells QBO what to do with it, it has to go somewhere. Depending on the situation, QBO dumps it into one of three accounts:

Uncategorized Income — This is the default holding account for deposits and credits that were accepted from the bank feed but never assigned to a real income account. You'll typically find this on the Profit & Loss under income, and it inflates revenue numbers because QBO treats it as earned income even though nobody's actually categorized it.

Uncategorized Expense — Same concept, opposite direction. Charges and debits that got pulled in from the bank feed and accepted without being categorized land here. This shows up on the P&L under expenses, and it makes total expenses look higher than they actually are — or at least higher than they should be once things are properly sorted.

Ask My Accountant — This is the old-school version. In desktop QuickBooks and older QBO files, there's an expense account called Ask My Accountant that served essentially the same purpose. Business owners would dump transactions there when they didn't know where they belonged, assuming their accountant would sort it out later. Spoiler: the accountant usually didn't, which is why you're cleaning it up now. In newer QBO files, this account may not exist by default, but I still see it in older files and migrated desktop conversions all the time.

Here's the thing that trips people up: these aren't broken transactions. They're real transactions — real money moved. They just don't have a proper category assigned, which means your financial statements are wrong. Revenue is wrong, expenses are wrong, and if the client is filing taxes based on those numbers, that's a real problem.

Why Uncategorized Transactions Exist in the First Place

Before we fix them, it helps to understand why they're there. In my experience, there are a few common scenarios:

The client connected their bank feed and hit "Accept" on everything without categorizing. This is the most common cause by far. QBO's bank feed interface makes it really easy to bulk-accept transactions, and most business owners don't realize that accepting isn't the same as categorizing.

A previous bookkeeper started the work but didn't finish. They might have connected the feeds and started categorizing, then stopped — maybe the client didn't pay, maybe they got overwhelmed. Either way, you've got a pile of half-done work.

Bank rules were set up incorrectly or not at all. If there are no bank rules, every single transaction that comes through the feed needs manual attention. And if the client was the one accepting transactions, they probably weren't doing that.

Transactions were imported via CSV without proper mapping. When you import bank transactions from a CSV file and don't map the category column correctly — or the CSV doesn't have one — everything lands in Uncategorized.

How to Find Uncategorized Transactions: The Chart of Accounts Method

This is my preferred starting point because it gives you the full picture in about 30 seconds. Here's the step-by-step:

Step 1: Go to your Chart of Accounts. In QBO, navigate to Settings (gear icon) > Chart of Accounts. Or if you're on the new QBO navigation, it's under Bookkeeping > Chart of Accounts.

Step 2: Look for accounts named Uncategorized Income, Uncategorized Expense, and Ask My Accountant. If you have a lot of accounts, use the search/filter at the top. You can also run a Quick Balance check — if any of these accounts show a balance, you've got work to do.

Step 3: Click into the account name. This opens the account register and shows you every single transaction sitting in that account. This is your hit list.

Step 4: Note the date range. Are these uncategorized transactions from three years ago or from last month? This matters because it tells you whether you're dealing with a long-standing mess or a recent habit.

The Chart of Accounts method is fast and visual. You can immediately see the scope of the problem. But if you need more detail — like filtering by date range, amount, or transaction type — you'll want the report method.

How to Find Uncategorized Transactions: The Transaction Detail Report Method

This method gives you more control and is better for large files where you need to slice and dice the data.

Step 1: Go to Reports in the left navigation. Search for "Transaction Detail by Account" and open it.

Step 2: Set your date range. I usually start with "All Dates" for the initial cleanup assessment, then narrow it down later when I'm actually working through the fixes.

Step 3: Click Customize (or the filter icon). Under the Account filter, deselect all and then select only Uncategorized Income, Uncategorized Expense, and Ask My Accountant. If you also want to catch things sitting in Uncategorized Asset (which happens with transferred funds), add that too.

Step 4: Run the report. Now you've got a clean list of every uncategorized transaction in the file, sorted by account, with dates, amounts, payees, and memo fields visible.

Pro tip: Export this report to Excel before you start making changes. I always keep a "before" snapshot so I can track my progress and have documentation if the client asks what changed. This is especially important if you're billing for cleanup work — you want proof of the volume you processed.

How to Fix Uncategorized Transactions: Step by Step

Now for the actual work. Here's the process I follow for every uncategorized transaction:

1. Open the transaction. From either the account register or the detail report, click on the transaction to open it. You'll see the full transaction details — date, payee, amount, account/category, and memo.

2. Identify what it is. Look at the payee name, the memo, and the amount. Cross-reference with the bank statement if needed. Most of the time, the payee name tells you everything. "AMAZON" is either supplies or inventory. "ADP" is payroll. "STATE TAX PAYMENT" is... well, you get it.

3. Change the category. In the Category (or Account) field, select the correct account. If this is income, assign it to the right income account. If it's an expense, assign it to the right expense account. If it's a transfer between accounts, change the transaction type to Transfer.

4. Add a memo if one doesn't exist. Future you — or the next bookkeeper — will thank you. A quick note like "Office supplies — Amazon" or "Monthly SaaS subscription" takes two seconds and saves ten minutes later.

5. Save and close. Move on to the next one.

If you're dealing with hundreds of transactions, you'll develop a rhythm. I use a Confidence Tier System to sort transactions by certainty level — obvious ones first, ambiguous ones flagged for client follow-up. I usually sort by payee name so I can batch similar transactions together. All the Amazon purchases at once, all the utility payments at once, and so on. This is faster than going chronologically because your brain doesn't have to context-switch between different types of expenses.

Bank Rules vs. Manual Categorization: When to Use Each

Bank rules are one of the most powerful features in QBO, but they're also one of the most abused. Here's when to use them and when not to:

Use bank rules when: The transaction is recurring, the payee name is consistent, and the category is always the same. Rent payments, subscription software, loan payments, insurance premiums — these are perfect candidates for bank rules. Set the rule, and every future transaction matching that criteria gets auto-categorized.

Don't use bank rules when: The same vendor could hit multiple categories. Amazon is the classic example. One purchase is office supplies, the next is inventory, the next is a personal charge the owner ran through the business card. A bank rule would force all of those into one category, and two out of three would be wrong.

Also don't use bank rules when: The client's business is complex enough that context matters. A construction company might pay the same vendor for materials on one job and equipment rental on another. You need to see each transaction individually.

My general rule: if I see the same payee show up five or more times in the uncategorized pile and it always goes to the same place, I'll create a bank rule while I'm in there. It saves future work and reduces the chance of more uncategorized transactions piling up.

Why You Should Never Just Delete Uncategorized Transactions

I see this suggestion in Facebook groups more often than I'd like. "Just delete them and re-import." Please don't do this.

Here's why: if a transaction was matched to a bank feed entry — meaning it was downloaded from the bank and accepted — deleting that transaction doesn't delete the bank feed record. It unmatches it. That bank feed entry goes back into the "For Review" tab, and now you have a ghost transaction floating around that can get duplicated if someone re-accepts it.

Worse, if the transaction was part of a reconciliation (even if it was categorized incorrectly), deleting it throws off the reconciliation. Your reconciled balance no longer matches. Now you've got a reconciliation discrepancy on top of your categorization problem, and that's a much harder fix.

The correct approach is always to edit the existing transaction — change the category, fix the details, and save. Never delete and recreate unless you're absolutely certain the transaction was a duplicate that should never have existed in the first place.

Common Mistakes When Fixing Uncategorized Transactions

After cleaning up hundreds of client files, I've seen — and made — every mistake in the book. Here are the ones that cause the most damage:

Recategorizing reconciled transactions without checking the reconciliation. This is the big one. If a transaction has been reconciled (you'll see a little "R" or "C" next to it), changing its account/category can affect the reconciliation. In QBO, changing the category of a reconciled transaction usually doesn't break the reconciliation — but changing the amount, date, or deleting it absolutely will. Always check. If you're unsure, run a reconciliation report for that period before and after your changes.

Bulk-categorizing without reviewing individual transactions. It's tempting to select 50 transactions from the same vendor and mass-categorize them. But even a consistent vendor can have outliers — refunds, returns, different product categories. Take the extra minute to spot-check.

Forgetting about the "Uncategorized Asset" account. When money is transferred between connected bank accounts and both sides get downloaded, QBO sometimes creates a one-sided entry in Uncategorized Asset. These won't show up when you filter for Uncategorized Income or Expense — you have to specifically look for them. They usually need to be matched to the corresponding entry or converted to a proper transfer.

Not checking the bank feed tab after cleanup. After you recategorize everything, go check the Banking/Transactions tab. Make sure nothing got unmatched or is sitting in "For Review" that shouldn't be. I do a final sweep of the bank feed as the last step of any uncategorized transaction cleanup.

How This Connects to the Bigger Diagnostic Process

Uncategorized transactions are usually just the tip of the iceberg. If a file has 200 uncategorized transactions, I guarantee it also has other issues — duplicate vendors, unreconciled months, misclassified liabilities, and probably some personal expenses mixed in with business ones.

That's why I always start a cleanup with a diagnostic scan before I quote the project. Before I touch a single transaction, I want to know the full scope of what's wrong with the file. How many months are unreconciled? What does the Chart of Accounts look like? Are there negative balances in asset accounts? Is sales tax set up correctly?

Uncategorized transactions are one signal. But they're rarely the only signal — a messy Chart of Accounts often makes categorization harder, and the two problems feed each other. Treating them in isolation — without understanding the broader health of the file — means you'll fix one problem while missing ten others. And when you think you're done, you still need a structured QC pass to make sure the file is internally consistent before you hand it off.

The diagnostic-first approach saves time, gives you an accurate scope for pricing the cleanup, and makes sure you don't promise a client clean books when there are still landmines buried in the data.

The Bottom Line

Finding and fixing uncategorized transactions in QBO isn't complicated. It's tedious. It's repetitive. But it's foundational. Categorizing uncategorized transactions is Step 6 of my full 12-step cleanup process — it comes after the COA rebuild, vendor cleanup, and bank rule setup so everything lands in the right place. If you skip this step or do it carelessly, nothing else in the cleanup will be accurate — your P&L will be wrong, your balance sheet will be misleading, and your client's tax return will be based on bad data.

Take it one transaction at a time. Use the Chart of Accounts method to get the big picture. Use the Transaction Detail report to work systematically. Set bank rules where they make sense. And for the love of clean books, don't just delete things.

I built LedgerClean to run this diagnostic automatically — upload your client's QBO exports and it flags uncategorized transactions along with 7 other issue categories, then gives you prioritized fix procedures and time estimates. Free to try.