How to Set Up Ecommerce Bookkeeping the Right Way

Most guides on setting up ecommerce bookkeeping stop at "pick software and connect your store." That's the easy part. The hard part — the part that decides whether your numbers can actually tell you if you're making money — is how you structure the accounts and how you treat the money Shopify deposits. Get that wrong and you'll have tidy-looking books that quietly hide your real product economics.

This guide walks the full setup in order, with the numbers competitors skip. It pairs with our ecommerce P&L guide for the deeper accounting theory.

Step 1: Choose cash basis or accrual basis

Every bookkeeping system starts with one decision: when do you record a transaction?

• Cash basis records money when it moves — when the payout hits your bank, when the ad card is charged.
• Accrual basis records revenue when the sale happens and costs when they're incurred, regardless of when cash moves.

For a small store you can start on cash basis, but accrual gives you an honest P&L, because it matches the sale to the fees and product costs of that same sale. If you sell on Shopify with paid ads, the timing gap between cash out and cash in is large enough that cash-basis books will mislead you month to month. More on that gap in Step 6.

Step 2: Separate your money before you record anything

Open a dedicated business checking account and route every sale and expense through it. Mixing personal and business money is the single most common reason first-year books become a weekend-long cleanup project.

This is also a legal boundary: if you run an LLC, commingling funds can weaken the liability protection the entity is supposed to give you. Set up one business account and one business card before your first order.

Step 3: Build a chart of accounts that shows product economics

Your chart of accounts is the list of buckets every transaction drops into. A generic template will lump costs together in ways that hide your margins. Structure yours to mirror a real ecommerce P&L, top to bottom:

1. Gross sales — total order value, before anything is subtracted.
2. Discounts — a contra-revenue account (reduces revenue).
3. Returns and refunds — also contra-revenue, not an expense.
4. Cost of Goods Sold (COGS) — direct per-unit cost: for a print-on-demand store, the supplier's production charge plus their shipping, and optionally payment processing.
5. Operating expenses (OpEx) — everything else: ad spend, your Shopify plan, apps, tools, contractor pay.

The rule that separates good books from useless ones: put ad spend in OpEx, not COGS. Ad spend scales with revenue, so it's tempting to file it as a cost of the sale. But burying acquisition cost inside COGS inflates your gross margin and hides the fact that customer acquisition cost is usually your biggest risk. Direct per-unit costs go in COGS; everything that keeps the business running goes in OpEx. For a deeper breakdown of every line, see what a P&L actually is.

Step 4: The setup mistake that ruins Shopify books — payout ≠ revenue

Here is the trap that no amount of good software saves you from if you set it up wrong.

The deposit Shopify sends to your bank is a net settlement. It bundles your sales, minus processing fees, minus refunds issued, plus or minus adjustments, chargebacks, gift-card activity, and shipping income — all on a rolling delay. A Shopify payout almost never equals your sales for the same window.

If you book that deposit as "sales," you understate revenue, erase your fees from the books entirely, and produce a P&L that can never be reconciled at tax time. Instead:

• Record gross sales at the top of your P&L.
• Record fees, refunds, and adjustments on their own lines.
• Treat the net payout as the cash consequence at the bottom — not as a revenue figure.

One more gotcha to set up correctly: when you refund a customer, the original payment processing fee is generally not returned to you, so a refunded order still costs you that fee. And cash received for a gift card is a liability (deferred revenue), not revenue, until it's redeemed.

Step 5: Connect a reconciliation tool and prove it ties out

Reconciliation means proving this equation every month:

net payout = gross sales − refunds − discounts − all fees ± adjustments − chargebacks + shipping income + gift-card movements

You can do this by hand from Shopify's payout reports for a very small store, but tools like A2X, Link My Books, QuickBooks, or Xero automate the split of each payout into its component accounts. Whichever you choose, the job is the same: every deposit must be broken back into its parts, not booked as a lump. Our roundup of the best ecommerce bookkeeping tools for accuracy compares the main options.

Know your fee structure so the reconciliation makes sense. Shopify Payments in the US commonly quotes around 2.9% plus 30¢ per online transaction on lower-tier plans, and a US chargeback carries a $15 dispute fee that's refunded if you win, though you should verify the current rate for your plan on Shopify's pricing page and A2X's Shopify fees accounting guide before quoting a number. Using an external gateway like PayPal instead of Shopify Payments triggers an extra Shopify transaction fee on top.

Step 6: Run a monthly P&L — a worked example

Once the accounts and reconciliation are set up, the P&L is where the setup pays off. Say you run a t-shirt store with these numbers in a month (illustrative figures, not market claims):

Now read it. Gross margin is 4,884 ÷ 8,830 = 55.3%, so the product is healthy. But operating profit is only 1,114 ÷ 8,830 = 12.6% of net sales, because ad spend eats most of the gross profit. If ad costs rose 20% (another $600), operating profit would nearly halve. That story is only visible because ad spend sits in OpEx where you set it up — hide it in COGS and the P&L would falsely scream "great margins."

