Shopify multi-currency bookkeeping in Canada: reconcile foreign sales and payouts

Selling in USD, EUR or other currencies can make a Canadian Shopify store look profitable in one report and unreconciled in another. The solution is not to force every number into the CAD bank deposit. It is to keep the order currency, payout currency, processor balance and accounting home currency connected through a documented exchange-rate policy.

The short answer: create a separate Shopify clearing balance for each payout currency, record sales and taxes using the business's approved Canadian-dollar conversion policy, post processing and currency fees separately, transfer each net payout to the matching bank account, and revalue any foreign-currency balances at the reporting date. Never record the converted bank deposit as new revenue when the underlying orders are already in the books.

First identify the four currency layers

"The store sold in USD" is not enough information to design the bookkeeping. A multi-currency Shopify workflow can involve four different monetary views:

Customer or presentment currency

The currency shown to the customer and used to complete the order. A Canadian store might present and collect USD from a US customer.

Store and reporting currency

The primary currency used for Shopify reporting. Shopify can translate activity for reports even when the customer paid in another currency.

Shopify payout currency

The currency Shopify Payments sends to the connected bank account. It can be CAD, USD or another supported currency depending on the merchant's region, plan and banking setup.

Accounting home currency

The currency in which the accounting file presents its financial statements. For many Canadian businesses this is CAD, even when foreign bank and clearing accounts are maintained.

These currencies can be the same, but they do not have to be. A customer can pay in USD, Shopify can settle to a USD bank account, and QuickBooks can still report the transaction in CAD. Alternatively, Shopify can convert the order and pay a CAD account. The bookkeeping must follow the route that actually occurred.

Choose the payout architecture before configuring QuickBooks

Option 1: receive everything in CAD

A Canadian merchant can sell in local currencies while receiving payouts only in its domestic currency. Shopify says that when the customer pays in a currency different from the payout currency, an exchange rate and currency conversion fee apply at capture. This setup has fewer bank accounts, but the payout workflow must preserve the conversion rate and fee behind each CAD settlement.

Option 2: maintain separate CAD and USD payouts

Eligible merchants can route supported currencies to dedicated bank accounts. Shopify's current guidance says Multi-Currency Payouts require the Advanced or Shopify Plus plan, while Canadian merchants on Basic or Grow can choose USD as the default payout currency subject to Shopify's stated conditions and fees. Eligibility, supported bank locations and pricing can change, so confirm the live Shopify settings before relying on a design.

A foreign-currency payout account does not eliminate bookkeeping conversion. It may avoid converting the payout cash immediately, but the accounting system still needs a Canadian-dollar value for reporting. Shopify also states that a non-domestic payout fee can apply based on payout currency even when the customer paid and the merchant received the same foreign currency.

Decision point: choose the banking structure based on real foreign-currency cash needs, conversion costs, plan costs and accounting complexity. Do not add a USD bank account solely because the Shopify setting is available.

Build the accounting structure before importing transactions

In QuickBooks Online, confirm the home currency and whether multicurrency is appropriate before connecting Shopify. Intuit currently warns that once multicurrency is enabled it cannot be turned off and the home currency cannot be changed. It is also unavailable in QuickBooks Online EasyStart.

A controlled chart of accounts commonly includes:

Shopify clearing - CAD: processor activity expected to settle in Canadian dollars.
Shopify clearing - USD: processor activity expected to settle in US dollars.
Bank - CAD and Bank - USD: separate accounts matching the actual bank statements.
Sales, discounts, refunds and shipping: mapped according to the approved reporting policy.
Shopify processing fees: ordinary payment-processing costs.
Currency conversion fees: fees charged when Shopify converts between currencies.
Multi-Currency Payout fees: fees tied to receiving a non-domestic payout currency.
Realized and unrealized foreign-exchange gain or loss: used only according to the accounting policy approved for the business.

QuickBooks assigns one currency to most foreign-currency bank, customer, supplier and balance-sheet accounts. That is why CAD and USD clearing activity should not be netted into one undifferentiated account. Separate balances make it possible to compare each ledger amount with Shopify's currency-specific reports.

Retain the source reports that explain each layer

Run the close by payout currency, not merely by storefront. Shopify says multi-currency payout transactions are grouped and filtered by currency, and payout schedules can differ by currency.

