--- title: "Find & Fix Duplicate Transactions in Your Books | MCC" description: "Where duplicates come from, how to spot them, which copy to keep and how to stop a repeat. Worked example." url: "https://mcc-solutionsnj.com/bookkeeping/guides/how-to-find-and-fix-duplicate-transactions" --- Bookkeeping guide · Updated October 12, 2026 # How to Find and Fix Duplicate Transactions Duplicate transactions inflate income and expenses and throw off reconciliations. They come from a few predictable sources, and each has a clean fix. By [Matthew Coleman](/about), MCC Solutions **Quick answer.** Duplicates usually come from a manual entry plus a bank feed line, an overlapping import, a second connection to the same account or a recurring template plus a bank rule. A reconciliation that is off by exactly one amount is the tell. Want this handled for you? Monthly bookkeeping, cleanup and year-end close for small businesses. Start with a free health check of your books. [Free health check](/bookkeeping/health-check)[Get a quote](/bookkeeping/#interest) **Related:** [Owner contribution or loan](/bookkeeping/guides/owner-equity-and-capital-contributions) · [Closing entries and retained earnings](/bookkeeping/guides/closing-entries-and-retained-earnings) · [Void vs delete a transaction](/bookkeeping/guides/voiding-vs-deleting-transactions) **Free tools:** [Late payment fee calculator](/bookkeeping/late-payment-fee-calculator) · [True cost of an employee](/bookkeeping/employee-cost-calculator) [![Intuit ProAdvisor Gold tier badge](/img/credentials/intuit-proadvisor-gold.png)](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)Gold tier in Intuit's ProAdvisor program. [See my Intuit listing](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77) Keeping your own books? Tallyfinch does invoices, bank import and reports on your computer. [See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software) ## 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. ## Want us to handle it? We get behind or messy books current, tell you what we found, and hand you a clean starting point, in QuickBooks, Xero or Excel. **Price:** Free review of your books first, then a written quote before any work starts. [Get a free review and quote](/bookkeeping/#interest) [How catch-up and cleanup work](/bookkeeping/catch-up) ## 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 **Could two identical charges be real?** Yes, such as two coffees or two subscription seats. Check the statement and receipts before deleting. **Will deleting a duplicate change my tax figures?** It changes your books for the period. If a return was filed, consult your accountant. 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. Let us handle it [### Monthly bookkeeping Categorizing, reconciling and monthly reports, with cleanup, payroll and NJ filings available. Bookkeeping →](/bookkeeping/) [### QuickBooks Online Monthly bookkeeping, cleanup and reconciliation in QuickBooks Online for New Jersey small businesses. Your account stays in your name. QuickBooks →](/bookkeeping/software/quickbooks-online)[### Xero Bookkeeping and reconciliation in Xero for New Jersey small businesses, including cleanup and moving from spreadsheets or another program. Xero →](/bookkeeping/software/xero) More guides - [What Is a Fractional CFO and What Do They Do?](/bookkeeping/guides/what-is-a-fractional-cfo) - [Fractional CFO vs Controller vs Bookkeeper: Differences](/bookkeeping/guides/fractional-cfo-vs-controller-vs-bookkeeper) - [How Fractional CFO Pricing Works: Models and Cost Drivers](/bookkeeping/guides/how-fractional-cfo-pricing-works) - [When to Hire a Fractional CFO: Signs Your Business Is Ready](/bookkeeping/guides/when-to-hire-a-fractional-cfo) Free tool - [Bookkeeping health check](/bookkeeping/health-check) [All guides](/bookkeeping/guides) Reach small business owners, freelancers and bookkeepers who read this guide: [advertise here](/advertise#bookkeeping). Do it yourself ### Chart of Accounts and QuickBooks Import Pack Start your books with an account list built for your type of business, instead of the generic default, and compare it with the accounts you already have. [See what's inside ($24)](/toolkits/chart-of-accounts-quickbooks-import-pack)14-day full refund ## Rather have us keep the books? Ask for a quote. [Get a Quote](/bookkeeping/#interest)[Call (908) 444-6373](tel:+19084446373)