Shopify GST/HST bookkeeping in Canada: a complete reconciliation workflow

For a Canadian Shopify store, the tax shown on orders, the balance owed to a tax authority and the cash deposited by Shopify are related—but they are not the same number. This guide shows how to connect them without recording revenue twice or losing the tax inside a net payout.

The short answer: record sales and GST/HST from Shopify's order-based reports, move the gross payment activity through a Shopify clearing account, record fees and refunds separately, and match only the final net payout to the bank. Reconcile the sales-tax liability independently from the cash deposit.

The three numbers that must stay separate

Most Shopify bookkeeping problems become easier once three different views of the business are kept separate:

1. Storefront activity

Orders establish gross sales, discounts, returns, shipping and taxes. This is the commercial activity that occurred in the period.

2. Sales-tax liability

GST/HST collected from customers is generally a liability until it is reported and remitted. It should not disappear into revenue or payment-processing fees.

3. Processor cash

Shopify Payments combines captured payments and then subtracts fees, refunds, disputes, holds and other adjustments before sending cash to the bank.

4. Bank settlement

The bank sees only the final deposit or debit. That amount proves the processor settled cash; it does not, by itself, prove revenue or tax was recorded correctly.

Shopify explicitly distinguishes its sales reporting from its payout reconciliation report. The payout report explains funds moving through Shopify Payments, while Shopify's finance reports explain order and sales activity. Their totals can differ because they answer different questions and use different timing.

Start with the correct Canadian tax context

Before designing the bookkeeping, confirm which registrations and rates actually apply to the business. The Canada Revenue Agency says most businesses generally have to register for GST/HST when they stop qualifying as a small supplier and make taxable supplies in Canada. The common small-supplier threshold is $30,000, but the effective registration date depends on whether the threshold is crossed in a single calendar quarter or across consecutive quarters.

Registration is not simply an annual-sales switch. Associated businesses, zero-rated supplies and the timing of the sale that crosses the threshold can matter. Businesses below the threshold may also register voluntarily, which brings both filing obligations and potential access to input tax credits. Confirm the effective date with the CRA or a qualified Canadian tax professional before changing Shopify settings.

The GST/HST rate is generally driven by the place-of-supply rules. Current CRA guidance lists 5% GST for non-participating provinces, 13% HST in Ontario, 14% HST in Nova Scotia and 15% HST in the other participating provinces. Separate provincial regimes—including QST, PST and RST—may also apply. Product taxability, zero-rated goods, exemptions, delivery location and special rules can change the result.

Important: Shopify can calculate tax based on the registrations and product information entered in the store, but Shopify says the merchant remains responsible for confirming registrations, rates, filing and remittance. Software configuration does not replace tax advice.

The source reports to retain each month

A defensible month-end process begins with reports that answer different parts of the reconciliation. Use one reporting cut-off, one store time zone and one payout currency at a time.

Shopify Total sales by order: gross sales, discounts, returns, shipping, taxes and total sales by order activity.
Shopify Taxes report: tax types, rates and tax charged for the selected period.
Shopify payout reconciliation report: opening processor balance, charges, refunds, fees, adjustments, payouts and ending balance for each payout currency.
Individual payout detail: the transactions and adjustments included in each bank transfer.
Third-party gateway reports: PayPal, Stripe, buy-now-pay-later or other funds that never enter Shopify Payments.
QuickBooks reports: sales-tax liability detail, profit and loss, clearing-account activity and bank reconciliation.
Bank statement: the independent record of deposits, withdrawals and settlement dates.

Save the exports used for the close. CRA guidance requires businesses to keep records supporting GST/HST returns and input tax credit claims, including the relevant sales and purchase documentation.

A reliable Shopify-to-QuickBooks workflow

1. Validate registrations and Shopify tax settings

Confirm the legal entity, GST/HST account number, effective registration date, provinces in which the store is registered, product categories, exemptions and any manual overrides. Investigate unexpected zero-tax orders and tax collected before the registration date rather than hiding them with a journal entry.

2. Lock the reporting period

Use the same start date, end date and time zone across the Shopify sales and tax reports. Separate each presentment or payout currency. A month-end cut-off should also identify refunds initiated after month-end, payouts still in transit and processor funds still unsettled.

3. Record order activity at gross amounts

Map sales, discounts, shipping, returns and sales taxes to their intended accounts. GST/HST collected should ordinarily increase a tax liability rather than revenue. The customer payment increases the Shopify clearing account because Shopify—not the bank—holds the funds at that point.

4. Record processor activity separately

Processing fees, chargebacks, reserves, financing deductions and other payout adjustments should use clearly defined accounts. Refunds reduce the appropriate sales and tax amounts and reduce the processor balance. Shopify currently states that the original Shopify Payments credit-card processing fee is not reimbursed when a customer is refunded, so the refund and fee may not reverse symmetrically.

5. Transfer the payout from clearing to the bank

When Shopify sends a payout, move the exact net amount from the Shopify clearing account to the bank account. In the bank feed, match the downloaded deposit to that existing accounting transaction. Do not add the deposit as new revenue if the orders were already recorded.

6. Explain the clearing-account ending balance

