Accounting
Ecommerce
Shopify Accounting: Payouts, Fees, Inventory and How to Sync It to Your Books
Last updated: October 7, 2026 · Independent guide · We do not sell rankings or coverage.
Shopify accounting means recording each order at its gross value and then reconciling the net payout Shopify sends to your bank. A payout is sales, shipping and sales tax collected, minus processing fees, refunds and chargebacks, so it almost never matches your sales figure for the same days. The reliable method is a Shopify clearing account: you post gross sales, tax, fees, refunds and gift card activity to it, and each bank deposit clears it back to zero. Inventory and cost of goods sold (COGS) are recorded separately, because Shopify payouts carry no cost information.
The rule and the journal entries
The reconciliation rests on one equation: payout = gross charges processed (product sales + shipping + sales tax + gift cards sold − gift card redemptions) − processing fees − refunds − chargebacks and chargeback fees. Each element gets its own account, so your profit and loss shows revenue and fees gross. The standard entries are below.
| Account | Debit | Credit | Note |
|---|---|---|---|
| Shopify clearing (asset) | Amount charged | 1. Sale. Owed by Shopify until paid out. | |
| Sales / Shipping income / Sales tax payable | Each component | 1. Sale. Tax is a liability. | |
| Shopify clearing / Gift card liability | Card value | Card value | 2. Gift card sold. |
| Gift card liability / Sales | Amount redeemed | Amount redeemed | 3. Gift card redeemed. Revenue now. |
| Sales returns / Sales tax payable / Shopify clearing | Returns and tax | Clearing | 4. Refund. Fee is not returned. |
| Merchant fees (expense) / Shopify clearing | Fees | Clearing | 5. Processing fees. |
| Chargeback losses and fees / Shopify clearing | Disputed amount + fee | Clearing | 6. Chargeback. |
| Bank / Shopify clearing | Deposit | Deposit | 7. Payout. |
| Cost of goods sold / Inventory | Cost of units shipped | Cost of units shipped | 8. COGS, from inventory records. |
If you also accept PayPal or another third-party gateway, give each provider its own clearing account, because each settles on its own schedule.
Worked example: one weekly payout
The figures in this section are an illustration, not data from a real store. A US store on the Shopify Basic plan uses Shopify Payments at the standard online rate of 2.9% + 30¢ per transaction (Shopify pricing, no date shown, checked October 7, 2026). In one week it takes 40 orders and sells one $100 gift card.
- Gross activity. Product sales are $3,200, shipping charged is $200 and sales tax collected is $272. One $60 order was paid $50 by gift card and the rest by card. Card charges therefore total $3,200 + $200 + $272 − $50 + $100 = $3,722 across 41 transactions.
- Processing fees. 2.9% of $3,722 is $107.94, plus 41 × $0.30 = $12.30, for $120.24. Real payouts can differ by cents because fees round per transaction.
- Refund. The store refunds one item: $80 of product plus $6.80 of tax, or $86.80. Shopify keeps the original fee on that order.
- Chargeback. A customer disputes an earlier $120 order. Shopify withdraws the $120 and the $15 US chargeback fee, $135 in total.
- Payout. $3,722.00 − $120.24 − $86.80 − $135.00 = $3,379.96.
- COGS. The cost per item recorded for the units shipped totals $1,280. The refunded item comes back into stock at a cost of $32.
The resulting entries bring the clearing account back to zero once the deposit posts.
| Account | Debit | Credit | Note |
|---|---|---|---|
| Shopify clearing | $3,722.00 | Weekly sales summary | |
| Gift card liability | $50.00 | Redemption on the $60 order | |
| Sales | $3,200.00 | Includes the $60 order in full | |
| Shipping income | $200.00 | ||
| Sales tax payable | $272.00 | Owed to the state | |
| Gift card liability | $100.00 | New card sold | |
| Sales returns | $80.00 | Refund | |
| Sales tax payable | $6.80 | Tax refunded | |
| Merchant fees | $120.24 | Shopify Payments | |
| Chargeback losses | $120.00 | Reverse if the dispute is won | |
| Chargeback fees | $15.00 | Returned if you win | |
| Shopify clearing | $342.04 | Refund, fees and chargeback | |
| Bank / Shopify clearing | $3,379.96 | $3,379.96 | Deposit |
| Cost of goods sold / Inventory | $1,280.00 | $1,280.00 | Units shipped |
| Inventory / Cost of goods sold | $32.00 | $32.00 | Returned item restocked |
At month end, the clearing account usually holds sales Shopify has processed but not yet paid out. Shopify lists a minimum settlement time of 3 business days for US stores, and weekends and holidays do not count (Shopify Help Center, no date shown). Any balance beyond payouts in transit needs investigating.
The rules behind each line
Shopify Payments fees, refunds and chargebacks
Your fee rate depends on your plan. With Shopify Payments you pay the card rate but no separate Shopify transaction fee. With a third-party gateway you pay that provider’s card fees plus a Shopify transaction fee (Shopify Help Center, no date shown). International cards add 1% (Shopify pricing, no date shown).
| Plan | Monthly price (billed yearly) | Standard online card rate | Fee if you use a third-party gateway |
|---|---|---|---|
| Basic | $29 | 2.9% + 30¢ | 2% |
| Grow | $79 | 2.7% + 30¢ | 1% |
| Advanced | $299 | 2.5% + 30¢ | 0.6% |
| Plus | From $2,300 | 2.25% + 30¢ | 0.2% |
Source: Shopify pricing, no date shown, checked October 7, 2026. Monthly billing costs more: $39, $105 and $399 for Basic, Grow and Advanced.
Shopify states that the original card fee is not refunded when you issue a refund. For US stores, if your Shopify Payments balance cannot cover a refund, Shopify debits your bank account outside the normal payout schedule (Shopify Help Center, no date shown). Code those debits to the clearing account. The US chargeback fee is $15, and Shopify returns both the disputed amount and the fee if the dispute is resolved in your favor (Shopify Help Center, no date shown).
Gift cards
Shopify’s own reports treat a gift card sale as a liability, not a sale, and count the item value as a sale when the card is redeemed. Its Outstanding gift card balance report tracks the balance daily (Shopify Help Center, no date shown). Under US GAAP, ASC 606-10-55-48 lets you recognize expected breakage (cards that will never be redeemed) as revenue in proportion to the pattern of redemptions. ASC 606-10-55-49 requires you to keep a liability for any amount you must remit to a state under unclaimed property law (Deloitte DART, no date shown).
Federal Regulation E generally requires store gift card funds to remain usable for at least five years from issue or last load (12 CFR 1005.20, eCFR, current as of October 5, 2026). For income tax, Treas. Reg. §1.451-8 allows accrual-method taxpayers to defer part of an eligible gift card sale to the following tax year if they track sale dates (26 CFR 1.451-8, eCFR, current as of October 5, 2026).
Sales tax
Since South Dakota v. Wayfair (decided June 21, 2018), states can require remote sellers to collect sales tax once they pass an economic threshold, even without a physical presence (US Supreme Court docket 17-494). Thresholds vary by state. On your own Shopify store you are the seller, so collected tax is your liability until you file and pay.
Shopify Tax calculates rates and costs 0.35% of each order on Basic, Grow and Advanced (0.25% on Plus) after the first $100,000 of sales, capped at $0.99 per order. Stores created on or after May 13, 2026 measure that $100,000 over lifetime sales rather than per calendar year (Shopify Help Center, no date shown). Shopify’s automated filing for US returns is closed to new enrollment (Shopify Help Center, no date shown). The Shopify Tax charge is billed on your Shopify invoice, not deducted from payouts, so post it as an expense.
Inventory and COGS
Shopify’s profit reports use the cost per item recorded at the time of sale. Shopify calls that field static and suggests an ERP or accounting system for dynamic reporting (Shopify Help Center, no date shown). For tax, IRS Publication 538 says inventory at cost must include all direct and indirect costs, so a reseller’s item cost should carry freight-in and import duties as well as the supplier price (IRS Publication 538, revised January 2022). A small business taxpayer can use a simplified inventory method under §471(c) if average annual gross receipts for the prior three years do not exceed $32 million for tax years beginning in 2026 (IRS Rev. Proc. 2025-32, October 2025). If you sell bundles, record COGS at the component level (see our guide to kitting and bundles in inventory software).
Common mistakes
- Booking the deposit as revenue. This understates sales, hides fees and skips sales tax payable.
- Recording gift card sales as revenue. Revenue is then counted again at redemption.
- Treating sales tax as income. Collected tax is a liability until you file.
- Ignoring direct bank debits. Refunds that exceed your balance are pulled from your bank, not a payout.
- Using the Shopify Payments activity report as a revenue statement. Shopify says the report reflects balance activity and is not a revenue statement for accounting purposes (Shopify Help Center, no date shown).
- Leaving cost per item blank. Orders without a recorded cost drop out of Shopify’s profit reports.
How to report it
On the income statement, show gross sales less sales returns to reach net sales, with shipping income in revenue or on its own line. Processing fees, chargeback fees and Shopify Tax charges are operating expenses, because they are paid to vendors rather than customers. COGS sits beneath net sales so gross margin is visible.
On the balance sheet, Shopify clearing is a current asset, while gift card liability and sales tax payable are current liabilities. Each month, tie the gift card liability to Shopify’s Outstanding gift card balance report and sales tax payable to the US sales tax report (available with Shopify Tax).
How accounting systems automate it
QuickBooks Online. Intuit’s own Shopify app is free to install and syncs products, orders and payouts to record sales and fees, with a daily summary option. It had a rating of 2.1 out of 5 from 64 reviews when we checked (Shopify App Store, checked October 7, 2026). QuickBooks Online Plus, which adds inventory tracking, lists at $140 a month (Intuit, no date shown), and Intuit says inventory defaults to FIFO costing (Intuit, September 22, 2026).
Xero. Xero’s own Shopify listing says the app is not currently available on the Shopify App Store (Shopify App Store, checked October 7, 2026), so Xero users rely on a connector. Xero’s US Growing plan is $59 a month and inventory beyond the basics is an add-on (Xero, no date shown).
A2X. A2X posts summarized entries for each Shopify payout and integrates with QuickBooks Online, Xero and NetSuite (A2X, no date shown). Shopify plans start at $29 a month for up to 200 orders and reach $79 for up to 2,000 orders (A2X, no date shown). Link My Books works similarly, but its page showed no USD prices when we checked.
Webgility and Synder. Webgility posts order-level detail and syncs inventory with QuickBooks, with plans from $69 a month billed annually for 300 orders (Webgility, no date shown). Synder starts at $52 a month billed yearly for 500 synced transactions (Synder, no date shown). Each vendor sells the product described. For the wider stack, see our guide to the software stack to run an ecommerce business, and our comparison of small business accounting software.
How we researched this
On October 7, 2026 we read Shopify’s Help Center pages on payouts, refunds, chargebacks, reports and Shopify Tax, plus its pricing page. We checked rules against eCFR, IRS and Supreme Court sources and Deloitte’s DART text of ASC 606. Connector prices come from vendor pages. We also reviewed the top-ranking guides, mostly from connector vendors, and covered what they omit: journal entries, gift card rules and tax thresholds.
Related guides
- Ecommerce ERP Integration: Shopify, BigCommerce, Amazon
- Amazon Seller Accounting: Settlements, Fees and Sales Tax
- NetSuite Payment Gateways: Options, Fees and Level 3
Frequently asked questions
Why doesn’t my Shopify payout match my sales?
A payout is net of processing fees, refunds and chargebacks, and it includes sales tax, shipping and gift card sales that are not revenue. Post the gross figures to a clearing account and the payout will reconcile.
Are Shopify fees refunded when I refund an order?
No. Shopify states that the original card transaction fee is not returned when you refund an order through Shopify Payments. Keep the fee as an expense.
How do I record Shopify gift cards in QuickBooks or Xero?
Create a current liability account called gift card liability. Credit it when a card is sold and debit it when a card is redeemed, recognizing the sale at redemption.
Does Shopify file my sales tax returns?
For most stores, no. Shopify Tax calculates and collects tax, but Shopify’s automated US filing is closed to new enrollment. You remain responsible for registering, filing and paying in each state where you have nexus.
Do I need A2X or another connector?
A low-volume store can post a weekly summary entry by hand. With several gateways or hundreds of orders a month, a connector usually costs less than the bookkeeping time it saves.
Sources
- Shopify, Pricing (plan prices, card rates, third-party fees), no date shown, checked October 7, 2026. shopify.com
- Shopify Help Center, Understanding Shopify Payments payout timing, no date shown, checked October 7, 2026. help.shopify.com
- Shopify Help Center, Viewing your Shopify Payments payout fees, no date shown, checked October 7, 2026. help.shopify.com
- Shopify Help Center, Shopify Payments refunds, no date shown, checked October 7, 2026. help.shopify.com
- Shopify Help Center, Responding to chargebacks and inquiries, no date shown, checked October 7, 2026. help.shopify.com
- Shopify Help Center, Shopify Payments activity report, no date shown, checked October 7, 2026. help.shopify.com
- Shopify Help Center, Finance reports, no date shown, checked October 7, 2026. help.shopify.com
- Shopify Help Center, Profit reports, no date shown, checked October 7, 2026. help.shopify.com
- Shopify Help Center, Shopify Tax pricing, no date shown, checked October 7, 2026. help.shopify.com
- Shopify Help Center, Automated filing considerations, no date shown, checked October 7, 2026. help.shopify.com
- Deloitte DART, Revenue Recognition Roadmap 8.8, Customers’ unexercised rights (breakage), quoting ASC 606-10-55-48 and 55-49, no date shown. dart.deloitte.com
- eCFR, 12 CFR 1005.20, Requirements for gift cards and gift certificates, current as of October 5, 2026. ecfr.gov
- eCFR, 26 CFR 1.451-8, Advance payments for goods, services and certain other items, current as of October 5, 2026. ecfr.gov
- Supreme Court of the United States, Docket 17-494, South Dakota v. Wayfair, Inc., judgment June 21, 2018. supremecourt.gov
- IRS, Publication 538, Accounting Periods and Methods, revised January 2022. irs.gov
- IRS, Rev. Proc. 2025-32 (2026 inflation adjustments, section 448(c) gross receipts test), October 2025. irs.gov
- Shopify App Store, QuickBooks Online by Intuit, checked October 7, 2026. apps.shopify.com
- Shopify App Store, Xero, checked October 7, 2026. apps.shopify.com
- Intuit, QuickBooks Online pricing, no date shown, checked October 7, 2026. quickbooks.intuit.com
- Intuit, What is FIFO and how is it used for inventory cost accounting, September 22, 2026. quickbooks.intuit.com
- Xero, US pricing plans, no date shown, checked October 7, 2026. xero.com
- A2X, A2X for Shopify (A2X sells this product), no date shown, checked October 7, 2026. a2xaccounting.com
- A2X, Shopify pricing (A2X sells this product), no date shown, checked October 7, 2026. a2xaccounting.com
- Link My Books, Pricing (Link My Books sells this product), no date shown, checked October 7, 2026. linkmybooks.com
- Webgility, Pricing (Webgility sells this product), no date shown, checked October 7, 2026. webgility.com
- Synder, Pricing (Synder sells this product), no date shown, checked October 7, 2026. synder.com
Sherman Hsieh
Independent analysis of enterprise software — ERP, CRM and more
