How to find duplicate transactions in QuickBooks Online? 4 lists

By the ReconoSync team · Published · Updated

Find duplicate transactions in QuickBooks Online by checking the bank statement first, then sorting the register by amount so identical lines sit together. A pair is a duplicate only if the cash hit the bank once. Confirm it against the statement and the field-app payout report before you exclude or void either copy.

This is the click path for a bookkeeper who closes several ServiceTitan, Housecall Pro, or Jobber shops in QuickBooks Online. QuickBooks Online has no Find Duplicates report. A field service management system, or FSM, is the shop’s job, invoice, and payment app.

Confirm the cash hit the bank once

Intuit’s duplicate-transactions help, read 2026-10-12, starts on the bank or card website. If the line appears twice on the statement, the charge really happened twice. Work with the bank or the processor. If it appears once at the bank and twice in QuickBooks, it is a duplicate in the books.

Pull four lists before you click Exclude or Void.

List Where What it shows
Bank or card statement The bank, not the feed Each posted line, once
Register Chart of accounts, View register Added, matched, and typed lines, with R, C, or blank
Bank feed All apps, Accounting, Bank transactions For review, Categorized or Posted, and Excluded
FSM payout, batch, or invoice list ServiceTitan Bank Deposits, Housecall Pro My Money, Jobber Payments Payouts Gross, fees, net, which invoices were in the lump

The statement is the list you reconcile. The feed is only what the bank sent QuickBooks. One bookkeeper on r/quickbooksonline in April 2026 described both copies landing automatically, with one matched and the other hanging in the chart of accounts.

Sort the register by amount

Intuit’s duplicate-transactions help, read 2026-10-12, is this path.

  1. Go to All apps, Accounting, then Chart of accounts.
  2. Select View register next to checking, the card, or Undeposited Funds.
  3. Set the date range with Filter.
  4. Select the Amount column so identical amounts line up.
  5. Compare date, payee, memo, and whether each copy was downloaded or typed.

If the register filter shows All plus deposits, change it to All. That view can show some transactions twice. A payment and the deposit it belongs to are one pair. Open one of them. If it links to the other, leave both.

On a busy shop, run Reports, Standard reports, search Transaction Detail by Account, set the period, and sort by amount. Intuit’s find-duplicate-transaction-numbers help, updated 2026-08-05, is Sales transactions or Expense transactions, then the NO. column. Two invoices with the same number are a collision. Two invoices with different numbers for the same job can still be a duplicate.

Check the bank feed tabs

Go to All apps, Accounting, Bank transactions. Open the account.

Tab Also called What a duplicate looks like
For review Pending The same downloaded line twice, or a line that already exists in the register
Categorized Posted Added instead of Matched, so the cash is in the books twice
Excluded Excluded Lines already marked duplicate or personal

If the same account is connected twice, QuickBooks downloads every transaction twice. Review the connected accounts, disconnect the extra connection, and make that account inactive. Keep the original account and its history. Do not disconnect and reconnect the live account to refresh it. That download of past dates is how a second copy of last month arrives.

Intuit’s exclude help, updated 2026-08-10, is For review, checkbox, Exclude. Excluded lines are not added again. Undo from Excluded puts a mistake back on For review. One bookkeeper on r/Bookkeeping in November 2023 deleted a feed line and watched it pop back into Needs Review. Exclude is the path that stops the re-download.

If the extra copy is already in the books, open Categorized or Posted, select the Added or Matched link, then Undo. Take Match to the record you already have, or Exclude it. Intuit’s categorize help, updated 2026-08-24, treats Categorize or Post as a new ledger entry. Turn auto-add off on rules that post processor payouts to income.

Look outside the bank register

Duplicates from an FSM sync often sit on invoices and Undeposited Funds, not on checking.

What you see Where to look Likely extra copy
Two Receive Payment records, one unapplied The invoice, then Undeposited Funds Bank feed or a second typed payment. Keep the applied, deposited copy.
Two invoices for one job Sales transactions, sorted by customer or amount Housecall Pro posted a second document, or the job was billed in both files.
Same sale as an invoice and a sales receipt Sales transactions Keep the one with the payment attached.
Same purchase as a bill and an expense The vendor Intuit’s help turns the expense into a bill payment.
Same amount every month, twice Recurring Template List Two templates for one payee.
Who added the second line Settings, Audit log User, date, and event for about two years.

