Prevent duplicate expense records by checking for an existing transaction before creating a new one. Compare the date, supplier, amount, currency, payment source and Business together; no single field is reliable on its own.

Give one transaction one record

A card alert, emailed invoice, paper receipt and bank-statement line can all describe the same purchase. Treat them as supporting evidence for one expense rather than four separate expenses.

Before adding a record, search a reasonable date range and check:

• supplier or payee name, including abbreviations;
• total amount and currency;
• transaction and posting dates;
• card, bank or owner payment source;
• invoice or receipt number; and
• the selected Business.

Attach new evidence to the existing record when the facts match.

Build stable matching rules

Use more than an exact supplier name. Statement descriptions may differ from the receipt, and a pending card authorization can post with a different date or amount. A practical duplicate check combines several fields and leaves uncertain matches for review.

Recurring subscriptions need special care: identical monthly charges may be legitimate separate transactions. Match the service period or invoice number before deciding.

Keep imports and manual entry in the same workflow

When bank transactions, receipt capture and manual entry meet in one review queue, search before creating. Do not automatically convert every imported statement row into a new expense. First determine whether it matches a record already supported by a receipt or invoice.

Use SilaTrail’s expense records, bank-statement matching and monthly review to keep evidence and transaction review connected.

Handle a suspected duplicate carefully

Do not delete one record simply because two totals look alike. Compare the evidence, payment source and Business. If they describe the same transaction, preserve the stronger record and use the approved archive, void or correction workflow for the extra entry. Record why the change was made so the sequence remains understandable.

Refunds and reversals are not duplicates of the original purchase. Link them to the original event while keeping their separate dates and amounts.

Frequently asked questions

Are two charges from the same supplier always duplicates?

No. Suppliers can bill the same amount more than once. Confirm dates, invoice numbers, service periods and payment accounts.

Should a receipt and a bank transaction become two records?

No. They are normally two pieces of evidence for one purchase. Match them to one expense record.

What if the duplicate was posted to another Business?

Stop and verify ownership and purpose. Use a controlled correction; do not copy the expense into both Businesses.

Official guidance

The CRA requires supporting records that explain business transactions. Review Business records and the CRA’s electronic record keeping guidance.

This workflow improves record integrity; it does not decide deductibility or accounting treatment.