How do I handle multiple currencies in ecommerce accounting?
Selling in GBP, EUR and USD means FX gains and losses, settlements landing in a currency your books were not set up to expect, and VAT that has to be right per currency. A Shopify-plus-spreadsheet stack cannot reconcile that cleanly. What you need is multi-currency handled natively in the accounting backend, not bolted on afterwards.
Why multiple currencies make reconciliation harder, not just bigger
FX gains and losses go untracked
A sale in EUR converted to GBP at checkout, then settled days later at a different rate, creates an FX gain or loss that most bookkeeping setups never actually record.
Payouts land in a currency spreadsheets do not expect
A payout arriving in EUR or USD against sales your accounts recorded in GBP is a reconciliation problem before you even get to fees and timing.
VAT still has to be right, per currency
Each currency of sale can carry its own VAT treatment and reporting requirement, and a single-currency accounting setup was never built to keep them straight.
Shopify plus spreadsheets was never built for this
A storefront reporting in one display currency, bookkeeping software expecting one base currency, and multiple real settlement currencies do not reconcile themselves.
Every sale booked in its own currency, reconciled to its own payout.
Each sale is recorded in the currency it was actually made in, converted at the correct rate, with FX gain or loss calculated automatically rather than estimated at month end. When a payout lands in EUR or USD, it is matched back to the exact orders it covers, in the currency they were sold in, not forced into a single base currency and hoped to balance.
Odoo handles multi-currency as a native feature, not a workaround
We build your accounting on Odoo, the open-source commerce ERP, which records each sale in its transaction currency and calculates FX gain and loss automatically as payouts settle. Combined with connectors we build and maintain ourselves across your storefronts and payment processors, multi-currency reconciliation is a match the system already made, not a spreadsheet exercise your finance team repeats every period.
This is the same discipline behind our EU delivery work and the EDI pipeline we built and run, processing thousands of invoices a day and saving roughly €1 million a year by replacing licensed middleware. Getting financial documents right in the currency they were issued in is the whole point of both.
See how the pieces fit
Sell into the EU from the UK
The wider EU trading problem multi-currency accounting sits inside.
Why don't my Shopify sales match my accounts?
The general reconciliation problem, before currency is even added.
Packaged commerce build
One system for your operation, from £20,000, live in 8 to 10 weeks.
Is it specifically the payout matching that hurts? See how to reconcile Shopify, Stripe and PayPal payouts →
Ready to fix your ops?
Book a free discovery call. We'll look at your current setup and tell you honestly whether Odoo is the right move and what it would involve.