Money basics

Foreign Receipt Date Formats: Avoid Wrong Entries (Canada Edition)

Receipts and invoices can carry several dates in different orders. Learn which date to log, and how to avoid month-day mix-ups in Canadian dollar expenses.

Editorial illustration for Foreign Receipt Date Formats: Avoid Wrong Entries (Canada Edition)

A conference invoice can show an invoice date, a service date and a payment date, each in a different order, and only one of them belongs in your expense log. Log the date you actually paid or received the service, write it as year, month, day, and keep the other dates in the note.

Which date on the document should you log?

Many invoices and online order confirmations carry more than one date. Use this guide when you are recording what you spent, not when the supplier billed you.

Date printedWhat it meansUse it as the expense date?
Order dateWhen you placed the orderOften yes, for a card purchase
Invoice dateWhen the supplier issued the billOnly if you paid on the same day
Service or travel dateWhen you used the serviceYes, if you are tracking by activity
Due dateLast day to payNo, but keep it for reminders
Delivery dateWhen goods arrivedRarely

How do you stay consistent?

Choose one rule per kind of spend and stick to it. Say you pick the card charge date for everything bought online, and the service date for travel. Write the rule at the top of your sheet so that you do not wonder six months later. A mixed rule is worse than either choice.

What about month names and year-first dates?

Some documents spell the month in words, which settles any doubt, while others print numbers only. Year-first dates such as 2026-05-06 are common on software invoices. A file from a conference in the US may use month-first order while a Canadian supplier uses year-first. If you see a slash date next to a month name, believe the month name.

Worked example: a trip to a conference

Imagine four documents for one trip, all in Canadian dollars: a registration invoice for C$450.00, a hotel folio for C$612.40, a taxi receipt for C$31.75 and a lunch slip for C$22.60. The total is C$450.00 + C$612.40 + C$31.75 + C$22.60 = C$1,116.75. The registration invoice is dated 05/06/26 and says the event is 12 to 14 June. Whichever way you read it, you only care about the date you paid. Your statement shows the payment on 6 June, so that is what goes in the log.

  • Registration: paid 2026-06-06, C$450.00, note: invoice printed 05/06/26.
  • Hotel: checkout 2026-06-14, C$612.40, charged on checkout.
  • Taxi: 2026-06-12, C$31.75.
  • Lunch: 2026-06-13, C$22.60.

How do you catch a swapped date later?

Sort the log by date and check each entry against your trip dates. Anything outside the trip window is a swap candidate. Then compare it with the statement charge for the same amount. If the statement charge falls inside the window and your entry does not, fix the entry.

What if the document shows only a month and a year?

Software and membership invoices often show a billing period such as June 2026 rather than a day. Log the day the card was charged, and write the period in the note. If you pay annually, a C$240.00 renewal belongs on the charge date, not spread across twelve invoice months, unless you deliberately split it into C$20.00 a month for planning. Decide that once and apply it to every similar item.

Before you close the month

Run down the list once more: every foreign receipt has an unambiguous year-first date, the original currency and amount, and the Canadian dollar amount charged. SpendixAI supports an expense in its own currency with totals in a base currency, though it is built around India and INR rather than Canadian accounts.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports