Get in Touch
Tell us about yourself and we will get back to you as soon as we can.
Tell us about yourself and we will get back to you as soon as we can.
Managing e-commerce bookkeeping is more complex than traditional service businesses due to high transaction volumes, embedded platform fees, and shifting inventory values. Many Shopify sellers make the mistake of recording net bank deposits as revenue, which understates their actual sales and hides processing expenses. To maintain clean, tax-ready financials, sellers must rigorously track gross product sales separately from fees and manage sales tax as a liability rather than income.
You made $80,000 on Shopify last year. But after Stripe fees, refunds, ad spend, and inventory costs, what did you actually keep?
Most e-commerce sellers have no idea. They see money hitting their bank account and assume the business is profitable. Then tax season arrives, their accountant asks for organized books, and the panic sets in.
Bookkeeping for e-commerce is genuinely harder than bookkeeping for a service business. You're dealing with high transaction volume, platform fees embedded in payouts, inventory that changes value, returns that need to reverse revenue, sales tax obligations across multiple states, and potentially three or four different selling channels each with its own payout schedule and fee structure.
This guide will walk you through exactly what to track, how to handle the tricky stuff, and how to stop doing it manually.
A consultant who invoices clients has relatively simple books: income comes in, expenses go out, and reconciliation is straightforward.
A Shopify seller's books look nothing like that.
On any given day you might have 40 orders processed, two partial refunds, a chargeback from last month, a Shopify Payments payout that's net of fees, an Amazon disbursement that bundles three weeks of sales, a Meta ad spend charge, and an inventory purchase from your supplier. Each of these needs to land in the right account, and the way platforms report them is almost never how your books need to see them.
The five areas where sellers consistently go wrong:
This is the single most common mistake, and it silently distorts your financials. When Shopify Payments or Stripe deposits money into your bank account, that deposit is already net transaction fees have been deducted. If you book that deposit as revenue, you're understating your revenue and you're missing the expense of those fees entirely. Your actual revenue is your gross sales. Your payment processing fees are a separate line item expense. The deposit is just what's left after the platform took its cut.
A refund reduces revenue, it does not create an expense. If a customer returns a $90 product and you issue a refund, your revenue for that transaction goes to zero. It doesn't appear as a $90 expense on your P&L. Chargebacks are slightly more complicated: there's the reversed transaction plus a chargeback fee (typically $15–25), and both need to be recorded correctly. Many sellers just ignore these or let them muddy their bank reconciliation for months.
Every product you sell has a cost. If you don't track the cost of goods sold (COGS), your gross profit number is meaningless, and gross profit is the most important metric in a product business. You can be generating $200K in revenue and losing money if your margins are thin enough. Without COGS in your books, you won't know until your accountant runs the numbers at year-end, which is far too late to do anything about it.
Shopify can collect sales tax from customers at checkout, but collecting it and remitting it are two completely different things. Collected sales tax is a liability on your books, not revenue. It sits in a liability account until you remit it to the relevant tax authority. If you book it as income, you'll pay income tax on money that was never yours.
If you're selling on Shopify, Amazon, and Etsy simultaneously, you have three completely different payout schedules, three fee structures, and three platforms' worth of transaction data to reconcile back to one set of books. Doing this manually is a multi-hour monthly exercise, and the error rate is high.
CPA Journal — How Wayfair's Economic Nexus Has Redefined Business Tax Obligations
Your chart of accounts is the backbone of your books. Here's what it should look like for an e-commerce business:
The key principle
• Revenue accounts capture gross activity.
• Fees and costs are always expenses, never reductions of revenue except for refunds, which specifically reverse revenue.
Here's exactly what happens every time Shopify Payments deposits money into your bank account, and how to record it properly.
What Shopify sends you: A net deposit. Say your payout summary shows $4,200 in gross sales, $180 in refunds, and $126 in transaction fees. You receive $3,894 in your bank account.
What most sellers book: $3,894 in revenue.
What you should book:
This matters enormously at tax time. If you book $3,894 as revenue twelve times a year, you've understated your revenue by $3,672 (the fees and refunds you netted out). Your P&L will look inexplicably thin, and your accountant will have to reconstruct the real numbers which takes time and costs money.
In your Shopify admin under Finances → Payouts, click any payout to see the full breakdown of gross sales, fees, refunds, adjustments, and disputes.
At low order volumes (say, under 50 orders a month), you can do this manually and it takes maybe 30 minutes. At 200+ orders a month with a few refunds and the occasional chargeback, you're looking at 3–5 hours a month of pure data entry, which is exactly the kind of work AI bookkeeping was built to eliminate.
Gross profit is the most important financial metric for any product business. It tells you whether your core business model actually works before you even factor in marketing and overhead.
Gross profit = Revenue − Cost of goods sold
If your gross margin is below 30 - 40% in most product categories, you're going to struggle to be profitable once you add in advertising, fulfillment, and Shopify fees. The only way to know your gross margin is to track COGS rigorously.
For most small Shopify sellers, Average Cost is simpler to manage, especially if you're reordering the same products at slightly different prices over time.
A Quick Correction: The choice of method matters most for tax purposes. In an inflationary environment (where supplier prices are rising), LIFO typically results in higher COGS and lower taxable income, while FIFO results in lower COGS and higher taxable income.
A Note on Dropshipping
If you're dropshipping, your COGS is the price you pay your supplier per unit shipped, not the retail price, and not the wholesale catalog price. It's the actual invoice amount for each fulfilled order. Many dropshippers accidentally track COGS as the catalog price, which is wrong if you've negotiated different rates or if prices fluctuate.
Nothing. The cost of your inventory doesn't change because you discounted the selling price. If you normally sell a product for $50 and put it on sale for $35, and the product costs you $18, your COGS is still $18. Your gross margin just compressed from 64% to 49%.
Sales tax is the area that trips up e-commerce sellers more than any other, and it has only gotten more complicated since the 2018 South Dakota v. Wayfair Supreme Court decision changed everything.
Economic nexus explained:
Before Wayfair, you only owed sales tax in states where you had a physical presence, a warehouse, an office, employees.
After Wayfair, most states can require you to collect and remit sales tax based purely on your sales volume into that state, even if you've never set foot there.
Most states set their economic nexus threshold at $100,000 in annual sales or 200 transactions. Once you cross that threshold in a state, you're obligated to collect and remit sales tax there.
Shopify can calculate and collect sales tax from customers at checkout, but this only handles the collection piece. Remitting that tax to the relevant state is your responsibility, on the state's schedule (monthly, quarterly, or annually depending on your volume).
Here's the critical bookkeeping rule: collected sales tax is a liability, not revenue.
When a customer pays $53.75 for a $50 product ($3.75 sales tax), your revenue is $50. The $3.75 goes into a Sales Tax Payable account on your balance sheet. When you remit it to the state, that liability account goes to zero. If you ever book it as revenue, you'll pay income tax on money you were just holding in trust.
For Canadian sellers: GST/HST rules apply once you cross $30,000 CAD in annual revenues much lower than most US thresholds. If you're selling physical goods to Canadian customers as a Canadian business, you need to be registered for GST/HST and remitting accordingly. LayerNext's CRA-compliant bookkeeping features handle this automatically.
Returns are a fact of life in e-commerce, the average return rate across product categories runs 15–30%. Here's how to handle them without creating a mess in your books.
Standard returns and refunds:
When you issue a refund, you're reversing revenue, not creating an expense. Create a Sales Returns and Allowances account (a contra-revenue account that sits against your gross sales). When you refund $75 to a customer:
If you also received the product back and it's resalable, you'd reverse the COGS entry too (debit inventory, credit COGS). If the product is unsalable (damaged, used), that inventory write-off becomes an expense.
Chargebacks:
Chargebacks are more complex. When a customer disputes a charge, the payment processor reverses the transaction and typically charges you a dispute fee ($15–25 depending on the processor). You have a window to dispute the chargeback with evidence.
If you lose the chargeback: reverse the original revenue, record the dispute fee as an expense. If you win the chargeback: no change needed to revenue; just record the dispute fee as an expense (it's non-refundable).
If you're managing books manually, here's what needs to happen every month. Treat this as non-negotiable if you want clean financials going into tax season.
Reconcile all Shopify Payments payouts to your bank account. Every payout should match a deposit, if it doesn't, something was miscategorized or missed. Download your payout breakdown from Shopify and verify gross sales, fees, refunds, and disputes are all booked correctly.
Reconcile all other payment processors, Stripe, PayPal, Afterpay, Klarna. Each has its own payout timing and fee structure. Don't let these pile up; a missed month of PayPal reconciliation can take hours to untangle.
Update your inventory value. If you received stock during the month, add the purchase to your inventory asset account and record accounts payable or the cash payment to your supplier. If you wrote off damaged stock, record the write-down as an expense.
Review your COGS entries and spot-check against units sold. Your inventory on hand (in your books) should reconcile closely with your actual physical count.
Check your Sales Tax Payable account and compare it against what Shopify collected. If you're using TaxJar or Avalara, reconcile their reports against your liability account.
Review your advertising accounts Meta, Google, TikTok. Make sure all ad spend is categorized correctly and that you haven't accidentally booked any ad spend as COGS.
Review your P&L. A quick sanity check: does your gross margin look consistent with prior months? A sudden swing usually means something was miscategorized.
At low volume (under 50 orders/month), manual bookkeeping for a Shopify store takes roughly 2-4 hours per month if you're organized and disciplined about it.
At 100-300 orders/month, with multiple payment processors, returns, and possibly multiple channels, you're looking at 6–10 hours per month, and the error rate climbs as volume grows.
Above 300 orders/month, you're either hiring a bookkeeper, using dedicated e-commerce accounting software, or falling behind. Falling behind is expensive: scrambling to reconstruct six months of Shopify payouts in April is a nightmare that often costs more in accountant fees than a full year of automated bookkeeping would have.
The bookkeeping steps in this guide aren't hard to understand, but they are relentless. Every payout, every refund, every chargeback, every supplier invoice needs to be processed correctly, every month, without gaps.
LayerNext connects directly to Shopify and QuickBooks and handles all of it automatically. Every Shopify payout is split into gross revenue, transaction fees, and refunds, and booked correctly without any manual entry. Bank reconciliation runs continuously, not once a month. Your books are always closed, not waiting for you to find time on a Sunday night.
If you're spending more than two hours a month on bookkeeping, you're spending too much time on it.
Related reading: How to Automate QuickBooks Bookkeeping in 2026 · What Is Bank Reconciliation? · Top Small Business Tax Deductions 2026
