Shopify Accounting: The Complete Guide for Store Owners

If you run a Shopify store and your accounting is a mess — or you're just getting started and want to set it up right from the beginning — this guide covers everything you need to know. Shopify accounting isn't complicated, but there are a handful of concepts that trip up nearly every new store owner: how payouts work, how to handle sales tax correctly, what counts as revenue vs. income, and how to track your actual profit margin.

This guide walks through each of these in plain language, with specific QuickBooks guidance throughout.

What You Need to Track in Shopify Accounting

Running a Shopify store generates several different types of financial events, and each needs to be recorded differently in your accounting software.

1. Sales Revenue

Every order your store processes is a revenue event. In QuickBooks, sales revenue should be recorded at the gross order amount — the price the customer paid for the product — before any fees or deductions.

Common mistake: recording only the net payout you receive from Shopify as revenue. This understates your revenue and understates your expenses simultaneously. Your P&L ends up compressed and inaccurate even if the net number looks right.

2. Shopify Fees

Shopify charges you multiple types of fees that are deducted from your payouts:

• Transaction fee (0.5%–2%): Charged if you use a third-party payment processor instead of Shopify Payments
• Processing fee (2.4%–2.9% + 30¢): Charged by Shopify Payments for card processing
• Monthly subscription: Your Shopify plan cost ($39–$399/month depending on plan)
• Shopify shipping label costs: Charged when you buy shipping through Shopify
• App fees: Third-party app charges sometimes deducted directly from payouts

All of these are business expenses. They should be recorded in QuickBooks as expenses, not as reductions to revenue. This distinction matters for your P&L and for understanding your true cost of selling through Shopify.

3. Refunds

When a customer returns a product and receives a refund, you need to record the reversal of revenue. In QuickBooks, use a Sales Returns & Allowances account (a contra-revenue account) to track refunds separately from your gross revenue. This gives you a visible refund rate you can monitor over time.

Shopify deducts refunds from your next payout. The refund appears as a negative amount in your settlement data.

4. Cost of Goods Sold (COGS)

COGS is the cost of the products you sell — what you paid your supplier or manufacturer. COGS is separate from Shopify fees. It represents the direct cost of the merchandise itself.

COGS should be recorded when the sale occurs (not when you purchase inventory). In QuickBooks:

• Set up a Cost of Goods Sold account (if not already present)
• Record COGS at your product cost each time a sale closes
• Track inventory as a current asset that decreases when COGS is recognized

For many Shopify sellers, especially dropshippers, the COGS entry is a manual estimate or is recorded from purchase orders rather than automatically from Shopify. Shopify itself doesn't push COGS to QuickBooks.

5. Sales Tax

Whether you need to track sales tax in QuickBooks depends on whether Shopify collects and remits it for you. In most US states, Shopify is a marketplace facilitator and handles remittance entirely — you never see the tax money and don't need to record a liability. In a few states, you still handle remittance yourself and need to track Sales Tax Payable.

See our detailed guide on Shopify sales tax in QuickBooks for the full breakdown.

6. Shopify Payouts

Shopify payouts are the net deposits that hit your bank account — gross sales minus fees and refunds. Payouts happen every 1–3 business days depending on your plan and location.

A critical point: do not record the payout amount as your revenue. The payout is net of fees and refunds. If you record it as income, you're understating both revenue and expenses. Record each payout as a journal entry that breaks out all components, with the net payout amount posted to your bank account.

Setting Up QuickBooks for a Shopify Store

Chart of Accounts

Before you start recording Shopify transactions, make sure your QuickBooks chart of accounts is set up with the right categories. Here's a recommended structure:

Income accounts: - Sales Revenue (or Product Revenue) - Shipping Revenue (amounts charged to customers for shipping)

Contra-revenue accounts: - Sales Returns & Allowances

Expense accounts: - Payment Processing Fees (Shopify transaction + processing fees) - Software Subscriptions (Shopify monthly plan) - Postage & Delivery (Shopify shipping labels)

