Accurate ecommerce bookkeeping requires Shopify sellers to separate gross sales, discounts, refunds, taxes, processing fees, payouts, inventory costs, and operating expenses instead of treating the net bank deposit as revenue. Clean books protect tax compliance, reveal true gross margin, and give founders the numbers needed to make product, inventory, and growth decisions.
The bank deposit is not your revenue. It is the remaining cash after Shopify Payments has processed sales activity, refunds, fees, adjustments, and payouts. Treating those numbers as identical is how ecommerce books become unreliable.
Image by rawpixel.com on Magnific
Running a Shopify store produces a volume and variety of financial data that most sellers underestimate when they start. Every payout from Shopify is a net figure: sales minus returns, minus payment processing fees, minus Shopify fees, sometimes minus taxes collected on behalf of specific jurisdictions. What lands in a bank account bears only a partial resemblance to what was actually sold. And that gap between gross sales and net deposits is where most e-commerce bookkeeping errors begin.
The sellers who discover this gap late, typically at the end of their first full tax year, spend significant time and money working backward through twelve months of transactions to produce financial statements that accurately reflect what actually happened. Those who build the right bookkeeping infrastructure early avoid that reconstruction and arrive at tax time with numbers that are already correct.
Standard bookkeeping tracks money in and money out in a relatively straightforward way. E-commerce bookkeeping involves several layers of complexity that standard tools and standard bookkeepers do not always handle well. Sales happen across multiple channels, potentially including Shopify, Amazon, Etsy, and wholesale orders, each of which has different fee structures, different payout schedules and different reporting formats. Inventory requires cost tracking, not just revenue tracking: the cost of goods sold must be matched against the revenue from those goods, which requires accurate inventory cost records.
The Canada Revenue Agency provides guidance for Canadian businesses selling online, including obligations around GST/HST registration thresholds, the treatment of returns and refunds, and how digital sales to customers in different provinces affect tax collection requirements. For Canadian Shopify sellers who have crossed the small supplier threshold or who sell to customers in provinces with different HST rates, understanding and correctly accounting for these obligations is a compliance necessity, not an optional extra.
Inventory is where e-commerce bookkeeping diverges most sharply from service business bookkeeping. A service business recognises revenue when a service is delivered and has relatively few balance sheet items. An e-commerce business carries inventory as an asset, recognises cost of goods sold when items are sold rather than when they are purchased, and needs to track shrinkage, obsolescence and returns accurately.
Most Shopify sellers initially approach inventory informally. They know roughly what they have, track their purchasing loosely, and reconcile at year end when the discrepancy between what the records show and what is actually in the warehouse is discovered. By that point, the cost of goods sold figure is unreliable, the balance sheet does not accurately reflect assets, and the profitability picture is distorted.
The solution is setting up inventory tracking from the start, using either Shopify’s native inventory management or a dedicated inventory tool integrated with the accounting system. Either approach requires assigning a cost to each SKU at purchase and updating it accurately when purchase prices change.
Shopify’s payout reports are not the same as revenue reports, and treating them as equivalent is one of the most common errors in e-commerce bookkeeping. The payout represents money received after fees, refunds and in some cases tax collection by Shopify. The revenue figure is what was actually sold before those deductions. Both figures matter for different purposes, and using the wrong one for tax reporting or profitability analysis produces incorrect results.
E-commerce bookkeeping specialists like Plyo Bookkeeping, a Vancouver-based firm that works with Shopify and Amazon sellers using integrations such as A2X to connect e-commerce platforms directly with QuickBooks Online and Xero, handle this reconciliation as a routine part of their monthly process. The integration tools pull the full transaction detail, separate revenue from fees and refunds, and post everything to the correct accounts in the accounting system. The result is financial statements that accurately reflect gross revenue, cost of goods sold, gross margin and operating expenses.
Sales tax, including GST/HST in Canada and state sales tax in the United States for sellers with cross-border exposure, is one of the most technically complex areas of e-commerce compliance. The rules governing when a seller must collect and remit tax in a given jurisdiction have changed significantly in recent years and continue to evolve. Economic nexus thresholds in US states mean that a Canadian seller with significant US sales may have collection and remittance obligations in multiple states without ever having a physical presence there.
Most sellers become aware of this issue only when it has already generated a compliance liability that is difficult and expensive to resolve. Building a process for tracking sales by jurisdiction from the beginning, and reviewing compliance requirements as revenue crosses relevant thresholds, is considerably cheaper than addressing accumulated unfiled obligations.
The most immediate value of accurate e-commerce bookkeeping is correct tax filings. The less-discussed value is the information it provides for business decisions: actual gross margin by product, actual customer acquisition cost relative to lifetime value, the real impact of promotions on profitability rather than just on revenue. Sellers who have accurate, current financial statements make better decisions about which products to expand, which to discontinue, and when the business can support additional investment. Sellers who do not discover their actual numbers until twelve months have passed are making those decisions blind.
Your Shopify payout does not match sales revenue because a payout is the net amount transferred to your bank after Shopify Payments activity such as refunds, payment-processing fees, chargebacks, adjustments, reserves, shipping-label charges, and payout timing differences. Revenue should reflect product sales before those deductions, while sales tax collected is generally recorded as a liability rather than revenue. Reconcile Shopify’s Payments activity and payout reports each month to separate gross sales, discounts, refunds, tax, fees, and adjustments. The resulting net amount should match the bank deposit without treating the deposit itself as your complete sales figure.
Shopify sellers should generally record inventory as an asset when they buy it and recognize the related cost as cost of goods sold when the product is sold. This matches the cost of the product to the revenue earned from that product and produces a more accurate gross-margin figure. Expensing all inventory purchases immediately can distort monthly profit, especially when a business buys stock well before selling it. The correct treatment can depend on your accounting method, inventory system, tax position, and business structure, so confirm the policy with a qualified accountant or tax adviser for your jurisdiction.
A Canadian ecommerce business generally needs to register for GST/HST when its worldwide taxable supplies exceed the $30,000 small-supplier threshold over the previous four consecutive calendar quarters, or immediately when it exceeds $30,000 in a single calendar quarter. The threshold is based on taxable sales activity, not simply on Shopify payouts or bank deposits. Sellers should track sales across Shopify, marketplaces, wholesale, and other channels, then review the threshold regularly as the business grows. GST/HST registration and provincial tax treatment can be complex, so use a qualified Canadian tax professional to confirm the timing and filing obligations for your situation.
Economic nexus is a state sales-tax rule that can require an out-of-state ecommerce seller to register, collect, and remit sales tax after reaching a defined level of sales or transactions in that state, even without a physical location there. Thresholds, measurement periods, included sales, marketplace-facilitator treatment, and registration timing differ by state. Sellers with US customers should track direct and marketplace sales by destination state, monitor returns and taxable sales, and review obligations regularly as revenue grows. A tax professional can determine registration requirements, but accurate state-level sales data is necessary to identify where the business may have crossed a threshold.
A Shopify seller should review a monthly profit and loss statement, balance sheet, cash-flow report, Shopify Payments activity report, payout details, sales and refund reports, inventory valuation, cost of goods sold, accounts payable, tax payable, advertising spend, and product or channel profitability where available. The Shopify Payments activity report is especially important because it reconciles gross activity, fees, payouts, and ending balance for the selected period. Compare these reports with bank statements, payment processors, marketplaces, supplier invoices, and inventory records. The purpose is to understand true revenue, margin, cash movement, and tax exposure before the information becomes stale.
