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.
| Date | Client | Billed | Deposited | Note |
|---|---|---|---|---|
| Jun 3 | US studio | US$2,500 | C$3,400 | Invoice 31, full |
| Jun 12 | UK agency | £900 | C$1,593 | Invoice 32, part 1 of 2 |
| Jun 19 | Local client | C$650 | C$650 | Invoice 33, full |
| Jun 27 | UK agency | £600 | C$1,044 | Invoice 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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

