Every cleanup engagement is somebody’s ordinary bookkeeping, done consistently, for months, in a way nobody checked.

What follows is the list — but organized around the thing most articles leave out. Each mistake comes with the specific report that finds it. Knowing that duplicate transactions are common is not useful. Knowing that an Open Invoices report showing “Checking” in the Account column means income is being double-counted is useful, because you can run it on a file you inherited this morning.

Work through these in order on any new file and you’ll find most of what’s wrong in an afternoon.

1. Payments deposited without using Receive Payment

The single most expensive error in most files, and the one that hides best.

The mistake
The report that finds it
What happens. A customer pays an invoice. Instead of recording it through Receive Payment, someone records a deposit directly to the bank — or enters it in the register against an income account. The money arrives. The books look funded.
But the invoice was already recorded as income when it was raised. So the income is now counted twice: once on the invoice, once on the deposit. And because no payment was ever applied, the invoice stays open.
What it costs. Overstated income, an accounts receivable balance full of invoices that were paid months ago, and a profit and loss that shows roughly double the real revenue in the affected periods.
How to find it. Run an Open Invoices report. Look at the Account column. Where you see Checking, that income was booked directly from a bank deposit. If the same amounts also appear against A/R, you have duplication — the deposit and the invoice are both counting.
The correct sequence, for reference: Invoice → Receive Payment → Undeposited Funds → Bank Deposit → match to the bank feed.
How to fix it. Two routes. For a small number, delete the erroneous deposits, re-enter the payments through Receive Payment into Undeposited Funds, then reassemble the original deposits. For high volume, a single zero-sum entry: select the payments in Undeposited Funds, add a line for the overstated income account with a negative for the current-year portion, and a further line to Retained Earnings for any prior-year portion.
That second method touches prior periods and retained earnings. It isn’t a bookkeeping task.
View data
StepCorrect workflowThe shortcut
1. InvoiceInvoice raised — income recordedInvoice raised — income recorded
2. PaymentReceive Payment applied against the invoiceSkipped
3. HoldingPayment sits in Undeposited FundsNot used
4. BankingBank Deposit groups the received paymentsDeposit recorded direct to an income account
5. ResultMatched to the bank feed. Invoice closed, income counted once.Invoice still open. Income counted twice.

2. Clicking Add when the answer was Match

The mistake
The report that finds it
What happens. The bank feed drops transactions into For Review, where each is either matched to something already in the file or addedas new. Someone who doesn’t know the difference clicks Add on everything.
Every Add against a transaction already recorded creates a duplicate.
What it costs. Inflated expenses and income. Reconciliations that won’t balance. A file that looks approximately right while being systematically overstated.
How to find it. Run Transaction Detail by Accountacross the period, export to Excel, and sort by date and amount to surface identical pairs. On a file you’ve inherited, do a full fiscal year.
How to fix it. In Banking, open the Categorized tab, find the transaction, click Undo to return it to For Review, then use Find match. Always check whether a transaction is reconciled before deleting anything.

3. Undeposited Funds never cleared

The mistake
The report that finds it
What happens. Receive Payment is used correctly, but the Bank Depositstep never follows. Payments pile up in Undeposited Funds — now sometimes labeled Payments to deposit — and the QuickBooks bank balance stops matching the actual bank.
What it costs. A growing phantom balance and an unreconcilable account.
How to find it. Check the Undeposited Funds balance. It should be near zero at any point where all received payments have been banked. A persistent or growing balance means the workflow is being half-completed.
How to fix it. Group the outstanding payments into deposits that match what actually cleared the bank. Then review the balance monthly, not annually — it’s a leading indicator that the AR workflow is wrong.

4. QuickBooks Payments and the bank feed both connected

The mistake
The report that finds it
What happens. A client uses QuickBooks Payments to take card or ACH payments. Payments correctly records the payment against the invoice. Then the connected bank account imports the same deposit from the bank, and it gets added.
Income doubles. This one is structural — both channels are working correctly and the result is still wrong.
What it costs. Systematically overstated revenue for as long as both run unmanaged.
How to find it. Compare the Deposit Detail report against invoice payment records for the same dates. Look for payment amounts appearing twice, once via Payments and once via the bank feed.
How to fix it. Match rather than add, or excludethe duplicate bank feed transaction. Note that exclusion is a manual action per transaction — see mistake 8 for why a bank rule can’t do this for you.

5. A chart of accounts built by accretion

