Most "Shopify accounting with QuickBooks" guides stop at "connect the two and reconcile." That leaves out the two things that actually decide whether your books are trustworthy: how Shopify's payouts get recorded, and where your profit truth lives. This guide fixes both, with a worked month you can copy.
Does Shopify connect to QuickBooks directly?
Not in a way you'd want to run your books on. QuickBooks does not offer a native, accounting-grade integration with Shopify — you need a third-party tool to move the data cleanly, as Finaloop lays out in its Shopify bookkeeping breakdown.
There are three common paths:
- A bridge app (A2X, Link My Books) that turns each Shopify payout into a categorized summary entry in QuickBooks. This is the setup most ecommerce accountants recommend.
- The QuickBooks Online Shopify app, which pulls orders order-by-order. It works, but it can create duplicate or mismatched transactions that are painful to reconcile.
- Manual entry from Shopify's finance reports. Doable for a very small store, but it must actually be done every month.
Whichever you choose, the goal is the same: your Shopify data has to land in QuickBooks in a shape that reconciles. That is where the real work is.
The one mistake that breaks your QuickBooks books
Here it is: your Shopify payout is not your revenue.
The deposit Shopify drops into your bank is a net settlement. It bundles sales, minus processing fees, minus refunds, plus or minus adjustments and chargebacks, on a rolling delay. A payout almost never equals your sales for the same window.
If you book that net deposit as "sales," you understate revenue, hide your fees entirely, and produce a P&L that cannot be reconciled at tax time. The correct treatment is to book gross sales at the top, record fees and refunds on their own lines, and let the net payout sit at the bottom as the cash consequence. Our ecommerce bookkeeping and sales tax compliance guide walks through the same principle in more depth.
Shopify's fees, line by line
You need each of these as its own account in QuickBooks so nothing hides inside a lump deposit:
- Payment processing — a percentage plus a fixed per-transaction fee, commonly quoted around 2.9% plus 30¢ for online card payments on lower-tier plans, per A2X's breakdown of Shopify fees. The rate drops on higher plans, so verify yours.
- Chargeback / dispute fee — $15 in the US on Shopify Payments, refunded to you if you win the dispute, also per A2X.
- Refund gotcha — when you refund a customer, the original processing fee is generally not returned. A refunded order still costs you that fee.
- Third-party gateway fee — if you use an external processor instead of Shopify Payments, Shopify adds its own transaction fee on top.
Set up these accounts once, and every payout maps to the same places month after month.
A worked month in QuickBooks
Say you run a t-shirt store on Shopify. Here is one illustrative month, laid out the way it should appear in your books (all figures are an example, not market data):
- Gross sales — 300 orders at about $32 average = $9,600
- Less discounts (a 10%-off code): −$480
- Less refunds (9 orders): −$290
- Net sales: $8,830
- COGS — production at ~$12 per unit × 300: −$3,600
- COGS — payment processing (2.9% + 30¢ × 300): −$346
- Gross profit: $4,884 → gross margin 4,884 ÷ 8,830 = 55.3%
- OpEx — ad spend (Meta + Google): −$3,000
- OpEx — Shopify plan + apps: −$180
- OpEx — email/design tools: −$90
- OpEx — owner draw / contractor: −$500
- Operating profit: $1,114 → operating margin 1,114 ÷ 8,830 = 12.6%
Read it and the story jumps out: the product is healthy at 55.3% gross margin, but ad spend eats most of the gross profit. If ad costs rise 20% — 3,000 × 1.2 = $3,600 — operating profit nearly halves to $514.
That is exactly why ad spend belongs in operating expenses, not COGS. Bury it in COGS and your gross margin looks inflated while your real risk — customer acquisition cost — disappears from view. The full mechanics of this layout live in our ecommerce P&L guide.
QuickBooks does bookkeeping — not per-order profit
Notice what the P&L above gives you: a store-level, month-level verdict. It says the business cleared about $1,114. It does not say which product, which ad campaign, or which order actually made money.
QuickBooks is built to be your general ledger and your tax-ready record. That is genuinely important — it is what your accountant files from and what survives an audit. If you're still choosing a stack, our guide to setting up ecommerce bookkeeping and our rundown of ecommerce bookkeeping tools built for accuracy both help.
But a ledger answers "did we make money?" It does not answer "is this order profitable once I subtract its share of ad spend, its processing fee, and its supplier cost?" That is a different question, and it needs data QuickBooks was never designed to join: your Shopify orders next to your Meta and Google ad spend next to your Printify or Printful and Stripe charges.
This is the gap PodVector fills. It connects Shopify, Meta Ads, Google Ads, Printify, and Printful, and computes true per-order profit — the real dollar left after every one of those costs. It is not a dashboard and not a replacement for QuickBooks; it sits alongside your books and answers the profit question your ledger can't. Its AI operator, Victor, analyzes that live data and can take Shopify-side actions with your approval, while leaving your ad accounts untouched. Keep QuickBooks for the books; add per-order truth on top.
Sales tax: what QuickBooks and Shopify each do
This trips up new sellers, so be precise about who does what.
Shopify calculates and collects sales tax at checkout, once you turn it on and tell it where you have nexus. Shopify does not register, file, or remit for you — that stays your job, per Shopify's own sales tax guide. The tax Shopify collects is not your money; you are holding it for the state.
QuickBooks helps you track what you've collected and owe, so you can file. Neither tool decides your obligations — nexus does. You can create a sales-tax duty in a state purely by sales volume there, thanks to South Dakota v. Wayfair, even with no physical presence.
This is general information, not tax advice. Rules change and vary by situation — consult a licensed CPA or tax professional before acting.
1099-K and estimated taxes
Your processor will send a 1099-K reporting your gross payment volume. For the 2025 and 2026 tax years, a processor must issue one only when gross payments exceed $20,000 and transactions exceed 200, after the One Big Beautiful Bill reverted the threshold, per the IRS.
Two traps: you owe income tax on your profit whether or not you get the form, and the 1099-K reports gross dollars — before fees, refunds, and COGS — so it is never your taxable income. Clean QuickBooks books are what let you reconcile that gross number down to real profit.
Because nothing is withheld, sole proprietors also owe self-employment tax of 15.3% on net earnings — 12.4% Social Security plus 2.9% Medicare — on top of income tax, and typically pay quarterly estimates, per the IRS. This is what surprises first-year sellers most.
FAQs
Does QuickBooks integrate with Shopify natively?
Not in an accounting-grade way. QuickBooks lacks a native ecommerce connection, so most sellers use a bridge app like A2X or Link My Books to summarize Shopify payouts into QuickBooks, as Finaloop describes. The QuickBooks Online app can pull orders directly but often creates reconciliation headaches.
Should I record my Shopify payout as sales in QuickBooks?
No. A payout is a net settlement — sales minus fees and refunds, on a delay. Book gross sales at the top of your P&L, record fees and refunds on their own lines, and treat the net payout as the cash result at the bottom. Otherwise your revenue and fees are both wrong.
Is QuickBooks enough to know if my store is profitable?
It tells you if the business was profitable over a period, which is essential for tax and financing. It does not tell you which orders, products, or campaigns are profitable after ad spend and fees. For that, you need a tool that joins Shopify with your ad and supplier data to compute per-order profit.
Where does ad spend go — COGS or operating expenses?
Operating expenses. It scales with revenue, but it is paid acquisition, not a direct product cost. Putting it in COGS inflates your gross margin and hides that customer acquisition cost is usually your biggest risk.
Does Shopify or QuickBooks file my sales tax?
Neither. Shopify calculates and collects at checkout; QuickBooks helps you track it. Registering, filing, and remitting to each state remains your responsibility, per Shopify. Where you owe is driven by nexus, not by which software you use.
Do I owe tax if I don't get a 1099-K?
Yes. The 1099-K threshold governs reporting, not taxability. You owe income tax on your profit regardless of whether any form is issued, and the IRS threshold is currently over $20,000 and over 200 transactions.