Cost of Goods Sold: - Cost of Products Sold

Liability accounts: - Sales Tax Payable (only needed if you remit your own tax in any state)

You don't need separate accounts for every Shopify fee type — grouping transaction fees and processing fees together under Payment Processing Fees is standard practice and keeps your P&L readable.

Accounting Method: Cash vs. Accrual

Most small Shopify stores use cash-basis accounting — revenue is recognized when the payout hits your bank account, and expenses are recognized when they're paid. This is simpler and is what most small business owners do.

Accrual accounting recognizes revenue when the sale occurs (when the order is placed) and expenses when they're incurred. This gives a more accurate picture of your business's financial position but is more complex. If your store is growing quickly, your accountant may recommend switching to accrual — but cash-basis works fine for most stores under $1M in revenue.

Shopify Bookkeeping: The Monthly Workflow

For most Shopify stores, the monthly bookkeeping workflow looks like this:

Weekly (or per-payout)

1. Download your Shopify payout report from Finances > Payouts
2. Create a journal entry in QuickBooks for each payout: gross revenue credited, fees and refunds debited, net payout amount debited to bank
3. Verify the journal entry balances — total debits equal total credits, bank debit matches the actual deposit
4. Match against your bank feed in QuickBooks to reconcile

If you use SettleBooks, you upload the payout file and get a balanced, categorized journal entry in under 60 seconds — ready to import into QuickBooks directly.

Month-End

1. Run bank reconciliation in QuickBooks — match every entry against your bank statement
2. Review the P&L — compare gross revenue, fees, refunds, and COGS. Do the margins look right?
3. Check Sales Tax Payable (if applicable) — make sure the balance matches what you owe
4. Record any outstanding COGS if you haven't been tracking it in real time

Quarterly or Annually

1. Sales tax filing — if you're in states where you handle remittance, file and pay
2. Inventory count — reconcile physical inventory against what your books show
3. 1099-K reconciliation — Shopify issues a 1099-K for gross sales. Your accountant will need to reconcile this against your QuickBooks gross revenue figure

Understanding Shopify's 1099-K

If your store processes more than $600 in payments annually, Shopify will issue a 1099-K (as of the current IRS threshold). The 1099-K reports gross sales including sales tax and refunds — which may differ from what's in your QuickBooks if you've excluded marketplace facilitator tax.

This is a common source of confusion at tax time. Your accountant will need to reconcile the 1099-K total against your QuickBooks revenue. The difference is explained by:

• Tax collected and remitted by Shopify (not your revenue, but included in 1099-K)
• Returns and refunds (deducted in your books, may or may not be excluded from 1099-K depending on timing)

Document these reconciling items so your accountant can file accurately. A mismatch between 1099-K and reported income without documentation is a red flag for auditors.

Shopify Profit and Loss: How to Read Your Numbers

Once your Shopify accounting is set up correctly, your QuickBooks P&L for a Shopify store should look like this:

Revenue
  Sales Revenue                    $48,000
  Shipping Revenue                  $2,400
  Sales Returns & Allowances       ($3,200)
  Net Revenue                      $47,200

Cost of Goods Sold
  Cost of Products Sold            $18,500
  Gross Profit                     $28,700

Operating Expenses
  Payment Processing Fees           $1,440
  Software Subscriptions              $399
  Postage & Delivery                $1,200
  [Other operating expenses]

Operating Income                   $25,661

Gross margin = Gross Profit / Net Revenue = 60.8% in this example. For a product-based Shopify store, gross margins typically range from 40%–70% depending on product category.

Net margin = Operating Income / Net Revenue. This is your true profitability after all Shopify fees and operating costs.

If your QuickBooks P&L looks wrong — margins that seem too high or too low, revenue that doesn't match your Shopify dashboard, or fees that appear inflated — the most common cause is incorrect journal entry structure (recording net payouts as revenue, or misclassifying fees as revenue reductions).

