Shopify Bookkeeping — The Complete Guide for Handmade Sellers

You launched your Shopify store. Products are selling. Then your accountant asks: “What was your cost of goods sold last year?” and you realize you’ve been eyeballing it from memory.

Sound familiar? You’re not alone.

Bookkeeping for Shopify sellers is genuinely different from other small business bookkeeping — and it’s especially different for makers who produce their own products. Shopify’s payout structure, sales tax obligations, and lack of native COGS tracking create gaps that catch a lot of handmade sellers off guard.

This guide walks you through everything you need to know: what Shopify bookkeeping actually involves, where makers get tripped up, and which tools solve the right problems.

How Shopify Bookkeeping Differs from Etsy

If you’re coming from Etsy, one of the first things you’ll notice is that the bookkeeping dynamic is different in a few important ways.

Payout timing is batched, not per-sale

On Etsy, your deposit statement maps fairly neatly to your orders. Shopify Payments works differently: payouts land in your bank account on a rolling schedule (typically every 2–5 business days), and each payout bundles together multiple orders, refunds, and fees. That means you can’t just look at your bank statement and count sales — you need to reconcile each payout back to the individual transactions it covers.

This is where a lot of Shopify sellers run into trouble at tax time. The bank shows one lump transfer; your actual income for that period is spread across dozens of orders.

You’re responsible for collecting sales tax (mostly)

This is the big one. Etsy acts as a marketplace facilitator in most US states, which means Etsy collects and remits sales tax on your behalf. Shopify does not — or at least not automatically.

When you sell through Shopify, you are responsible for collecting the right amount of sales tax for each order and remitting it to the correct state agencies. Shopify can help you charge the right rate if you configure it correctly, but the compliance responsibility sits with you.

For more background on how this works, see our guide to Shopify marketplace facilitator taxes.

Fee structure is different

Etsy charges per-listing, per-transaction, and payment processing fees. Shopify charges a monthly subscription fee plus transaction fees (unless you use Shopify Payments — in which case the transaction fee is waived, replaced by a payment processing fee). These need to be tracked as business expenses correctly to get an accurate picture of your margins.

COGS is on you

Shopify has basic inventory tracking built in. What it doesn’t do is calculate your cost of goods sold from raw materials. For makers, COGS isn’t just the wholesale price of a finished product — it’s the cost of the materials, labor, and overhead that went into making it. Shopify doesn’t track any of that. You need a separate system.

5 Shopify Bookkeeping Best Practices for Makers

1. Reconcile payouts, not transactions

The temptation is to just record each Shopify payout as “income” when it hits your bank. Don’t. The payout is not your revenue — it’s a net transfer after fees and refunds. Your revenue is the gross sales amount for the period.

Set up a system (either in your accounting software or a spreadsheet) to map each payout back to the orders it covers. If you use Craftybase alongside Shopify, this is handled for you through the Shopify integration — orders sync automatically on a daily basis.

2. Separate your business and personal finances immediately

Open a dedicated business bank account and route all Shopify income and expenses through it. This isn’t just tidy — it’s necessary for accurate bookkeeping and will save you hours of reconstruction work when tax season arrives.

Most US makers who sell on Shopify should also consider a business credit card for supply purchases. The paper trail makes material cost tracking much more straightforward.

3. Track your materials and COGS from day one

This is the step most makers skip when they’re just getting started — and the one they regret most at tax time. Your COGS (cost of goods sold) is a deductible business expense, but you need documentation to support it.

For makers, COGS includes:

• Raw materials used in production
• Packaging and supplies
• Direct labor costs

Without a system tracking material usage per product, you’re guessing. Our guide to how to calculate COGS explains the mechanics; the short version is that you need to know what went into each product you sold during the year.

See also: Managing your inventory on Shopify for the basics of keeping stock levels accurate.

4. Set up sales tax correctly — and check your nexus

Shopify can automatically calculate and collect sales tax if you enable it in your settings. But before you do, you need to understand where you have sales tax nexus — meaning which states you’re obligated to collect tax in.

The threshold has changed. Most states now have economic nexus rules that kick in at $100,000 in sales or 200 transactions per year in that state. If you’re selling across the US on Shopify and growing, this is something you need to actively monitor — not just a “deal with it later” issue.

Once you have nexus and are collecting tax, that money isn’t yours. Keep it in a separate account until you remit it. Commingling sales tax with your operating funds is a common trap.

5. Review your finances monthly, not just at tax time

Set a recurring monthly appointment to review your Shopify income, expenses, and margins. Specifically:

• Are your product margins where you expect them to be?
• Are any materials becoming more expensive and squeezing your COGS?
• Are your Shopify fees as a percentage of revenue creeping up?

Doing this monthly means you catch problems while they’re still fixable, rather than discovering them in April when you’re filing.