The mistake
The report that finds it
What happens. QuickBooks ships a default chart of accounts that doesn’t fit most businesses. Accounts get added on the fly, never reviewed, never merged. Practitioners report files with three hundred accounts where thirty to fifty would do.
What it costs. Reports that don’t tell anyone anything. Slow categorization decisions, because there are eleven plausible options. Errors that compound, because similar transactions land in different accounts depending on who coded them that day.
How to find it. Open the Chart of Accounts and sort by transaction count. Accounts with one or two entries, near-duplicate names, and accounts misclassified between types — asset where it should be expense, for instance — surface in a single pass.
How to fix it. Redesign to fit the business. Merge duplicates, inactivate what’s dead, map old accounts to new. This is a before-you-start-monthly-bookkeeping task, not something to attempt alongside a close.
Do this before connecting any integration. A connector inherits whatever structure it finds, and can modify it.

Related: Sync is not accuracy

6. The same vendor under four different names

The mistake
The report that finds it
What happens. “Amazon”, “Amazon.com”, “AMZN Mktp”, “Amazon Marketplace” all exist as separate vendors. Same for customers.
What it costs. Vendor totals that mean nothing. 1099 preparation that misses thresholds because spend is split across variants. Reports that understate concentration.
How to find it. Sort the vendor and customer lists alphabetically and read them. Near-duplicates cluster together and are obvious on sight. It’s a five-minute job that nobody does.
How to fix it. Merge the duplicates. Then agree a naming convention and write it down, because otherwise it recurs within a quarter.

7. Account numbers never switched on

The mistake
The report that finds it
What happens. QuickBooks Online has account numbers, but they’re off by default. A file runs for two years without them.
What it costs. Audit software expecting numbered accounts can’t import cleanly. Parent entities with a mandated chart can’t be reported into. And retrofitting numbers to an established chart of accounts is considerably more work than setting them at the start.
How to find it. Look at the chart of accounts. If there’s no number column, they’re off.
How to fix it. Settings → Advanced → Chart of accounts → Enable account numbers. Do it before the file has volume. If the file already has years of history and audit or reporting requirements are coming, it’s a project — plan it rather than discover it.

8. Bank rules created without review

The mistake
The report that finds it
What happens. Rules auto-categorize incoming transactions. Useful, and they quietly become a problem in two ways.
They apply to everything matching the pattern, including transactions that should have been coded differently. And they collide with integrations — a rule categorizing anything containing “Google” as advertising will create an expense every time, and if an expense tool is also exporting that charge, you get two.
What it costs. Consistent miscategorization, and duplicates wherever a rule overlaps a connector.
How to find it. Settings → Rules. Read every one and ask what it catches that it shouldn’t. Then cross-check against what your integrations post.
How to fix it. Tighten or remove over-broad rules. Where a rule overlaps an integration, one of them has to stop.
The thing most people get wrong

Bank rules can only categorize. They cannot exclude. Intuit’s support confirms it. If you’re relying on a rule to keep transactions out of the books, it isn’t doing that.

9. Pending transactions added, then posted again

The mistake
The report that finds it
What happens. Some bank feeds deliver transactions while still pending. Someone adds one. Days later it posts with a different date and the feed delivers it again as a separate item.
Practitioners report this most on credit cards, particularly American Express.
What it costs. Duplicates that are harder to spot than most, because the dates differ — so they don’t surface in a same-date-same-amount scan.
How to find it. Scan for same-amount, same-vendor pairs within a few days of each other. This is the one your standard duplicate check misses.
How to fix it. Delete the duplicate, keep the posted version. Some bookkeepers avoid it entirely by working only with posted transactions.

10. Opening balances entered wrong at setup

The mistake
The report that finds it
What happens. The file is created mid-life. Opening balances are entered from whatever was to hand — a bank balance rather than a reconciled position, a guess at accounts receivable, nothing at all for accrued liabilities.
What it costs. Every subsequent reconciliation carries the original error. The balance sheet has been wrong since day one and nothing in normal bookkeeping surfaces it.
How to find it. Take the balance sheet at the conversion or setup date and tie it to the prior accountant’s closing trial balance. If there isn’t one, that’s the finding.
How to fix it. Correct via journal entry with documentation attached, at the setup date, and lock the period afterwards. This is judgment work, not data entry.

11. Personal spending left on the business card

The mistake
The report that finds it
What happens. An owner uses the business card for personal purchases. Nobody separates them, or they’re coded to a plausible-looking expense account because that’s faster.
What it costs. Overstated deductions, which the IRS can disallow on examination. Distorted margins. And in a partnership or corporation, distributions that were never recorded as distributions.
How to find it. Filter the general ledger by the card account and read it. Personal spending has a recognizable shape — grocery stores, consumer subscriptions, weekend restaurant charges.
How to fix it. Reclassify to Owner’s Draw or the appropriate equity account, in bulk, and agree a rule for future periods. Practitioners describe this as one of the standard cleanup sweeps.

