A duplicate payment is when you pay twice. A duplicate invoice is how you get there. If the same bill is entered into your books two times, nothing is wrong yet. The cost arrives later, when both entries are approved and both get paid.
This guide covers the two linked problems: the same invoice recorded more than once, and bills paid for more than they were worth. You can check both from your own records.
Four ways the same invoice ends up in your books twice
- Entered twice, identically. Two rows with the same vendor, the same invoice number and the same amount. This often happens when an invoice arrives by email and by post, or when two people each enter it.
- Entered under different spellings.
INV-2087,INV 2087andINV-02087read as three different bills to a spreadsheet and as one bill to a person. - Entered with different amounts. The same invoice number appears twice with two different totals, for example after someone corrects a typo by adding a new entry instead of editing the old one.
- Entered under two numbers. A vendor reissues an invoice with a new number, or an amended copy arrives, and both get recorded.
How to check your bills for duplicates
Work through a list of vendor bills, ideally exported to a spreadsheet.
Check 1: Same vendor, same number, same amount. Sort by vendor, then invoice number. Identical rows are the easy catch.
Check 2: Normalize invoice numbers. Add a column that strips spaces, dashes, dots and leading zeros from each invoice number, then sort by it. Matches in the new column that look different in the old one are duplicates in disguise.
Check 3: Same number, different amount. Filter for invoice numbers that appear more than once with different totals. One of them is wrong, and which one is not obvious until you look at the original invoice.
Check 4: Same vendor, same amount, same date. Two bills of identical size from one vendor on one date are suspicious. They are often one invoice entered under two numbers. They can also be two genuine invoices, such as two identical shipments, so confirm with the vendor before you remove anything.
Check 5: Look for near-identical vendors. Two vendor records with almost the same name can split one vendor's bills across two accounts, which hides duplicates from every check above.
Overpaid bills
An overpaid bill is one where the total of the payments exceeds the invoice. The common causes are:
- A duplicate payment against the same invoice.
- A credit memo that wasn't deducted. You paid the full invoice amount and never took off the credit the vendor issued.
- A rounding or keying error. An extra digit or a decimal in the wrong place.
- An advance payment never offset. A deposit paid earlier that was never applied to the final bill.
To find them, add up the payments against each bill and compare the total with the invoice. Anything over is an overpayment. Don't let a single large invoice hide a small overpayment: check each bill, not just the big ones.
What to do when you find one
- Stop the second payment if it hasn't gone out yet. Remove or void the duplicate entry.
- Confirm with the vendor whether one invoice or two were issued, and send them the invoice number.
- Ask for a refund or a credit if you've already paid twice or overpaid. Include the payment dates and amounts.
- Fix the process. One route for invoices to enter the books, one person to approve, and a check for the invoice number before it's saved.
Where this gets hard
These checks only find problems you think to look for, and variations in spelling, spacing and number format multiply quickly. Most people don't normalize invoice numbers by hand every month.
How Guardian finds duplicate invoices and overpaid bills
Guardian reads your vendor bills and payments from spreadsheet or CSV exports and checks them for exactly these patterns: the same invoice entered more than once, the same number under different spellings, the same number with different amounts, several bills from one vendor with the same amount and date, bills paid more than once, and bills paid for more than their total. It also flags vendor records with similar names that may be the same vendor set up twice.
Each finding shows the amount at stake, the rows behind it, why it was flagged and what to do next. Findings are graded by confidence: an identical entry is stronger evidence than a pair of same-sized bills that might be two real purchases. The checks follow fixed rules rather than guesses.
Some matches are only "possible" duplicates, and Guardian says so. Two real invoices can look identical. The point is to tell you which to confirm first.
Try the sample demo to see how findings are presented →
The one-time Founder Lifetime offer for the first 100 founders is on the founder page.
FAQ
Is a duplicate invoice the same as a duplicate payment? No. A duplicate invoice is a duplicate entry in your records. A duplicate payment is when the money goes out twice. One often leads to the other.
What if the vendor really did send two invoices? Then both are valid and you owe both. That's why you confirm with the vendor first, before treating a match as a mistake.
How do I prevent duplicates? Use one route for incoming invoices, record each invoice number once, and check for the number before saving.
Can I get a refund for an old overpayment? Often, yes, but vendors differ in how far back they'll go, so check sooner rather than later.