After all payouts through month-end are matched, the clearing balance will not always be zero. It can represent captured payments not yet paid out, refunds or disputes in process, reserves, foreign-currency settlement, payout timing or a genuine error. Tie the balance to Shopify's ending processor balance and a short list of documented exceptions.

7. Reconcile the GST/HST control

Compare Shopify's tax reports with the GST/HST posted in QuickBooks. Then review the QuickBooks sales-tax liability and return-preparation reports. Intuit's Canadian sales-tax reconciliation tool compares income in the profit and loss report with sales and other revenue reported on line 101, helping identify transactions that are out of scope, blank or missing from one side of the comparison.

This control is separate from matching payouts. A bank deposit can match perfectly even when tax has been mapped to revenue, recorded twice or assigned to the wrong jurisdiction.

Worked example: why the payout is not revenue

Assume a simplified Alberta transaction with no discounts or prior-period activity:

Taxable merchandise: $1,000
GST collected at 5%: $50
Customer payment captured: $1,050
Shopify Payments fee: $29
Net bank payout: $1,021

Record the sale

Debit Shopify clearing $1,050
Credit sales revenue $1,000
Credit GST/HST payable $50

Record the fee

Debit processing fees $29
Credit Shopify clearing $29

Record the payout

Debit bank $1,021
Credit Shopify clearing $1,021

Result

Revenue is $1,000, GST payable is $50, the fee is $29, bank cash is $1,021 and the simplified clearing balance returns to zero.

If the $1,021 bank deposit were instead added as revenue, sales would be understated relative to the order in this isolated example, tax could be omitted, and the original Shopify order might also remain recorded—creating either incomplete or duplicate books. Real payouts contain many orders and adjustments, but the control logic is the same.

This example is conceptual. The account names, tax treatment of fees, timing basis and journal-entry method must be approved for the business's circumstances.

How refunds affect tax and payouts

A refund can touch three periods: the original sale date, the date the refund is issued and the date Shopify deducts the cash from a payout or bank account. Shopify's sales reports generally reflect returns and associated tax adjustments based on the order/refund activity, while Shopify Payments deducts the refund from available processor funds according to its settlement timing.

At month-end, verify that the accounting system captured both the revenue/tax reversal and the processor-side cash movement. Do not create a second sales return merely because the refund appears inside a later payout. Also review custom refunds, exchanges and refunds processed outside Shopify, because they may not carry the same line-item tax detail as an ordinary product return.

Input tax credits require their own evidence

GST/HST collected from customers is only one side of a return. A registrant may be eligible to recover GST/HST paid or payable on purchases used in commercial activities through input tax credits. CRA guidance says these claims require adequate supporting documentation, and eligibility depends on how the purchase is used.

Do not infer an input tax credit solely from a net Shopify payout. Retain the applicable Shopify fee invoices, app bills, shipping invoices and other supplier documents, and record the recoverable-tax component only when the documentation and tax treatment support it.

Common reasons Shopify tax does not match QuickBooks

The payout was recorded as sales. Net cash replaced the order-level sales and tax breakdown.
Both an app and a bank rule posted the deposit. The same activity reached QuickBooks twice through different paths.
Reports use different dates or time zones. Orders, refunds and payouts fall into different reporting periods.
Tax-inclusive pricing was mapped incorrectly. Revenue and tax were not separated consistently.
Refund tax did not follow the returned items. A custom refund or external adjustment created a different result.
Third-party processors were omitted. Shopify sales include the order, but the related PayPal or external-gateway cash is outside Shopify Payments.
Provincial taxes were combined. GST/HST, QST, PST or RST balances need the mapping required by the business's registrations and filings.
Marketplace or merchant-of-record taxes were treated as merchant cash. The platform may collect or remit an amount differently from an ordinary direct sale.
Opening balances were never established. A new connector started mid-period without accounting for unsettled processor funds.
Foreign currencies were netted together. Sales currency, presentment currency, payout currency and exchange differences were not separated.

Month-end control checklist

Confirm the Shopify store time zone, reporting period and payout currencies.
Tie gross sales, discounts, returns, shipping and taxes to the Shopify finance reports.
Review unexpected zero-tax sales, overrides and registration changes.
Tie Shopify Payments activity to the payout reconciliation report.
Match every settled payout or debit to the bank.
Explain the Shopify clearing-account ending balance.
Reconcile third-party gateways separately.
Compare Shopify tax totals with QuickBooks sales-tax detail.
Review supported input tax credits and retain the source documents.
Save the reports, exception list and reviewer sign-off with the close package.

What can be automated—and what still requires judgment

Importing transactions, mapping routine categories, creating payout deposits and matching exact bank amounts can often be automated after a clean opening balance and a validated mapping. The first complete period should be reviewed manually so every category and exception can be traced.

Registration obligations, place-of-supply determinations, product taxability, provincial tax requirements, input tax credit eligibility and filing positions still require informed professional judgment. A reliable workflow makes those decisions visible; it should not silently make them on the owner's behalf.

Want us to review your Shopify tax-to-payout workflow?

Tell us which Shopify, payment and accounting systems you use. We will identify where sales, tax or payout activity is being duplicated, omitted or left unreconciled.

Request a free payout assessment →

Official references

Reviewed August 4, 2026. This guide is general educational information and is not accounting, legal or tax advice. Rules and software features change; confirm the treatment for your business with the applicable authority and a qualified professional.