2026-11-11 · Accounting

How to Clear Uncategorized Income, Expense and "Ask My Accountant" Before Year-End

↓ Get the free Excel + PDF kit for this article

Open your Profit and Loss in November and you may find a line called Uncategorized Expense or Uncategorized Income with a number much bigger than you expected. On the Balance Sheet there may be an Uncategorized Asset, and in older desktop files an account called Ask My Accountant. These accounts fill up quietly all year: a bank-feed transaction gets added without a category, a deposit is saved "for later", an import brings in rows with no account. Owners and bookkeepers ask about them in accounting forums every year-end, and the usual answer is "go through them one by one" — which is right, but not very helpful when there are 300 rows.

Why it matters: money in these accounts is not on the right line of your tax return. Real expenses can be missed, personal spending can look like business spending, customer payments can be counted twice, and a contractor you paid $3,000 may never show up on your 1099 list. This guide shows a method you can follow with a spreadsheet you build yourself, then the exact places to fix each row in QuickBooks Desktop and QuickBooks Online.

Flowchart of the six-step uncategorized cleanup: export, paste and add rules, read flags, send owner questions, fix in QuickBooks, re-run the report
The whole cleanup in six steps.

Step 1: Back up, then export one report per account

Before you change anything, back up your company file (Desktop) or save your current reports (Online). Then run Transaction Detail by Account for the full year, filtered to one uncategorized account at a time.

Keep these columns: Date, Type, Num, Name, Memo/Description, Amount. Add one column called Source and type which account the rows came from. Delete the running Balance column.

Step 2: Let keyword rules do the easy 60%

Most uncategorized rows are boring repeat vendors: fuel, phone, software, bank fees. Make a small rules table on the side — a keyword in column K and the category in column L (for example SHELL → Car & Truck - Fuel, COMCAST → Telephone & Internet). Then, with Name in column D and Memo in column E, this formula in the first row suggests a category:

=IFERROR(LOOKUP(2,1/((ISNUMBER(SEARCH($K$2:$K$40,D2&" "&E2)))*($K$2:$K$40<>"")),$L$2:$L$40),"ASK OWNER")

If two keywords match, the lower rule in the list wins, so put specific rules (for example CARD PAYMENT) below general ones (TRANSFER). In Google Sheets, wrap the formula in ARRAYFORMULA( ). Copy it down. Every row that still says ASK OWNER is a real question.

Step 3: Add three warning formulas

A category suggestion is not enough. Three quick checks catch the expensive mistakes (Amount in column F, Date in column A):

For every row from Uncategorized Income, also search your open invoices for the same amount. A deposit that matches an open invoice is a customer payment, not new income.

Name (example)AmountSourceSuggestedWarning
SHELL OIL 57443$64.18Uncategorized ExpenseCar & Truck - Fuel—
ADOBE CREATIVE CLD$59.99Uncategorized ExpenseSoftwarePossible duplicate
ZELLE FROM CUSTOMER$975.00Uncategorized IncomeASK OWNERCheck open invoices
DEPOSIT$5,000.00Uncategorized AssetASK OWNERRound + large amount
AMZN Mktp US (return)($42.50)Uncategorized ExpenseOffice SuppliesRefund: use original category

Table 1. Example rows after Steps 2 and 3. All names and amounts are examples.

Step 4: Send one question list to the owner

Filter the sheet to ASK OWNER, sort by amount (largest first), and send that list once. Ask for short answers — "fuel", "personal", "loan", "customer #1021" — and receipts for anything large. Never ask for bank passwords or full account numbers; you do not need them. The decision tree below covers most deposits.

Decision tree for a deposit in Uncategorized Income: invoice payment, transfer, loan, owner money, sales or vendor refund
Work down the questions until one is "yes".
You seeIt is oftenUsually goes to
Credit card payment from checkingPaying the card balanceTransfer to the card account (not an expense)
Personal purchase on a business cardOwner's spendingOwner draw / distribution or shareholder account
Loan paymentPrincipal plus interestSplit: loan liability + interest expense
Payroll provider debitNet pay, taxes, feesSplit using the payroll report
IRS or state tax paymentPayroll, business or personal taxLiability, tax expense or owner draw — check the notice
Zelle or Venmo to a personContractor, refund or personalContract labor (get a W-9), refund or draw

