E-commerce & Shopify Bookkeeping: Why Settlement Reports Break Normal Bookkeeping

The single deposit that lands in your bank account from Shopify or Amazon is not a sale. It's dozens or hundreds of them, netted against fees and refunds — and bookkeeping that doesn't unpack it produces margins that are quietly, confidently wrong.

Ordinary small-business bookkeeping assumes a reasonably direct relationship between a bank deposit and a sale: a client pays an invoice, the money lands, you record it. E-commerce breaks that assumption completely. A Shopify payout landing in your bank account on a Tuesday might represent 340 individual orders placed over the previous few days, minus 12 refunds, minus Shopify Payments processing fees, minus a discount code that ran that week — all compressed into one number. Book that single number as "sales," and your revenue is overstated, your fees are invisible, and your actual margin per product becomes unknowable.

What a settlement report actually contains

Here's a simplified version of what sits behind a single e-commerce payout — the kind of breakdown that needs to become several separate journal entries, not one:

Recording only the $17,538 deposit as revenue hides $18,420 in actual gross sales, $612 in fees that should show up as a real expense line, and $540 in refunds that matter for understanding return rates and product quality issues. None of this is visible from the bank feed alone — it only becomes visible by reconciling against the platform's own settlement or payout report.

How this gets handled properly

1. Settlement report pulled for the exact period the payout covers, from Shopify, Amazon Seller Central, or the relevant platform.
2. Journal entry built breaking gross sales, discounts, refunds, shipping income, and fees into their correct separate accounts.
3. Sales tax collected separated out as a liability, not revenue — a frequent and costly error in DIY e-commerce bookkeeping.
4. Net deposit matched against the actual bank feed entry, confirming the math ties out exactly.
5. COGS recognized against the units actually sold in that batch, using real landed cost per SKU.

Tools like A2X and Link My Books automate steps 1-2 by connecting directly to Shopify, Amazon, and other marketplaces and posting correctly structured entries into QuickBooks Online or Xero — turning what used to be hours of manual reconciliation work into a review-and-approve process. The tool doesn't replace the bookkeeper's judgment, but it removes the manual transcription that used to be the main source of errors.

Cost of goods sold: the number most DIY sellers get wrong

COGS for e-commerce needs to be tracked at the product level, using landed cost — the unit cost plus freight, duties, and any per-unit fulfillment cost — not just what appears on the original supplier invoice. Recognized against actual units sold in a period, not against inventory purchased, this is what turns "we sold $18,000 this month" into "we made $6,200 in gross margin this month," which is the number that actually matters for a decision about pricing or ad spend. Inventory tools (Cin7, Skubana, or Shopify's own inventory tracking for simpler catalogs) feed unit-level cost data into the accounting platform so this calculation runs automatically rather than being reconstructed manually at year-end.

Multi-channel selling: the consolidation problem

Selling across multiple channels means multiple settlement formats, multiple fee structures, and multiple places inventory can be sitting — and a single consolidated view of true profitability requires all of it feeding into one chart of accounts consistently, rather than three disconnected pictures. This is where a lot of growing e-commerce businesses hit a wall: each channel individually looks fine, but nobody can answer "which channel is actually most profitable per dollar of ad spend" without the underlying data unified first.

Sales tax nexus: a real and growing exposure

US economic nexus rules mean a business can owe sales tax in a state purely based on sales volume there, with no physical presence required — and thresholds vary by state. Multi-channel sellers need nexus tracked in aggregate across every platform, since a state doesn't care whether the sales came through Shopify or Amazon. Tools like TaxJar or Avalara integrate with e-commerce platforms and accounting software to monitor thresholds and automate filing, and are worth having in place well before nexus becomes a genuine liability rather than a hypothetical one.

Returns and refunds: the profitability signal most sellers ignore

Refund data buried inside a net deposit figure hides one of the most useful signals an e-commerce business has: which products are actually generating returns, and why. When refunds are properly categorized against the specific SKU and reason code rather than lumped into a single "returns" bucket, patterns become visible that raw deposit-watching never surfaces — a specific product line with an unusually high defect-related return rate, or a sizing issue driving returns on one SKU variant but not others. This is a case where correct bookkeeping doesn't just produce accurate financial statements, it produces an early warning system for product and supplier problems that would otherwise only show up much later as declining reviews or repeat-customer rates.

Inventory valuation: FIFO, weighted average, and why the method matters

Most e-commerce sellers default to whatever their inventory tool assumes without ever deciding deliberately, but the valuation method chosen — first-in-first-out (FIFO) versus weighted average cost — genuinely changes reported COGS and therefore reported profit, particularly when unit costs shift due to supplier price changes or currency fluctuation on imported goods. FIFO assumes the oldest inventory cost is recognized first, which during a period of rising costs tends to show higher margins than weighted average would. Neither method is wrong, but consistency matters — switching methods opportunistically between periods to make numbers look better is both poor practice and, in most jurisdictions, not permitted without formal disclosure. A bookkeeper who understands e-commerce sets this once, deliberately, at setup.

What to look for in an e-commerce-specialist bookkeeper

• Direct experience with A2X or Link My Books, not just general QuickBooks/Xero familiarity
• A clear answer for how they handle sales tax nexus across multiple channels
• Understanding of landed cost, not just supplier invoice price, for COGS
• Experience reconciling at least one of Shopify, Amazon Seller Central, or a similar marketplace specifically
• A described process for handling returns and refunds at the SKU level, not just in aggregate

Generalist bookkeepers can absolutely learn this, but the learning curve is real, and a business with meaningful e-commerce transaction volume pays for that learning curve one way or another — either in a slower onboarding with a generalist, or a faster start with someone who's already solved these exact problems for other sellers.

Frequently asked questions

Further reading and official resources

• Avalara: Sales Tax Nexus GuideA practical overview of economic nexus thresholds by US state.
• A2X Support CenterOfficial documentation for settlement report automation into QuickBooks/Xero.
• Outsourced bookkeeping services: the complete guideOur broader guide to scope, pricing, and provider vetting.