What Records Do Shopify Sellers Need to Keep?

At minimum, you need documentation of:

• All sales income — even transactions below the 1099-K threshold
• Material and supply purchases — receipts, invoices, supplier bills
• Shopify fees paid — subscription fees, payment processing fees, app costs
• Shipping costs — both what you charged customers and what you paid carriers
• Home studio or workspace expenses — if you work from home, a portion may be deductible
• Equipment purchases — cameras, tools, packaging equipment used for the business
• Beginning and ending inventory values — needed for COGS calculation at year end

The IRS recommends keeping business records for at least three years from the date you filed the return they relate to. If you’re ever audited, these are the documents that substantiate your deductions.

How to Track COGS in Shopify

Shopify tells you how many units you have in stock. It does not tell you what it cost you to make those units from raw materials.

For resellers — people buying finished goods wholesale and selling them on Shopify — Shopify’s built-in cost per item field works fine. You enter the cost, Shopify records it, done.

For makers who produce their own products, it’s more complex. You need to track:

1. What materials went into each product (your “recipe” or bill of materials)
2. How much you paid for those materials
3. How much of each material was consumed when you made a batch

This is sometimes called recipe costing or bill of materials costing. Shopify doesn’t support it natively. Most makers handle this one of three ways:

Option 1: Spreadsheets. Works when you have a handful of products. Becomes unmanageable quickly as your range expands or material prices change. Every time a supplier increases prices, you’re manually updating formulas across your entire product catalog.

Option 2: Shopify inventory apps. Some Shopify apps add inventory tracking features. Most are built for retail and wholesale models — they assume a fixed cost per unit, not a cost-per-recipe that changes with material prices.

Option 3: Dedicated maker software. Tools like Craftybase are built specifically for makers who manufacture their own products. You enter your materials and recipes once; Craftybase calculates your cost per unit automatically using current material prices, and tracks COGS as your orders sync from Shopify.

Shopify Bookkeeping Tools Compared

QuickBooks Online

QuickBooks is the most widely used accounting software for small businesses and integrates reasonably well with Shopify through a few connector apps. It handles income, expenses, and bank reconciliation well.

Where QuickBooks falls short for makers: it doesn’t natively track raw material inventory or calculate COGS from recipes. You can record COGS as a manual journal entry, but that requires you to calculate it yourself first — which brings you back to the spreadsheet problem.

If you’re already committed to QuickBooks for your broader bookkeeping, pairing it with Craftybase is a popular approach for Shopify makers. Craftybase calculates your exact COGS from material usage; you can then push those numbers to QuickBooks as journal entries. See our guide on the Shopify QuickBooks integration for what that workflow looks like in practice.

Xero

Xero is strong on financial reporting and multi-currency support — a good choice if you’re selling internationally through Shopify. Like QuickBooks, it doesn’t track raw materials or calculate production COGS. You’ll need a separate tool for that piece.

A2X

A2X is specifically built for Shopify (and Amazon/Etsy) sellers. Its main value is payout reconciliation: it takes your Shopify payout data and maps it to the correct income and expense accounts in your accounting software automatically. If the payout reconciliation problem is your biggest headache, A2X is worth looking at.

Note that A2X handles accounting reconciliation only — it doesn’t track inventory or calculate COGS for makers.

Craftybase

Craftybase is purpose-built for makers who sell on Shopify. Where it differs from general accounting tools:

• Recipe costing: Enter your materials and the quantities used per product. Craftybase calculates your cost per unit automatically.
• Material inventory tracking: Know what you have on hand and when to reorder — see how to track low stock in Shopify.
• Order sync: Orders pull in from Shopify automatically each day. No manual entry.
• COGS reports: Year-end COGS figures are generated from actual material usage — not estimates.
• Expense tracking: Track business expenses and generate profit reports alongside your inventory data.

For many Shopify makers, Craftybase replaces the need for a separate accounting tool entirely. If you have a more complex business (multiple entities, employees, accrual accounting), you may still want QuickBooks alongside it — but for most independent makers selling on Shopify, Craftybase handles the full picture.

Start a 14-day free trial → — no credit card required.

Frequently Asked Questions

Get Your Shopify Bookkeeping Under Control

Good bookkeeping doesn’t happen by accident on Shopify — it takes the right system in place from the start. For makers especially, that means going beyond what Shopify gives you natively.

Know your payout reconciliation process. Get your COGS tracked from actual material costs. Understand your sales tax obligations before they become a problem. And pick tools that fit how you actually work — not tools designed for resellers or service businesses.

If you want a bookkeeping and inventory tool that’s built for makers who sell on Shopify — one that tracks your materials, calculates your COGS, and keeps your financials tidy year-round — Craftybase offers a 14-day free trial with no credit card required.