Business

Quarterly Expense Summaries for Freelancers (Europe Edition)

Freelancers paid in several currencies can keep a clean quarterly expense summary in euros. Template, worked example and a habit for handling exchange rates.

Editorial illustration for Quarterly Expense Summaries for Freelancers (Europe Edition)

If you invoice clients in more than one currency, your quarterly summary needs one extra column: the exchange rate you used. Record each payment in its original currency, convert it to euros at a rate you note down, and total everything in euros at the end. What your tax office expects for rates, categories and deadlines is a question for your accountant.

Why currency makes summaries messy

A payment of 1,000 US dollars is a different number of euros every week. If you convert later from memory, you will get a different total from the one your bank showed when the money arrived. Fixing this means choosing one method and applying it consistently.

Pick a conversion rule and write it down

  • Use the rate your bank or payment platform actually applied on the day money arrived, or
  • use one published daily rate for the date of each transaction, from a source you name in your notes.

Either is fine as a record-keeping approach as long as you use the same one throughout the quarter. Ask your accountant which they prefer.

A worked example with two currencies

Say a client pays 1,000 US dollars and your bank credits €920.00 on that day. Another pays €1,500 directly. A third pays 800 British pounds, credited as €935.20. For the quarter these three give income of €920.00 plus €1,500.00 plus €935.20, which equals €3,355.20.

PaymentOriginalEuro creditedRate note
Client A1,000 USD€920.00Bank rate on arrival
Client B€1,500€1,500.00No conversion
Client C800 GBP€935.20Bank rate on arrival

Now costs: software €240, a co-working pass €180, and a course priced at 150 US dollars that cost you €138.50 on your card. Total costs are €240 plus €180 plus €138.50, which is €558.50. Net for the quarter, before any treatment your accountant applies, is €3,355.20 minus €558.50, which is €2,796.70.

How do I set up the sheet?

  1. Columns: date, description, original currency, original amount, euro amount, category, document reference.
  2. Fill the euro amount from the bank or card record, not from a conversion you do afterwards.
  3. Add a quarter column, so a filter can pull one quarter at a time.
  4. At quarter end, total income and each cost category in euros.
  5. Keep a second tab with the rate rule you chose.

What to keep alongside the sheet

  • Invoices you issued, with the invoice currency visible.
  • The matching bank statement lines.
  • Receipts for costs, in the original currency.
  • A one-page note on how you convert.

What if a client pays in instalments?

Record each instalment on its own row, with its own date and euro amount, and tie them together through the invoice number. Do not combine them into one line at an average rate. If one instalment is converted at a better rate than another, that is simply how the money arrived. Keeping them separate makes your totals match your bank and removes the need to explain differences later to your accountant.

At the end of the quarter, add a small check line: total euro income from the sheet against total euro credits on the bank statement. They should agree to the cent. If they differ, look first for a payment platform fee taken before the money reached your account, since that is the most common reason the two numbers drift apart. Record that fee as its own cost line rather than hiding it inside income.

When a tracker helps with multiple currencies

SpendixAI lets each expense carry its own currency and totals in a base currency using the rate saved with each transaction, but it is built around India and INR, so it is not designed for a euro-based freelancer. The idea is still worth copying in a sheet: save the rate with each row, and never recalculate old rows with a new rate.

SPENDIXAI JOURNAL

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

Explore your reports