Add vs Match in QuickBooks Bank Feeds: Fixing Duplicate Income the Right Way
I Clicked “Add” on Everything in QuickBooks: How to Fix Duplicate Income Without Nuking Your Books
Hi, I’m Elena. I clean up messy books for a living, and this is one of the most common bank-feed panics I see:
“I connected my bank, everything turned green, I clicked Add on every single line… and now my income has doubled. Did I break QuickBooks?”
You did not break QuickBooks. You just trained it to do exactly the wrong thing — and the good news is, we can un-train it.
In this guide, I’ll show you:
How QuickBooks Online actually decides between Add and Match
How to confirm you really have duplicate income
How to safely undo and exclude the extra entries
And how to work with bank feeds going forward so this never spirals again
This is a zero-judgment zone. Most of my best clients started right where you are.
Why Clicking “Add” on Everything Creates Fake Income
Let’s translate the bank feed buttons into human language.
When a transaction comes in from your bank, QuickBooks Online lets you either Add or Match it.
Add = “Please create a brand-new transaction in my books based on this bank line.”
QuickBooks will start a new expense, income, transfer, etc., using the amount/date/payee from the feed.
Match (or Find match) = “This bank line is the real-world proof of something I already recorded.”
QuickBooks looks for existing invoices, payments, sales receipts, bills, or expenses that fit and ties the bank line to them.
Where trouble starts:
You create an invoice or sales receipt inside QuickBooks.
Later, when the bank deposit shows up in Banking, you hit Add instead of Match.
QuickBooks now thinks there were two separate sales:
One from the invoice/sales receipt you created.
One from the “Add”-generated transaction.
Your bank balance may still look fine, but your Profit & Loss thinks you made twice as much money.
Step 1 – Confirm You Really Have Duplicate Income
Before we fix anything, let’s prove the problem exists with data, not just vibes.
Run a Profit & Loss Detail for the “Add Spree” Period
Go to Reports → Profit and Loss.
Set the Report period to the months when you know you clicked Add on everything (for example, “Last quarter” or a custom date range).
Click the Total Income amount to open the transaction detail.
In the detail view, look for:
Pairs of transactions on the same date for the same amount.
Two different transaction types for what should be a single payment, for example:
A Payment/Receive Payment and a Deposit, or
A Sales Receipt and a Bank Deposit.
If you see this pattern repeatedly, you’re not imagining it — your income is doubled.
Open Your Bank Register in a Second Tab
Pros always work with the bank register in one tab and Banking in another. It helps you see what’s already in your books.
Go to Accounting → Chart of Accounts.
Find the bank account that’s causing the trouble.
Click View register (open it in a new browser tab).
In the register:
Scroll around your problem period.
Look for pairs of entries with the same date and amount.
Check the Type column:
One might be tied to a customer (from an invoice payment).
The other might be a standalone Deposit created from the bank feed.
When you see that “twin” pattern, you’re looking right at the duplicates.
Step 2 – Use Undo and Exclude (Don’t Randomly Delete Things)
Here’s the part most people skip: if the duplicates came from the bank feed, you want to fix them from the bank feed, not just by deleting things in the register.
Find the Bank Feed Transactions You Already “Added”
Go to Banking / Transactions → Bank transactions.
Select the right bank account.
Click the Categorized (or “Reviewed”) tab — this shows what you’ve already added or matched.
In this list, look for:
Deposits that match payments you know were already recorded from invoices or sales receipts.
These are often the extra “Add” entries we want to undo.
Undo the Bank Feed Actions
For each suspect line:
Tick the checkbox on the left.
Click Undo on the black action bar.
What Undo does:
It cancels the “Add” or “Match” you previously chose.
It sends the bank line back to the For review / Pending tab.
If the transaction only existed because of that Add, it effectively de-links it so you can handle it correctly.
You should now see those bank lines reappear under For review.
Exclude the True Duplicates from Your Books
Once they’re back in For review:
Staying in Banking, switch to the For review / Pending tab.
Use the Date filter to narrow to your problem period.
Tick all the bank lines that are definitely duplicates of invoices/sales receipts already in your books.
Click Exclude.
Excluded transactions:
Will not create new income entries.
Move to the Excluded tab as an audit trail.
If you ever realize you excluded the wrong items, you can select them in the Excluded tab and click Undo to send them back to For review.
After this pass, go back to your Profit & Loss detail and refresh it. You should see fewer duplicated pairs in your income lines.
Step 3 – Clean Up Any Leftover Duplicates in the Register
If you or a previous bookkeeper also created manual deposits or journal entries, Undo/Exclude alone may not catch everything.
Working in the bank register tab you opened earlier:
Scan for same-date, same-amount pairs again.
Click into each pair and inspect:
One may be a Receive Payment linked to an invoice (usually the one you want to keep).
The other may be a standalone Deposit with no customer detail (often the duplicate).
If you’re certain one of them exists only because of your earlier “Add everything” spree:
Open that duplicate transaction.
Click More → Delete.
If you are not certain:
Don’t guess.
Add the date, amount, and a short note (“Possible duplicate of payment from Client X”) to a simple internal list called “Questions for bookkeeper/CPA.”
Good cleanup is about being accurate, not heroic.
Step 4 – Learn How to Work with Bank Feeds Safely
We’ve undone the worst of the damage; now we change how you use bank feeds so we don’t have to do this again.
Rule 1 – If You Use Invoices, Always Look for a Match First
If you’re invoicing customers and recording payments inside QuickBooks, then the bank feed should be used to confirm those payments, not to create new ones.
In Banking:
When you see a deposit you recognize as an invoice payment, click the line to expand it.
If QuickBooks suggests a Match, review and approve it.
If it doesn’t suggest the right one, click Find match and search for the correct invoice/payment.
You’re telling QuickBooks: “Tie this bank line to the transaction that already exists; don’t create another.”
Rule 2 – Use Add Only When Nothing Exists Yet
Use Add when:
It’s a small, one-off expense that you never entered manually.
It’s a simple, non-invoiced sale and you’re okay recording it directly as income from the bank deposit.
If there’s already an invoice, bill, or expense in your books, your first instinct should be Match, not Add.
Rule 3 – Be Careful with Auto-Add Rules
QuickBooks lets you create rules that auto-categorize recurring transactions and even auto-add them. That’s powerful, but if a rule is too broad, it can auto-create a lot of bad data very quickly.
My guidelines:
Start with rules that only suggest categories, not auto-add.
Keep rules narrow (for example: “Bank fee from [Bank Name] → Bank service charges”).
Avoid auto-add rules on anything related to customer payments until you’re very confident.
Rule 4 – Reconcile Every Month
Bank feeds are not the same thing as reconciliation. Reconciliation is how you catch the sort of lingering errors we just fixed.
At least once a month:
Go to Accounting → Reconcile.
Pick your bank account and enter the statement ending balance and date.
Work through any mismatches until your difference is zero.
If you suddenly see big unreconciled differences, that’s your early warning system that something has been duplicated or misclassified.
Step 5 – How Bad Is “Too Bad” to DIY?
Here’s my honest yardstick, after years of doing forensic cleanup work:
If the Add-everything pattern has been going on for one to three months, many owners can unwind it themselves with some focused sessions.
If it’s been happening for a year or more, or if you’ve already reconciled those months, it may be more efficient to bring in a cleanup specialist.
A pro cleanup engagement typically includes:
A defined time frame (for example, “Clean January 2023–December 2024”).
A side-by-side review of your bank statements, registers, and reports.
A systematic process to remove duplicates, fix mismatches, and preserve an audit trail.
If you’re feeling overwhelmed reading this, that doesn’t mean you’re bad with money. It means you’ve spent your time building your business instead of becoming a bookkeeping expert. That’s normal.
You’re allowed to hand this part off.
Next: “I Reconnected My Bank and Now I Have 15 Months of Duplicates in QuickBooks – How to Undo a Bad Bank Connection Safely.”
About Elena:
Elena Vance spent over a decade as a corporate controller untangling complex ledgers, managing month-end closes, and preparing financials for people who never saw the chaos underneath. Today, she brings that same calm, methodical energy to small businesses that feel embarrassed by their books.
From three-years-behind Etsy sellers to seven-figure agencies with spaghetti bank feeds, Elena specializes in forensic cleanups of QuickBooks Online files that “got away” from their owners. She is obsessed with practical systems, plain language, and never making a client feel stupid for clicking the wrong button.
When she’s not screen-sharing through a bank reconciliation, you’ll find her recording Loom videos on how to fix common mistakes, writing deeply honest guides like this one, or talking herself out of reorganizing her clients’ entire Chart of Accounts at 11 PM.
Her ground rule: you are never “bad with money” for having messy books. You just haven’t had the right support yet.
Comments
Post a Comment