Accountants · problem and fix
How to delete duplicate transactions in QuickBooks Online on Mac: bank feed fixes, 2026
To delete duplicate transactions in QuickBooks Online, check the pair against your bank statement first. Then exclude the bank feed copy instead of deleting it. Deleting a feed line makes the bank send it again on the next download. Manual entries you can delete or void.
The short answer
- Check each duplicate pair against the bank statement before you change anything.
- In QuickBooks Online, exclude bank feed copies. Deleting them lets the bank resend them.
- Delete or void only manual entries. Keep the copy marked C or R when it is reconciled.
- Use a helper column in Excel on a copy of the export. Remove Duplicates alone misses many copies.
- Lazur can point at the menus and guide each click. It does not make the changes for you.
What removing duplicate bank-feed and bill entries costs you
Wrong numbers in your reports
A duplicate expense lowers profit in the Profit and Loss report. A duplicate income line inflates it. Either way the number you give a client is wrong. That error can carry into a tax return or a lender package.
Reconciliations that will not balance
The bank balance will not match the book balance. You then hunt for a difference that is really a copy. The hunt rarely shows up as a line item, but it often eats the afternoon.
Time spent proving a copy is a copy
Every minute spent checking a duplicate is a minute not spent on closing, reviewing, or client questions. No public study measures these hours, so measure your own month before you decide what it costs.
Paying the same bill twice
Duplicate bills can lead to duplicate payments. APQC's accounts payable benchmark, reported by CFO.com in 2020, put duplicate or erroneous payments at 0.8% of annual disbursements for top performers and 2% for bottom performers. That study covers payables, not bank feeds, but the mistake is the same kind.
Why it happens
An account connected twice
If the same bank account is connected twice, each download brings in the same transactions again. Intuit says to disconnect the extra connection and make its account inactive. Keep the original account and its history, so the matching stays in one place.
Reconnecting or reactivating an account
A reconnect re-downloads past transactions. Your books already have many of them, so the copies appear. Quicken for Mac documents this clearly. Its help says reactivating can create duplicates, and that it can re-download roughly 90 to 200 days of history, depending on the institution.
Overlapping file imports
A CSV or OFX file that covers dates the live feed already brought in creates copies. This happens often when someone imports a statement file to catch up, and forgets the feed already did the work.
Adding instead of matching
The feed shows a charge, and someone clicks Add. But a bill or manual entry for the same charge already exists. Now there are two records. Matching links the feed line to the existing record. Adding creates a new one.
The same sale recorded two ways
A sale gets entered as an invoice or bill, and the bank payment for it arrives through the feed. Both land in the register unless the payment is matched to the invoice or bill. Intuit lists this as a separate cause.
The bank changed transaction IDs
Quicken uses the Financial Institution Transaction ID to spot transactions it already has. If a bank changes those IDs on existing transactions, the software cannot tell they are the same. The copies pile up quietly, and nothing on the screen flags them.
How to fix it
These work with or without any app.
Check the statement before any change
Pull the statement or the PDF from the bank for the same month. Match date, payee, and amount for each pair. A copy the statement does not show is the one to fix. Never delete from memory.
Exclude feed copies, do not delete them
In QuickBooks Online, exclude a feed copy from the For review tab. Or revert a feed line through the Added or Matched link and Undo. The bank then stops sending that transaction again. Deleting it brings it back on the next download.
Delete or void manual copies
For a manual entry, use More > Delete or Void. If both copies exist, keep the one marked C or R when it is reconciled. Remove the other one. Check the statement once more before you save.
Disconnect the second connection
If an account is connected twice, disconnect the extra connection and make its account inactive. Keep the original, so the history stays in one place. Then watch the next download to confirm the copies stop.
Use a helper column in Excel, on a copy
Export the register, work on a copy, and add the COUNTIFS helper column described on this page. Filter the higher counts and check each one against the statement. Only then remove anything in QuickBooks Online.
Xero: run the Duplicate statement lines report
Xero won't automatically delete duplicate statement lines, according to a Xero community manager in May 2025. Run the Duplicate statement lines report, choose which line to keep, and reconcile. For reconciled lines, confirm the Remove & Redo or Unreconcile path on Xero Central first.
Quicken for Mac: choose Link when you reactivate
When you reactivate an account in Quicken for Mac, choose Link, not Add. Quicken's help says Add creates duplicates. If you already have copies, check the transaction IDs with the Columns button at the bottom of the register.
This page is for bookkeepers and accountants who run QuickBooks Online on a Mac. The browser version works the same on macOS as on Windows, so the steps below hold. Xero and Quicken for Mac get their own section, because their tools handle duplicates differently. If you work at a firm, follow your firm's rules on client data before you export a register or paste bank details into any tool, Lazur included.
What the numbers do and do not tell you
No public study we could open measures how often bank-feed duplicates happen, or how many hours they take. Vendor blogs quote figures for this. Those figures could not be traced to a primary source, so this page leaves them out. The costs in this section are the ones you can see in your own books.
The U.S. Bureau of Labor Statistics counts about 1.5 million bookkeeping, accounting, and auditing clerks in 2025. The BLS describes their job as reconciling records, or noting and reporting the differences they find. A duplicate is one of those differences. It is easy to mistake for a bank error, which is why it can waste so much time.
1.5 million
Bookkeeping, accounting, and auditing clerk jobs in 2025, per BLS. Their work includes reconciling records and reporting differences.
Bookkeeping, Accounting, and Auditing Clerks (BLS Occupational Outlook Handbook)0.8% to 2%
Duplicate or erroneous payments as a share of annual disbursements, top and bottom APQC performers. Accounts payable, 2020.
Metric of the Month: Detect and Prevent Duplicate or Erroneous Payments (CFO.com)90 to 200 days
Transaction history Quicken for Mac can re-download after an account is reactivated, depending on the institution.
Duplicate Transactions or Accounts Downloaded in Quicken Mac (Quicken)Match where a copy came from to the right fix
Use this table to connect the origin of a copy with the fix. The origin tells you which menu to use. Most people skip this step and delete the wrong line.
| Where the copy came from | What to do | Where to click |
|---|---|---|
| Feed line added instead of matched | Undo the add, then match the feed line to the existing bill or entry | Added or Matched link, then Undo |
| Account connected twice | Disconnect the extra connection and make its account inactive. Keep the original account and its history | Bank transactions in All Apps > Accounting |
| Reconnect or reactivate re-downloaded history | Exclude the copies. Do not delete them, or the bank sends them back | For review or Excluded tab, then Undo |
| Manual entry plus a feed line for one charge | Keep the copy the statement confirms. Delete or void the manual one if it is the extra | More > Delete or Void |
| Reconciled copy plus unreconciled copy | Keep the reconciled copy marked C or R. Remove the other one | Register, status column |
How to find duplicate transactions in QuickBooks Online on Mac
The menus have moved over time. Older posts send you to Banking > Bank Feeds Center. Intuit's current path is All Apps > Accounting > Chart of accounts. Open the account you suspect, then select View register.
- Go to All Apps > Accounting > Chart of accounts, then select View register on the account.
- Select Filter and set a date range that covers the month you are closing.
- Sort by Amount. Copies of the same charge sit next to each other.
- Change 'All plus deposits' to 'All'. Intuit says this avoids false matches.
- Compare date, payee, and amount for each pair against the bank statement.
Press ⌘F in your browser to jump to a payee name in a long register. Search for the vendor first, then sort by amount to confirm. It is faster than scrolling a whole year.
Remove the right copy without losing the real one
The fix depends on where the copy lives. A feed copy and a manual entry look alike on screen. They behave differently when you remove them. A feed copy comes back if you delete it. A manual entry does not.
For a line on the For review tab, exclude it. Open the Excluded tab and use Undo if you excluded the wrong one. For a feed line that is already added, open the Added or Matched link and choose Undo. Manual entries go through More > Delete or Void.
Mistakes that make duplicates worse
- Deleting feed lines. They return on the next download, and the copy you fixed is back.
- Reconnecting before you check. A reconnect re-downloads past transactions and can add a fresh round of copies.
- Deleting the reconciled copy. Keep the one marked C or R, then fix the other.
- Deleting two real payments because they match. Same payee, same day, and same amount can be two real charges. Check the statement first.
- Running a spreadsheet dedupe on live data. Remove Duplicates in Excel is permanent. Work on a copy.
Check duplicates in Excel for Mac before you change the books
Export the register to a file you can open in Excel for Microsoft 365 for Mac. Work on a copy, never the original export. The Remove Duplicates button sits on the Data tab, in the Data Tools group. Microsoft defines a duplicate as a row whose values all exactly match another row. It deletes those rows permanently.
Remove Duplicates misses many feed copies. One copy may carry a different description, or a date that moved by a day. A helper column catches more, and it changes nothing in the file until you decide.
Put this formula in a helper column, starting on the second row: =COUNTIFS($A$2:A2,A2,$B$2:B2,B2,$D$2:D2,D2). It assumes the date is in column A, the payee in column B, and the amount in column D. The first row of each set counts as the original. Later copies count higher. Filter for the higher counts, then check each one against the statement.
Xero and Quicken: the same cleanup, different tools
In May 2025, a Xero community manager said Xero won't automatically delete duplicate statement lines. Xero points users to the Duplicate statement lines report. Run it, choose which line to keep, then reconcile. Xero staff also point to the Statement exceptions report, which lists statement lines Xero removed as duplicates.
For unreconciled duplicates, a third-party guide says to delete the line on the Bank Statements tab. For reconciled lines, it says to use Remove & Redo or Unreconcile. Unreconciling needs the admin role, or standard plus bank accounts access. Check those steps before you use them on a live file.
Quicken for Mac also works from the register. When you reactivate an account, choose Link, not Add. Choosing Add creates duplicate accounts and transactions. If you suspect the bank changed transaction IDs, use the Columns button at the bottom of the register to show them.
A worked example: one charge, two lines
Say a software charge hits your bank account. You entered the bill by hand in QuickBooks Online last week. Then the feed line showed up, and you clicked Add. Now the register has two lines with the same payee, date, and amount.
Start with the bank statement. It shows one charge. Next, look at each line's status. The feed line you added is the copy to fix. Open its Added link and choose Undo. Then match the feed line to the bill, so the bank line and the bill become one record.
Check the result. The register should show the charge once. If the balance still does not agree with the bank, the copy may sit in another month. Widen the date filter and look again.
Where Lazur helps, and where it does not
Lazur does not click buttons, edit your books, or operate QuickBooks Online for you. It is not a plugin for any app. It helps you find the right spot, understand the menu, and say what to do next. You still make every change yourself.
Hold ⌥ ⌘ and ask about anything on screen. Ask where the Excluded tab is, and Lazur draws a circle and a label around it. Ask how to undo a match, and Lazur guides you one click at a time, waiting for each click before it moves on.
Hold fn to dictate. Clean text lands at the cursor in any app. That helps when you write a reconciliation note while the register is still open. Lazur can also draft a short client message about a reversed charge. Read every draft before you send it.
Research runs in Lazur's own Chrome tabs, through the Lazur for Chrome extension. It comes back with a summary and a report. It works well for pulling public vendor help pages into one place. Use it for reading, not for checking a client's books.
Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer them. They are not stored, and content is never used to train AI models. Your firm's rules still apply, so check them before any tool sees bank details.
Stop duplicates before they start
Most duplicates come from setup. Connect each bank account once. Write down which feed belongs to which client account. Match a feed line whenever a bill or manual entry already exists. Do not add a second copy.
Run the register check at a fixed point each month, before you close. A monthly pass takes less effort than a year-end search. Keep the statement PDF in the same folder as the register export, so the comparison is quick.
When a client adds a new bank account, reconnect it on the first day, then check the first download. Duplicates from a new connection are easy to catch early and hard to find late.
For the formula work and other Excel errors at closing time, see Excel for accountants on Mac. If you want Lazur for these steps, check Lazur pricing first.
Faster with Lazur
Where Lazur helps with removing duplicate bank-feed and bill entries
Hold ⌥ ⌘ and say what you want. Lazur sees your Chrome window. Lazur draws a circle and a label around the button or menu you need.
- 1
Hold ⌥⌘ and talk
- 2
Lazur draws a circle and a label around the button or menu you need.
- 3
You stay in Chrome. Nothing to copy into a chat window.
More things to say in Chrome
- “Where is the Excluded tab in this register?”
- “Walk me through undoing this match, one click at a time.”
- “Why would this charge show up twice in the register?”
- “Draft a note to the client about the reversed charge.”
- “Dictate a reconciliation note for this account.”
- “Research how several vendors describe duplicate bank feed fixes.”
Free for 3 days, then $18/month. Download for Mac
You say“Where is the Excluded tab?”
Lazur · points at itLazur draws a circle and a label around the Excluded tab. You click it yourself, then use Undo on the copy.
What accountants say to Lazur for this
Each one is a single hold of ⌥ ⌘.
“Where is the Excluded tab in this register?”
Lazur draws a circle and a label around the Excluded tab, so you can find it and click it yourself.
Points at it
“Walk me through undoing this match, one click at a time.”
Lazur guides one click at a time and waits for each click before it moves to the next step. You do the clicking.
Walks you through it
“Why would this charge show up twice in the register?”
Lazur explains the likely cause out loud, using the screen you are looking at. You still check the statement.
Explains what's on screen
“Draft a note to the client about the reversed charge.”
Lazur drafts the text. You read and edit it before you send it, and you follow your firm's rules on what client details can go in a message.
Drafts it
“Dictate a reconciliation note for this account.”
Hold fn and speak. Clean text lands at the cursor in any app, so the note gets written while the register is still open.
Types what you say
“Research how several vendors describe duplicate bank feed fixes.”
Research runs in Lazur's own Chrome tabs and returns a summary and a report. It is for public help pages, not your client files.
Researches in the background
A plan you can start this week
- Day 1
Check bank connections
Open All Apps > Accounting > Bank transactions. Look for any account connected twice. Disconnect the extra connection and make it inactive, keeping the original. Do this before you touch any copy, so the next download is clean.
- Day 2
Find copies in the register
For each bank account, go to All Apps > Accounting > Chart of accounts and select View register. Filter to the month, sort by amount, and change the filter to All. Note every pair you suspect. Change nothing yet.
- Day 3
Check each pair against statements
Pull each month's statement PDF. Mark which copy the bank shows. Keep a short list of fixes, with the payee and date for each one, so you can work through them without guessing.
- Day 4
Fix feed and manual copies
Exclude feed copies, or revert them with the Added or Matched link and Undo. Delete or void manual copies with More > Delete or Void. Leave every line marked C or R alone unless your firm's process says otherwise.
- Day 5
Set a monthly check
Put a short duplicate check on the calendar before each close. Run the register sort, then the Excel helper column on a copy. Save the notes next to the export, so next month starts faster.
Questions people ask
Can I bulk delete duplicate transactions in QuickBooks Online?
Intuit's help article describes fixes by where each copy came from, not as a bulk step. Exclude feed copies, and delete or void manual entries. Check each pair against the statement first.
Why did my deleted transaction come back?
It was probably a bank feed transaction. After you delete it, QuickBooks Online downloads it again from the bank. Exclude it instead, so the bank stops sending it.
Will removing duplicates in Excel change QuickBooks Online?
No. Excel changes only the file you have open. Your QuickBooks Online data stays the same until you change it there. Work on a copy, because Remove Duplicates deletes rows permanently.
What if the duplicate is already reconciled?
In QuickBooks Online, keep the copy marked C or R and remove the other one. Xero reconciled lines need a different path, such as Remove & Redo or Unreconcile, so confirm those steps on Xero Central first.
Does Lazur fix duplicates for me?
No. Lazur points at things, explains what to do, and guides each click. It does not click buttons or change your books. You make each change yourself after you check the statement.
What does Lazur do with the screen I show it?
Lazur listens and looks at the screen only while you hold the shortcut. Audio and the screenshot go to AI providers to answer, and they are not stored. Content is never used to train AI models. Follow your employer's rules on client data before you share anything.
Sources
- Fix duplicate transactions in QuickBooks Online bank feeds · Intuit · checked 2026-11-08
- Duplicate Transactions or Accounts Downloaded in Quicken Mac · Quicken · checked 2026-11-08
- Filter for or remove duplicate values · Microsoft · checked 2026-11-08
- Bookkeeping, Accounting, and Auditing Clerks · U.S. Bureau of Labor Statistics · checked 2026-11-08
- Bank reconciliation: automatically recognise and remove duplicate statement lines · Xero community · checked 2026-11-08
- Metric of the Month: Detect and Prevent Duplicate or Erroneous Payments · CFO.com · checked 2026-11-08
- Xero Duplicate Bank Transactions: Exactly What to Delete · The Software Scribe (third-party) · checked 2026-11-08
Fix removing duplicate bank-feed and bill entries with Lazur, free for 3 days
Hold a key and ask. Lazur sees your screen, points at the button and talks you through it, in any Mac app. No credit card.