Step 7: Separate profit from cash — the float problem

Your P&L shows profit. It does not show cash. Profit is booked on the sale date; cash moves on Shopify's payout schedule. This gap sinks profitable stores.

Ad platforms bill your card daily, and print-on-demand suppliers charge you at production — often before the matching payout lands. Shopify Payments settles on a rolling multi-day delay (commonly around two business days in the US, but it varies by plan and account risk, and payouts don't settle on weekends). So cash goes out faster than it comes back.

Walk it through: you spend $100/day on ads with a two-business-day payout delay. Over a Friday-to-Sunday run you spend $300 on ads with zero cash coming in until Tuesday's settlement. Double your ad budget to grow and you double the float you must pre-fund from your own pocket. The store can be profitable on every cohort and still be cash-negative at any moment. Set up a cash buffer sized to at least (daily ad + supplier spend) × (payout delay + weekend cushion).

Step 8: Set up your tax accounts from day one

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

Three tax setups belong in your bookkeeping from the start:

• Sales tax. Shopify calculates and collects sales tax once you configure your nexus, but it does not register, file, or remit for you — that's your job as the seller of record on your own store. You owe tax where you have physical nexus (home state, inventory, warehousing) and where you cross a state's economic nexus threshold, a concept created by the 2018 South Dakota v. Wayfair decision; a common trigger is $100,000 in sales or 200 transactions, but thresholds vary by state, so check each state's Department of Revenue, per Shopify's US sales tax guide.
• Resale certificate. If you're print-on-demand, get a sales tax permit, then submit a resale certificate to each supplier before ordering — Printful reviews it in about two business days and Printify in roughly three to five, per the Printful and Printify help centers. Without it you pay sales tax to your supplier and again collect it from your customer — double tax, with no retroactive refunds.
• Income and estimated taxes. You owe income tax on your profit whether or not a payment processor sends you a 1099-K. The IRS reverted the federal 1099-K reporting threshold to gross payments over $20,000 and more than 200 transactions for 2025 and beyond, per the IRS FAQ on the OBBBA change. Because nothing is withheld, most sellers must pay quarterly estimated taxes, plus self-employment tax, or face an underpayment penalty.

Set up a separate savings account and sweep a fixed percentage of profit into it every month for these. Clean, reconciled books are what let you prove your actual net income against the gross number on a 1099-K.

Where PodVector fits

Setting up the books answers "did the store make money last month?" What it doesn't answer on its own is "which orders, products, and ad campaigns actually made money right now?" PodVector connects Shopify, Meta Ads, Google Ads, Printify, and Printful and computes true per-order profit across them — so the gross-sales-minus-real-costs picture your bookkeeping enforces at month-end is available at the order level, live.

It's not a dashboard you have to read. Victor is an AI employee that analyzes your connected data and proposes moves, executing approved actions on the Shopify side with your sign-off — he reads your ad data but does not touch your ad account. Your bookkeeping stays the system of record; PodVector is the operating layer on top of it.

FAQs

Do I really need to set up bookkeeping if my store is small?

Yes. Even a store below any 1099-K threshold owes income tax on its profit, and you can't prove that profit without reconciled books. The smaller and earlier you start, the less cleanup you face later — setting up correctly on day one is far cheaper than reconstructing a year of mixed transactions.

Cash basis or accrual basis for a Shopify store?

You can start on cash basis, but accrual gives a truer picture because it matches each sale to its own fees and product costs. For an ad-driven store where cash in and cash out are days apart, cash-basis books can make a profitable month look like a loss, or vice versa. Many sellers keep accrual books for decisions and let their accountant handle the tax-basis view.

Why doesn't my Shopify payout match my sales?

Because the payout is a net settlement, not a sales figure. It's your sales minus fees, minus refunds, plus or minus adjustments and chargebacks, on a delayed rolling schedule. Always book gross sales at the top of your P&L and treat the payout as the cash result at the bottom.

What's the biggest ecommerce bookkeeping setup mistake?

Booking the net Shopify deposit as revenue. It understates your top line, hides your fees, and produces books that can't be reconciled. A close second is putting ad spend in COGS instead of operating expenses, which inflates your gross margin and hides that acquisition cost is your real risk.

Do I need bookkeeping software or can I use a spreadsheet?

A very small store can reconcile payouts by hand from Shopify's reports, but a connected tool that splits each payout into gross sales, fees, and refunds saves hours and reduces errors as volume grows. What matters is that every payout gets broken into its parts, not booked as a lump — the tool is just the fastest way to do that reliably. Compare options in our bookkeeping tools guide.

How do I handle payment processing fees in the books?

Record them on their own line, not netted into sales. A refunded order still costs you the original processing fee, so track refunds as contra-revenue and leave the fee where it was recorded. For how gateways stack fees, see our note on payment gateway pricing.