Travel and vehicles

Track freelance income paid in several currencies (US)

A US freelancer paid in euros, pounds and Canadian dollars can keep one clean income log in dollars. Here is the ledger, the formulas and the habits.

Editorial illustration for Track freelance income paid in several currencies (US)

Keep one row per payment, and record three things on it: the amount in the currency you invoiced, the currency name, and the dollars that actually landed in your account. Your dollar total is then just the sum of the landed column, and nothing has to be re-converted at the end of the year. The rest of this article shows how to set that up so a messy mix of clients stays readable.

Why does mixed-currency income get so confusing?

Three dates and two amounts hide inside every foreign invoice. You invoiced on one day, the client paid on another, and the money reached your US account on a third, usually at a different exchange rate from the one you had in mind. If you only note "€2,000 from the Berlin client", you cannot say later what that was worth in dollars. If you only note the dollars, you cannot tell which invoice it settled.

The fix is not a clever formula. It is deciding that your home currency, dollars here, is the base for every total, and that every row carries its own conversion.

What should each row of the income log hold?

Say a freelance designer sent three invoices in March. Here is the log after the money arrived:

InvoiceDate paidInvoiced asLanded in accountRate it implies
101Mar 4€2,000$2,1601.08 dollars per euro
102Mar 11£1,500$1,9051.27 dollars per pound
103Mar 20C$2,400$1,7760.74 dollars per Canadian dollar

The implied rate is simply landed divided by invoiced: 2,160 / 2,000 = 1.08, 1,905 / 1,500 = 1.27, and 1,776 / 2,400 = 0.74. March income in dollars is 2,160 + 1,905 + 1,776 = $5,841. These numbers are made up to show the arithmetic, not typical rates.

Which formulas keep the totals honest?

  • Implied rate in column E: =D2/C2, where C holds the invoiced amount and D the dollars landed.
  • Total dollars for one month in a sheet where column B holds the payment date: =SUMIFS($D$2:$D$500, $B$2:$B$500, ">="&$H$1, $B$2:$B$500, "<="&$H$2), with the first and last day of the month typed into H1 and H2.
  • Total by client currency: =SUMIFS($D$2:$D$500, $F$2:$F$500, "EUR"), where column F holds a three-letter currency code.
  • Count of invoices still unpaid: =COUNTIF($G$2:$G$500, "Unpaid"), if column G holds a status.

Type currency codes consistently. "EUR" and "Euro" are two different values to a spreadsheet, and the SUMIFS above will quietly skip one of them.

What about invoices that are paid in parts or in a different amount?

Add a second row rather than editing the first. If a client owes £1,500 but pays £1,000 now and £500 later, you have two landed amounts and probably two rates. Keep the invoice number the same on both rows and add a "part" note. When the sum of the invoiced column for one invoice number equals what you billed, the invoice is closed.

Short-paid invoices are worth a note too. If a client sends £1,470 against £1,500 because their own bank took a cut, write the shortfall in the notes column. It is a cost of doing business in several currencies, and it is easier to see when it is written down.

Where does an expense tracker fit in?

A sheet like this is enough for a handful of invoices a month. It stops being enough when you also want your business spending, subscriptions and personal costs in the same place, with receipts attached. SpendixAI lets each expense carry its own currency and shows totals in one base currency using the rate saved with each transaction, with a foreign-currency spend report. It is built around India and INR, so check whether it suits your situation before relying on it.

A short monthly routine

  1. On the day a payment arrives, add the row: invoice number, currency, invoiced amount, dollars landed.
  2. Once a month, compare the landed column against your bank statement total for foreign receipts.
  3. Mark any invoice older than your payment terms as chased, with the date you chased it.
  4. Glance at the totals by currency so you notice if one client now accounts for most of your income.
  5. Before any tax conversation, ask your accountant which rate or date convention they want, since rules differ and change. Do not guess it yourself.
SPENDIXAI JOURNAL

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

Explore your reports