Fix guide
Shopify multi-currency orders wrong in QuickBooks
You sell in more than one currency, and the foreign-currency orders are the ones that don't tie out: posted at amounts that differ from the order, posted in the wrong currency, or absent from QuickBooks entirely. Orders in a second currency are a known sync edge case - like gift-card tenders, they route differently through many pipes and sometimes fall out altogether.
The root complication is that a multi-currency order has several defensible values: the presentment amount the customer paid, the store-currency amount Shopify converts it to, and the settled amount after the processor's conversion and fees. A sync, QuickBooks, and your bank can each pick a different one - all individually reasonable, collectively irreconcilable unless you know which value posts where.
Small scattered differences concentrated on foreign-currency orders are conversion-point noise. Missing foreign-currency orders are drop-outs. The checks below separate the two.
The symptoms
- Foreign-currency orders post at amounts that don't match either the presentment or store-currency value
- Some foreign-currency orders never arrive in QBO while domestic orders sync fine
- Small per-order differences that cluster on international orders only
- Payout reconciliation differences that grow in months with more international sales
Why it happens
Conversion at different points
Shopify converts at order time at one rate; the processor settles at another; QBO's multicurrency feature may revalue at its own rate. A sync posting the presentment amount into a store-currency QBO account (or vice versa) produces persistent small mismatches that are conversion artifacts, not lost money - but you can't call them harmless until you've verified which value posts where.
Drop-outs on the foreign-currency path
Syncs exercise their multi-currency code path far less than the domestic one. Orders in a second currency dropping out of the sync entirely is a reported failure shape - the order exists in Shopify, converts fine, and simply never posts.
QBO multicurrency settings
If QBO's multicurrency is off, everything must arrive pre-converted to home currency; if it's on, the sync must post the right currency to the right account. A mismatch between what the sync sends and what QBO expects mangles amounts silently.
How to check and fix it by hand
- 01
Verify a sample against all three values
Take five foreign-currency orders. For each, note the presentment amount, Shopify's store-currency amount, and what QBO recorded. Which value QBO matches (or fails to match) tells you where conversion is happening - and whether the sync and QBO agree on whose job it is.
- 02
Count foreign-currency orders on both sides
Filter a settled month's Shopify orders to non-store currencies and count; count the same orders in QBO. A count gap means drop-outs, which are missing revenue and missing tax - a different problem from conversion noise.
- 03
Reconcile through the payout
For one payout containing international orders, check that the settled amounts (after conversion and fees) tie to the deposit. Conversion differences that net out at the payout level are timing/rate artifacts; residuals that persist are real findings.
- 04
Record drop-outs; document conversion policy
Missing orders get recorded at your books' policy rate with tax handled per jurisdiction - your accountant should bless the currency treatment once, in writing, so corrections are consistent. A line-by-line diff finds the drop-outs for you: LedgerClear's free scan compares by order ID, so foreign-currency orders that never posted surface immediately, read-only.
Common questions
- Why don't my international Shopify orders match QuickBooks?
- Conversion happens at up to three points - order time, processor settlement, and QBO revaluation - and each can use a different rate. Verify which value your sync posts before treating small differences as errors; consistent absence of foreign-currency orders is the real red flag.
- Are small differences on foreign-currency orders normal?
- Rate-timing differences of a fraction of a percent are expected and typically net out through the payout. Differences that equal the whole conversion, or orders missing entirely, are findings that need correcting.
- Does LedgerClear handle multi-currency stores?
- The scan matches orders by ID, so foreign-currency orders that dropped out of your sync surface as missing regardless of currency, and amount comparisons show both sides so conversion-point differences are visible rather than hidden. It's read-only and free to run.
LedgerClear doesn’t replace your sync. It audits per-order syncs today - the official connector and Synder. Summary-posting tools like A2X and Link My Books: auditing support is coming later, and LedgerClear runs alongside them without touching their entries. If the right answer for you is switching tools, the scan report is the damage report to migrate with.