Your Shopify store processed $94,000 in orders last month. Shopify Payments deposited $88,400 across 22 separate daily payouts. The $5,600 difference is scattered across transaction fees, refunds, chargebacks, and a Shopify Payments reserve hold you did not know existed. Now your bookkeeper is trying to match 22 bank deposits to hundreds of individual orders, and nothing reconciles.
This is the daily reality of Shopify bookkeeping. Unlike Amazon, where a biweekly settlement report gives you a single document to reconcile, Shopify pays you daily (or on a rolling 2-3 day schedule) with no built-in settlement summary. Each payout lumps together sales, partial refunds, chargebacks, and adjustments from different days — making manual bank reconciliation a time-consuming puzzle.
This guide covers the Shopify-specific bookkeeping challenges that store owners face: payment processing and payout reconciliation, refund and chargeback handling, app and subscription cost tracking, shipping cost management, discount accounting, inventory valuation, and sales tax setup. For the broader e-commerce picture, see our complete e-commerce seller bookkeeping guide.
How you accept payment determines how your money flows — and how complicated your reconciliation will be.
Shopify Payments is Shopify’s native payment processor (powered by Stripe). Per Shopify’s documentation, most stores use it because:
Processing rates (2026):
| Shopify Plan | Online Rate | In-Person Rate | Monthly Fee |
|---|---|---|---|
| Basic | 2.9% + $0.30 | 2.6% + $0.10 | $39/mo |
| Shopify | 2.7% + $0.30 | 2.5% + $0.10 | $105/mo |
| Advanced | 2.5% + $0.30 | 2.4% + $0.10 | $399/mo |
| Plus | 2.15% + $0.30 | 2.15% + $0.10 | $2,300/mo |
On $100,000/month in sales, the difference between Basic (2.9%) and Advanced (2.5%) processing rates saves $400/month — which more than covers the difference in subscription fees. Run the math before deciding your plan tier.
If you use a payment gateway other than Shopify Payments, Shopify charges an additional transaction fee on top of whatever the gateway charges:
This means a seller on the Basic plan using PayPal pays the PayPal processing fee plus an additional 2.0% to Shopify — potentially 4.4-4.9% total per transaction. This is why most Shopify stores use Shopify Payments unless they have a specific reason not to (high-risk category, multi-currency requirements, etc.).
Bookkeeping implication: If you use both Shopify Payments and PayPal (common for stores that offer PayPal as a checkout option), you have two payment streams to reconcile — Shopify Payments payouts in one bank account and PayPal deposits in another. Your bookkeeper needs to match orders to the correct payment method and reconcile each stream independently.
Pro Tip: Enable Shopify Payments even if you also offer PayPal. Shopify Payments eliminates the additional transaction fee on credit card orders, and PayPal orders still process at PayPal’s rates without the Shopify surcharge. The dual-processor setup adds reconciliation complexity, but the fee savings are significant above $50K/month in sales.
Shopify Payments deposits money into your bank account on a rolling schedule — typically a 2-business-day delay. A sale on Monday settles to your bank on Wednesday. A refund on Tuesday reduces Wednesday’s deposit. A chargeback from three weeks ago might reduce today’s deposit.
The result: your bank shows a deposit of $4,127.38, and you have no obvious way to determine which orders, refunds, and adjustments make up that number.
This works for stores doing 5-10 orders per day. At 50+ orders/day, manual payout reconciliation takes 3-5 hours per week. That is not sustainable.
A2X for Shopify connects to your store, reads every payout, breaks it down into accounting categories (gross revenue, discounts, refunds, shipping, taxes collected, processing fees, and other adjustments), and posts a summarized journal entry to QuickBooks or Xero for each payout.
The journal entry nets to the exact payout amount, enabling one-click bank reconciliation. For stores doing $50K+/month, A2X ($19-$69/month) eliminates 10-15 hours of manual reconciliation per month.
Shopify refunds and chargebacks are handled differently, and each requires distinct bookkeeping treatment.
When you issue a refund in Shopify:
Bookkeeping entries for a $50 refund on a $100 order:
| Account | Debit | Credit |
|---|---|---|
| Sales Revenue | $50.00 | |
| Accounts Receivable / Cash | $50.00 |
Note: the processing fee on the original $100 sale ($3.20 on a 2.9% + $0.30 rate) is not refunded. You paid $3.20 in processing fees on a sale that is now only $50 — your effective processing rate on the remaining revenue doubled to 6.4%. Track refund volume as a KPI; high refund rates compound processing fee losses.
A chargeback occurs when a customer disputes a charge with their credit card company. Shopify:
Bookkeeping treatment: Record chargebacks as a debit to a “Chargebacks” expense account and a credit to Accounts Receivable. If the dispute is resolved in your favor, reverse the entry. If the dispute is lost, the expense stands and the $15 fee remains.
For stores with chargeback rates above 1%, this is a significant and often hidden cost. A store doing $100K/month with a 1.5% chargeback rate loses $1,500 in disputed revenue per month, plus $225 in chargeback fees (assuming 15 disputes at $15 each) — $1,725/month or $20,700/year.
Important: Shopify monitors your chargeback rate. If it exceeds 1% of transactions consistently, Shopify Payments may freeze your payouts, increase your reserve holdback, or terminate your Shopify Payments account. Track this metric monthly in your bookkeeping reports.
Shopify’s app ecosystem is both a strength and a bookkeeping headache. The average Shopify store runs 6-8 paid apps, and costs add up quietly.
| App Category | Examples | Typical Monthly Cost |
|---|---|---|
| Email Marketing | Klaviyo, Omnisend | $50 – $500 |
| Reviews & UGC | Judge.me, Loox, Yotpo | $15 – $100 |
| SEO & Analytics | Plug in SEO, Lucky Orange | $20 – $100 |
| Upsells & Cross-sells | ReConvert, Bold | $20 – $100 |
| Subscription/Recurring | Recharge, Skio | $99 – $500+ |
| Inventory Management | Stocky, Inventory Planner | $50 – $300 |
| Shipping & Fulfillment | ShipStation, Shippo | $25 – $200 |
| Customer Support | Gorgias, Zendesk | $50 – $300 |
A mid-size Shopify store easily spends $500-$1,500/month on apps alone — $6,000-$18,000/year. Yet most store owners cannot name all their active app subscriptions or their total monthly app spend without checking.
Bookkeeping best practice: Create a dedicated “Shopify Apps & Subscriptions” expense account. Review the Shopify bill monthly (Settings > Billing > Shopify bill) which itemizes every app charge. Reconcile against your credit card or bank statement — some apps charge through Shopify’s billing system, others charge your credit card directly.
Conduct a quarterly app audit: list every active subscription, its monthly cost, and whether it is actively driving revenue or saving time. Kill any app that does not have a clear ROI justification. We have seen stores save $300-$500/month just by canceling apps they forgot they installed.
Shipping is often the third-largest expense for Shopify stores (after COGS and marketing). Accurate tracking requires separating several components:
If you charge customers for shipping, you have both shipping revenue and shipping cost:
The difference is your shipping margin — and it can be positive or negative. Free shipping (the most common Shopify store policy) means your shipping cost is a pure expense with no offsetting revenue. Track the gap monthly; many stores lose 2-5% of revenue to shipping cost overruns because they set free shipping thresholds too low.
If you offer free returns, return shipping labels are a cost that many stores fail to track properly. Prepaid return labels may be deducted from Shopify Shipping credits or charged to your carrier account. Book these to a “Returns Shipping” or “Returns Processing” expense account, separate from outbound shipping.
Shopify makes it easy to create discount codes, automatic discounts, and sale prices. From a bookkeeping perspective, discounts reduce your gross revenue — and the financial impact compounds faster than most store owners expect.
Bookkeeping treatment: Discounts should be tracked as a contra-revenue account (reducing gross revenue) rather than an expense. This gives you visibility into your gross sales (before discounts), net sales (after discounts), and your discount rate (discounts as a percentage of gross sales).
A store doing $100K/month in gross sales with a 12% average discount rate is giving away $12,000/month — $144,000/year. If your bookkeeper does not track discounts separately, you cannot see whether your promotional strategy is eroding margins.
Pro Tip: Pull Shopify’s Sales by Discount report monthly. Identify which discount codes are driving incremental sales versus which ones are being used by customers who would have purchased at full price anyway. A discount code that shows up on 40% of orders is not a promotion — it is a permanent price reduction you have not acknowledged.
If you sell physical products, your Shopify bookkeeping must include proper inventory accounting. Shopify tracks inventory quantities but does not track inventory cost — that is your bookkeeper’s job.
QuickBooks Online (Plus or Advanced tier) has native inventory tracking that works alongside Shopify:
Valuation method: QuickBooks Online uses FIFO (First In, First Out) for inventory valuation. This means the oldest inventory costs are assigned to COGS first. If your costs are rising, FIFO will show higher gross margins in the current period (because older, cheaper inventory is being expensed). Be aware of this when analyzing margin trends.
For a detailed comparison of inventory valuation methods and worked examples, see our guide on COGS and inventory accounting for online sellers.
Shopify provides built-in tax calculation (Shopify Tax) that handles sales tax collection at checkout. Your Shopify bookkeeping responsibilities include:
Sales tax collected from customers is not revenue — it is a liability. Your bookkeeping must track:
If your bookkeeper is recording collected sales tax as revenue, your revenue is overstated and your tax liability is invisible on the balance sheet.
For the full breakdown of e-commerce sales tax obligations, nexus rules, and automation options, see our e-commerce sales tax compliance guide.
A clean monthly close process for your Shopify store:
Week 1:
Week 2:
Week 3:
Week 4:
Need help with your Shopify bookkeeping? We work with Shopify store owners who have outgrown spreadsheets and need clean, accurate financials. Get an instant quote or learn about our bookkeeping services.
Get a free quote and see how Steph's Books can save you 40-60% vs hiring in-house.
