Growthy
AI Bookkeeping

AI & Automation

AI BookkeepingHow AI is changing transaction categorization, bank reconciliation, and bookkeeping workflows.
AI for Accountants
Bookkeeping Automation
QuickBooks Automation

Payments & Reconciliation

Stripe Bookkeeping Guide: Payouts, Fees, Refunds, and QBO/Xero
Payment Reconciliation: How to Match Merchant Deposits to Gross Revenue in 2026
Accounts Payable Workflow for Bookkeepers: 2026 (3-Way Match, AP Aging, Vendor Recs, 1099 Roll-Up)
QuickBooks Integrations

Industry Guides

Ecommerce Accounting: A Practitioner's Guide to Payouts, Fees, Inventory, and Multi-Channel Books
SaaS Accounting: A Practitioner's Guide to Revenue Recognition, Deferred Revenue, and the Books Behind the Subscription
1099 Filing

Foundations

Chart of Accounts: The Complete Guide for Bookkeepers
Asset Account CategoriesEquity Accounts ExplainedExpense Account CategoriesView all →
Glossary
Balance Sheet TermsBookkeeping Foundation TermsIncome Statement TermsView all →
Bookkeeper Scaling

More Topics

Accounts Receivable Management: A Bookkeeper's Guide to Aging, Collections, and Getting Paid
For BookkeepersFor AccountantsPricing
Join the Alpha
Growthy

© 2026 Growthy. All rights reserved.

  1. Blog
  2. Chart of Accounts: The Complete Guide for Bookkeepers
  3. How to Categorize Shopify in QuickBooks (Subscription, Payments, Capital, Apps)

How to Categorize Shopify in QuickBooks (Subscription, Payments, Capital, Apps)

Bobby Huang

Partner, SDO CPA LLC / CEO, Growthy

May 20, 2026
9 min read
Chart of Accounts: The Complete Guide for Bookkeepers
How to Categorize Shopify in QuickBooks (Subscription, Payments, Capital, Apps)

In this article

How to Categorize Shopify in QuickBooks (Subscription, Payments, Capital, Apps)

One Shopify bill is never one thing. The $79 monthly subscription rides alongside Shopify Payments processing fees, a Klaviyo app charge, three shipping label purchases, and maybe a Shopify Capital repayment. Most bookkeepers dump the whole stack into a single "Shopify expense" line and move on. That's how books rot.

The real problem starts when Shopify deposits hit the bank. Shopify Payments sends you the net, not the gross. Your $3,000 sales day shows up as $2,847.92 in the bank. If you book that deposit as revenue, your fees never hit the P&L and your gross sales are wrong by 5%. Then add sales tax collected (a liability, not income), a Capital advance (a loan, not revenue), and the wheels come off. This guide shows the right way to split Shopify across your chart of accounts. It covers the pricing tiers ($29 Basic, $79, $299, $2,300+ Plus) and the eight edge cases that bite e-commerce sellers every quarter.

How do you categorize Shopify in QuickBooks?

Shopify is two or more different categories on the same bill. The monthly subscription ($29 to $2,300+) goes to Software or Dues & Subscriptions, Schedule C Line 27a. Shopify Payments processing fees (2.9% + $0.30 typical) go to Merchant Account Fees, also Line 27a. App subscriptions billed through Shopify (Klaviyo, Recharge) get categorized to that app's vendor account, not Shopify. A Shopify Capital advance is a Notes Payable liability, not income; repayments split between principal and interest. You don't issue a 1099 to Shopify (corporate). Shopify sends you a 1099-K if you cross $20,000 AND 200 transactions in TY2026 (OBBBA reverted threshold). Every Shopify Payments deposit splits into Gross Sales, Fees contra, Refunds, and Sales Tax Payable.

Key Takeaways

  • Two-part GL split is non-negotiable - Subscription goes to Software/Dues & Subscriptions; Payments fees go to Merchant Account Fees. Same vendor, two accounts.
  • Net vs gross deposit trap - Shopify Payments deposits net of fees and refunds. Book the deposit as one revenue line and your P&L understates both sales and expenses.
  • 1099-K threshold for TY2026 is $20,000 AND 200 transactions - OBBBA reverted the threshold from the $5,000 interim. Refresh annually.
  • Sales tax collected is a liability, not revenue - Shopify Tax collections go to Sales Tax Payable until remitted. Booking as income inflates revenue and creates a tax mess.
  • Shopify Capital advance is a loan - Notes Payable on the balance sheet. Repayments split: principal reduces the loan, interest hits Schedule C Line 16b.
  • App subscriptions get their own GL - Klaviyo on a Shopify bill is still Klaviyo. Each app is its own vendor (Marketing, Software, Subscriptions) regardless of who collects the payment.

What is Shopify?

Shopify is an e-commerce platform that bundles your online storefront, hosting, checkout, inventory, and POS into one subscription. Plans run from Basic at $29/month to Shopify Plus at $2,300/month and up. Most stores also use Shopify Payments, the built-in processor, at 2.9% + $0.30 per online card transaction (rates drop on higher tiers). Around 5 million+ active stores run on Shopify. The platform also sells discounted shipping labels, third-party apps through the App Store, and merchant cash advances through Shopify Capital, all billed to the same account.

