Duplicate receipts: how to avoid VAT mistakes?

Where duplicates come from in a freelancer's books

No one records the same expense twice on purpose. Duplicates arise from having too many channels: the receipt is photographed the same day, then the PDF invoice arrives by email two days later and also gets sent to the accountant. Or a batch of receipts is scanned once at the end of the week, found again in the glovebox, and scanned a second time at month end.

Other classic sources: an export redone after a correction and sent on top of the first one, a card purchase later refunded and re-entered, or two people in the same household managing the same folder.

The risk of deducting VAT twice

A duplicate produces two effects at once: a charge recorded once too often, which artificially lowers profit, and inflated deductible VAT, which lowers the VAT payable. The second point is the one that draws attention, because it directly affects a periodic return.

In an audit, the claw-back covers the wrongly deducted VAT plus late-payment interest. Isolated mistakes are corrected without drama; it is a file riddled with duplicates that turns a routine check into a deep-dive audit, because it casts doubt on the reliability of the whole set of accounts.

A duplicate is not fraud, but it looks like fraud when it keeps happening. That is why it is better to block it at entry than to fix it later.

Three cases not to confuse with a duplicate

Not every pair of similar-looking lines is a duplicate. Before deleting anything, check these three perfectly legitimate situations.

Spotting a duplicate in your paperwork

On a CSV export, the manual method is to sort by supplier then by date, and watch for identical consecutive gross amounts. A spreadsheet spots this in seconds with conditional formatting on the concatenation of supplier + date + amount.

• Sort by descending date and scan through lines from the same day.
• Compare the trio of supplier / date / gross amount.
• Check the time and receipt number before concluding anything.
• Check bank reconciliations: a single debit matching two expense lines is the most reliable signal.

ScanCompta's duplicate alert at scan time

The best moment to deal with a duplicate is before it exists. When you photograph a receipt, ScanCompta reads the supplier, date and amount, then compares that data against your already-recorded expenses. If a match appears, an alert shows up before saving, with the existing expense right there: you either confirm it is a separate purchase or you cancel.

Since every expense is tied to a client or job folder, the check takes context into account: two identical purchases on two different jobs are not read the same way as one purchase scanned twice. And the monthly export, generated straight from the database rather than assembled by hand, cannot send the same document twice.

Correcting a duplicate already declared

If the VAT return has not been filed yet, delete the extra line and regenerate the export: nothing else to do. If it has been filed, the correction goes through the next return, reducing deductible VAT by the wrongly deducted amount, or through an amended return depending on the scale.

Either way, tell your accountant rather than quietly fixing it yourself: a spontaneous, well-documented correction is treated as what it is — a mistake.

In short

Duplicate receipts cost you a VAT claw-back and, above all, the credibility of your file. Systematically check supplier, date and amount, keep only one document per expense, tell genuine false pairs like deposits apart, and let the tool block double entries at scan time rather than hunting for mistakes at year end.

Frequently asked questions

Read next

• Invoice or receipt: what should you give your accountant?
• Lost receipt: what to do to justify the expense?
• Photographing receipts: is it legal?
• Expense report software: how to choose when you run everything yourself