Shopify Bookkeeping in 2026: How to Track COGS, Sales Tax, and Platform Fees
Why Shopify Bookkeeping Is Harder Than It Looks
Selling on Shopify feels simple: customer buys, Shopify processes the payment, money lands in your bank account. You feel like a business genius. Then tax season arrives.
The problem is not the volume of transactions. It is that Shopify’s default reporting is about as useful for your finances as a screenshot of your bank balance. Shopify Payments deposits do not equal revenue. Gross sales do not equal taxable revenue. And without a proper inventory and COGS system, you are essentially guessing at your own profitability and hoping for the best.
Here’s how to stop guessing.
The Core Bookkeeping Challenges for Shopify Sellers
Challenge 1: Shopify Payments Deposits ≠ Revenue
When Shopify deposits money into your bank account, the amount has already been reduced by payment processing fees, refunds, and chargebacks. If you record the deposit as revenue, you’re understating your gross revenue and distorting your financials.
The correct approach:
- Record gross sales as revenue
- Record Shopify processing fees as an expense
- Record refunds and chargebacks separately
- The deposit is just the net cash that hit your bank — not a revenue number
What This Looks Like in Practice
Say Shopify deposits $1,815 into your bank account for a payout period. Here is everything A2X breaks out behind that single number, mapped to the correct account in your books:
| Line Item | Account | Amount |
|---|---|---|
| Product sales (taxable) | Sales Retail | $1,500.00 |
| Product sales (non-taxable) | Sales Retail | $500.00 |
| Discount | Sales Discounts | -$50.00 |
| Refunds | Sales Returns | -$200.00 |
| Sales tax on refund | Sales Tax Liability | -$15.00 |
| Shopify fee | Merchant Account Fees | -$60.00 |
| Sales tax collected | Sales Tax Liability | $140.00 |
| Net deposit to your bank | $1,815.00 |
If you recorded $1,815 as revenue you would be understating gross sales by $185, burying your refunds and discounts, and treating $125 in sales tax as income, which is money you owe to the state, not money you earned.
Every line above flows to a different account for a reason. Revenue stays clean, sales tax sits in a liability account until you remit it, fees hit expenses, and refunds are tracked separately so you can see return rates by period. This is what accurate books actually look like, and it is what A2X produces automatically for every single Shopify payout.
Challenge 2: Sales Tax is a Liability, Not Revenue
Shopify collects sales tax from customers in states where you have nexus, but that collected tax is not your revenue — it’s a liability you owe to the state.
Common mistake: Some bookkeepers include collected sales tax in revenue. This overstates your revenue, overstates your tax bill, and creates reconciliation headaches at tax time.
The correct approach:
- Credit collected sales tax to a Sales Tax Payable liability account
- Debit that account when you remit the tax to the state
- Never include sales tax in your revenue line
Most states establish economic nexus at $100,000 in sales. Many states previously also applied a 200-transaction threshold, but as of 2026 more than 16 states have eliminated it entirely. Do not assume the transaction threshold applies in your key states — check each state’s current rules or use a sales tax automation tool to stay current.
Challenge 3: Cost of Goods Sold (COGS)
COGS is the direct cost of the products you sell — not your overhead, not your marketing, not your shipping. Tracking it accurately requires a proper inventory accounting method.
Three inventory methods:
| Method | How It Works | Best For |
|---|---|---|
| FIFO (First In, First Out) | Oldest inventory is sold first | Most ecommerce businesses, especially seasonal products |
| LIFO (Last In, First Out) | Newest inventory is sold first | Rare for ecommerce; not allowed under IFRS |
| Weighted Average | Average cost is calculated across all units | High-volume, commodity-based products |
For most Shopify sellers, FIFO is the default and the most straightforward.
The COGS formula:
COGS = Beginning Inventory + New Purchases − Ending Inventory
In plain terms: start with what you had, add what you bought, subtract what’s left. The difference is what you sold — and what you can deduct.
Example: You start the month with $10,000 in inventory, buy $5,000 more, and end with $8,000 on hand. Your COGS is $7,000.
If you’re using Shopify’s built-in inventory tracking, you can pull COGS data from there — but you’ll need to verify that your costs are properly entered for every product.
Challenge 4: Shipping Costs
Shipping can be classified several ways depending on your business model:
- If you charge customers for shipping: The fee collected is revenue; the actual shipping cost is COGS
- If you offer free shipping: The shipping cost is COGS (it’s a direct cost of delivering the product)
- Inbound shipping to your warehouse: Part of inventory cost, capitalized into COGS
Be consistent and document your policy. Some accountants prefer keeping outbound fulfillment costs as a separate operating expense line below gross profit rather than in COGS — this keeps your gross margin clean and easier to benchmark against industry standards. Either approach is acceptable; what matters is applying it consistently year over year.
Challenge 5: Shopify Fees and Platform Costs
Shopify charges monthly subscription fees, transaction fees (if not using Shopify Payments), and app fees. These are all operating expenses, not COGS.
Shopify fee breakdown:
- Monthly plan fee → G&A or platform expense
- Shopify Payments processing fee → COGS or payment processing expense
- Third-party transaction fee → COGS or payment processing expense
- App subscriptions (Klaviyo, Gorgias, etc.) → G&A or marketing expense
The Right Accounting Stack for Shopify in 2026
QuickBooks Online is the most common choice for Shopify sellers, with native Shopify integration and strong inventory tracking. The Shopify connector syncs orders, payouts, and refunds automatically.
Xero is a strong alternative, particularly if you’re in multiple countries or want more flexibility in your chart of accounts.
A2X is the most popular Shopify-specific accounting integration. It pulls Shopify payouts and maps them correctly to QuickBooks or Xero, handling the gross revenue vs. net deposit problem automatically. Recommended for any Shopify seller who wants accurate books, because the gross revenue vs. net deposit problem exists regardless of your volume.
The ecommerce accounting stack we recommend:
- Shopify (sales platform)
- A2X (reconciliation bridge)
- QuickBooks Online or Xero (accounting)
- Numeral, Kintsugi, Zamp Avalara (sales tax automation)
Monthly Bookkeeping Checklist for Shopify Sellers
Week 1 of the following month:
- ☐ Reconcile Shopify Payments deposits to bank statements
- ☐ Verify all sales tax collected has been moved to Sales Tax Payable
- ☐ Record returns and refunds
- ☐ Review and categorize all business expenses
Week 2:
- ☐ Update inventory counts and verify COGS calculation
- ☐ Reconcile any Amazon, eBay, or other channel sales (if multi-channel)
- ☐ Review accounts payable — what do you owe suppliers?
- ☐ Bank reconciliation across all accounts and credit cards
By the 15th:
- ☐ P&L review — is gross margin where it should be?
- ☐ Check sales tax remittance schedule — what’s due this month?
- ☐ Review cash position and projected cash needs
Common Shopify Bookkeeping Mistakes to Avoid
1. Recording deposits as revenue — Already covered, but worth repeating. Record gross sales, then deduct fees.
2. Not tracking inventory properly — If you’re using the periodic inventory method (count everything once a year), your monthly P&L will be inaccurate all year. Shift to perpetual inventory tracking.
3. Mixing personal and business finances — Get a dedicated business bank account and credit card if you haven’t already.
4. Ignoring sales tax nexus — If you’re shipping to multiple states, you likely have nexus obligations you’re not meeting. This creates significant back-tax liability.
5. Not separating COGS from operating expenses — Shopify fees are not COGS. Marketing is not COGS. Gross margin is one of the most important metrics for ecommerce businesses — keep it clean.
When to Hire an Ecommerce Accountant
DIY bookkeeping works until it doesn’t. Consider bringing in a professional when:
- You’re doing more than $500K/year in revenue
- You’re selling in multiple states with complex sales tax obligations
- You’re multi-channel (Shopify + Amazon + wholesale)
- You want to raise capital or exit the business
- Tax time feels like a crisis every year
Frequently Asked Questions
Can I use Shopify's built-in reports for my taxes instead of separate accounting software?
Shopify’s reports are useful for operational context but are not a substitute for proper accounting software. The critical limitations: Shopify doesn’t separate revenue from sales tax collected by default, and Shopify Payments deposit reports show net-of-fees amounts that aren’t the same as gross revenue. Additionally, Shopify can’t produce a balance sheet, can’t track your outstanding accounts payable, and doesn’t do bank reconciliation. For tax purposes, you need QuickBooks Online or Xero reconciled to your Shopify data. The A2X integration bridges the two systems and handles the gross revenue vs. net deposit problem automatically — it’s become the standard for any Shopify store doing more than $100K/year.
We sell on Shopify plus Amazon plus our own website. How do we centralize bookkeeping across channels?
Multi-channel bookkeeping requires an integration layer for each channel feeding into a single general ledger. The standard stack: A2X for both Shopify and Amazon settlements (they have separate connectors), feeding into QuickBooks Online. Your own website (if on a different platform) needs its own connector or manual reconciliation. The key accounting discipline: each channel should be a separate revenue line in your chart of accounts so you can see channel-level gross margin. The biggest mistake multi-channel sellers make is commingling revenue streams and not knowing which channel is actually profitable. We frequently see Amazon sellers subsidizing their Shopify channel (or vice versa) without realizing it because channel P&Ls aren’t broken out.
Our Shopify store uses Shop Pay Installments. How do we record those sales?
For Shop Pay Installments (Shopify’s BNPL product), you receive the full sale amount from Shopify minus a processing fee — Shopify assumes the collection risk. From your bookkeeping perspective, treat it like a regular Shopify Payments transaction: record full revenue at the time of sale, record the Shop Pay Installments fee as a selling expense. You don’t carry the receivable; Shopify does. The fee for Shop Pay Installments is higher than standard Shopify Payments fees, so make sure your COGS and margin calculations include it — some sellers calculate margins using standard processing fee rates and inadvertently overstate gross margin.
What's the right way to handle Shopify gift cards in the books?
Gift card sales are not revenue at the time of sale — they’re a liability (Gift Card Liability or Deferred Revenue) because you haven’t yet delivered value to the customer. Revenue is recognized when the gift card is redeemed for a purchase. Breakage — gift cards that are never redeemed — can be recognized as income after a ‘breakage rate’ is established, typically after a year or more of data. In practice, many small Shopify sellers record gift card sales as revenue immediately, which overstates revenue. If your gift card program is significant (more than 2-3% of revenue), the liability treatment is worth getting right — it’s also required by GAAP.
Our Shopify Payments account was placed on reserve because of high chargebacks. How do we account for the reserve?
A Shopify Payments reserve is cash you’ve earned but can’t yet access — it belongs on your balance sheet as ‘Restricted Cash’ or ‘Shopify Payments Reserve,’ not as an expense. You’ve still earned the revenue; you’re just temporarily unable to use the funds. Record the movement into reserve as a transfer from Shopify Payments clearing to the restricted cash account. When funds are released, transfer to your operating account. Separately, track chargebacks as a contra-revenue account and record the associated chargeback fees as expenses. If your chargeback rate is high enough to trigger a reserve, that’s also a signal to review your fraud detection settings — chargebacks are very expensive per incident when you factor in the product cost, shipping, chargeback fee, and administrative time.