Common Ecommerce Bookkeeping Mistakes to Avoid

Small Shopify stores rarely fail because the product is bad. They fail because the books lie — not on purpose, but because ecommerce money moves in ways ordinary bookkeeping habits were never built for. A deposit is not a sale. A profitable P&L is not a full bank account. And the tax you never see withheld is still owed.

This guide walks the mistakes that cost real money, with worked numbers so you can see exactly where the profit leaks. For the full structure behind these fixes, see our ecommerce P&L guide.

This is general information, not tax advice. Rules change and vary by situation — consult a licensed CPA or tax professional before acting.

Mistake 1: Treating your Shopify payout as revenue

This is the single most common error, and it poisons everything downstream. The deposit that lands in your bank from Shopify Payments is a net settlement — sales, minus processing fees, minus refunds, plus or minus adjustments and chargebacks, batched on a rolling delay. It almost never equals your sales for the same window.

Book the payout as "revenue" and you understate your true top line, hide your fees entirely, and produce books that can't be reconciled at tax time. The correct treatment: record gross sales at the top of your P&L, then put fees, refunds, and discounts on their own lines. The payout belongs at the bottom, as the cash consequence.

Say you sell 300 orders at $32. Your gross sales are 300 × $32 = $9,600. But a Shopify Payments payout for that period might read closer to $8,900 after fees and refunds. If you record $8,900 as revenue, you've erased roughly $700 of fees and refunds from your books — and you'll never know your real margin.

Mistake 2: Ignoring the fees baked into every transaction

Even merchants who separate payouts from sales often forget how many distinct fees Shopify takes. Online card payments on lower-tier plans are commonly quoted around 2.9% plus a fixed 30¢ per transaction, according to A2X's breakdown of Shopify fees — verify the exact rate for your plan on Shopify's pricing page.

On those same 300 orders, processing runs roughly (2.9% × $9,600) + (300 × $0.30) = $278 + $90 = $368. That's real gross profit, and it should appear as its own line, not vanish into a net deposit.

Two more fees trip people up. A chargeback dispute costs $15 in the US on Shopify Payments, refunded only if you win, per A2X's fees guide. And when you refund a customer, the original processing fee is generally not returned — so a refunded $32 order still costs you its ~$1.23 fee even though you kept nothing.

Mistake 3: Putting ad spend in cost of goods sold

COGS is the direct cost of the units you sold — for a print-on-demand store, the supplier's production charge plus shipping to the customer. Ad spend is paid acquisition, and it belongs in operating expenses, below the gross-profit line.

Why it matters: bury blended ad cost inside COGS and your gross margin looks inflated while your real risk — customer acquisition cost — stays invisible. The P&L should scream "the danger here is CAC," and it can't if that cost is hidden.

Here's the same store laid out correctly. These figures are illustrative; the one real-world input, the processing rate, is cited above.

Read it: the product is healthy at ~55% gross margin, but ad spend eats most of the gross profit. If ad costs rise 20% — another $600 — operating profit nearly halves. That story only appears when ad spend sits visibly in OpEx.

Mistake 4: Confusing profit with cash

Look again at that table. It shows about $1,092 of profit — and the store could still be short on cash this week. Profit is booked on the sale date; cash moves on the payout schedule. The gap between them is the float problem, and it's the top reason growing, ad-funded stores hit a wall.

Ad spend leaves your card daily. Shopify payouts arrive on a delay — often a couple of business days in the US, but it varies by plan and account, and settlements pause on weekends while your ads never do. POD supplier charges hit at production, often before the matching payout lands.

Say you spend $100 a day on ads with payouts arriving two business days later. Over a Friday-to-Sunday run you've spent $300 with zero settlements until Tuesday — money out the door, funded entirely from your own pocket. Double the ad budget to scale, and you double the float you must pre-fund. You can be genuinely profitable and cash-negative at the same moment. The fix is a cash buffer sized to roughly (daily ad + supplier spend) × (payout delay + weekend cushion) — and watching cash conversion, not just margin. If a payout delay is straining your float, understand your options in our Shopify Capital program explanation and how Shopify Capital funding is structured before you treat any advance as free money.

Mistake 5: Assuming Shopify handles your sales tax

