Ecommerce Multi-Currency & FX: Settlement, Remeasurement & Margin Integrity
Handle multi-currency ecommerce the right way: settle in payout currency, remeasure FX at month-end, and protect margins. CPA-reviewed bookkeeping in QuickBooks or Xero
Selling cross-border is great, until FX noise buries your real margins. Our ecommerce bookkeeping workflow separates operational settlement from accounting remeasurement so Shopify, Amazon, Stripe, and PayPal deposits land cleanly and your P&L reflects economics, not exchange swings. We reconcile each payout in its settlement currency, map gross → fees → refunds/chargebacks ± reserves = net deposit, and tie it to the bank. Then, at month-end, we post a CPA-reviewed FX remeasurement so monetary balances (cash, AR, reserves) reflect period-end rates, without distorting channel margins or COGS timing. Inventory costing (landed cost) and revenue remain in operating currency; FX gains/losses are isolated to dedicated accounts. You get a consistent margin by channel, a transparent FX roll-forward, and lender-ready statements, no spreadsheet gymnastics.
Settlement vs Remeasurement
-
Settlement (operational): recognize deposits/fees at payout rate; one payout = one bank line - Remeasurement (accounting): period-end FX adjusts monetary balances only; post to FX gain/loss accounts
-
Translation (if applicable): consolidated reporting for foreign subs handled outside channel ledgers
Channel Playbooks
Shopify/Stripe
Payouts often arrive in store currency; gateways may settle in a different currency → book at settlement rate; isolate gateway FX fees
Amazon
Settlements can be batched/converted by Amazon → book the statement rate; keep reserve balances by currency and remeasure monthly
PayPal
Multi-currency wallets → remeasure wallet balances at month-end; book conversion fees separately from FX gain/loss
Inventory & COGS with FX
- Landed cost (freight/duty) is capitalized in functional currency; conversion fees recorded to landed-cost adjustments
- Item-level or periodic COGS posted in functional currency; do not remeasure historical COGS
Month-End FX Checklist
- Reconcile payouts by settlement currency; Undeposited Funds = 0
- Identify monetary balances per currency (cash, AR, reserves, gateway holds)
- Apply period-end rates; post FX remeasurement entries with memos (rate source, IDs)
- Validate FX gain/loss to prior month roll-forward
- CPA review → variance note → period-lock guidance
Reports You’ll Trust
- FX roll-forward: Beginning Balance (by currency) + Conversions – Settlements ± Remeasurement = Ending
- Channel margins (pre-FX) + FX impact disclosure
- Gateway fee/FX fee dashboards with effective rates
Frequently Asked Questions
We book sales/fees at settlement rate and isolate FX remeasurement to dedicated gain/loss accounts. Margins are analyzed pre-FX, with FX disclosed separately.
Yes, each payout is booked in settlement currency, wallets are remeasured, and consolidated reporting is prepared in functional currency.
We track reserves by currency on the balance sheet and remeasure them monthly; releases are recognized at the payout rate.
Yes, one-time cleanup restates monetary balances, isolates FX, and re-bases margin reporting going forward.
Explore
- Map Shopify payouts and fees in settlement currency.
- Fix Amazon settlements and reserves with clean FX treatment.
- Stabilize inventory & COGS timing, then isolate FX.
- Run all channels under one close calendar.
- See full Ecommerce Bookkeeping services.
- Need historical repairs first? QuickBooks Cleanup.