To track freelance income in several currencies, record every payment twice: once as the amount the client was invoiced in their currency, and once as the amount that actually reached your account in your home currency. Keep the fees in between as their own column. The home-currency figure is what you budget with, and the gap between the two is what the currency cost you.
What should we record for each payment?
One row per payment, with the same columns every time. This example is written for a freelancer whose home currency is the US dollar, but the method works anywhere. Tax rules are specific to where you live and are not covered here; ask a qualified accountant what records they want to see.
- Invoice number and client name.
- Invoice date and the date money arrived. They often differ by weeks.
- Invoice currency and amount.
- Amount received in your home currency, as shown on the bank or payout statement.
- Fees taken by the payment platform or bank, in the same currency as the amount received.
- Effective rate: amount received divided by invoice amount.
A worked example with made-up numbers
Say a freelance designer has three clients in different currencies in one month.
| Client | Invoiced | Received (USD) | Fees (USD) | Net (USD) |
|---|---|---|---|---|
| Studio in Germany | EUR 1,200 | 1,308.00 | 24.00 | 1,284.00 |
| Agency in Canada | CAD 2,000 | 1,460.00 | 18.00 | 1,442.00 |
| Start-up in the USA | USD 900 | 900.00 | 0.00 | 900.00 |
Net income for the month is 1,284 + 1,442 + 900 = 3,626 dollars. For the first row, the received amount implies a rate of 1,308 divided by 1,200, which is 1.09 dollars per euro. The fees of 24 dollars are about 1.8 percent of 1,308. If every month shows fees near that level, you can price future quotes accordingly.
Which exchange rate should we use?
Use the one your bank or payout service actually applied, because it matches the money that arrived. Do not recompute from a rate you found later; it will not match your deposit. If you must convert something that was never deposited, such as an unpaid invoice you want to forecast, use a clearly labelled estimate rate and mark the row as an estimate until the payment lands.
How do we stop unpaid invoices from vanishing?
- Add a status column: Sent, Overdue, Paid.
- Review it on a fixed day each week, and chase anything beyond its due date.
- Keep the invoice amount in the original currency while it is unpaid; convert only when the deposit arrives.
- Add a column for expected net in your home currency, using a conservative rate, so cash planning is realistic.
What does a bad month look like, and how do we prepare?
Foreign-currency income swings in two ways: how much work arrived, and what the currency did. A client paying in a weakening currency can feel like a pay cut even though the invoice is unchanged. Look at your last six months of effective rates and use the lowest as your planning rate. If your income was 3,626 dollars at the example rates but 3,400 at a weaker rate, plan household spending around the lower figure, and let the better months build a buffer.
Monthly close in fifteen minutes
- Match each deposit to an invoice row.
- Fill in received amounts and fees from the statement.
- Calculate effective rates and note any that look unusually low.
- List invoices still unpaid and their ages.
- Save the statement files and invoice copies in a folder named for the month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