Jobber’s reconcile help, updated 2023-06-06, names the usual pair: the Jobber payment and the bank payout, often net of fees. That fix is how to fix duplicate payments from the Jobber QuickBooks sync. Two invoices for one Housecall Pro job is why Housecall Pro creates duplicate invoices in QuickBooks.

Intuit’s recurring-template help, updated 2026-08-05, is Reports, Recurring Template List, then Recurring transactions to delete the extra template. Recurring templates are on Essentials and Plus. Intuit’s audit-log help, read 2026-10-12, is Settings, Audit log. Admin access. Events stay for two years.

Pairs that are not duplicates

Same amount is a candidate. It is not proof.

Pair Duplicate?
Same amount, once on the statement Yes, after you confirm payee and date
Same amount twice on the statement No. Two real charges. Talk to the bank or processor.
Payment and the Bank Deposit that groups it No. One cash event in two records.
Gross payments in Undeposited Funds and the net processor lump No. Put the fee on the grouped deposit, then Match.
Deposit invoice plus the final invoice on one Housecall Pro job No, unless both bill the full job.
Recurring charge on two different dates No. One bookkeeper on r/QuickBooks in March 2025 had QuickBooks trying to merge separate cafe receipts of the same amount.

A deposit at gross next to a bank line at net is a fee, not a twin. Group the payments and put the fee on that deposit. That path is how to reconcile ServiceTitan deposits in QuickBooks Online.

After you find the extra copy

If one copy is reconciled, keep that one. Intuit’s duplicate-transactions help, read 2026-10-12, says the reconciled copy shows C or R, and the bank-feed copy usually carries the bank’s memo text. If neither is reconciled, keep the copy matched to the invoice or the deposit.

Where the extra copy sits What to do
For review Exclude. Undo from Excluded if you miss.
Categorized or Posted Undo, then Match or Exclude.
Typed in the register Intuit’s void-or-delete help, updated 2026-09-07. Void keeps a zero record. Deleted lines cannot be restored.
Unapplied Jobber payment Void the unapplied copy after the payout report confirms one cash event.
Second Housecall Pro invoice Void the extra invoice with a memo that names the job and the invoice you are keeping.

Prefer exclude or void with a memo over a bulk delete. Do not undo the FSM sync wholesale. Do not undo the whole reconciliation for one extra line unless the statement was finished over many wrong lines. That smaller undo is how to undo a reconciliation in QuickBooks Online. A missing bank line is why the QuickBooks Online bank feed is missing transactions.

What still works

The native ServiceTitan, Housecall Pro, or Jobber sync wins the posting job. It is included with the FSM on the plans that offer it, and it creates the invoices and payments so you are not retyping them. QuickBooks Online’s register, bank feed, and Match still find the extra copy. A careful bookkeeper who Matches the feed and voids confirmed twins with a memo does tie out.

Pull last week’s bank or card statement, the QuickBooks register for that account, the Bank transactions tabs, the Undeposited Funds detail, and the FSM payout, batch, or invoice list. Start with those files. They already exist.

Frequently asked questions

Does QuickBooks Online have a Find Duplicates report?

No. Intuit's duplicate-transactions help, read 2026-10-12, is Chart of accounts, View register, Filter the dates, then select the Amount column so identical amounts line up. Check the bank statement first. For duplicate numbers, sort Sales transactions or Expense transactions by the NO. column.

Why does a deleted bank-feed line come back on For review?

Intuit's duplicate-transactions help, read 2026-10-12, says once a downloaded line is added or excluded, QuickBooks stops the bank from sending it again. Delete it, and the bank sends it again. Exclude from For review. If it was already added, Undo it from Categorized, then Exclude.

Should I keep the copy that already shows R or C?

Yes. Intuit's duplicate-transactions help, read 2026-10-12, says if one transaction is reconciled, keep that one. The reconciled copy shows R or C. Void or exclude the other copy after you confirm the cash hit the bank once. Do not undo the whole month for one extra line.

Why do two lines of the same amount show up when the customer paid once?

The field-app sync posted the payment, and the bank feed posted the same cash, or someone Categorized the payout instead of Matching it. Match the bank line to the payment or deposit you already have. On a Jobber shop the extra copy is usually the unapplied line in Undeposited Funds.

Related

Set up your client books

Month-to-month. No card needed today. Privacy