Industry · Shopify accounting
Shopify accounting that reconciles the payout, not the screen.
Your Shopify dashboard shows gross sales. Your bank shows a smaller, irregular Shopify Payments deposit — net of processing fees, refunds, chargebacks, and held funds. TechBrot’s Certified QuickBooks ProAdvisors reconcile gross order value to net payout for every deposit, book gift-card and sales-tax liability where they belong, and tie in Shop Pay, PayPal, and your POS. We keep the records and the by-state numbers your CPA needs; your CPA confirms nexus and files. Independent firm, not affiliated with Intuit Inc. or Shopify Inc.
Shopify accounting has one problem most bookkeepers miss: the number in your Shopify admin is not the number that hits your bank. A single Shopify Payments payout nets processing fees, refunds, chargebacks, and reserves against gross sales, while collected sales tax and unredeemed gift cards are liabilities — not revenue — that the deposit hides. TechBrot’s Certified QuickBooks ProAdvisors reconcile gross order value to each net payout, post summarized journal entries from Shopify into your own QuickBooks file, fold in Shop Pay, PayPal, and POS, and keep clean by-state sales-tax records. Because Shopify is your own store — not a marketplace facilitator — you generally remit your own sales tax; we keep the records and reconcile what Shopify Tax calculates, and your CPA or state authority determines nexus, registration, and filing.
Reviewed by the Certified QuickBooks ProAdvisor team at TechBrot Inc., an independent firm — not affiliated with Intuit Inc. or Shopify Inc. Bookkeeping and ProAdvisor scope; does not file the client’s sales or income taxes — nexus, registration, and filing are determined with the client’s CPA or state authority. Marketplace-facilitator framing reflects the seller’s own Shopify store, where the seller is generally the responsible party.
Shopify accounting, in five questions.
Why doesn’t my Shopify payout match my sales?
Because a Shopify Payments payout is netted — processing fees, refunds, chargebacks, and held reserves are subtracted before the deposit. Accurate books reconcile gross order value to the net payout, booking each piece where it belongs instead of recording one lump deposit.
How does Shopify data get into QuickBooks?
We post summarized journal entries from your Shopify admin into your own QuickBooks file — revenue gross, fees as expense, refunds and chargebacks as contra-revenue, sales tax and gift cards as liabilities — and reconcile each entry to the matching bank deposit.
Do you handle Shopify POS, Shop Pay, and PayPal too?
Yes. Shopify POS, Shop Pay, and third-party processors like PayPal each settle differently. We reconcile every channel and processor so your total revenue and fees are correct, not double-counted across them.
Who is responsible for Shopify sales tax?
On your own Shopify store you are generally the responsible party — unlike a marketplace facilitator, Shopify does not remit your sales tax for you. Shopify Tax helps calculate it; we keep the by-state records and reconcile what was collected. Your CPA or state authority determines nexus, registration, and filing.
What does it cost?
A fixed monthly fee against a written scope — driven by order volume, number of channels and processors, inventory complexity, and sales-tax footprint. See pricing. No hourly billing.
Shopify accounting, plainly.
Shopify accounting goes wrong at one specific seam: the gross sales in your Shopify admin almost never equal the Shopify Payments payout that lands in your bank. Each payout is netted — processing fees, refunds, and chargebacks are subtracted, and Shopify can hold a reserve — so the deposit is smaller, irregular, and bundles several things at once. On top of that, collected sales tax and unredeemed gift cards are liabilities, not income, even though they move through the same gross order value. Booked as a single deposit, revenue is understated, fees disappear, and your liabilities are wrong.
TechBrot is a firm of Certified QuickBooks ProAdvisors who reconcile gross order value to each net payout, posting summarized journal entries from your Shopify admin into your own QuickBooks file — revenue gross, fees as expense, refunds and chargebacks as contra-revenue, sales tax and gift cards as liabilities, reserves as receivables. We fold in Shopify POS, Shop Pay, and third-party processors like PayPal, maintain inventory and COGS by SKU, and keep clean by-state sales-tax records. This is the Shopify-specific layer on top of our general e-commerce accounting; for sellers on the other big channel, see Amazon seller accounting. Independent ProAdvisor firm — not affiliated with Intuit Inc. or Shopify Inc.
| In one Shopify payout | On the deposit — what you see | Reconciled — how we book it |
|---|---|---|
| Gross order value | Never matches the deposit | Booked as revenue, gross |
| Shopify Payments processing fees | Silently subtracted from the payout | Booked as an expense, visible on the P&L |
| Refunds & chargebacks | Netted against sales | Booked as contra-revenue, tracked separately |
| Collected sales tax | Mixed into gross order value | Booked as a liability you generally remit, not income |
| Gift cards sold vs redeemed | Treated like a normal sale | Booked as a liability until the card is redeemed |
| Shopify reserves & holdbacks | Deposit looks short | Tracked as a receivable until released |
Three places Shopify books drift from the bank.
Nearly every messy Shopify file fails in the same three areas. Knowing which one you’re in tells us where to start.
Net payouts hide your real revenue.
Shopify Payments deposits net of fees, refunds, and reserves, so a single payout never equals your gross order value. Booked as one number, revenue is understated and processing fees vanish from your P&L. The fix is payout-level reconciliation that ties gross order value to each net deposit, separating revenue, fees, refunds, and tax — every payout, every month. If you’ve never reconciled a payout, your margins are currently fiction. It’s fixable.
Sales tax and gift cards booked wrong.
Collected sales tax and gift-card sales flow through gross order value, but neither is revenue — tax is money you generally remit, and a gift card is a liability until it’s redeemed. Booked as income, your revenue is inflated and your obligations are invisible. The fix is booking both as liabilities, with clean by-state sales-tax records and gift-card balances tracked to redemption. We keep the records; your CPA or state authority makes the nexus and filing call.
POS, Shop Pay, and PayPal double-counted.
Once you add Shopify POS, Shop Pay, or PayPal, the same order can appear to settle twice, or a channel’s fees can go unbooked entirely. Totals stop tying out. The fix is reconciling every channel and processor to a single source of truth in QuickBooks, so revenue is counted once and every fee lands on the P&L — the foundation for accurate monthly bookkeeping.
Shopify accounting, done by an expert.
Every engagement is scoped to your channels and order volume, delivered in your own QuickBooks file by a named Certified ProAdvisor.
Shopify Payments payout reconciliation
Gross order value tied to each net Shopify Payments payout — processing fees, refunds, chargebacks, and reserves separated correctly, every deposit, never netted into one number.
Sales-tax & gift-card liability
Collected sales tax and unredeemed gift cards booked as liabilities — not income — with clean by-state records and gift-card balances tracked to redemption.
Multi-channel & processor reconciliation
Shopify POS, Shop Pay, and third-party processors like PayPal reconciled alongside Shopify Payments, so revenue is counted once and every fee hits the P&L.
Inventory & COGS tracking
COGS and inventory maintained in QuickBooks by SKU and channel, including landed cost where relevant, so gross margin on your Shopify catalog is accurate and decision-ready.
QuickBooks setup & the app stack
A Shopify-ready chart of accounts and correct QuickBooks setup, with the right connector apps posting clean summarized journal entries from your Shopify admin into the file.
Shopify books cleanup
Untangle netted payouts, correct sales tax and gift cards booked as income, and reconcile each channel to a known-good baseline before monthly bookkeeping begins.
Connected to every way Shopify pays out.
- Shopify Payments — payouts reconciled gross order value to net deposit
- Shop Pay — accelerated-checkout orders tied back to the right payout
- Shopify POS — in-person sales reconciled alongside online orders
- PayPal — mixed payouts separated from Shopify Payments deposits
- Other gateways (e.g. Stripe-backed) — fees and refunds split correctly
- Shopify Tax — collected tax reconciled and kept as by-state records
- Gift cards — sold vs redeemed tracked as a liability to redemption
- Connector apps (e.g. A2X) — summarized journal entries posted to QuickBooks
Run more than one store, or sell on another channel alongside Shopify? If it pays out to a bank account, we can reconcile it. Ask on a discovery call.
From netted payouts to matched deposits.
Every Shopify engagement follows the same four-phase rhythm — payouts reconciled first, profit visibility second, advisory third.
Discovery
A 30-minute call to map your Shopify setup — channels, processors, order volume, gift cards, and where the books drift from the deposits. No pitch.
Cleanup & setup
If needed, a cleanup to untangle netted payouts and correct mis-booked tax and gift cards, plus the right QuickBooks setup and connector apps for Shopify.
Monthly reconciliation
Every Shopify Payments payout reconciled gross-to-net, all channels and processors tied out, with COGS and by-state sales-tax records maintained.
Reporting & advisory
A monthly financial package with channel-level margin and, as you scale, cash-flow and growth advisory.
Clean books are the start. Decisions are the point.
Once every Shopify payout reconciles and your margins are real, the question changes from “do the books match the bank?” to “what do we do about them?” Which products to scale, when a discount or free-shipping threshold actually pays for itself, how margin holds up against rising ad costs and processing fees — the decisions that move a Shopify business.
That’s where advisory comes in: a Certified ProAdvisor who knows your numbers turning them into cash-flow, pricing, and growth decisions. Accurate books come first; then that judgment turns them into decisions. As automation commoditizes basic bookkeeping, this advisory layer is where the value — and the margin — now lives. Explore fractional CFO & advisory →
Reviewed by the ProAdvisor team.
This page reflects how TechBrot actually handles Shopify engagements. It is maintained by the Certified QuickBooks ProAdvisor team at TechBrot Inc., a Delaware-incorporated independent ProAdvisor firm, and reviewed for technical accuracy on Shopify Payments payout reconciliation, gift-card and sales-tax liability, and multi-channel revenue. Where our approach or scope changes, this page is updated. TechBrot delivers the books and keeps the by-state records; your CPA or state authority determines nexus, registration, and filing.
Certifications
Active Intuit Certified QuickBooks ProAdvisor — Online (L2), Desktop, Enterprise, Payroll
Scope
Shopify payout reconciliation, multi-channel & processor, inventory/COGS, by-state sales-tax records · nexus & filing with your CPA/state authority
Engagement
Fixed-fee, written scope before work · delivered in your own QuickBooks file
Independent
Not affiliated with Intuit Inc. or Shopify Inc. · QuickBooks and Shopify are trademarks of their respective owners
Shopify accounting questions.
Why doesn’t my Shopify Payments payout match my Shopify sales?
How do you get Shopify data into QuickBooks?
Who is responsible for collecting and remitting Shopify sales tax?
Do you reconcile Shopify POS, Shop Pay, and PayPal too?
How do you handle gift cards and chargebacks on the books?
My Shopify books are already a mess. Where do we start?
Ready when you are
Get Shopify books that match the bank.
Book a discovery call. A Certified ProAdvisor reviews your Shopify payouts, your other channels, and where the books drift from the deposits, flags any margin or sales-tax exposure, and sends a written fixed-fee scope within 3 business days. No pitch. Independent firm — does not file your taxes; coordinates with your CPA.