Table 2. General patterns only; the right account depends on your entity type and your accountant's setup.

Step 5: Fix each row in QuickBooks

QuickBooks Desktop

  1. Open the same Transaction Detail by Account report in QuickBooks and double-click a row.
  2. Change only the account on that line, then Save & Close. Keep the date, amount and bank account the same so reconciliations are not affected.
  3. Accountant and Enterprise editions can do many rows at once: Accountant › Client Data Review › Reclassify Transactions, select rows, tick Account to, pick the account and click Reclassify. Intuit notes the tool cannot change transactions that use A/R or A/P (invoices, bills) or transactions linked to other transactions — open those one by one.

QuickBooks Online

  1. Run the report in QuickBooks Online and click a row; the transaction opens. Change the category on that line and save.
  2. For rows that came from the bank feed, you can also go to Banking › Bank transactions, open the tab with already-added transactions, choose Undo on the row and categorize it again. Undo is the cleanest fix when a row was matched to the wrong transaction. Tab names have changed over time, so look for the tab that holds added transactions.
  3. With QuickBooks Online Advanced, or through your accountant's QuickBooks Online Accountant, use Settings (gear) › Reclassify transactions (in some versions under Dimensions › Dimension assignment). Choose the account type and the uncategorized account, select rows, Reclassify, pick the new account and Apply. Intuit lists limits: the bank account on an expense cannot be changed there, transactions with items allow class changes only, and payroll transactions cannot be changed.
Before and after mock table: five rows in Uncategorized Expense moved to fuel, internet, credit card transfer, software and one duplicate removed
Example: the account goes to $0 and the credit card payment stops being counted as an expense.

Step 6: Re-run the report and check your 1099 list

Run the report again. Each uncategorized account should be $0, or a small balance you can explain in one sentence. Then total money paid per payee with =SUMIFS($F:$F,$D:$D,D2) and review anyone at $2,000 or more. For payments made in 2026, the IRS minimum for reporting nonemployee compensation on Form 1099-NEC is $2,000. Payments you made by credit card, debit card or a payment app are reported by the payment company on Form 1099-K, not by you on 1099-NEC. Form 1099-NEC is due January 31; for 2026 payments that date is a Sunday, so the due date is February 1, 2027.

Timeline: November export and questions, December fixes and 1099 review, December 31 year end, February 1 2027 Form 1099-NEC due
Start in November so the answers arrive before the 1099 deadline.

Common mistakes

FAQ

Will recategorizing undo my bank reconciliation?

Changing only the category (income or expense account) does not change the cleared amount, so the reconciliation stays the same. Changing the date, amount or bank account can.

Can I just make one journal entry to move the whole balance?

You can move a total with a journal entry, but the original transactions keep the wrong account, vendor reports stay wrong and 1099 totals are not fixed. Fixing each transaction is slower but cleaner; ask your accountant if you prefer an entry.

What is Uncategorized Asset, and should it be zero?

It often holds transfers with one side missing, opening balances or deposits brought in without an account. Compare it to your bank and loan statements. Talk to your accountant before moving an old balance to equity.

The owner does not remember a transaction. Now what?

Look at the bank statement image or the card receipt, write a one-line note, and leave it for your tax preparer as a clearly listed open question rather than guessing.

Checklist

You can download the ready-made Uncategorized Transactions Cleanup Kit for free in the Free kit download box below (Excel + PDF guide, no sign-up).

This article is for education only and is not tax, legal or accounting advice. Rules change and every business is different; talk to your tax professional about your situation. All names and amounts shown are examples. QuickBooks is a registered trademark of Intuit Inc.; not affiliated with or endorsed by Intuit.

Sources

Free kit download

Tools to follow this article step by step. No sign-up needed.

Free to use for yourself and your own business; please do not resell or redistribute. General information, not tax, legal or accounting advice; check every figure against your own records. QuickBooks is a trademark of Intuit Inc.; BIZLEX is not affiliated with Intuit.

← All articles Privacy