--- title: "Duplicate transactions in a QuickBooks feed | Ledgerbrook" source: https://ledgerbrook.com/fixes/duplicate-transactions-bank-feed/ description: "How duplicate bank-feed transactions happen, and how to clear them without breaking a prior reconciliation." --- [Fixes library](/fixes/) # Duplicate transactions in a QuickBooks feed Updated October 9, 2026 · [Omkar Moraye](/about/) [](https://www.linkedin.com/sharing/share-offsite/?url=https%3A%2F%2Fledgerbrook.com%2Ffixes%2Fduplicate-transactions-bank-feed%2F%3Futm_source%3Dlinkedin%26utm_medium%3Dsocial%26utm_campaign%3Dshare)[](https://x.com/intent/post?url=https%3A%2F%2Fledgerbrook.com%2Ffixes%2Fduplicate-transactions-bank-feed%2F%3Futm_source%3Dx%26utm_medium%3Dsocial%26utm_campaign%3Dshare&text=Duplicate%20transactions%20in%20a%20QuickBooks%20feed)[](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fledgerbrook.com%2Ffixes%2Fduplicate-transactions-bank-feed%2F%3Futm_source%3Dfacebook%26utm_medium%3Dsocial%26utm_campaign%3Dshare)[](mailto:?subject=Duplicate%20transactions%20in%20a%20QuickBooks%20feed&body=Duplicate%20transactions%20in%20a%20QuickBooks%20feed%0A%0Ahttps%3A%2F%2Fledgerbrook.com%2Ffixes%2Fduplicate-transactions-bank-feed%2F%3Futm_source%3Demail%26utm_medium%3Dsocial%26utm_campaign%3Dshare) ## How do I fix duplicate transactions in a QuickBooks bank feed? Duplicate transactions usually come from two feeds pulling the same charge: a bank feed and a connected app, or a reconnected account downloading past transactions again. Exclude the extra copy in For review instead of deleting it, undo a copy already added before excluding it, and check the register count against the statement for the 2 dates involved. Sounds like - The same charge shows up twice in the register with identical amounts and dates - Reconciliation is off by exactly the amount of one repeated transaction - A bank account was reconnected after an error and now shows months of transactions again - The register total doesn't match the bank statement even though every line looks categorized ## Why do transactions show up twice in QuickBooks? QuickBooks Online pulls transactions into the [bank feed](/blog/bank-feeds-in-quickbooks-online/) from more than one place at once, and it does not always know that two pulls describe the same real-world charge. The three common causes: A bank was disconnected and reconnected. QuickBooks Online downloads past transactions again when an account is reconnected, which Intuit’s own duplicates guide warns about. If any of that window was already reviewed and added to the register, every one of those transactions now has a twin sitting in the “For Review” tab, waiting to be added a second time. A payment processor or payroll provider is connected as its own feed alongside the bank feed. Square, Gusto, and similar connections often post a transaction into QuickBooks the moment a batch settles, and then the same settlement arrives again through the bank feed a day or two later once it clears. Both are legitimate feeds; only one of the two transactions should ever hit the register. A credit card was paid, and the payment shows up as a transaction in both the card account and the checking account it was paid from. This one is not a true duplicate at all, it is a transfer, but it gets miscategorized often enough to be worth naming here. ## How do I find duplicate transactions in QuickBooks Online? Before touching anything, separate a true duplicate from a look-alike. A true duplicate has an identical amount, an identical or near-identical date, and the same payee description. A look-alike has a matching amount but a different date, a different payee string, or turns out to be a legitimate second charge. A vendor that bills twice in one week is not a bug. | Characteristic | True duplicate | Look-alike | | --- | --- | --- | | Amount | Identical | Identical | | Date | Identical or a day or two apart | Different | | Payee description | The same | Different, or a real second charge | | What to do | Exclude or remove the extra copy | Leave it; it is a real transaction | Open the bank feed’s “For Review” tab and sort by amount instead of date. True duplicates cluster next to each other once sorted this way even when their dates are a day or two apart, because settlement timing rarely lines up exactly with the original charge date. ## How do I delete duplicate transactions in QuickBooks Online? If both copies are still sitting in “For Review” and neither has been added to the register, this is the easy case. Select the transaction that should not exist, and use Exclude from the Batch actions menu rather than deleting it outright. Exclude keeps a record that a transaction existed and was reviewed, which matters later if a client or a tax preparer asks why a charge that appears on the bank statement is missing from QuickBooks. A deleted transaction leaves no trace; an excluded one leaves an auditable one. ## When the duplicate has already been added to the register This is the case that actually breaks a reconciliation. Once a duplicate has been added it behaves like any other register transaction: it can get categorized, matched to a rule, even reconciled against a bank statement in a prior period. Deleting it now, after the fact, changes a period that a client or their CPA may already consider closed. The safe order of operations: run a search in the register for the amount, scoped to a date range wide enough to catch both copies. Confirm which of the two is the extra one, usually whichever has no matching line on the actual bank statement for that date. If the copy being removed was reconciled, that month only balanced because something else gave, usually a discrepancy adjustment posted when someone finished with a difference. Remove the copy and reverse the adjustment together, as set out in [editing a reconciled transaction](/fixes/edit-a-reconciled-transaction/). Undo the whole reconciliation only if the month cannot be put right that way, and check [what an undo takes with it](/blog/undo-a-reconciliation-in-quickbooks-online/) first: QuickBooks Online also undoes every later reconciliation on the account. Deleting a reconciled copy without doing either is the most common way a bookkeeper shifts a client’s reconciled balance without meaning to. ## Duplicates after the bank changes its connection Banks are moving their QuickBooks connections to newer feeds, often described as open banking, and when that happens the account usually has to be connected again. So does an account that is disconnected and reconnected to clear an error. Intuit’s own duplicates guide warns that disconnecting and reconnecting makes QuickBooks download past transactions again. Everything in that re-downloaded range that was already added or matched arrives a second time in For review. Nothing is wrong with the new transactions themselves. They are the same bank lines with new download records, which is why QuickBooks does not recognise them as already handled. The fix is to deal with the overlap before anything is added: 1. Find the date of the last transaction already in the register from the old connection. 2. In **Transactions > Bank transactions**, open **For review** on that account and sort by date. 3. Tick every line dated on or before that date that is already in the register, and choose **Exclude** from **Batch actions**. 4. Work through what is left from the new connection as normal, matching before adding. If the reconnection was pointed at a new account in the chart of accounts instead of the existing one, the copies land in a second register, which is [bank feed transactions in two accounts](/fixes/bank-feed-transactions-in-two-accounts/). If lines you excluded come back after a later refresh, see [excluded transactions keep reappearing](/fixes/excluded-transactions-keep-reappearing/). ## Preventing the next round Bank feed rules that auto-add transactions are the most frequent repeat cause. A rule that auto-adds “any transaction from Square” will happily add both the processor’s own feed entry and the bank feed’s settlement entry, silently, with no review step at all. Auto-add rules are appropriate for transactions with one source only, like a fixed loan payment or a recurring subscription charged to one card. Never for anything that could also arrive through a second connected feed. The other prevention step is disconnecting a feed cleanly instead of deleting the bank account itself when a card gets replaced or an account closes. Deleting the account and re-adding it under the same login is what triggers the re-download described above; disconnecting the feed while leaving the account and its history in place does not. For accounting firms managing multiple files, see our guide on preventing [duplicates across a client roster](/blog/duplicates-across-a-client-roster/). ## What this costs to fix A bank feed with duplicate transactions scattered across several months is squarely a [cleanup](/quickbooks-cleanup/) engagement, not something to patch month to month. The fix has to work backward through however many reconciled periods are affected, which is exactly what a cleanup is scoped and priced for. $99per month of backlog20% off 6+ months If any duplicate sits inside a period that has already been reconciled, [send the file for a free review](/contact/?from=fixes%2Fduplicate-transactions-bank-feed) before deleting it. See every offer, and what each one covers for a backlog of any size, on the [pricing page](/pricing/). Ledgerbrook Behind on your QuickBooks books? Cleanup or catch-up $99 per month of backlog, 20% off 6+ months Turnaround 5 business days for a typical year Monthly close From $99 a client file a month [Get a free file review](/contact/?from=fixes%2Fduplicate-transactions-bank-feed) Free, no card. A written answer within about 48 hours. [See every price](/pricing/) Certified - [![Intuit QuickBooks Certification Level 1](/_astro/level-1.BokmyvzE_Z2cyGo6.webp)](https://www.credly.com/badges/7ceaf1c4-83da-4a1b-b19f-7e15cb5c0ac7/public_url "Intuit QuickBooks Certification Level 1. Verify on Credly.") - [![Intuit QuickBooks Certification Level 2](/_astro/level-2.D-GWLUNI_Z1Sh5RD.webp)](https://www.credly.com/badges/02426568-00bb-46e1-a939-9063497c54d6/public_url "Intuit QuickBooks Certification Level 2. Verify on Credly.") - [![Intuit Bookkeeping Certification](/_astro/bookkeeping.C82JE0Dn_Z1YzPBj.webp)](https://www.credly.com/badges/30b70ae2-e369-4a8b-9fee-d6db3a47b70c/public_url "Intuit Bookkeeping Certification. Verify on Credly.") - [![QuickBooks Online Payroll Certification](/_astro/payroll.r5Yo2XnL_VxspM.webp)](https://www.credly.com/badges/2fc8fb7d-90d1-43ba-961b-aff161fe8491/public_url "QuickBooks Online Payroll Certification. Verify on Credly.") Issued by Intuit, verified by Credly. Updated October 9, 2026 · [Omkar Moraye](/about/) Share this fix[](https://www.linkedin.com/sharing/share-offsite/?url=https%3A%2F%2Fledgerbrook.com%2Ffixes%2Fduplicate-transactions-bank-feed%2F%3Futm_source%3Dlinkedin%26utm_medium%3Dsocial%26utm_campaign%3Dshare)[](https://x.com/intent/post?url=https%3A%2F%2Fledgerbrook.com%2Ffixes%2Fduplicate-transactions-bank-feed%2F%3Futm_source%3Dx%26utm_medium%3Dsocial%26utm_campaign%3Dshare&text=Duplicate%20transactions%20in%20a%20QuickBooks%20feed)[](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Fledgerbrook.com%2Ffixes%2Fduplicate-transactions-bank-feed%2F%3Futm_source%3Dfacebook%26utm_medium%3Dsocial%26utm_campaign%3Dshare)[](mailto:?subject=Duplicate%20transactions%20in%20a%20QuickBooks%20feed&body=Duplicate%20transactions%20in%20a%20QuickBooks%20feed%0A%0Ahttps%3A%2F%2Fledgerbrook.com%2Ffixes%2Fduplicate-transactions-bank-feed%2F%3Futm_source%3Demail%26utm_medium%3Dsocial%26utm_campaign%3Dshare)