A remote worker who pays in several currencies can keep clean books with three habits: choose one home currency for reports, record each expense in the currency it was actually charged, and log the rate on the day. Add a column that separates client-related costs from personal ones, and you can answer what did that project cost me without redoing any maths.
What does one row need to contain?
| Field | Example (made up) | Why |
|---|---|---|
| Date | 12 Nov | Ties to the statement |
| Paid amount | €48.00 | Exactly as charged |
| Currency | EUR | Never infer from the symbol |
| Rate to home | 1.08 dollars per euro | Fixed on that day |
| Home amount | $51.84 | The one you total |
| Purpose | Coworking day pass | What it was for |
| Type | Work or Personal | Keeps costs apart |
| Paid with | Card A | Reconciles to a statement |
The rate here is a made-up figure to show the method. Use what your card or provider actually applied, which you can usually see on the statement or in the app. 48 times 1.08 is $51.84.
Where do I get the rate?
- The card or bank statement often shows the converted amount. Divide it by the original amount to get the rate that was effectively used.
- If you hold balances in several currencies, use the rate shown by the provider when you converted.
- For payments in the same currency as your home account, the rate is 1.
- Use the same method each time so the sheet stays consistent.
What happens when currencies move?
Old rows must not change. If you store the rate on each row, a later swing leaves earlier months untouched. A sheet that applies today's rate to everything quietly rewrites the past. Say you spent €300 in March at 1.05 ($315.00) and again €300 in September at 1.10 ($330.00). Both are €300, but the home amounts differ by $15.00, and that difference is real cost.
How do I keep client costs separate?
- Add a Project column and a Type column.
- Use one card for work spending if possible, so a statement matches your records.
- Keep receipts for work items together by project.
- At month end, use =SUMIFS($F$2:$F$500,$G$2:$G$500,"Work",$H$2:$H$500,"Project A") to total a project in home currency.
- Check that Work plus Personal equals the sum of all rows.
Is there a tool with this built in?
SpendixAI allows each expense to be in its own currency, with totals in a base currency using the rate saved with the transaction, and a Foreign-currency spend report. It is built for India, so its base currency is INR and its other features are not set up for US banks. If you mostly work in dollars, the sheet method above is the better match.
Monthly check
- Every row has a currency and a rate.
- Home totals match the statements after conversion.
- Work and personal are separated.
- Recurring foreign subscriptions are on a list.
What about fees and subscriptions in foreign currency?
Software charged in another currency can differ month to month even at a fixed price, because the conversion changes. Give those recurring lines a Recurring tag and compare the home amount each month. If a €20.00 plan came to $21.60 one month and $22.40 the next, the plan did not get dearer; the rate moved by $0.80. Seeing that in the sheet stops you from cancelling something that did not change.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

