Three years ago, I lost roughly $2,400 to bad exchange rates and missed receipts. I was freelancing for clients in the US, UK, and Singapore, and my “system” was a messy spreadsheet with color-coded tabs. It didn’t work. Here’s what does.
The problem nobody warns you about
!Lodge, Thingwall House – geograph.org.uk – 37397
*Photo by Sue Adair on Wikimedia Commons*
When you work with international clients, expenses don’t come in one currency. A SaaS subscription bills in USD. A co-working space in London charges GBP. Your phone plan is in SGD. And every month, you’re supposed to make sense of all of it for taxes, invoicing, and your own sanity.
Most advice online assumes you’re dealing with a single currency. That’s fine if you work locally. But if you’re a contractor billing clients across borders, you need a system that handles three (or more) currencies without turning expense tracking into a part-time job.
How I set up my tracking system
I use a three-layer approach: capture, convert, categorize.
Layer 1: Capture everything in the original currency
I never convert at the point of entry. If I spend £45 on a train ticket, it goes into my tracker as £45, not whatever that equals in USD that day. This matters because exchange rates fluctuate, and converting at the point of entry creates phantom gains and losses that make your books messy.
My tool of choice is a business account from Reap. It holds multiple currencies in one place, so I can see my USD, GBP, and SGD balances side by side. Every transaction shows up with the original amount and the merchant details, which saves me from manually logging most expenses.
For cash expenses or anything that doesn’t go through the card, I snap a receipt with my phone and add it to a simple Google Form I built. The responses dump into a spreadsheet automatically. Takes about 15 seconds per receipt.
Layer 2: Convert at a fixed monthly rate
Here’s the trick that saved me hours of reconciliation. At the start of each month, I pick a single exchange rate for each currency pair and use it for all conversions that month. I pull the rates from XE.com on the first business day.
This isn’t perfectly accurate, but it’s close enough for expense tracking and way better than converting each transaction individually. My accountant confirmed this approach works for tax purposes in most jurisdictions, though you should check with yours.
The fixed-rate approach means I can build formulas in my spreadsheet that auto-convert everything. No manual math, no rounding errors from doing it differently each time.
Layer 3: Categorize once, review monthly
I use seven expense categories: software, travel, equipment, professional services, marketing, office, and other. Every expense gets tagged once when I enter it. At the end of each month, I spend about 20 minutes reviewing the totals.
The monthly review is where I catch things. Last month I noticed my software subscriptions had crept up to $340/month because I’d forgotten to cancel a trial. That one review saved me $29/month going forward.
The spreadsheet setup
My tracker has five columns: date, description, amount, currency, and category. That’s it. I added a sixth column for “receipt link” that points to a folder in Google Drive where I store photos of physical receipts.
On a second tab, I have a summary that pulls the monthly totals by category, converted to my home currency using the fixed rates. Conditional formatting highlights any category that’s over budget in red. Simple, visual, takes five seconds to scan.
I’ve tried fancier tools like Expensify and FreshBooks. They work, but they either don’t handle multi-currency well or they cost more than I want to spend. A spreadsheet with the right structure does 90% of what I need.
What I’d do differently
!Now that’s what I’d call a beach^ – geograph.org.uk – 1868158
*Photo by Des Colhoun on Wikimedia Commons*
If I were starting over, I’d set up the system before landing my first international client. The first three months of scrambling to organize retroactively cost me more time than a year of proper tracking.
I’d also get a multi-currency business account from day one. Using personal bank accounts for business expenses across currencies creates a nightmare at tax time. The fees alone from converting through a regular bank add up fast. According to Wise, the average bank markup on currency conversion is 3-5%, which on $50,000 in annual expenses means $1,500 to $2,500 lost to fees.
The bottom line
Multi-currency expense tracking doesn’t have to be complicated. Capture in the original currency, convert at a fixed monthly rate, and categorize consistently. Use a multi-currency account as your hub so most transactions are captured automatically. Review monthly, not quarterly.
The system takes about 30 minutes a month to maintain. That’s a fair trade for knowing exactly where your money goes across every currency you work in.