Splitting expenses in different currencies, explained

Splitting expenses in different currencies is where most shared spreadsheets break. Some people paid in euros, others in dirhams, and the exchange rate on the day you settle is not the one you paid at.

Record what you actually paid

Always add an expense in the currency on the receipt. Converting in your head introduces errors and makes it impossible to check later.

Choose one settlement currency

When a group has several currencies, pick one to settle in. Everyone gets a single balance instead of separate debts in each currency, which is much easier to pay.

Lock the rates

Live exchange rates move every day. Locking them when you choose the settlement currency means everyone sees the same numbers, and you can update to the latest rates when you are ready to settle.