Building a duplicate-payment check for rental invoices and rebills

By RentalSpend · October 21, 2026

Use supplier, contract, invoice number, billed period, and unit-level detail together. That is the safest way to catch true duplicates and still allow legitimate rebills when they are backed by a credit or replacement invoice.

The safest duplicate-payment control for equipment-rental invoices is to block payment on two levels: first, match supplier ID, invoice number, and amount; second, search for the same supplier, unit, and billing period even when the invoice number changed. For rebills, do not pay the new invoice until you can tie it to a prior invoice, a credit memo or replacement reference, and the off-rent, return, or delivery record that proves which days were actually billable.^[1][2][3]

Work the control in this order

1. Match the invoice to a known supplier, contract, and rental account before it is entered for payment.
2. Check the invoice number, gross amount, and business unit against any invoice already in AP.
3. Search for the same supplier, unit, and billing dates, even if the invoice number is new.
4. Confirm the billed period agrees with the delivery ticket, off-rent confirmation, pickup record, or other acceptance evidence.
5. If the invoice is a rebill, require a linked credit memo or replacement reference before release.

Sources: ^[1][2][3]

What the system should stop automatically

If your ERP can do it, create a hard stop for any voucher that repeats supplier ID + invoice number + gross amount within the same business unit. That kind of rule catches the obvious duplicate. But do not stop there, because rental rebills often arrive under a different invoice number. Add a second exception search that flags the same supplier, same unit, and same date range, especially when the second bill lands soon after the first one.^[2]

Do not combine multiple supplier invoices into one voucher unless your procedure explicitly allows it and your duplicate logic still works after the combination. Ohio AP guidance warns that combining invoices can make duplicate detection harder. If you must use a source document instead of an original invoice, add controls that preserve when it was received so a later re-submission does not slip through as a new bill.^[2]

Illustrative example: a rebill with a correction

In that example, the credit and the replacement invoice together explain why the second bill is valid. Without the credit, the same days would be charged twice. Without the replacement reference, AP cannot tell whether the new invoice corrects the old one or simply repeats it.^[1][3]

Records that matter most

When a rebill is real, not duplicate

A rebill is usually safe to pay only when it clearly replaces a prior bill and the prior bill has been credited or otherwise voided in AP. That check matters because supplier terms vary. Some agreements bill in arrears upon invoice receipt, while others place charges on the applicable invoice with line items that can include rental, freight, fuel, surcharges, taxes, and reimbursements. A new invoice number by itself does not prove the charge is new.^[4][5][6]

• The new invoice references the old invoice number or a credit memo.
• The old invoice is marked credited, reversed, or otherwise removed from open payables.
• The billed period is the same, but the rate or charge is corrected with documentation.
• The invoice amount changed for a clear reason that matches the contract or rate sheet.
• The unit, rental dates, and charge types line up with the source documents.

Sources: ^{[1][2][3][4][5][6]}

What to do when the control flags something

Treat the item as a probable duplicate until someone confirms it is a valid rebill or a separate charge. Ask for the original invoice, the credit memo if one was issued, and the delivery or off-rent record. If the supplier cannot show that the first invoice was reversed, do not pay the second one. If the same invoice number appears with a different amount, check whether someone changed the invoice field in AP without a legitimate business reason; that can hide a duplicate instead of fixing one.^[2]

Next steps: set the first screen to supplier ID + invoice number + amount, add a second screen for supplier + unit + billing period, and require a linked credit or replacement document for every rebill. Then test the rule set against a sample of paid rental invoices, especially freight, fuel, surcharge, and damage-related charges, because those are the lines most likely to be repeated or corrected separately.^{[1][2][3][5][6]}

← All resources