Travel and vehicles

Tracking freelance income across currencies: three traps (Australia)

Australian freelancers with clients in the US, New Zealand and Singapore can keep their income straight. Three common traps and how to avoid them, in A$.

Editorial illustration for Tracking freelance income across currencies: three traps (Australia)

The most common way to lose track of freelance income in more than one currency is to record a converted figure with no trace of the original. Keep the original amount, the currency, the date and the Australian dollars received on every row, and you can rebuild any total later. Three traps make this harder than it needs to be.

Trap 1: Converting once and throwing away the original

A freelance online tutor with students in the US, New Zealand and Singapore bills in each student's home currency. If the sheet only says "A$412", you cannot tell whether that was a US$270 lesson block or an NZ$450 one. Later, when a student disputes an invoice, you have nothing to compare it against.

The cure is a row that reads: date, student, currency, amount billed, A$ received. For a block of US$270 that lands as A$412, the implied rate is 412 / 270 = 1.526. For NZ$450 landing as A$408, it is 408 / 450 = 0.907. Both are imagined numbers for illustration.

Trap 2: Mixing "billed" and "received" in the same total

Say the tutor billed US$270 + NZ$450 + S$300 in a month. Added up, that is nonsense, because three different currencies were summed. The correct total is the sum of the A$ received column. Suppose it is 412 + 408 + 305 = A$1,125. If one student has not paid, their A$ column is blank, and they appear under "owing", not in income.

  • Billed column: kept in each row's own currency, never summed across currencies.
  • Received column: always A$, the only column you total.
  • Status column: Paid, Part-paid or Owing.

Trap 3: Using one rate for the whole month

It is tempting to pick a single rate on the first of the month and apply it to everything. But money arrives on different days, and the amount actually credited depends on when it was converted. A month of payments at a single flat rate can differ noticeably from the sum of the real deposits. Use the deposit, not a monthly average.

How do I build the totals?

What you wantFormula (dates in A, currency in C, A$ received in E)
Income for one month=SUMIFS($E$2:$E$500, $A$2:$A$500, ">="&$H$1, $A$2:$A$500, "<="&$H$2)
Income from US students=SUMIFS($E$2:$E$500, $C$2:$C$500, "USD")
Number of unpaid rows=COUNTIF($F$2:$F$500, "Owing")
Average A$ per payment=AVERAGE($E$2:$E$500)

Type the first and last day of the month in H1 and H2 as proper dates, not text, or the comparison will not work.

What should I do when a payment lands short?

Record the actual deposit and add a note. If a student paying US$270 sends it through a provider that deducts a fee on its side, you may receive less than you expected. Your sheet should show the number you received, not the number you hoped for. If a gap keeps appearing, ask the provider for a breakdown, since fees and rates vary by provider and over time and we cannot tell you what yours charge.

Can an expense tracker replace the sheet?

For income alone, a sheet is fine. If you want costs such as software, internet and travel in the same view, SpendixAI shows totals in one base currency using the rate saved with each transaction. It is built around India and INR, so we would treat it as a reference point for the features to look for rather than a drop-in answer here.

What if a client wants an invoice in their own currency?

That is fine, and often kind to the client, but it moves the exchange uncertainty to you. Before agreeing, look at how many weeks pass between invoice and payment, because a longer gap leaves more room for the rate to move. Some freelancers add a line to their terms about which currency applies and when. Whatever you choose, write it in the sheet header so a later reader understands why the A$ amounts vary for the same US$ price.

A quick audit once a quarter

  1. Sum the A$ received column and compare it with deposits on your bank statements.
  2. Check every row still has an original amount and currency.
  3. Chase anything marked Owing for more than the terms you set.
SPENDIXAI JOURNAL

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

Explore your reports