Bookkeeping for Claude, ChatGPT and other AI apps.

Recording Shopify Sales And Payouts In Solarium

A Shopify payout is your orders minus fees and refunds. Here is how to book Shopify sales, tax and fees in Canada, and what Solarium does with your store.

Solarium How-Tos Updated Facts Checked

What It Is

When a customer checks out on your Shopify store with Shopify Payments, Shopify collects the money, keeps its processing fee, and sends the rest to your bank in a payout. One payout can hold dozens of orders, a refund or two, and an adjustment. So the deposit you see at the bank is not your sales. Recording Shopify properly means booking what customers actually bought, the sales tax you collected for the government, and the fees Shopify kept, then matching the payout to the deposit. Solarium gives you the pieces to do that cleanly.

Key Rules

Shopify Payments online card rates in Canada, from Shopify’s Canadian pricing page today:

PlanOnline Card RateFee If You Use Another Payment Provider
Basic2.8% + 30¢ CAD2%
Grow2.6% + 30¢ CAD1%
Advanced2.4% + 30¢ CAD0.6%

The last column is Shopify’s third-party transaction fee, which applies when you take payments through another provider instead of Shopify Payments.

How payouts work in Canada:

  • Funds from orders paid with Shopify Payments go to your payout bank account.
  • The minimum settlement time in Canada is 3 days. There is no minimum payout amount.
  • Each payout’s details show a breakdown of charges, refunds, adjustments, fees, reserves and retried payouts, plus the orders inside it.
  • You can export payout transactions to CSV from Finance, then Payouts. Each row has the amount, the fee and the net.

Tax rules that affect the entry:

  • If you are registered for GST/HST, the CRA’s rule for goods is simple. When you deliver goods to a customer, the sale is made in the province you deliver to, so that province’s rate applies. See place of supply.
  • The rates differ a lot. Ontario HST is 13%. Nova Scotia HST is 14%. Alberta and British Columbia are 5% GST.
  • Tax you collect is a liability you owe, not income.

A Worked Example

Fernhill Candle Co. is a made-up candle shop in Hamilton, Ontario, on the Basic plan. All of this week’s 50 orders ship within Ontario. Customers paid:

  • Candles: $2,000.00
  • HST at 13%: $2,000.00 × 13% = $260.00
  • Total paid: $2,260.00

Step 1: Shopify’s fees. The payout export shows the fee on each order. On the Basic plan’s online rate, the 50 orders work out to:

  • $2,260.00 × 2.8% = $63.28
  • 50 orders × $0.30 = $15.00
  • Total fees: $63.28 + $15.00 = $78.28

Step 2: The payout. $2,260.00 − $78.28 = $2,181.72 lands in chequing.

Step 3: Book one balanced entry for the payout.

AccountDebitCredit
Chequing (the payout)$2,181.72
Merchant Fees$78.28
Sales$2,000.00
HST Payable$260.00
Totals$2,260.00$2,260.00

If Fernhill booked the $2,181.72 deposit as sales, it would overstate sales by $181.72, leave $260.00 of HST off its books, and lose $78.28 of fees it can deduct. If the week had a refund, it would come off sales and HST in the same entry, and the payout would be smaller by that amount.

Common Mistakes

  • Booking the payout as sales. The deposit is net of fees and refunds. Sales and tax are based on what customers paid.
  • Using one tax rate for every order. A Shopify store often ships across Canada. The rate follows the delivery province, so an Ontario store doesn’t charge 13% everywhere.
  • Booking orders from one place and payouts from another. If orders already sit in your books from an app or a sync, booking the payout as sales counts them twice. Pick one source for sales and treat the payout as cash arriving.
  • Forgetting Shopify’s other charges. Your monthly plan, apps and shipping labels are separate bills from Shopify. They are expenses too. Check each bill for GST/HST before you claim it.
  • Never matching payouts to deposits. Every payout should equal one bank deposit. See bank reconciliation.

How Solarium Handles It

Here is what Solarium does with Shopify today, and what it doesn’t:

  • Payouts arrive through your bank feed. Connect your bank and each Shopify deposit comes into Solarium for review. See bank feeds.
  • Your AI books the gross-to-net entry. Ask your AI in Claude or ChatGPT, connected to Solarium, to book a payout or a whole month of Shopify as sales, discounts, returns, shipping, tax and fees. Solarium previews the lines, checks that debits equal credits, and posts one balanced journal entry when you confirm. If you use QuickBooks, the entry goes there too.
  • Your Shopify export is kept. Hand your AI a Shopify CSV or XLSX export and Solarium stores it with your documents for the Solarium team. It isn’t read as a receipt or booked on its own.
  • Shopify connects for reading. In Settings, you can connect your store so Solarium can read your orders and products, with read-only access. Solarium doesn’t turn those orders into entries yet.
  • Your Shopify bills are receipts. Forward the monthly Shopify invoice to your Solarium receipts address, and it’s read and matched to the card charge like any other receipt. See receipts by email and text.

Would you rather not do any of it? On the Done For You plan, the Solarium team books your Shopify payouts and keeps your books reconciled. Compare plans on the pricing page.

Common Questions

Is My Shopify Payout The Same As My Sales? +

No. A payout is a batch of orders minus Shopify's fees, refunds and adjustments. Your sales are the full order amounts before tax. Book the payout as money arriving, and book sales, tax and fees separately.

How Long Do Shopify Payouts Take In Canada? +

Shopify's help centre says the minimum settlement time in Canada is 3 days, and there is no minimum payout amount. Your bank may take extra time to show the deposit.

Where Do I Find What Is Inside A Shopify Payout? +

In Shopify, go to Finance, then Payouts, and open the payout. It breaks down charges, refunds, adjustments, fees and reserves. You can export the transactions to a CSV with the amount, fee and net of each one.

Does Solarium Book My Shopify Orders Automatically? +

Not yet. You can connect your store so Solarium can read your orders and products, but orders aren't turned into entries on their own. Payouts arrive through your bank feed, and your AI can book a period's sales, tax and fees as one balanced entry.

Sources

Solarium checks every rate, threshold and deadline in this entry against the official sources above. This is general information. Solarium and Maple Ventures Core Inc. do not provide tax advice for your situation.

Let Solarium Keep Your Books

Connect your bank, text your receipts, and Solarium sorts the GST/HST for you. Start free with self-serve, or let the Solarium team close your books daily.