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, with 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
Part B: Shopify Payments processing fees
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 splits each Shopify Payments deposit into gross sales, fees contra, refunds, and Sales Tax Payable using pattern learning, with a confidence score on every line. Capital advances and unusual chargebacks get flagged for human review. You review and approve the splits in one pass instead of manually unpacking every deposit.
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
Stop letting Shopify Payments rot your books. Get started with Growthy for automatic net-vs-gross splits with audit trail.
1099-K TY2026 threshold ($20,000 + 200 transactions) verified against tax-thresholds-2026.yaml on 2026-05-20 per OBBBA. Pricing verified shopify.com/pricing 2026-05-20. Sales-tax remittance via Shopify Tax varies by state and nexus.
