Home · Help · Duplicate transactions in the QuickBooks bank feed

Duplicate transactions in the QuickBooks bank feed

The same withdrawal or deposit appears twice in the register, or a downloaded item in For review (sometimes labeled Pending) looks identical to something you already recorded. Your register balance no longer matches the bank.

Go to All apps, then Accounting, then Bank transactions. Work in the For review tab first (it may be labeled Pending). Posted items are under Categorized (sometimes labeled Posted). Older QuickBooks Online companies may still say Banking in the left-hand menu.

Likely causes

• A bill, expense, invoice payment, or transfer was entered by hand, and the downloaded bank line was added as a new transaction instead of matched to the one you already had.
• The bank was disconnected and connected again, or a CSV was uploaded that overlaps dates already in the feed.
• The same bank account was connected twice, so every download arrives on two account cards.
• QuickBooks Payments or a sales receipt already created a deposit, and the bank download was added again.

Quick fixes

1. On Bank transactions, confirm the account appears only once. If it was connected a second time, keep the original account and its history, and disconnect the extra connection.
2. In For review, compare each downloaded line with what is already in the register. If QuickBooks suggests a match, open it and confirm the date, amount, and payee before you post. Use Find other match (or Find match) if the suggestion is wrong.
3. If the item should not be on the books at all — a true second copy, or a personal charge you do not record here — select it and choose Exclude. Excluded items move to the Excluded tab and are not added again. Use Undo there if you exclude the wrong one.
4. If you already added a duplicate, open the Categorized tab, open the added item, and select Undo. That returns it to For review so you can match it or exclude it. Prefer excluding or undoing a feed item over deleting it; Intuit notes that a deleted download can come back from the bank.
5. If one copy is already reconciled (C or R in the register), keep that copy. Remove the unreconciled extra. Then reconcile to the statement to confirm the balance.

A few more questions

When should I match a bank line, and when should I categorize or add it?

Match when the money is already in QuickBooks — an invoice payment, bill, expense, transfer, or paycheck. Categorize (add) only when there is no existing record. Adding a line that already exists is how most duplicates start.

A payment and its deposit both show in the register. Is that a duplicate?

Not always. A customer payment and the bank deposit it belongs to can be two linked parts of the same activity. Open one and see if it points to the other before you exclude or delete anything.