Order and finance reports: gross sales, discounts, returns, shipping, tax and customer currency.
Payout reconciliation report: opening balance, charges, refunds, fees, adjustments, payouts and ending balance for the selected currency.
Individual payout details: the exact transactions included in each bank transfer.
Currency and fee detail: historical exchange rates and conversion or payout fees attached to the relevant orders and settlements.
Bank statements by currency: the independent evidence of CAD and foreign-currency deposits.
QuickBooks reports: clearing-account detail, foreign bank balances, profit and loss, balance sheet and any home-currency adjustment report.

The Canada Revenue Agency says computerized and e-commerce records must remain organized and preserve the sequence of business transactions. Save the reports used for the close rather than relying on a dashboard that can change after refunds, disputes or software updates.

A reliable multi-currency reconciliation workflow

1. Establish the opening balances

Choose a clean implementation date. For every payout currency, document Shopify's unsettled processor balance, the corresponding clearing-account balance and any payouts already in transit. If the connector begins after sales have occurred but before their payouts arrive, the opening entry must account for those funds.

2. Record the underlying order activity

Record gross sales, discounts, returns, shipping and tax before recording the payout. Use the conversion method approved for the business, and keep the source foreign-currency amount and applied rate traceable. For Canadian GST/HST purposes, CRA Memorandum 3-6 describes acceptable conversion dates and sources and stresses consistent use of the chosen method for a reasonable period.

3. Post Shopify Payments activity by currency

Charges increase the relevant Shopify clearing balance. Refunds, disputes, processing fees, conversion fees and payout fees reduce or reclassify that balance according to their nature. Do not combine a processing fee and an exchange-rate difference merely because both reduce the cash received.

4. Record the payout as a transfer

Move the exact payout amount from the currency-specific Shopify clearing account to the matching bank account. If Shopify paid USD 9,160 to the USD bank, the USD clearing transfer is USD 9,160. QuickBooks also stores the home-currency equivalent; that conversion does not turn the payout into additional revenue.

5. Match the bank deposit

Match the downloaded bank transaction to the existing payout transfer. If the bank received CAD after a processor conversion, use the settlement detail to explain the CAD amount. Do not alter the original sales amount until the deposit happens to match.

6. Reconcile the ending processor balance

For each currency, the clearing-account ending balance should agree with Shopify's remaining unsettled activity after known timing differences. A single net zero across CAD and USD is not sufficient: one currency can be overstated while the other is understated.

7. Review foreign monetary balances at month-end

Foreign-currency bank, receivable, payable or clearing balances can have a different Canadian-dollar value at month-end than when the transactions were first recorded. Intuit's home-currency adjustment feature can recalculate the home-currency value of eligible foreign balances and report realized or unrealized gains and losses. Have the accountant approve the accounts, date and rate before posting a revaluation.

Worked example: a USD payout for a Canadian store

Assume a Canadian merchant has a USD payout account and the following simplified Shopify Payments activity. Tax is excluded so the example can focus on payout mechanics:

Gross customer payments: USD 10,000
Refunds: USD 400
Shopify Payments processing fees: USD 290
Multi-Currency Payout fee: USD 150
Net payout to the USD bank: USD 9,160

Processor reconciliation in USD

USD 10,000 - USD 400 - USD 290 - USD 150 = USD 9,160. The payout should clear the same USD amount from Shopify clearing to the USD bank.

Financial reporting in CAD

Each component also needs a Canadian-dollar value under the business's approved conversion policy. The CAD values may not equal the payout multiplied by one convenient month-end rate.

Bank matching

The USD bank deposit is matched as a transfer, not sales. A later bank conversion from USD to CAD is a separate transaction with its own rate and possible bank fee.

Month-end balance

If USD funds remain in the bank or clearing account, review whether the Canadian-dollar carrying value requires a home-currency adjustment.

This example is illustrative, not a Shopify fee quote or accounting entry for a specific business. Shopify plan fees, tax treatment, recognition timing and exchange-rate policy must be confirmed using the merchant's actual reports and professional advice.

Account for Shopify's April 2026 fee-calculation change

Shopify changed how currency conversion fees and Multi-Currency Payout fees are calculated on April 6, 2026. Its current guidance says these fees are calculated directly on the gross order amount. Earlier periods used a formula based on the amount after Shopify Payments fees.