12. Ask My Accountant used as a bin

The mistake
The report that finds it
What happens. Anything uncertain goes to Ask My Accountant. Nobody ever asks the accountant. The balance grows.
What it costs. Unclassified transactions sitting in the P&L or balance sheet, meaning every report is provisional. And each one is a decision deferred to a point where nobody remembers the context.
How to find it. Run a general ledger filtered to that account. The balance and the line count tell you how long it’s been accumulating.
How to fix it. Triage the whole population in one pass while asking the client about them in one batch, rather than one at a time. Then set a rule: nothing sits there past month-end close.

Diagnose before you fix

One instruction matters more than the list.

Fixing before diagnosing makes it worse

Cleanup practitioners are consistent about this: start with a diagnostic, not with fixing. Recategorizing transactions, reconciling accounts and deleting duplicates before understanding what’s wrong and where frequently breaks working data while trying to fix broken data — the cleanup makes it worse. The right first pass is the chart of accounts view: every account, its transaction count, its balance. It surfaces structural problems before you’ve touched a single transaction. Then work the list above in order.

It’s also worth separating two words people use interchangeably. Cleanup corrects errors. Catch-up enters transactions that were never recorded. Different problems, different costs, and a file can need both.

For scale: practitioners put a simple one-to-three month backlog in the region of $500 to $1,500, and multi-year rescues with structural problems between $2,000 and $13,000.

The short version

#MistakeThe report that finds it
1Payments deposited without Receive PaymentOpen Invoices — look for "Checking" in the Account column
2Add clicked instead of MatchTransaction Detail by Account, exported and sorted
3Undeposited Funds never clearedUndeposited Funds balance — should be near zero
4QuickBooks Payments and bank feed both liveDeposit Detail against invoice payments
5Chart of accounts built by accretionChart of Accounts sorted by transaction count
6Same vendor under several namesVendor and customer lists, alphabetical
7Account numbers never enabledChart of Accounts — is there a number column
8Bank rules created without reviewSettings → Rules, read every one
9Pending added, then posted againSame-amount pairs a few days apart
10Opening balances wrong at setupBalance sheet at setup date vs prior closing trial balance
11Personal spending on the business cardGeneral ledger filtered to the card account
12Ask My Accountant as a binGeneral ledger filtered to that account

Frequently asked questions

Why does QuickBooks show double my income?

Most often because payments were recorded as bank deposits to an income account instead of through Receive Payment. The invoice already recorded the income, so the deposit counts it again — and the invoice stays open. Run an Open Invoices report: where the Account column shows Checking, income was booked directly from a deposit, and if the same amounts also appear against A/R, it’s being duplicated.

What's the difference between Receive Payment and Bank Deposit in QuickBooks?

Receive Payment applies a customer payment against an open invoice and clears the receivable. Bank Deposit records money arriving in the bank. The correct sequence is invoice, then Receive Payment into Undeposited Funds, then Bank Deposit, then match to the bank feed. Skipping Receive Payment leaves the invoice open and double-counts the income.

How do I find duplicate transactions in QuickBooks Online?

Run a Transaction Detail by Account report for the period, export to Excel, and sort by date and amount to surface identical pairs. Duplicates caused by pending-then-posted bank feed entries have different dates, so also scan for same-amount, same-vendor pairs a few days apart.

Can bank rules stop duplicate transactions in QuickBooks?

No. Bank rules can only categorize transactions, not exclude them — Intuit’s support confirms this. Preventing duplicates means matching rather than adding, or excluding the duplicate transaction manually.

How many accounts should a small business chart of accounts have?

Practitioners typically suggest thirty to fifty for a small business. Files that grew by accretion often reach three hundred, which slows categorization, produces reports nobody can use, and causes similar transactions to land in different accounts depending on who coded them.

Should I clean up QuickBooks myself or hire someone?

The determining factor is whether the errors are transaction-level or structural. Miscategorized entries and duplicates are visible and fixable. A chart of accounts built wrong from the start, incorrect opening balances, or corrections touching prior periods and retained earnings require accounting judgment rather than software proficiency. Start with a diagnostic either way — fixing before diagnosing frequently damages working data.

What's the difference between QuickBooks cleanup and catch-up?

Cleanup corrects errors in how transactions were recorded. Catch-up enters transactions that were never recorded at all. They’re different problems with different costs, and a file can need both.

About the author
Sejal Jansari
Senior Accountant

QuickBooks Online ProAdvisor and Xero Certified Advisor. Leads delivery for US CPA firm engagements at Nimblechapps Finance.

LinkedInLast reviewed: August 3, 2026