Shopify Bookkeeping for Different Business Models

Dropshipping

For dropshipping stores, COGS is typically the supplier invoice amount per order. You don't hold inventory, so there's no inventory asset to track. Record COGS when the order is fulfilled and you pay your supplier.

Key challenge: matching supplier invoices to orders accurately. Many dropshippers use a COGS estimate (average product cost × units sold) rather than order-by-order tracking.

Print-on-Demand

Similar to dropshipping — the print-on-demand supplier charges you per order, which is your COGS. No inventory asset. Revenue recognized when the order is fulfilled.

Inventory-Based Products

If you manufacture or hold inventory, you need to track: - Inventory asset: the value of goods on hand (what you paid for unsold units) - COGS: recognized when inventory is sold, reducing the asset and recording the cost

QuickBooks Online Plus and Advanced support inventory tracking. Simple Start and Essentials do not.

Subscription Products

If you sell Shopify subscriptions (via Recharge or similar), revenue recognition is more complex — you're receiving payment upfront but recognizing revenue over the subscription period. Consult your accountant about the right approach. For most small stores, recognizing subscription revenue at the time of payment (cash-basis) is acceptable.

Connecting Shopify to QuickBooks

Getting data from Shopify into QuickBooks is the central challenge of Shopify accounting. You have three options:

Manual journal entries: Download your payout CSV from Shopify and build journal entries in QuickBooks by hand. Takes 20–45 minutes per payout. Error-prone but gives full control.

Shopify's built-in export: Limited to QuickBooks Desktop, doesn't include fees, requires manual triggering. Not viable for QBO users.

Automated sync: Use a tool to convert Shopify settlement data to QuickBooks journal entries automatically. SettleBooks processes your payout file and produces a balanced, ready-to-import journal entry in under 60 seconds. No API connection required — just download your Shopify settlement file and upload it.

For a detailed comparison of all three methods, see our Shopify QuickBooks integration guide.

Shopify Accounting FAQs

Do I need an accountant for my Shopify store?

A bookkeeper (or yourself, with the right setup) can handle the day-to-day recording. An accountant is valuable for tax filing, especially for reconciling your 1099-K, handling sales tax nexus questions across states, and structuring your business correctly. Many small Shopify stores handle their own bookkeeping and use a CPA only at tax time.

What accounting software should I use with Shopify?

QuickBooks Online is the most common choice for Shopify stores — it's widely supported by accountants and bookkeepers and integrates with most third-party tools. Xero is a strong alternative, particularly popular in the UK, Australia, and Canada. Sage is less common but preferred by some businesses and industries.

How do I handle Shopify accounting if I sell internationally?

International orders introduce currency conversion complexity. Shopify converts foreign currency amounts to your home currency at the time of payout. Use the Shopify payout amount (in your home currency) as the basis for your journal entry — it's the actual amount you received. For significant international volume, QuickBooks Online's multicurrency feature can help track exchange rate differences.

How often should I reconcile my Shopify books?

At minimum, monthly. Weekly is better. Catching errors early is much easier than untangling months of incorrect entries. With each payout taking 60 seconds in SettleBooks, there's no reason to let it accumulate.

Can I do my Shopify accounting myself, or do I need a bookkeeper?

You can absolutely handle it yourself with the right workflow. The main risk is falling behind — once you're three months behind on reconciliation, catching up is genuinely painful. The other risk is incorrect journal entry structure (the net-payout-as-revenue mistake described above). If you set up your QuickBooks chart of accounts correctly from the start and record each payout with proper gross revenue + fees + refunds structure, the mechanics aren't difficult.

---

The clearest path to accurate Shopify accounting: set up your QuickBooks chart of accounts correctly, record every payout as a balanced journal entry with gross revenue and itemized fees, handle sales tax according to your nexus situation, and reconcile monthly. SettleBooks makes the payout-to-journal-entry step fast and error-free — try it free, no credit card required.