How to Find and Fix Duplicate Transactions

Where duplicates come from

The typical causes are a manual entry plus a bank feed line for the same payment, a CSV import that overlapped with the feed, a second connection to the same bank account, a recurring template plus a bank rule, and a customer payment entered twice. Knowing the source tells you how to stop it.

Find them

Reconcile the account, since a duplicate usually leaves the balance off by exactly its amount. Run a transaction list sorted by amount and date, and scan for same-day, same-amount items. Some software has a duplicate detection tool or flags possible matches in the bank feed. Check the vendor or customer ledger as well, for repeated bills and invoices.

Decide which to keep

Keep the entry that has the better detail, such as the attached receipt, the correct category or the link to an invoice. If one was matched to the bank feed and reconciled, keep that one. Removing the reconciled version forces you to undo reconciliation, so it is usually easier to delete the unreconciled copy.

Delete, void or exclude

For feed items, you can exclude the duplicate line from the review list. For entries you created, delete them if never used, or void documents that must retain a number. If the period is closed, speak with your accountant before making a change, because filed returns could be affected. Document the correction with a note.

Prevent a repeat

Choose one entry method per type of transaction. If the bank feed brings in your expenses, do not also enter them manually. Set a start date on any new connection that avoids overlap. Review the For review list before accepting items in bulk. Keep a log of imports. When customers pay by several methods, record each payment once and apply it to the invoice instead of creating separate income lines.

After fixing, rerun the profit and loss for the affected period. Revenue or expenses should drop by the duplicate amounts. If the totals do not change as expected, the duplicate may have been in a different account.

A worked example

Imagine a 300 dollar equipment payment entered by hand on the 5th, then imported from the bank feed on the 7th. The reconciliation is off by 300. Search the register for 300 around those dates, find both items, keep the one matched to the bank and delete the manual copy. Reconcile again, and the difference disappears. Write a note so the same handling is used next time.

Duplicates are not limited to bank lines. A vendor bill entered twice can lead to a double payment, and an invoice entered twice overstates income. Sort the bill and invoice lists by number and amount, and look for repeats. Check whether a vendor sent a revised copy with a different number. Many software tools warn when a bill number is reused, so leave that warning on.

Mistakes that cost money

Deleting the wrong copy, usually the one that matched the bank feed. Removing a duplicate in a reconciled month. Assuming two identical amounts are duplicates when they are two real purchases. Fixing the symptom without finding the cause, so the feed or import duplicates it again next month.

Check your work

After cleanup, compare the register balance to the bank statement for each affected month, and rerun your profit and loss. Total expenses should fall by exactly the duplicate amounts you removed.

Common questions

This guide is general information, not tax, legal or accounting advice. Rules, fees and due dates change; check with the IRS, the NJ Division of Taxation or a licensed professional for your situation.