Where Shopify goes in your books

Shopify has two distinct line items on almost every account. Map them separately or your e-commerce books won't reconcile.

Part A: Shopify subscription

Field

Value

QBO account

Software OR Dues & Subscriptions (Detail Type: Software)

Xero account code

463 (Subscriptions) OR 408 (Software & IT)

Schedule C

Line 27a (Other expenses, "E-commerce platform subscription")

MCC

7372 (Data Processing)

1099-NEC to Shopify

No. Shopify Inc. (NYSE: SHOP) is a C-corp, §6041 exemption

Sales tax on subscription

State-dependent. As of 2026, generally taxable in states like TX (taxed as data processing, ~80% of the charge), NY, OH, WA and generally exempt in CA, FL, but treatment varies by state and locality and changes often. Verify your state's (and city's) current rule.

Part B: Shopify Payments processing fees

Field

Value

QBO account

Merchant Account Fees OR Bank Charges (sub-account "Shopify Payments Fees")

Xero account code

410 (Merchant Fees) or sub-account under Bank Fees

Schedule C

Line 27a ("Merchant processing fees")

1099-K issued by Shopify to you

Yes if you cross $20,000 AND 200 transactions (TY2026 OBBBA)

Sales tax on fees

Not subject. Processing fees aren't taxable.

The Difficult 20%: The Shopify Trap List

These are the edge cases that turn a clean Shopify file into a quarter-end fire drill.

1. Net vs gross deposit

A Shopify Payments deposit of $2,847.92 isn't $2,847.92 of revenue. It's gross sales of $3,000 minus processing fees of $86.50 minus a refund of $65.58. Book it as three lines: Gross Sales $3,000 (revenue), Shopify Fees $86.50 (contra-revenue or Merchant Account Fees), Refunds $65.58 (contra-revenue). Naive bookkeepers post the deposit as one revenue line, and the fees never hit the P&L. Sales are understated, expenses are understated, gross margin lies.

2. Sales tax collected via Shopify Tax

If Shopify Tax is enabled, Shopify collects state sales tax at checkout and includes it in the deposit. That sales tax is NOT your revenue. It's a Sales Tax Payable liability you owe the state. Split the deposit so the sales tax portion lands on the balance sheet, not the P&L. Shopify remits or you remit per each state's filing schedule.

3. Subscription vs Payments vs Apps

Three different lines on one Shopify invoice, three different GLs. Monthly subscription = Software. Per-transaction Payments fees = Merchant Account Fees. App charges (Klaviyo, Recharge, Yotpo) = that app's vendor category. Lumping all three into "Shopify" hides where the money actually goes.

4. Shopify Shipping labels

Discounted USPS, UPS, and DHL labels billed through Shopify are shipping costs, not platform fees. For product sellers, shipping out is COGS (Schedule C Line 38, Materials & supplies, for resellers). For service businesses shipping samples or returns, it's Line 22 (Supplies).

5. Shopify Capital advance

A Shopify Capital advance is a loan. Book the inbound funds as Notes Payable (liability), not as revenue. Repayments are deducted from each daily Shopify Payments deposit. Each repayment splits between principal (reduces the loan balance) and interest expense (Schedule C Line 16b). Booking the original advance as income inflates revenue by tens of thousands and then double-counts the repayment as an expense. It's the most common Shopify Capital error.

6. POS hardware

Card readers, terminals, and Shopify POS hardware are capital purchases. Book to Equipment as an asset and depreciate, or expense to Office Supplies if the invoice is under the §263 de minimis safe harbor ($2,500 per invoice for taxpayers without an audited financial statement). Don't bury hardware in "Shopify subscription".

7. Returns and chargebacks

Refunds are contra-revenue, not an expense. Shopify chargeback dispute fees ($15 typical) go to Bank Charges. If the chargeback is upheld, the lost revenue is a refund (contra-revenue) plus the fee.

8. App subscriptions on the Shopify bill

Apps like Klaviyo (email), Recharge (subscriptions), Yotpo (reviews), and ShipStation often bill through your Shopify account for convenience. Ride-along billing doesn't change the category. Klaviyo is still Marketing/Software with Klaviyo as the vendor, not Shopify. Otherwise you can't see what each app actually costs.

How Growthy categorizes Shopify automatically

Growthy spots the Shopify lines on your bank feed and suggests a category from pattern learning across your books: subscription to Software, Payments fees to Merchant Account Fees, app charges to their own vendor. Unusual or first-time items, like a Capital advance or a chargeback, get flagged for your review. You review and approve every suggestion.

FAQ

What expense category is Shopify in QuickBooks?

Shopify is two categories. The monthly subscription is Software (or Dues & Subscriptions). Shopify Payments processing fees are Merchant Account Fees. App charges billed through Shopify are categorized to each app's vendor.

How do I separate Shopify subscription from Shopify Payments fees?