Shopify does exactly one part of the job: once you configure it, it calculates and collects the right tax at checkout. It does not register you with the state, file your returns, or remit the money. Those are 100% the merchant's job — and the tax Shopify collects isn't yours to keep.

You also owe tax in more places than you think. Beyond your home state, crossing a state's economic nexus threshold — most commonly $100,000 in sales or 200 transactions in a year, though thresholds vary and some states have dropped the transaction test, per Shopify's guide to charging US sales tax — creates an obligation in states you've never set foot in. And note the trap: marketplace facilitator laws cover Amazon or Etsy, but on your own Shopify store you are the seller of record, so the filing and remitting fall on you.

Mistake 6: POD sellers skipping the resale certificate

If you sell print-on-demand, this leaks money every single month. When Printify or Printful produces your product, you're buying goods to resell — which should be exempt from sales tax. But only if you've given the supplier a valid resale certificate. Without it, the supplier charges you sales tax on every order, and since you already collect tax from your customer, you effectively pay twice.

Get a sales tax permit first, then submit the certificate to each supplier before ordering — Printful reviews it in about two business days, per its resale certificate help article, and Printify in roughly three to five, per its resale certificate guide. There are no retroactive refunds: orders placed before approval keep their tax. Set it up on day one.

Mistake 7: Forgetting the taxes nobody withholds

Two surprises hit first-year sellers hardest. First, no 1099-K does not mean no taxable income — you owe income tax on your profit regardless of whether any form arrives. The current federal threshold for a processor to issue a 1099-K is gross payments over $20,000 and more than 200 transactions, both required, after the One Big Beautiful Bill reverted it, per the IRS 1099-K threshold FAQ. And that form reports gross dollars, not profit — your taxable income is far lower, which is exactly why clean books matter.

Second, sole proprietors owe self-employment tax of 15.3% — 12.4% Social Security plus 2.9% Medicare — on top of ordinary income tax, per the IRS estimated tax guidance. Because nothing is withheld, you pay in quarterly installments; the 2026 due dates are April 15, June 16, September 15, and January 15, 2027, per Kiplinger's estimated-tax schedule. Miss them and you risk an underpayment penalty.

The through-line: you can't fix what your books hide

Every mistake here distorts the same target — true per-order profit. That's the number that tells you whether a product, an ad campaign, or the whole store is actually working, and it's the first casualty of messy books.

This is where PodVector fits. It connects Shopify, Meta Ads, Google Ads, Printify, and Printful, and computes your true per-order profit — sale, fees, refunds, ad cost, and supplier charge netted to what you actually kept. PodVector is not a dashboard you have to read; Victor, an AI operator, analyzes your live data and proposes moves, then executes the ones you approve on the Shopify side. Victor reads your ad data but does not touch your ad account. If you want the numbers this article describes computed for you automatically, try PodVector free and see the down-funnel profit and loss app built for exactly this.

FAQs

Why doesn't my Shopify payout match my sales?

Because the payout is a net settlement, not a sales figure. It bundles your sales minus processing fees, refunds, and adjustments, and it arrives on a rolling delay covering a prior window — not the calendar month. Book gross sales at the top of your P&L and treat the payout as the cash result at the bottom.

Should ad spend go in COGS or operating expenses?

Operating expenses. COGS is the direct per-unit cost of goods sold — for POD, the supplier's production and shipping charge. Ad spend is paid acquisition; putting it in COGS inflates your gross margin and hides that customer acquisition cost is your real risk.

Can I be profitable and still run out of cash?

Yes. Profit is booked on the sale date, but cash moves on the payout schedule. Ad spend and supplier charges leave first; payouts arrive days later. Growing stores that scale ad spend against that delay create a negative float and can be cash-short despite a profitable P&L.

Do I owe income tax if I never get a 1099-K?

Yes. The 1099-K threshold governs reporting, not taxability. You owe income tax on your profit whether or not a form is issued, and the form itself reports gross dollars before fees and costs — not your actual taxable income. This is general information, not tax advice; confirm your situation with a CPA.

Does a resale certificate really save money for POD sellers?

Usually, yes. Without one, your supplier charges you sales tax on every production order while you're also collecting tax from your customer — double tax on the same item. A valid resale certificate, submitted before you order, moves the tax to the correct point in the chain: your retail sale.