Travel and vehicles

A simple way to log freelance income in mixed currencies (Canada)

Canadian freelancers paid in US dollars and pounds can keep a single Canadian-dollar income log. Worked example with part payments and a monthly check.

Editorial illustration for A simple way to log freelance income in mixed currencies (Canada)

Log each payment on its own row with the currency, the amount invoiced and the Canadian dollars deposited, then total the deposited column. If a client pays an invoice in two instalments, they get two rows. That small rule solves most of the confusion when income arrives in several currencies.

Who runs into this problem?

A freelance video editor in Calgary with a US studio client, a UK agency and a local wedding videographer will have money arriving in three flavours. Each client has a different payment rhythm: the studio pays on net-30 terms, the agency pays quickly but in pounds, and the local client pays by e-transfer the day after delivery. A single column of numbers cannot tell those stories.

What does a worked month look like?

All figures below are invented to demonstrate the arithmetic.

DateClientBilledDepositedNote
Jun 3US studioUS$2,500C$3,400Invoice 31, full
Jun 12UK agency£900C$1,593Invoice 32, part 1 of 2
Jun 19Local clientC$650C$650Invoice 33, full
Jun 27UK agency£600C$1,044Invoice 32, part 2 of 2

Total deposited for June: 3,400 + 1,593 + 650 + 1,044 = C$6,687. The agency invoice was £1,500 in all (900 + 600), deposited as 1,593 + 1,044 = C$2,637, which works out to 2,637 / 1,500 = 1.758 Canadian dollars per pound across both parts. Notice that the two parts came in at slightly different rates (1.77 and 1.74), which is exactly why they need separate rows.

How do I check that an invoice is fully paid?

Add a column for the invoice number and use a SUMIF to total what you billed against it: =SUMIF($F$2:$F$500, "32", $C$2:$C$500) returns the billed amount received so far for invoice 32, here 1,500 (keep column C as plain numbers, with the currency in its own column, so it can be added). If your original invoice was for £1,500, it is closed. If the number is lower, you still have a balance to chase. Make sure the invoice numbers in column F are entered the same way each time, either all as numbers or all as text, otherwise the match can fail.

What should the callout rule be for rates?

How often should I look at it?

  • After each deposit: add the row while you still remember which invoice it settled.
  • Weekly: skim for invoices older than the terms you agreed.
  • Monthly: total the deposited column and compare with the bank statement.
  • Quarterly: look at income by currency. If most of it is in one foreign currency, you are more exposed to swings in it than you may have realised.

For the quarterly view, a pivot table with currency as rows and months as columns, summing the deposited column, shows the balance at a glance. In Excel or Google Sheets, select the data, insert a pivot table, put Currency in Rows, Month in Columns and Deposited in Values. If the month column does not exist, add a helper with =TEXT(A2,"yyyy-mm").

Is there a point where an app helps more than a sheet?

When you want expenses, receipts and income in one record, yes. SpendixAI stores a currency on each expense and reports totals in a base currency using the rate saved with each transaction, with a foreign-currency spend report. It is designed for India and INR, so we would not suggest it as a ready-made fit for Canadian freelancing; consider it only as an example of what to look for in any tool, which is a stored rate per transaction and one base currency for totals.

When to ask for help

If you are unsure how foreign income should be reported, or which exchange rate convention is accepted, ask an accountant who works with self-employed clients. The log above gives them what they need: dates, original amounts, deposits and invoice references.

SPENDIXAI JOURNAL

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

Explore your reports