The fastest way to catch a duplicate supply-house invoice is to stop matching on invoice number. Match on the order or ticket number, the PO, and the combination of date plus SKU plus quantity plus amount. Almost every duplicate that actually gets paid carries a different invoice number than the bill it duplicates, which is exactly why the check most shops run does not catch it.
The rest of this is how the second bill gets created, why duplicate invoice detection is harder in a ten-person shop than in a company with an AP department, and how to get the money back once it is out the door.
One thing up front, because it changes how you approach the phone call: nearly none of this is deliberate. A supply house runs a counter, a will-call window, a delivery fleet, a backorder queue, and a statement cycle, and material moves through all five with paper attached. Duplicates are a process artifact of a paper-heavy counter business, the same category of problem as material price creep. Walk in accusing someone and you spend your credibility on the wrong thing.
The seven ways the same material gets billed twice
A will-call ticket and a delivered invoice for the same order
Your tech pulls half the order at the counter Friday because the job needs it Monday. The rest goes on Tuesday’s truck. The counter writes a will-call ticket for what walked out. The delivery side invoices the order as written, all of it. Now you have a ticket and an invoice covering overlapping material, generated by two systems that both think they are the record of the sale. Counter sales and order management are separate modules in the ERPs distributors run, which is a fair description of why the two documents can disagree (Epicor’s electrical distribution suite ships Counter Sales as its own module).
The statement billed alongside the invoices it summarizes
This is the single most common one in small shops, and it is not the supply house’s error at all. Most shops buy on account with monthly terms. The house emails individual invoices as orders ship, then mails a month-end statement listing all of them. Your bookkeeper pays the invoices as they land, then the statement arrives, looks like a bill, and gets paid too. Statements are summaries, not new charges. If the statement total ever gets keyed as its own payable, you have paid the month twice.
A corrected or rebilled invoice issued without a credit on the original
The first invoice priced a fitting off stock pricing instead of your job quote. You called. The rep fixed it and reissued. Whether you now owe one amount or two depends entirely on whether someone at the branch also raised a credit memo against the original. Sometimes they do. Sometimes the correction is issued as a fresh invoice and the original stays open, sitting in your payables looking exactly like a legitimate bill. This is the cousin of the problem covered in quote vs invoice mismatch: the correction is the fix, and the correction is also the new risk.
A backorder shipped and billed separately, then billed again on the original
Ten of twelve go out Tuesday, two are backordered. Some branches invoice the ten and open a backorder line. Some invoice all twelve and ship the last two when they land. If the first branch behavior gets keyed and the second gets billed, the two backordered pieces show up on both documents. Small dollars, high frequency, and it never trips a total-level review because two elbows do not move a $3,000 invoice much.
A counter ticket entered by two people
Somebody photographs the ticket and emails it in. Somebody else drops the paper copy in the office tray that night. Both get entered. This one is entirely on your side of the counter and it is the easiest to fix, which is a nice thing to know before you call anyone.
The invoice emailed and also mailed
Same document, two delivery channels, two arrival dates, two entries. The emailed PDF gets keyed the day it arrives. The paper copy shows up nine days later and does not look like something already in the system, because nobody remembers a $412 invoice from last week.
A job account and a house account both charged
Shops that run a separate account per big job, or a house account plus a job account at the same branch, can end up with material coded to both. The counter guy asks which account and gets told “put it on the Ridgeline job,” but the order was opened on the house account that morning. Two accounts, one pile of pipe, and neither account’s history shows the other.
Why duplicate detection fails in a small shop
Big AP departments catch these because they run a real three-way match: purchase order, delivery receipt, invoice, cross-checked before payment, with tolerance rules that decide what needs a human (Stampli’s rundown of three-way matching is a clean description of the control). That control is worth running even at ten people, and it scales down further than most owners expect: here is three-way matching sized for a contractor. A shop with one bookkeeper and a truck full of paper fails on four specific things.
You match on invoice number. Accounting software flags a repeated invoice number and that feels like duplicate protection. It is not. Six of the seven mechanisms above produce a second document with its own number. A rebilled invoice, a statement, a will-call ticket, and a backorder invoice all carry different numbers than the bill they overlap with. The one check you have running is the one that misses.
Paper tickets never enter the system. A counter ticket in a glovebox is not in your payables, so nothing can compare against it. When the invoice for that ticket arrives three weeks later, there is no prior record to duplicate against, and if the ticket does eventually get keyed, it becomes the duplicate.
Approval happens by total, not by line. The owner scans an invoice, sees $2,847, decides that looks about right for that week, and signs. A duplicated backorder line, a doubled bag of couplings, a second fitting entry: none of those change whether $2,847 looks right. The named failure modes in AP matching practice (quantity mismatch, price over tolerance, misaligned line-item descriptions) are all line-level problems (Tipalti’s tolerance guidance), and none of them are visible from the total.
Nobody sees a month at once. Invoices arrive one at a time and get paid one at a time. A duplicate is only obvious when two documents sit side by side, and in most shops those two documents are never on the same screen on the same day.
The checks that actually work
Match on order or ticket number and PO, not invoice number. Every supply-house document carries the order number it came from, usually printed smaller than the invoice number and often labeled “order,” “SO,” or “ticket.” Two documents with the same order number are two bills for one order. That is the check. If you issue POs, the PO number does the same job and does it across branches, which is one of several reasons POs earn their keep even in a shop that thinks it is too small for them (POs are also what let you see committed cost before the invoice lands).
Match on date plus SKU plus quantity plus amount. For anything without a usable order number, sort your line items and look for the same SKU, same quantity, same extended amount, within a few weeks. Exact-amount repeats on the same part number are rare in honest billing and common in duplicates.
Explicitly look for statement-versus-invoice double entry. Once a month, pull the statement and tick every line on it against a paid invoice. You are not auditing the statement for accuracy. You are confirming the statement itself never got entered as a payable. Two minutes, and it catches the most expensive version of this problem.
Run a lookback across months, not just the current one. The gap between an original and its duplicate is frequently four to eight weeks, because that is how long it takes a mailed copy, a statement cycle, or a corrected rebill to come around. A check that only looks at the current month structurally cannot see it. Sort a full quarter by vendor and amount and the pairs jump off the page.
Set a floor so you are not chasing pennies. Institutions publish these thresholds openly: one university runs two-way match at or below $2,499.99 and full three-way match above $2,500 (UGA’s published policy). Your number will be far lower, but pick one. A $12 duplicate costs more in phone time than it returns.
Mechanism to check
| How the duplicate got created | The check that catches it |
|---|---|
| Will-call ticket plus delivered invoice for one order | Match on order or ticket number, not invoice number |
| Statement paid alongside its own invoices | Monthly statement tick-off against paid invoices |
| Corrected or rebilled invoice, original never credited | Search the vendor for two invoices sharing an order number or PO; confirm a credit memo exists |
| Backorder billed separately and again on the original | Line-level compare on SKU plus quantity across the two invoices from that order |
| Counter ticket entered twice by two people | Date plus SKU plus quantity plus amount match within the same week |
| Invoice emailed and also mailed | Exact duplicate of number and total, four to eight weeks apart; quarterly lookback |
| Job account and house account both charged | Roll all accounts for one vendor into one list before checking, then match on date and SKU |
The pattern in the right column: five of the seven need a view of more than one document at once, and none of them are answered by a repeated invoice number.
An illustrative example
Say you buy from one house and the branch invoices you 22 times in June. Two of those invoices share order number SO-44819: one for $1,910 dated June 6, one for $1,910 dated June 24, because the first was corrected for a pricing error and reissued without a credit. Separately, four SKUs on a backorder appear on both the June 11 partial invoice and the June 19 completion invoice, worth $186 together. Total exposure that month, illustrative: $2,096. The $1,910 pair is invisible to an invoice-number check and invisible to total-level approval, because both totals are plausible. It is visible in about four seconds to anyone sorting the vendor’s June activity by amount.
Getting the credit back after you have already paid
You have paid it. The recovery is a credit memo, and the process is boring in a good way.
Send one email per duplicate, with the paper attached. Both invoice PDFs or photos, the shared order or PO number circled, and one sentence: “Invoices 388102 and 388477 both bill order SO-44819. We have paid both. Please issue a credit for $1,910.” No theory about why it happened. There is a copyable duplicate-invoice credit request written to that shape if you want the exact phrasing. The standard AP response to a mismatch is exactly this, a corrected invoice or a credit note (bill.com’s summary of the practice), and your rep processes these routinely.
Expect a credit memo, not a check. Credit memos typically get applied against an open balance or offset a future payment to the same vendor rather than refunded in cash (one published credit memo policy spells this out). If you buy from that house every week, that is fine. If you are winding the account down, say so in the email and ask for a refund specifically.
Send it fast. Fresh duplicates get honored close to automatically because the branch can still see both documents in the current cycle. Old ones turn into a research project for somebody who has no reason to prioritize it. The same published policy escalates uncollected credit balances at 45 days and again at 90, which is a reasonable mirror of how long your own patience should last before you follow up in writing again.
Do not confuse this with a return. A duplicate bill is a billing error and costs you nothing to fix. Material you actually want to send back is a different transaction with real friction: published distributor policies commonly charge a minimum 25% restocking fee and exclude wire cuts and non-stock items from returns entirely (Colonial Electric’s published policy), and the windows and exclusions are covered in detail in what a supply house can charge you to take material back. Frame the email as a billing correction, because that is what it is.
Realistic timing. A same-month duplicate with both documents attached is usually credited in a week or two. A prior-quarter one takes longer and sometimes goes nowhere, which is the real argument for a monthly review rather than an annual one.
What to do this month
- Pull the last three months of activity for your largest supply house into one list.
- Sort by amount and look for exact repeats. Check the order number on any pair.
- Tick last month’s statement against your paid invoices, confirming the statement itself was never entered.
- Compare any partial-shipment invoice against the completion invoice line by line for backordered SKUs.
- Roll job accounts and house accounts together before you check, or you will miss the cross-account ones.
- Send one email per finding, with both documents attached and the shared order number named.
- Then go fix the entry side: one person keys counter tickets, and paper copies of emailed invoices get shredded, not keyed.
Duplicates are the easiest money in an invoice audit because they are provable. Nobody argues about whether an order got billed twice, unlike a price that drifted or a contract price that quietly became a counter price. You attach two PDFs and someone types a credit memo. The hard part was only ever seeing them.
Sources
- Three-way invoice matching, explained (Stampli): invoice, purchase order and delivery receipt cross-check, and how tolerance rules are set.
- 3-way match tolerances and failure modes (Tipalti): typical 2% to 3% tolerance practice and the named mismatch types.
- 3-way matching and the response to a mismatch (BILL): withhold payment and request a corrected invoice or credit note.
- Credit memo policy (Miami University): credit memos applied against an open PO or a future payment, with 45-day and 90-day escalation on uncollected balances.
- Purchase order matching thresholds (University of Georgia): a published two-way versus three-way match dollar cutoff.
- Job costs and purchase orders (Foundation Software): POs as the record of committed cost at the job and cost-code level.
- Electrical distribution software modules (Epicor): Counter Sales, contract pricing and job management as separate systems inside a distributor ERP.
- Return and restocking policy (Colonial Electric Supply): minimum 25% restocking fee, no returns on wire cuts or non-stock items.