Guide · 7 min read

    Shopify bookkeeping

    Shopify isn't accounting software. It collects money and reports sales — but tracking fees, inventory cost, sales tax, and real profit is on you. Here's the simplest setup that works.

    Where Shopify stores lose money to bad books

    Shopify Payments deposits net of fees. If you only record deposits, you'll under-deduct ~2.9–3.5% of revenue in processing fees. On $200k in sales that's $5,800 of missed deductions per year. Multiply by other apps (Klaviyo, Recharge, Shipstation) and a typical store leaves $10–20k in deductions on the table.

    The 5-step Shopify bookkeeping system

    1. 1

      Dedicated business bank account

      Connect a free business checking account to Shopify Payments as the deposit account. Never run store money through your personal account.

    2. 2

      Pull monthly Finances reports

      Shopify Admin → Finances → Payouts and Finances → Summary. Export CSV monthly. These reports break each deposit into sales, refunds, fees, and adjustments.

    3. 3

      Record gross sale + fee separately

      Every order: gross sale (positive), processing fee (negative). Not just the deposit. This is the single biggest fix for Shopify bookkeeping accuracy.

    4. 4

      Track inventory cost (COGS)

      Log per-unit cost when you buy inventory. When Shopify reports a sale, the corresponding COGS becomes a deductible expense. Without this, you can't tell profitable SKUs from losers.

    5. 5

      Hold sales tax separately

      Move collected sales tax to a separate savings account weekly. Use Shopify Tax or TaxJar to determine where you owe; never spend collected tax.

    Shopify-specific deductible expenses

    Shopify subscription plan
    Shopify Payments processing fees
    Third-party payment fees (PayPal, Shop Pay Installments)
    App subscriptions (Klaviyo, Recharge, Yotpo, etc.)
    Theme purchases & customization
    Domain & SSL costs
    Shipping & fulfillment (ShipStation, ShipBob)
    Cost of goods sold (per SKU)
    Packaging & shipping supplies
    Returned merchandise & refunds
    Ads (Meta, Google, TikTok, influencer)
    Email marketing platforms
    Photography & product shoots
    Inventory storage / 3PL fees

    Shopify bookkeeping in 15 min/week

    Reconcile payouts, separate fees, track inventory cost, and see real margin per month.

    Start free

    Related

    FAQ

    Does Shopify do my bookkeeping?+

    No. Shopify processes payments and gives you sales reports, but it isn't accounting software. It doesn't track cost of goods, inventory value, fees from non-Shopify payment processors, or expense categories. You still need a bookkeeping layer on top.

    How do I record Shopify Payments deposits?+

    Shopify Payments deposits net of fees (around 2.9% + 30¢ for online cards). Always record the gross sale and the processing fee separately — not just the deposit — or you'll undercount deductible fees. Pull the Finances → Payouts report monthly.

    What about sales tax?+

    Shopify can collect sales tax for you (Shopify Tax), but doesn't remit it — that's on you. Treat collected sales tax as a liability, not income. Many small Shopify stores get burned by spending sales tax money and owing it later.

    Cash or accrual accounting?+

    Cash basis is simpler and works for most Shopify stores under $1M average revenue. If you hold significant inventory year-round, accrual (with inventory accounting) gives a more accurate picture and may be required — talk to a CPA at $500k+.

    What's the easiest setup?+

    One dedicated business bank account connected to Shopify Payments. Download the monthly Finances Summary CSV. Categorize sales, refunds, fees, shipping income, and shipping cost separately. Tag COGS per SKU as inventory ships.