When clients pay in currencies other than the euro, the question is which euro figure you treat as the truth: the amount your bank actually credited, or a converted value at the invoice date. Pick one convention, write it at the top of your sheet, and apply it to every row. Mixing the two is how totals stop adding up.
Which euro figure should I record?
There are two honest options, and each suits a different kind of freelancer.
- Credited amount: the euros that reached your account. Simple, matches your bank statement, and needs no rate lookup. Best if you are paid through one account and want to reconcile to the cent.
- Value at invoice date: the invoiced amount converted into euros at a rate you record for the day you issued the invoice. Useful if you want your income figures tied to billing rather than banking, but it creates a gap between what you booked and what arrived.
A software developer in Lisbon invoicing a US client $3,000 and a UK client £1,200 would see the difference clearly. If the dollar invoice converts to €2,760 at invoice date and €2,715 lands in the account, the credited-amount method books €2,715 and the invoice-date method books €2,760 with a €45 difference to explain. Neither is wrong, but the second needs a place for the difference.
How do I structure the sheet for the credited-amount method?
| Column | What goes in it | Example |
|---|---|---|
| A | Date credited | 14 May |
| B | Client | Studio in New York |
| C | Invoice currency | USD |
| D | Amount invoiced | 3,000.00 |
| E | Euros credited | €2,715.00 |
| F | Invoice reference | INV-2026-018 |
Totals by month come from =SUMIFS($E$2:$E$500, $A$2:$A$500, ">="&DATE(2026,5,1), $A$2:$A$500, "<"&DATE(2026,6,1)). Using "less than the first of next month" avoids missing a payment that arrives late on the last day.
What if I use the invoice-date method?
Add two more columns: the rate you used, and the euro value at invoice date. Then add a final column for the difference between that value and the euros credited. Over a year, the sum of the difference column is a rough measure of how much conversion moved against or in your favour. If the first invoice is worth €2,760 and €2,715 landed, the difference is -€45. A second invoice worth €1,404 at invoice date that lands as €1,420 gives +€16. Net across both: -€29.
Keep the source of each rate in a notes column, such as "rate shown on my invoice template" or "rate from my payment provider's statement". You will thank yourself when your accountant asks where it came from.
How do I avoid double-counting?
The classic mistake is booking an invoice when it is sent and again when the money arrives. Use a single list with a status column: Sent, Paid, Overdue. A row is income only when its status is Paid, and the totals formula can filter on that: =SUMIFS($E$2:$E$500, $G$2:$G$500, "Paid"). Everything with another status is a receivable, not income yet, and belongs in its own tally.
When does it make sense to use an expense tracker instead?
A sheet suits a few invoices a month. If you also want your costs, such as a co-working desk, software and train tickets, tracked in the same place, an app can reduce copying. SpendixAI lets each expense keep its own currency and reports totals in a chosen base currency using the rate saved on each transaction. It is built around India and INR, so we cannot promise it fits a European workflow; look at what it does and decide.
Month-end checklist
- Total the credited euros for the month and match them to the bank's foreign-receipt lines.
- List invoices still unpaid with their currency, so you can see exposure to each one.
- Check that every row has an invoice reference.
- Write the convention you used at the top of the sheet.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
