Back Office
How to find and recover duplicate vendor payments
Small businesses pay the same invoice twice more often than most owners think, and vendors rarely call to give it back. Here is where duplicates hide, how to find them in your own records, and how to recover the money.
Short answer
To find duplicate vendor payments, export 12 months of paid bills and payments from your accounting system, bank and card statements, then match them on vendor, amount and date, and normalize invoice numbers so that "INV-1043" and "1043" count as the same bill. Confirm each match against the vendor's statement, then ask the vendor in writing for a refund or a credit, citing both payment references. Most vendors will return a clearly documented duplicate, but the older it gets, the harder it is to recover.
Key takeaways
- Duplicates usually come from the same bill entering your system twice: a re-sent invoice, a statement paid as if it were an invoice, or one vendor set up under two names.
- Exact-match searches miss most of them. Match on vendor, amount and a date window, and clean up invoice numbers before comparing.
- Check more than one payment channel. A bill paid by check and again by card never shows up as a duplicate inside one report.
- Recovery is mostly paperwork: both payment references, the invoice, and a written request for a refund or credit.
- Unapplied credits and missed early-pay discounts sit in the same data and are worth checking in the same pass.
Why duplicate payments happen
A duplicate payment is when you pay a vendor more than once for the same invoice or the same goods. It almost never comes from carelessness in one moment. It comes from the same bill entering your system twice through two different doors.
In a 5 to 100 person business, those doors are everywhere. Invoices arrive by email, by mail and through vendor portals. A field manager pays a supplier on the company card to get material released, and the office pays the invoice when it shows up a week later. A vendor sends a "second notice" with a new date and a slightly different invoice number. Someone sets up "ABC Supply" and someone else sets up "ABC Supply Co." Your accounting software checks for duplicates within one vendor record and one bill number, so none of these trip the warning.
Vendors are not required to call you about an overpayment. Most will sit on it as a credit balance on your account, and many never apply it to the next invoice unless you ask. Your bookkeeper reconciles what you paid to the bank, which is correct even when the payment itself was wrong.
The six patterns to look for
Most duplicates fall into a handful of patterns. Knowing which one you're looking for tells you which data to pull and how loose the match needs to be.
| Pattern | What it looks like | Why your software misses it |
|---|---|---|
| Re-sent invoice | Same amount, same vendor, invoice number with a suffix or different date | The bill number doesn't match exactly |
| Statement paid as invoice | A payment equal to a statement balance that already included paid invoices | The statement is entered as its own bill |
| Two payment channels | Card or ACH payment plus a check or bill-pay for the same invoice | Card charges are coded to an expense account, not matched to the bill |
| Duplicate vendor records | Same vendor under two names, addresses or tax IDs | Duplicate checks run inside one vendor record |
| Typo or format variation | "INV-01043" and "1043", or $1,250.00 and $1,205.00 | Exact matching treats them as different |
| Recurring charge plus invoice | An autopay charge and a manually paid invoice for the same period | Nobody connects the autopay to the bill |
How to find duplicates yourself, step by step
You can do a useful first pass in a spreadsheet in an afternoon or two. The key is pulling every payment channel into one list and matching loosely, then confirming by hand.
- Pull 12 months of payments. Export paid bills and bill payments from your accounting system, plus bank statements (checks and ACH) and every company credit card. Twelve months is a practical window: long enough to catch annual vendors, recent enough that vendors still have the records.
- Put everything in one sheet. One row per payment: date, vendor name, amount, invoice or reference number, payment method and source.
- Clean the vendor names. Strip "Inc.", "LLC", "Co.", punctuation and capitalization. Group variations of the same vendor under one name. Card statements often show a processor name, so look those up.
- Clean the invoice numbers. Remove prefixes, dashes, spaces and leading zeros, so "INV-01043" becomes "1043".
- Match on vendor plus amount. Sort by cleaned vendor, then amount. Flag any pair with the same amount within roughly 60 days of each other. Then flag pairs with the same cleaned invoice number regardless of amount.
- Look for near-matches. Same vendor and invoice number but amounts that differ by a transposed digit, or one payment that equals the sum of two others.
- Check against the vendor's statement. Request an account statement from each vendor with a flagged pair. A credit balance or an invoice shown as paid twice confirms it.
- Rule out the legitimate repeats. Rent, retainers, subscriptions and progress billings often repeat the same amount on purpose. Pull the invoices behind each flagged pair before contacting anyone.
The false positives are the slow part. Most flagged pairs turn out to be legitimate recurring charges, so plan for the review step to take longer than the matching.
How to get the money back
Recovery is mostly about sending a vendor a request they can verify in two minutes. A clear, documented request usually gets a refund or credit. A vague one gets ignored.
- Build a one-page packet per vendor. Include the invoice, both payment references (check numbers, ACH trace numbers or card transaction details), dates and amounts.
- Decide refund or credit. If you buy from the vendor regularly, a credit against the next invoice is faster. If you rarely use them, ask for a refund. Say which one you want.
- Send it to accounts receivable, not your sales rep. AR can see the payment history and issue the credit memo. Ask for written confirmation.
- Follow up on a schedule. If there's no answer in two weeks, follow up. Note every contact.
- Make sure credits actually get used. A credit memo that sits on the vendor's books hasn't saved you anything yet. Record it in your accounting system and apply it to the next bill.
Illustrative example: a contractor with 80 active vendors runs this process and confirms three duplicates: a $4,180 lumber invoice paid by check and again by card, a $960 equipment rental paid off a statement and the original invoice, and a $2,300 subcontractor bill entered under two vendor records. That's $7,440 back, recovered with three short emails and a couple of follow-up calls. The numbers are made up, but the pattern is typical.
Older duplicates are harder to get back. Vendor staff change, records get archived, and some vendors write off old credit balances. In many states, unclaimed credit balances can eventually be reported to the state as unclaimed property, so check your state's unclaimed property database for your business name if you suspect old overpayments.
Unapplied credits and missed early-pay discounts
The same 12 months of AP data usually hides two other kinds of leakage, and they're worth checking in the same pass.
Unapplied credits
An unapplied credit is money a vendor owes you, from a return, a rebate, a pricing correction or an overpayment, that was never deducted from a later bill. The fix is the vendor statement: any credit balance or open credit memo on it is money you can claim. Ask each regular vendor for a full account statement once a year, and compare it line by line with your own records.
Missed early-pay discounts
An early-pay discount is a term like "2/10 net 30": take 2% off if you pay within 10 days, otherwise the full amount is due in 30. Look for invoices with discount terms that were paid in full after the discount date.
The discount is worth more than it looks. Paying 20 days early to save 2% works out to an annualized return of roughly 37% (2 ÷ 98 × 365 ÷ 20). If cash allows, it's one of the best returns a small business can get on its own money. Missed discounts usually can't be claimed after the fact, but some vendors will honor them if you ask, and the review shows you which ones to take going forward.
How to stop it happening again
Prevention comes down to having one door for bills and one way to pay each vendor. Most of these controls cost nothing.
- One intake address. Have vendors send all invoices to one AP inbox, and ask them to stop mailing paper copies.
- Clean up the vendor list. Merge duplicate vendor records and require a tax ID (from the vendor's W-9) before adding a new vendor.
- One payment method per vendor. If a vendor is paid by ACH, don't also pay them on the card. If the field has to use a card, the receipt goes to AP the same day and gets matched to the bill.
- Turn on duplicate bill warnings in your accounting software, and enter invoice numbers exactly as printed.
- Never pay from a statement. Pay from invoices only, and use statements to reconcile.
- Review before each payment run. Sort the batch by vendor and amount and scan for repeats. It takes minutes.
Matching thousands of lines across bank, card and AP exports is exactly the kind of tedious, rules-heavy reading that software does well and people do poorly. It's one of the four areas Tarvora checks in its free Back Office Audit, where AI reviews 12 months of documents and a person verifies every finding before you see it. If your contracts and renewals are the bigger worry, see our guide to how auto-renewing contracts lead to overpaying. For the people-side costs, read how to recover health premiums paid for former employees.
Frequently asked questions
How common are duplicate vendor payments?
Duplicate payments are common enough that large companies hire recovery firms to look for them every year. In small businesses they usually come from the same bill entering the system twice, such as a re-sent invoice, a statement paid as if it were an invoice, or a vendor set up under two names. Any business paying more than a couple of dozen vendors through more than one channel should check.
Will a vendor refund a duplicate payment?
Most vendors will refund or credit a duplicate payment once it is clearly documented. Send their accounts receivable team the invoice and both payment references, say whether you want a refund or a credit, and ask for written confirmation. Requests for older payments take longer and are less likely to succeed.
How far back should I look for duplicate payments?
Twelve months is a practical starting window because it catches annual vendors and vendors still have the records. If you find several duplicates, extend the search to two or three years, since the same process problem has probably been producing them for a while.
Doesn't QuickBooks catch duplicate bills automatically?
Accounting software such as QuickBooks can warn you when you enter a bill number that already exists for the same vendor. It does not catch duplicates with a different invoice number format, duplicates across two vendor records, or a bill paid once through accounts payable and again on a company card.
What is an unapplied vendor credit?
An unapplied vendor credit is money a vendor owes you from a return, rebate, pricing correction or overpayment that was never deducted from a later invoice. It usually shows up as a credit balance on the vendor's statement, and you can claim it as a refund or apply it to your next bill.