Shopify multi-currency accounting in QuickBooks Online

The short answer

A Shopify store can show prices to customers in several currencies without receiving several payout currencies. That distinction controls the accounting. Start with the currency Shopify actually sends to the bank, then identify how the customer's payment became that amount.

For many merchants, Shopify converts international customer payments into one domestic payout currency. QuickBooks can then record the Shopify payout in the same currency as the bank and preserve Shopify's actual conversion fees. The merchant should not translate the original customer amount a second time.

Advanced and Shopify Plus merchants in eligible regions can add bank accounts for Multi-Currency Payouts. In that setup, each payout currency needs its own clearing account, bank account and reconciliation. Vatteo is the clearest close workflow when the Shopify settlement currency matches the QuickBooks home currency.

Name the four currencies before touching QuickBooks

These currencies can all be USD, but do not assume they are. Write them at the top of the reconciliation. Most avoidable exchange errors begin when a report total is copied without its currency or when a customer amount is compared directly with a converted bank deposit.

QuickBooks' home currency is the reporting base for the company. A foreign-currency bank account can retain its foreign balance while QuickBooks also shows a home-currency value when multicurrency is enabled.

Choose between two Shopify payout models

Shopify currently limits Multi-Currency Payouts to eligible Advanced and Shopify Plus stores and supported regions. A merchant can sell in local currencies on other plans while still receiving only the domestic payout currency.

Do not design the chart of accounts around every currency a shopper might select. Design it around the currencies in which providers actually hold balances and pay bank accounts.

Worked example: international sale, domestic payout

A US merchant prices an order for a European customer at €100. Shopify captures the customer's payment and converts it into the store's USD payout route. The payout detail shows $108.00 of gross converted activity, $3.50 of processing fees and $1.62 of currency conversion fees. The net contribution to the USD payout is $102.88.

The merchant should record the payout components in USD using Shopify's settlement evidence. The €100 remains order evidence, but converting it again with a month-end rate would replace Shopify's actual transaction conversion with a different number.

The example isolates one order for explanation. In practice, post the approved payout summary from the full Shopify payout because several orders, refunds, adjustments and currencies can contribute to one deposit.

Do not create a second exchange rate

Shopify applies an exchange rate when a payment currency differs from the payout currency. Shopify's order timeline and payout evidence can show the historical rate and the resulting payout-currency amount.

If QuickBooks records the same transaction by taking the customer amount and applying its own daily rate, the clearing account can differ even though the provider and bank are correct. The difference came from two systems translating the same payment independently.

Choose one source for settlement conversion. For a Shopify Payments payout, use Shopify's payout-currency values to build the clearing and bank movement. Preserve customer-currency detail for order support and tax review without using it to create another settlement entry.

Record currency fees where the payout shows them

Shopify can charge currency conversion fees when a customer payment must be converted and Multi-Currency Payout fees for eligible non-domestic payout currencies. These are not the same as an unexplained accounting exchange difference.

From 6 April 2026, Shopify states that currency conversion and Multi-Currency Payout fees are calculated directly on the gross order amount. Use the fee actually reported for the payout rather than recreating it from an old formula or a remembered percentage.

Map the fee to an approved expense account and keep the provider label. A separate currency-fee subaccount can help a merchant measure the cost of international selling, but one payment-processing expense account can work when management does not need that detail.

Worked example: a true foreign-currency payout

A US merchant on an eligible plan adds a GBP payout account. During the month, Shopify records £8,000 of payout-currency activity, deducts £240 of processing and non-domestic payout fees, and transfers £7,760 to the GBP bank account.

Reconcile the GBP Shopify clearing account to the GBP payout and match £7,760 to the GBP bank deposit. QuickBooks can also show the home-currency value in USD when multicurrency is enabled, using the approved rate and its foreign-currency features.

The foreign amount must balance before translating it into USD reporting. Do not plug a home-currency difference into Shopify fees merely because the GBP settlement has changed value since it was captured.

Use QuickBooks multicurrency deliberately

QuickBooks Online can assign a currency to supported bank, customer, supplier and other accounts after multicurrency is enabled. Enabling the feature changes how the file handles currencies and should be planned with the accountant before importing payouts.

Create a foreign-currency bank account for a real bank balance held in that currency and a matching provider clearing account when the provider also settles that currency. Keep the QuickBooks home currency unchanged unless the company itself has a valid reporting reason to change systems or files.

