data.day
expense management / fraud prevention / audit / controls

The Duplicate Receipt Disaster: One Lunch, Two Claims, Zero Patience

We paid for the same lunch twice. Why? Because the employee was 'helpful' and sent the receipt via email AND the app. Here is how to stop the double-dip.

Klara Budget Klara Budget

Stop Paying for the Same Burger Twice

You are paying your employees a bonus they did not earn. It is called “The Duplicate Reimbursement Bonus.”

I audited a creative agency last month. Nice people. Terrible process. They had a Sales Director, “Dave.” Dave was disorganized, so he uploaded receipts to the company expense app and threw the paper receipts into a shoebox for the bookkeeper.

The bookkeeper, trying to be efficient, processed the shoebox manually. The app processed the digital claims automatically. Dave got paid double for every client dinner in Q3. The cost? €1,200 in leaked cash.

This is absurd. You would not pay a vendor twice for the same software license. Why do you pay your staff twice for the same pasta?

The Audit Risk: The “Dual Pipe” Failure

The root cause is having two open pipes for data ingestion without a filter between them.

  • Pipe A: The App (OCR, digital flow).
  • Pipe B: The Inbox/Shoebox (Manual flow).

When these pipes run parallel and do not talk to each other, duplicates are guaranteed. Humans are bad at spotting duplicates. If I see a receipt for €45.50 on Tuesday and another for €45.50 on Thursday, I assume Dave likes that restaurant. I do not assume it is the same piece of paper.

This destroys your audit trail. The tax authority will see two claims for one VAT event. They will disallow both and fine you for negligence.

The Control: The Digital Fingerprint

We need a machine to kill the duplicate.

Modern AP tools use Hashing. They look at the combination of:

  1. Date
  2. Amount
  3. Supplier Name

If a new invoice arrives that matches these three fields on an existing record, the system screams “DUPLICATE” and blocks the upload.

The Fix:

  1. Close the Manual Pipe: Stop accepting paper. If it is not in the app, it does not exist. The shoebox goes in the trash.
  2. The “One Source” Rule: If an invoice arrives via email, it must be forwarded to the same intake address that the app uses. Do not manually type it into Xero/QuickBooks. Let the intake engine spot the collision.
  3. The Weekly Scan: Every Friday, run a “Potential Duplicates” report in your accounting software. Look for:
    • Same Amount + Same Vendor + Dates within 3 days of each other.
    • (Often the date is off by one day due to timezone differences).

Summary

“Being safe” by submitting data twice is not safety. It is noise. Tell your team: “One receipt. One upload. Do it once, do it right.”

Meten is weten. If you count the receipt twice, your numbers are a lie.

FAQs

Why doesn't the software catch duplicates automatically?

Because software is dumb. If the date format differs slightly (01/05 vs 1-May), or if the amount varies by one cent due to exchange rates, the robot thinks it is a new bill.

Is it really a big deal if we pay €20 twice?

Yes. Multiply €20 by 50 employees by 12 months. You are bleeding thousands. And if you pay a duplicate vendor invoice of €5,000, it is a disaster.

How do I stop employees from double-submitting?

You cannot fix people. You must fix the pipe. Block the second entry at the gate.