The same bill, twice
Every payables team pays something twice eventually: a resent bill with a new reference, the same invoice by mail and portal. May’s scan flagged five pairs, a person spent ten minutes, and 8,940.00 stayed in the bank instead of becoming a recovery.
◆ May, the flagged pairsfive candidates, two real.
| Review outcome | Pairs |
|---|---|
| Cleared, legitimate recurring charges | 3 |
| Confirmed duplicates, blocked | 2 |
| Pairs flagged | 5 |
The two confirmed pairs totalled 8,940.00: one supplier re-sent an unpaid bill with a new reference, one bill arrived by both mail and portal. Neither was fraud, both would have paid twice, and the recovery email that never had to be written is the whole return on this control. Sample values are illustrative, never client data.
◆ What the rule looks atsimilarity, not identity.
Exact-duplicate checks catch almost nothing, because resent bills get new references. The rule scores similarity: same supplier and amount, dates within a window, references that differ by a suffix. Wide enough to catch the re-send, narrow enough that the review list stays five pairs, not five hundred.
◆ The owned answerthe check as a nightly query.
With invoice lines landed on the supplier star, the candidate scan is a nightly self-join, the review takes minutes, and the outcome lands back as data, so the rule’s precision is itself measured month over month.
- AP
- Accounts payable, the money owed to suppliers.
- duplicate candidate
- A pair the rule flags for human review.
- similarity rule
- Same supplier and amount, close dates, near references.
- confirmed duplicate
- A pair a person blocked before payment.
- recovery
- Asking a supplier for money back; the failure mode.