QuickBooks home-currency adjustments can update the home value of foreign balances and report realized or unrealized gains and losses. That process is separate from proving the original Shopify payout in its own currency.

Refunds can use a different exchange rate

Shopify says a refund is processed in the original order currency but can use the current exchange rate. Shopify does not charge a conversion fee on the refund, yet the payout-currency amount can differ from the amount associated with the original sale.

That difference is not automatically a Shopify fee or a bookkeeping mistake. Preserve the original payment amount, original conversion, refund amount, refund conversion and the payout where the refund was deducted.

Apply the accountant-approved treatment for the resulting exchange difference. Do not edit the original sale until its settlement equals the later refund; doing so destroys the historical evidence for both events.

Keep chargebacks and reserves in their payout currency

Shopify can deduct a chargeback from the bank account tied to the original currency, or from the default payout account when the original currency account no longer exists. A conversion fee may apply in some cases.

Record the dispute hold, fee, reversal and final outcome from the provider evidence. A reserve is still money held within the provider route; it should not become an exchange loss merely because it has not reached the bank.

When an account was added, removed or replaced, note the effective date. Shopify warns that changing payout accounts can pause payouts, which can leave legitimate balances in transit across month end.

Separate other gateways by provider and currency

PayPal and other gateways can hold balances or convert currencies under their own rules. Their activity does not enter Shopify Payments payout reconciliation merely because the order originated in Shopify.

Use a separate clearing account for every material provider-currency pair that settles independently. A PayPal USD balance and PayPal GBP balance should not be hidden inside Shopify Payments clearing. Reconcile each provider's receipts, fees, refunds, transfers and ending balance from its own reports.

This makes the close longer only on paper. In practice, clear boundaries reduce investigation because every remaining balance has one provider and one currency.

Build a currency reconciliation pack

A reviewer should be able to follow the month without reopening every order. Save the Shopify payout reconciliation report for each payout currency, the individual payout exports, the bank statements, and a list of conversions or fees that explain material differences.

For a single-currency settlement, the pack should connect customer-currency orders to Shopify's payout-currency values and then to the bank. For a true foreign-currency payout, it should first prove the provider and bank amounts in that currency, then show the approved QuickBooks home-currency translation or adjustment.

Include refund and dispute conversions when they differ from the original payment, plus the source and date of any manual exchange rate. A screenshot of today's Shopify rate does not explain the historical rate used for a payment captured last month.

Finish with a short roll-forward for every provider-currency clearing account: opening balance, captured activity, fees, refunds, payouts and closing balance. The closing amount should agree with funds that Shopify or another provider still holds, not a plug entered to make QuickBooks balance.

• Payout reconciliation report for each Shopify payout currency
• Individual payout detail and transfer references
• Bank statement in the matching currency
• Historical conversion and fee evidence
• Refund, dispute and reserve movements
• QuickBooks foreign-balance adjustment and approval when applicable

How Vatteo protects the multi-currency close

Vatteo is the strongest fit for a Shopify Payments merchant whose settlement currency matches the QuickBooks home currency, even when customers shop in several local currencies. It uses Shopify's payout evidence, preserves the reported fees and prevents a second conversion from appearing in QuickBooks.

The close keeps sales, refunds, tax, fees, clearing and the bank deposit connected to the same payout and currency. Unexpected currency evidence becomes a blocking exception instead of being rounded into a miscellaneous gain, loss or fee.

For true Multi-Currency Payouts into foreign bank accounts, Vatteo currently stops cross-currency posting rather than guessing. That safeguard protects the books while the merchant uses an accountant-approved foreign-currency workflow for those settlements.

Month-end multi-currency checklist

• Customer, store, payout and QuickBooks home currencies are documented.
• Every payout and clearing account has one explicit currency.
• Shopify's reported conversion values are used once, not recalculated in QuickBooks.
• Processing, conversion and non-domestic payout fees follow the actual payout detail.
• Refund and dispute conversions retain their own event-date evidence.
• Foreign-currency payouts balance in the foreign currency before home-currency adjustment.
• Other payment gateways are separated by provider and settlement currency.
• Bank deposits match the correct payout account, currency and transfer reference.
• Every gain, loss or remaining balance has an approved explanation.