Multi-Channel Reconciliation: Amazon, Shopify, and Walmart
Three platforms, three payout schedules, three fee structures. Here is how to reconcile each deposit to actual revenue, fees, and tax collected.
Running three sales channels means three separate deposit streams hitting your bank account on different schedules, each calculated using a different method. Most sellers record those deposits as revenue. The result is books that are simultaneously wrong about revenue, wrong about expenses, and wrong about GST/HST obligations.
The correct approach is not complicated, but it requires treating each platform’s deposit as the output of a calculation rather than as income. This guide walks through how each platform calculates what it pays you, how to map each deposit back to its components, and where reconciliation most commonly breaks down.
How Each Platform Calculates Your Payout
Amazon
Amazon does not pay you your sales. It pays you your sales minus everything it has already deducted.
A typical Amazon settlement covers a two-week period. Amazon closes the settlement and initiates the transfer, with the deposit arriving 3 to 5 business days later. The settlement report deducts, in one calculation:
- Referral fees (ranging from 8% to 15% depending on category, per the Amazon fee schedule)
- FBA fulfillment fees (per unit, based on size tier and weight)
- FBA storage fees (monthly charge, sometimes reconciled within the same period)
- Advertising costs from Sponsored Products and Sponsored Brands campaigns
- Refunds processed during the settlement window, regardless of when the original sale occurred
- GST/HST collected on your sales, which may be remitted by Amazon directly or passed through to you depending on your marketplace tax collection settings
A return on an order from three weeks ago reduces this week’s settlement. A large advertising campaign spend reduces the same deposit as product revenue. The deposit is a net figure representing two weeks of activity across all of these categories simultaneously.
Shopify
Shopify Payments operates differently from Amazon. It pays out closer to gross sales and charges separately for fees.
When a transaction is processed through Shopify Payments, the minimum settlement time for Canadian bank accounts is 3 business days, with actual timing depending on your bank and payout schedule settings. The deposit equals gross transaction value minus the payment processing fee, which is typically 2.4% to 2.9% plus CAD $0.30 per transaction depending on your plan. Shopify’s monthly subscription fee is billed separately on its own cycle.
If you use a third-party payment processor alongside Shopify Payments, each processor deposits independently. A single Shopify store can generate deposits from multiple sources with no automatic consolidation.
Refunds processed through Shopify Payments reduce a future payout, not the original one. This creates the same timing asymmetry as Amazon: a refund issued in May reduces a May deposit even if the original sale occurred in April.
Walmart
Walmart Marketplace pays out bi-weekly, with payment made no later than 7 business days after the end of the payment period. Like Amazon, Walmart deducts its fees before the deposit.
Walmart referral fees range from 6% to 20% depending on category. There are no monthly seller fees, which can make Walmart appear more profitable than it is until the referral fee impact on margins is calculated correctly.
New sellers are subject to a reserve hold that is released over time as account history is established. The reserve amount is visible in Walmart Seller Center under Finance, and represents cash that has been earned but not yet disbursed.
A Worked Example: Three Channels, One Bank Account
A seller operating on all three platforms receives the following deposits in a given week:
| Platform | Deposit |
|---|---|
| Amazon settlement | CAD $4,218 |
| Shopify Payments (7 days) | CAD $1,940 |
| Walmart settlement | CAD $876 |
| Total deposits | CAD $7,034 |
Their platform dashboards report CAD $9,940 in gross sales across the same period. The CAD $2,906 difference is not missing money. It is made up of platform fees, refunds processed, reserves, and taxes that are either passed through to the seller or remitted by the marketplace directly, depending on each platform’s tax settings and your registration status.
Breaking down the Amazon deposit (assumes taxes passed through to seller, not remitted by Amazon):
| Item | Amount |
|---|---|
| Gross product sales | CAD $6,840 |
| Referral fees | (CAD $820) |
| FBA fulfillment fees | (CAD $1,140) |
| Advertising costs | (CAD $380) |
| Refunds processed | (CAD $210) |
| GST/HST passed through | (CAD $72) |
| Net settlement deposit | CAD $4,218 |
The correct entry is CAD $6,840 in Amazon revenue, not CAD $4,218. The fees are operating expenses. If Amazon has passed GST/HST through to you, that amount is a liability owed to the CRA, not income. If Amazon is remitting on your behalf under its marketplace tax collection rules, the tax line will not appear in your settlement the same way, and the gap will consist only of fees and refunds.
The Shopify deposit follows the same logic at smaller scale. CAD $2,060 in gross sales minus CAD $120 in transaction fees equals the CAD $1,940 deposit. Revenue is CAD $2,060. The fee is an expense. Shopify does not remit GST/HST on behalf of sellers; tax collected through Shopify Payments flows through to you and must be remitted directly.
Walmart: CAD $1,040 in gross sales minus CAD $164 in referral fees equals the CAD $876 deposit. Revenue is CAD $1,040. Walmart Canada’s payment statements distinguish between GST/HST remitted by seller and GST/HST remitted by Walmart, depending on the transaction type. Confirm which applies to each line before determining whether a tax liability sits with you or with the marketplace.
Correct revenue for the period: CAD $9,940. What was deposited: CAD $7,034. The CAD $2,906 gap belongs to fees, refunds, and taxes, with the tax portion sitting either as your liability or already handled by the marketplace depending on your platform tax settings.
Reports to Pull from Each Platform
Amazon
The Settlement Report (also called the Flat File Settlement Report, available in Seller Central under Reports > Payments) is the authoritative record for each settlement period. Pull this first.
Supporting reports that explain settlement line items:
- Date Range Transaction Report: individual order-level transactions within a date range
- Advertising Reports: confirms spend by campaign and period
- Returns Report: shows refunds processed and the settlement period in which they appear
The Settlement Report is the source of record. Transaction-level reports explain it.
Shopify
The Finances Summary report (Analytics > Reports > Finances) shows gross sales, returns, discounts, shipping collected, taxes collected, and processing fees by period.
For Shopify Payments specifically, the Payouts report (Finances > Payouts) shows each individual payout with its component transactions. For a detailed walkthrough of how to interpret each line, see How to Read a Shopify Payouts Report.
If you use a third-party processor, download that processor’s transaction export separately. There is no Shopify report that consolidates across multiple payment processors.
Walmart
The Payment Report in Walmart Seller Center (Finance > Payments) shows the settlement breakdown including gross sales and referral fee deductions. Walmart’s reporting is less granular than Amazon’s, but the settlement report is sufficient for reconciliation purposes.
Where Reconciliation Breaks Down
Booking deposits as revenue. This produces both the wrong revenue total and the wrong date for that revenue. Amazon deposits arrive weeks after the sales they represent. Recording the deposit when it lands assigns March revenue to April and understates expenses by the amount of fees already deducted.
Returns processed in a different period than the original sale. A March sale refunded in April reduces the April settlement. Books that treat settlements as revenue will show March as too profitable and April as unexpectedly weak. The correction is to record gross revenue when the sale occurs and record the refund when it is processed, as two separate entries.
GST/HST treatment depends on which party is remitting. Amazon and Walmart may remit GST/HST on the seller’s behalf under their marketplace tax collection rules, or pass it through to the seller to remit directly, depending on the seller’s tax settings and the transaction type. When tax is passed through, it appears in the settlement and belongs in a liability account, not income. When the marketplace remits, the tax does not flow through your books the same way but your obligation to track and confirm the correct treatment still exists. Shopify does not remit GST/HST on behalf of sellers; amounts collected through checkout are always the seller’s obligation. For a full treatment of how GST/HST flows through marketplace settlements, see Amazon GST/HST for Canadian Sellers.
Platform fees pooled into a single account. Amazon referral fees, FBA fulfillment fees, Shopify transaction fees, and Walmart referral fees serve different analytical purposes. Pooling them into one “platform fees” account eliminates the ability to assess which channel is actually profitable. For SKU-level profitability analysis, see How to Calculate True Amazon FBA Profitability.
Timing mismatches across platforms. Amazon settles bi-weekly. Shopify Payments deposits daily or within a few days. Walmart settles bi-weekly on a cycle that may not align with Amazon. In a given calendar month, you may have two Amazon settlements, twenty or more Shopify deposits, and two Walmart settlements. Managing cash position requires knowing not just how much is coming in but when each platform will release it. For how payout timing interacts with inventory purchasing obligations, see Inventory as a Cash Flow Problem.
What Your Books Need to Track
The goal is a set of records where revenue reflects actual sales by channel, fees are categorized by type, and GST/HST collected sits in a liability account rather than income.
Revenue split by channel. Amazon revenue, Shopify revenue, and Walmart revenue in separate accounts. This is the minimum required to evaluate whether each channel is worth operating.
Fees split by type. Referral fees, fulfillment fees, advertising costs, and transaction fees each tell a different story about the cost structure of a channel. Combining them produces a number that cannot be analyzed.
GST/HST treatment confirmed per platform and period. Where the marketplace passes GST/HST through to you, it belongs in a liability account, not revenue, and is released when remitted to the CRA. Where the marketplace remits on your behalf, confirm this is reflected correctly in your settlement reports before recording anything. The treatment can differ by transaction type on the same platform, particularly on Walmart, where payment statements distinguish between seller-remitted and marketplace-remitted tax.
A clearing account per platform. When a sale occurs, revenue is recorded at gross. When the settlement or payout arrives, the deposit hits the bank and the clearing account is reduced by the deposit amount, with simultaneous entries for each fee and tax component. A clearing account balance at period end represents sales that occurred but have not yet settled. This is expected and normal, particularly for Amazon and Walmart.
The mandatory GST/HST registration threshold is CAD $30,000 in taxable revenues over four consecutive quarters or within a single quarter. That threshold applies to gross sales revenue, not deposits. A seller receiving CAD $5,500 per month in combined platform deposits may have gross revenue of CAD $7,000 or more after accounting for fees deducted before payout. Sellers tracking only deposits may reach the registration threshold without realizing it.
Scope of This Guide
This guide covers payout reconciliation for Canadian sellers operating on Amazon, Shopify, and Walmart Marketplace simultaneously. It does not cover:
- Etsy, eBay, TikTok Shop, or other platform payout mechanics
- Inventory valuation or cost of goods sold
- Provincial sales tax
- U.S. sales tax obligations for Canadian sellers
- GST/HST filing mechanics
Each platform deposit is a calculation, not income. Reconciliation is the process of reversing that calculation back into its components. Done once, with the right account structure, it does not need to be re-engineered at filing time.