Look at the Shopify billing statement, not just the bank feed. The statement breaks out subscription fees, processing fees, app charges, shipping labels, and Capital repayments. Book each line to its own GL. In QBO, use sub-accounts under Shopify if you want the same parent vendor.

Do I record Shopify sales as gross or net?

Gross. Always gross. The Shopify Payments deposit is net of fees and refunds, but for accurate revenue, COGS, and gross margin reporting, post gross sales to revenue, then book the fees and refunds as separate lines.

Will Shopify send me a 1099-K?

For TY2026, yes if you cross both $20,000 in gross payments AND 200 transactions through Shopify Payments. OBBBA reverted the threshold from the $5,000 interim. Even if you don't get a 1099-K, you still report all revenue. The form doesn't define what's taxable.

How do I categorize Shopify Capital?

The advance is Notes Payable (balance sheet liability), not revenue. Each repayment splits between principal (reduces the loan) and interest (Schedule C Line 16b). Track the loan balance separately from any other Shopify activity.

What Schedule C line covers Shopify?

Both the subscription and the Payments processing fees go on Line 27a (Other expenses), labeled separately as "E-commerce platform subscription" and "Merchant processing fees". Shipping labels go on Line 38 (Materials & supplies) for resellers or Line 22 (Supplies) for service businesses. Capital advance interest goes on Line 16b.

How do I record Shopify sales tax collected?

Sales tax collected at checkout is Sales Tax Payable, a balance sheet liability. It's not revenue. When you (or Shopify) remit to the state, you reduce the liability. If you book it as revenue, you'll overstate income and have to unwind the mess at tax time.

Do I issue a 1099 to Shopify?

No. Shopify Inc. is a publicly traded C-corp (NYSE: SHOP), exempt from 1099-NEC reporting under §6041.

Related

  • Chart of accounts hub
  • How to categorize Stripe fees (payment-processing parallel)
  • How to categorize Amazon Business (e-commerce supplies parallel)
  • How to categorize Adobe Creative Cloud

Stop letting Shopify Payments rot your books. Get started with Growthy and let pattern learning suggest the split, so you're reviewing instead of rebuilding it by hand.

1099-K TY2026 threshold ($20,000 + 200 transactions) verified against tax-thresholds-2026.yaml on 2026-07-03 per OBBBA. Pricing verified shopify.com/pricing 2026-05-20. Sales-tax remittance via Shopify Tax varies by state and nexus.

Growthy is bookkeeping software, not a CPA firm. This content is educational, not professional advice.

Continue reading

  • What Category Is Accountant / CPA Fees? (Chart of Accounts Guide)
  • Asset Account Categories: Current, Fixed & Other Assets Explained
  • What Category Is Attorney / Lawyer Fees? (Chart of Accounts Guide)
  • What Category Is Bank Fees & Interest? (Chart of Accounts Guide)
  • What Category Is Business Insurance? (Chart of Accounts Guide)
  • What Category Is Contractor Payments (1099)? (Chart of Accounts Guide)
  • What Category Is Employee Benefits? (Chart of Accounts Guide)
  • Equity Accounts Explained: Owner's Equity, Retained Earnings & More
  • Expense Account Categories: Complete List for Bookkeepers
  • Liability Account Categories: What You Owe and Where It Goes
  • What Category Is Marketing & Advertising? (Chart of Accounts Guide)
  • What Category Is Meals & Entertainment? (Chart of Accounts Guide)

See It Work on Your Data

Free during alpha. Read-only access. You review every sync.

✓ No credit card✓ Works with QuickBooks✓ 85% accuracy
Request Early Access

Bobby Huang • Partner, SDO CPA LLC / CEO, Growthy

CPA firm partner who got tired of watching bookkeepers click categorize 500 times a day. Built Growthy to fix it.

View author profile

Growthy is dedicated to helping businesses of all sizes make informed decisions. We adhere to strict editorial guidelines to ensure that our content meets and maintains our high standards.

Keep reading

white printer paperr
Chart of Accounts: The Complete Guide for Bookkeepers

How to Categorize Calendly in QuickBooks (and Xero)

Calendly posts to Software or Dues & Subscriptions, Schedule C Line 27a. No 1099. Per-seat billing prorates mid-cycle. Annual prepays deduct in full under the 12-month rule.

B
Bobby Huang
9 min
Featured image for How to Categorize Slack in QuickBooks (and Xero)
Chart of Accounts: The Complete Guide for Bookkeepers

How to Categorize Figma in QuickBooks (and Xero)

Figma posts to Software or Dues & Subscriptions, Schedule C Line 27a. No 1099. Per-editor billing means a free viewer who edits can jump your bill mid-cycle. Annual prepays deduct under the 12-month rule.

B
Bobby Huang
9 min
Featured image for How to Categorize Zoom in QuickBooks (and Xero)
Chart of Accounts: The Complete Guide for Bookkeepers

How to Categorize Zoom in QuickBooks (and Xero)

Zoom posts to Software or Dues & Subscriptions, Schedule C Line 27a. No 1099. Zoom Phone is telecom, not software; Zoom Rooms hardware capitalizes separately. Annual prepays deduct under the 12-month rule.

B
Bobby Huang
8 min