How to find and fix miscoded expenses in QuickBooks Online

If you've ever opened a Profit and Loss report and thought "that can't be right", there's a fair chance a miscoded expense is behind it. A software subscription sitting in Office Supplies, a fuel purchase in Repairs and Maintenance, a contractor payment in Wages — individually they're small, but together they distort your margins, your tax claims and every decision you make off those numbers.

This guide covers why miscoding happens, how to find miscoded expenses in QuickBooks Online by hand, and a faster way to do the same job.

Why expenses end up in the wrong account

Miscoding is rarely carelessness. It's usually one of these:

• Bank feed suggestions. QuickBooks Online suggests a category based on rules and past behaviour. If a supplier was coded wrong once, the feed will happily suggest the same wrong account forever, and "Add" is only one click away.
• Suppliers that sell more than one thing. A Bunnings receipt might be tools, materials or a mop for the office kitchen. Amazon and Officeworks are the same. The supplier name alone can't tell you where it belongs, so whoever codes it guesses.
• Overlapping accounts. If your chart of accounts has Office Expenses, Office Supplies and General Expenses, three people will code the same purchase three different ways — and each of them is arguably right.
• Multiple people coding. The owner, a bookkeeper and an office manager each carry a slightly different mental map of the accounts. The differences accumulate quietly.
• Deadline pressure. Coding done in a rush the week before BAS or year-end is coding done from memory, not from the receipt.

None of this is fixed by telling people to be more careful. It's fixed by reviewing the file periodically — which brings us to how.

The manual way to find miscoded expenses

You don't need any special tools for this, just a few reports and some patience. Set aside an hour for a small file, longer for a busy one.

1. Scan the Profit and Loss for oddities

Run Reports → Profit and Loss, set the comparison to the previous period (or run it by month across the year). You're looking for:

• Accounts that spiked or collapsed with no business reason
• Accounts with a suspiciously round or suspiciously small total
• Accounts you didn't expect to see at all

Click any figure to drill into the transactions behind it. This top-down pass catches the big misplacements quickly.

2. Read each expense account with Transaction Detail by Account

Run Reports → Transaction Detail by Account, filtered to your expense accounts and the period since your last review. Now read each account's list and ask one question: does every supplier here belong here?

A telecommunications provider in Motor Vehicle Expenses jumps out immediately when you read the list this way. Sorting by amount (largest first) helps you cover the material items before your attention fades.

3. Check each supplier for consistency

Run Expenses by Supplier Summary, then drill into your largest suppliers one at a time. For each, check which accounts their transactions have landed in. A supplier whose purchases are spread across four different expense accounts is the classic tell — sometimes that's legitimate (they genuinely sell different things), but more often it's the same kind of purchase coded inconsistently over time.

This supplier-by-supplier pass is the most reliable manual method, and also the most tedious, because you're effectively doing a peer comparison in your head: "everything else from this supplier went to Subscriptions — why did this one go to Office Expenses?"

4. Empty the holding accounts

Check Uncategorised Expense, Uncategorised Asset and any "Ask My Accountant" style account. These are parking spots, not destinations. Anything sitting in them needs a real home.

5. Fix what you found

For individual transactions, open the transaction and change the category — QuickBooks keeps the bank match intact. If you have QuickBooks Online Accountant, the Reclassify Transactions tool moves batches of transactions between accounts in one operation, which is much faster for systematic errors (that supplier coded wrong for eight months, say).

Two cautions while fixing: watch the GST code when you move a transaction between accounts, because the right account with the wrong tax code is a new problem; and if the period has already been included in a lodged BAS or a finalised year, talk to your accountant before changing it.

The faster way: let the outliers reveal themselves

The manual method works, but notice what you were actually doing in step 3: comparing each transaction to its peers and flagging the ones that disagree. That's a statistical job, and it's exactly what we built Ledger Optics to do.

Ledger Optics is a free data-cleanup app for QuickBooks Online. It connects read-only via OAuth, then draws your ledger as an interactive cluster view — a force-graph where transactions that statistically disagree with their vendor and amount peers visibly stand apart from the group. Expense coding is its flagship repair area: it finds purchases coded to a different account than their vendor/amount peers — the same pattern you were hunting for supplier by supplier, surfaced in one pass. It also reviews your chart of accounts, class tracking and tax codes.

The flagged items land in a "Needs fixing" list with a proposed correction for each. You review every proposed change in a confirm-before-write dialog, and only the changes you tick are written back to QuickBooks. Nothing changes without your explicit approval.

A few honest notes before you try it:

• Detection is statistical peer comparison, not generative AI. Your data isn't sent off for AI processing — it's read on demand, held in memory only, and never stored or shared.
• It works best on files with at least 50 transactions. A very new file doesn't have enough peers to compare against.
• The chart of accounts repair area needs account numbers enabled in QuickBooks to be at its most useful, and system accounts can't be edited (they're shown greyed out).
• It proposes; you decide. Judgment calls — "is this tools or materials?" — are still yours. It just makes sure you're looking at the right transactions.

It has passed Intuit's security assessment, it's free to connect, and if it finds nothing, that's a genuinely useful result too: you've verified your coding is consistent.

FAQ

Will it change my books without asking? No. Ledger Optics connects read-only, and every proposed correction goes through a confirm-before-write dialog. Only the changes you individually tick are written back. Untick everything and your file is untouched.

Is my data stored anywhere, or sent to an AI? No. Data is read on demand and held in memory only — never stored, never shared. Detection is a statistical anomaly engine (peer comparison), not generative AI, so nothing leaves for AI processing.

What does it cost? It's currently free, including the write-back of corrections.

My file is quite new — will it still work? It works best on files with 50 or more transactions. Below that there aren't enough peers for the statistics to compare against, so expect fewer (or no) findings on a brand-new file.

Can it fix my chart of accounts too? Yes, that's one of its four repair areas — but it needs account numbers enabled in QuickBooks Online to shine, and system accounts can't be edited (they're shown greyed out).

Should I still do a manual review? Periodically, yes — especially the holding-accounts check and anything involving judgment about your specific business. Think of Ledger Optics as doing the tedious peer-comparison pass so your review time goes where a human is actually needed.

Ledger Optics is built by QADAN ANALYSIS CONSULTING PTY LTD (NSW, Australia). Questions: info@qadan.com.au.