This can create small differences when comparing a 2026 payout with an older template, spreadsheet or connector rule. Keep the historical fee detail and effective date. Do not force the difference into processing fees or foreign-exchange gain or loss without confirming what Shopify actually charged.

Refunds and chargebacks create cross-period currency differences

Shopify says refunds are processed in the original order currency. When the merchant does not have a bank account for that currency, the refund can be deducted from the default payout account. Shopify also notes that refunds use the current exchange rate and do not receive the original conversion fee back.

Chargebacks follow the original order currency, but they can also reach the default account when no matching payout account exists. At month-end, connect the commercial event, processor deduction, currency conversion and bank movement. A refund initiated in July and deducted from an August CAD payout should not become a second August sales return if the order activity was already recorded correctly.

Keep GST/HST conversion policy separate from payout conversion

The rate Shopify uses to convert settlement cash is not automatically the rate the business should use for every Canadian tax or financial-reporting purpose. CRA Memorandum 3-6 says foreign-currency consideration for GST/HST can be converted using specified dates and acceptable sources, including an actual conversion source, a Canadian chartered bank or the Bank of Canada. The selected source and method must be documented and used consistently.

Bank of Canada daily, monthly and annual averages are available as reference data, but choosing the appropriate rate and date is an accounting and tax-policy decision. Review the policy with a qualified professional, especially when orders, captures, refunds and payouts fall in different reporting periods. For the complete tax-to-payout control, see the Shopify GST/HST bookkeeping guide.

Common multi-currency failure modes

CAD and USD share one clearing account. Opposite errors can net together and hide the currency that is actually unreconciled.
The bank deposit is recorded as sales. The same orders can be recognized through Shopify and again when the payout arrives.
One exchange rate is applied to the whole month. That may conflict with the business's approved policy or obscure actual conversion fees.
Conversion fees are treated as exchange losses. A separately charged fee and a rate-driven gain or loss are economically different items.
Refunds are converted using the original sale rate. The processor can settle them using a later rate and in a different payout period.
A USD bank transfer creates new revenue. Moving already-recorded USD cash into CAD is a bank conversion, not another customer sale.
QuickBooks multicurrency is enabled without a design. Intuit warns that the feature cannot simply be turned off later.
Only settled payouts are reviewed. Unsettled processor funds and foreign balances remain unexplained at month-end.

If the books already contain these symptoms, use the free payout mismatch diagnostic before adding another automatic rule. The broader Shopify payout troubleshooting guide can help separate timing, duplication and opening-balance problems.

Month-end checklist for Canadian multi-currency stores

Confirm the store currency, customer currencies, payout currencies, bank-account currencies and accounting home currency.
Save Shopify order, finance, payout reconciliation and individual payout reports by currency.
Tie gross sales, discounts, refunds, shipping and tax to the order-level reports.
Post processing, conversion and non-domestic payout fees to their approved accounts.
Match every CAD and foreign-currency payout to its bank account.
Reconcile each Shopify clearing account independently.
Explain refunds, disputes, holds and payouts that cross the period end.
Review foreign bank and clearing balances for an approved home-currency adjustment.
Confirm that the GST/HST conversion method and source were applied consistently.
Retain the exchange-rate evidence, exception list and reviewer sign-off with the close package.

This currency-specific close fits inside the broader e-commerce month-end checklist. If Shopify and QuickBooks are not yet connected cleanly, start with the Shopify and QuickBooks reconciliation workflow.

What can be automated, and what still needs judgment

Importing currency-tagged transactions, mapping routine fees, creating payout transfers and matching exact deposits can often be automated after a clean opening balance and one validated period. Exception rules can also flag missing currencies, unusual fee types, cross-period refunds and balances outside tolerance.

The reporting currency, conversion method, GST/HST treatment, revaluation date, gain-or-loss classification and decision to maintain foreign bank accounts still require informed judgment. Automation should apply an approved policy consistently; it should not invent that policy.

Want a clean workflow for CAD and foreign-currency payouts?

Run the free diagnostic or request an assessment. LZ Financial can map the currencies, clearing accounts, fees, bank transfers and month-end exceptions before routine activity is automated.

Run the free payout diagnostic →

Official references

Reviewed August 10, 2026. This guide provides general educational information, not accounting, legal or tax advice. Platform features, plan eligibility, fees and government guidance can change. Confirm current settings and obtain professional advice for the treatment used by your business.