Good Shopify bookkeeping starts by treating each Shopify payout as a settlement, not a straightforward sales deposit. In practice, a payout is a bundle of activity — gross sales, discounts, fees, refunds, and other adjustments — summarized into a single bank transfer. This guide walks through those pieces and lays out a practical monthly workflow to reconcile payouts to your bank deposits. You’ll also see frequent pitfalls, recordkeeping habits that help at tax time, and when it’s sensible to loop in a CPA or bookkeeper.
Why Shopify bookkeeping is harder than matching deposits
Many owners look at the cash that lands in the bank and call it “sales.” That’s quick, but it bakes in errors that compound over time. A Shopify payout is a net figure: processing fees are already removed, refunds may be deducted, and certain adjustments or reserves can be in play. In other words, the payout is a settlement of several moving parts, not a single number that maps cleanly to gross sales for the same day.
Illustrative example: your store lists $10,000 in orders for the month. Shopify withholds $300 for payment processing and processes $200 of customer refunds. The bank deposit you receive is $9,500, not $10,000. If you record $9,500 as sales, revenue will be understated and the real fee and refund activity will be blurred. That makes margin analysis unreliable and turns month-end clean-up into guesswork.
There’s also timing to consider. Orders post as they occur. Payouts group activity and then transmit cash, sometimes on a different calendar than your month-end. Because of this, you’ll get the cleanest results by reconciling at the settlement (payout) level and using Shopify’s finance and payout reports to understand what the bank is actually receiving. A simple payments clearing account gives you the bridge you need between Shopify’s detail and the deposit that appears on the bank statement.
Once you set this up, bank reconciliation becomes a confirmation step rather than a research project. You’ll be able to answer common questions faster, like “How much did we discount last month?” or “Are refunds creeping up?” without ripping apart past months to find the pieces.
The settlement map: gross sales, discounts, fees, refunds, and payouts
A Shopify payout follows a straightforward equation, even if the reporting screens feel busy:
Bank deposit = Gross sales (orders) − refunds − discounts − payment fees ± adjustments.
Each term deserves its own place on your books. Blending them together — for example, netting refunds against fees or burying discounts inside sales — makes your financial statements less useful and harder to explain.
- Gross sales — the full amount customers were charged before discounts, refunds, and taxes. Pull gross sales from Shopify’s finance reports by the settlement period you’re reconciling for consistent results (Shopify Help Center: Finance Reports). Sales taxes belong in a liability account, not in sales revenue.
- Discounts and gift cards — recorded as reductions of revenue. Discounts are typically posted to a contra-revenue account so you can see gross and net sales. Gift card redemptions are also reductions of sales; the original gift card sale should have been recorded as a liability that is relieved upon redemption.
- Refunds — reversals of prior sales that often carry fee implications. Record refunds as contra-revenue or negative sales when they occur, not by revisiting past closed periods. Keep a clear trail from the original sale to the refund and any related fee adjustments so the flow makes sense later.
- Payment fees — expenses charged by Shopify Payments or other processors. Book these in a merchant-fees or bank-fees expense account, separate from sales. Shopify shows fees at the payout level (Shopify Help Center: Payouts), which makes reconciliation much easier.
- Payouts (net deposits) — the cash that hits your bank. Reconcile each payout to your clearing account and then match the clearing entry to the bank deposit.
Using a payments clearing account (sometimes called “undeposited funds” or “Shopify clearing”) lets you post gross sales and related reductions as they happen and then clear that temporary account when the payout arrives. This approach preserves detail for analysis and keeps your bank reconciliation simple.
| Shopify line | Bookkeeping account | Illustrative journal |
|---|---|---|
| Gross sales | Sales (Revenue) | Dr Payments clearing / Cr Sales |
| Discounts | Sales discounts (contra-revenue) | Dr Sales discounts / Cr Payments clearing |
| Refunds | Refunds issued (contra-revenue) | Dr Refunds / Cr Payments clearing (or Cr Cash if refunded to card immediately) |
| Payment fees | Bank fees or Merchant fees (Expense) | Dr Merchant fees / Cr Payments clearing |
| Net payout | Bank | Dr Bank / Cr Payments clearing |
Two notes to keep your process smooth:
- Some accounting systems prefer that you collect customer receipts into an undeposited funds account and then create a single deposit entry to mirror the payout. Others can post individual lines straight into a clearing account. Choose what fits your software and leaves the best paper trail.
- Sales taxes, shipping income, and tips (if applicable) should retain their own mapping so that operating margins aren’t distorted by pass-through items.
Illustrative mapping choice: a store that runs one processor can often live with one “Payments clearing” account. A store using multiple processors might keep subaccounts — one per processor — so each bank deposit can be traced back to the right clearing bucket without cross-contamination.
A monthly payout-reconciliation workflow
Set one recurring session each month — 30 to 60 minutes for many small shops — to bring Shopify activity current. Consistency is more valuable than speed; you’re building a repeatable close routine. The steps below assume you use accounting software and can access Shopify’s payout and finance reports. If you run higher volume or multiple processors, expect to spend more time or consider delegating parts of the process.
- Download the payout report. In Shopify, export the payout and transaction details for the month you’re closing (Shopify Help Center: Understanding Your Payouts). Save the export in your month-end folder. Name files consistently so future-you (or your CPA) can find them quickly.
- Post gross sales. Record gross sales for the payout periods into your revenue accounts, or import order-level data if your workflow is order-based. Handle sales taxes separately in a liability account and confirm that tax amounts from Shopify agree to what you collect and remit.
- Record discounts and gift cards. Post discounts to a contra-revenue account so your gross and net are both visible. Confirm that gift card sales were recorded as liabilities and reduce that liability when cards are redeemed.
- Record refunds. Enter refunds in the period they occur. If the payout includes a fee reversal tied to a refund, post that portion to merchant fees. Avoid reopening prior months unless you’re correcting a material error and you’ve documented the reason.
- Post payment fees. Use the payout breakdown to book merchant fees to the proper expense account. If you also receive a monthly processor statement, reconcile your totals to the statement so that your expense line isn’t missing a late adjustment.
- Use a payments clearing account. Post the net of individual order receipts and related reductions so the clearing account balance equals the payout for that period. The goal is a clean one-to-one match with the expected bank deposit.
- Match the bank deposit. When the bank shows the payout, match it to the clearing account entry and clear it to zero for that payout. This tightens your bank reconciliation and confirms that your accounting reflects what actually cleared.
- Document and resolve differences. If the clearing balance doesn’t equal the deposit, stop and investigate (see the steps below). Add a short note explaining the cause and your fix. These annotations become gold when you review trends or respond to questions months later.
Checklist: monthly payout reconciliation
- Export payout and transaction reports from Shopify
- Post gross sales, discounts, and refunds
- Record payment fees
- Clear payments clearing account to bank deposit
- Review reconciliation and save supporting files
If bank reconciliation feels unfamiliar, this bank reconciliation guide walks through the mechanics. Automations and third-party connectors can reduce entry time, but check mappings periodically. A small mis-map — for example, sending refunds to discounts — won’t shout at you right away, but it will skew margins until corrected.
Illustrative timing practice: close Shopify activity on the same day you close your bank for the month. If a payout lands on the first day of the next month for orders placed at month-end, let the timing stand and explain it in your notes instead of forcing entries into the earlier month.
How to investigate a difference without guessing
Differences happen. The fastest fix is a consistent, documented approach, not a plug entry. Start with the dates, move through the lines, and collect evidence as you go.
1. Confirm the payout period and deposit dates
Payout dates group activity; they are not the dates of the individual orders. Confirm the payout ID and the deposit date shown by Shopify and by your bank; mismatched periods explain many issues out of the gate (Shopify Help Center: Payouts).
2. Reconcile line items
Match each line in Shopify’s payout report to your entries: sales, discounts, refunds, and fees. If you see a fee line in Shopify that isn’t in your books, post it to merchant fees. If a refund appears in the next payout, record it in that later period and note the timing difference; don’t rewrite closed revenue unless you’re correcting a clear error.
3. Watch for withheld or reserve amounts
Processors may hold reserves or delay settlement for risk reasons. If Shopify indicates a withheld amount or an adjustment, record a liability for the hold and track releases from that liability as they are paid. A simple subledger or running list of “held vs. released” amounts prevents double-counting when funds are returned.
4. Use the bank statement and Shopify export as evidence
Don’t guess — build a quick reconciliation worksheet showing Shopify gross, refunds, fees, and the net that equals the bank deposit. Save the Shopify export and the bank statement image together; the IRS stresses keeping reliable records for business transactions (IRS Recordkeeping).
Illustrative reconciliation worksheet (simplified):
| Line | Shopify report | Book entry |
|---|---|---|
| Gross sales | $12,000 | Sales $12,000 |
| Refunds | -$400 | Refunds $400 |
| Payment fees | -$360 | Merchant fees $360 |
| Expected deposit | $11,240 | Clearing cleared to bank $11,240 |
If the numbers still don’t tie, expand your review: look for chargebacks, late adjustments, currency conversion effects if you sell in more than one currency, or manual journal entries that may have combined lines. Leave yourself a one-line explanation for each variance you resolve. Those notes shorten future closes and help any reviewer get oriented quickly.
The reports an owner should review each month
Reviewing the same small set of reports each month will catch issues early and simplify tax prep. Keep the files together in a single monthly folder with clear names.
- Shopify payout report — shows each payout with fee and adjustment details (Understanding your payouts). Scan for unusual fee spikes or withheld amounts.
- Shopify finance summary — summarizes gross and net sales for the period (Finance Reports). Compare discounts and refunds as a percentage of sales to your typical range.
- Bank statement — verify deposit dates and amounts. Save the page or image showing each Shopify deposit.
- Profit and loss — confirm that revenue and merchant-fee lines look reasonable month to month; for help interpreting variances, see the firm’s guide to understanding financial statements.
- Cash flow summary — ensure payout timing isn’t creating a short cash gap before large bills come due; tie this to your planning using small-business cash flow strategies.
Save the Shopify export, the bank statement page, and your reconciliation worksheet in the same folder. The IRS guidance on records is straightforward: keep support that explains income and expenses in your books (IRS: What Records Should I Keep?).
Illustrative review rhythm: scan the payout report for holds and chargebacks, review fees as a percent of sales for drift, glance at refunds compared to last month, and then archive the files. Five to ten minutes here can prevent an hour of cleanup later.
When a CPA or bookkeeper should step in
Bring in a professional when the cost of sorting things out exceeds the value of your time or when the accounting questions are getting in the way of running the business. Common triggers include:
- Differences persist after a careful review and you need help tracing fee or timing adjustments.
- Sales volume, multiple processors, or marketplace activity make manual reconciliation inefficient.
- Your financials aren’t showing gross and net amounts clearly and you want a durable clearing-account setup.
A bookkeeper with e-commerce experience can establish reliable imports and mappings. If you’re evaluating workflows, preview options with a QuickBooks Online test-drive walkthrough or consult a CPA to design and review your close. A pro can also help you document procedures, set naming conventions, and identify where limited automation makes sense without sacrificing accuracy.
As your volume grows, you may also want periodic review of internal controls: who can issue refunds, who reconciles payouts, and how exceptions are approved. For small teams, simple separation — for example, the owner reviewing a monthly reconciliation prepared by staff — goes a long way.
Why this guide is different
The closest existing site page is “QuickBooks Online Test Drive.” This article focuses on the accounting behind e-commerce settlements for Shopify payouts — gross sales, payment fees, refunds, and deposit matching — rather than a product tutorial. The goal is a repeatable month-end routine you can follow regardless of software flavor.
The guidance emphasizes keeping gross revenue and expenses visible, not netted away. That visibility supports practical questions: Are discounts where we expect? Are refunds rising? Are fees consistent with plan? When you can see the parts, you can act on them.
Scope and recordkeeping disclaimer
This article provides general bookkeeping process guidance for U.S. small businesses. It is not individualized tax, legal, or accounting advice. For questions that depend on your specific facts, consult a qualified accountant or tax professional. For recordkeeping expectations and retention, see the IRS guidance on recordkeeping and Publication 583 (IRS Recordkeeping, IRS Publication 583).
Practical notes on payment processors and cards
If you accept credit cards or mobile wallets through Shopify, treat those fees like any other merchant account expense. For a fuller overview of how to classify card fees and handle mobile payments, see the firm’s credit-card and mobile-payment accounting guide. Additional considerations include:
- Chargebacks — record the chargeback when it occurs and track any recovery separately. Watch the payout detail for the chargeback fee and any later reversal.
- Multi-currency sales — if Shopify pays you in a currency different from your accounting currency, capture foreign exchange gains or losses associated with settlement.
- Third-party marketplaces — keep marketplace fees and remittances separate from Shopify payouts so that deposits from different sources don’t get co-mingled in one clearing account.
Document unusual events — a one-time bulk refund, a processor credit, or a reserve release — in your month-end notes. Clear explanations now reduce rework later.
Illustrative exception: if a refund is issued the same day as a payout is finalized, it may appear in the next payout. Rather than forcing it backward, record it in the next period and leave a note. Your totals will align over the two payouts and your reconciliation will stay clean.
Frequently asked questions
Should Shopify sales equal the deposit in my bank account?
No. Shopify sales (gross orders) usually won’t match the deposit because payouts are net of refunds, discounts, and processing fees. Reconcile to the payout by posting gross sales, discounts, refunds, and fees so that the net equals the bank deposit. A clearing account makes this tie-out simple to review later.
How should refunds appear in Shopify bookkeeping?
Record refunds as reductions of revenue — commonly in a contra-revenue account — in the period the refund occurs. If a refund triggers a fee adjustment, post that fee change to your merchant-fees expense. Keep the original sale, refund, and any fee change linked in your records so reviewers can follow the trail without guesswork.
Can I use one clearing account for Shopify payouts?
Yes. One payments clearing (undeposited funds) account works for many stores: post receipts there and clear it when the payout hits the bank. If you also use other processors or marketplaces, consider subaccounts or separate clearing accounts so each payout can be traced to the correct source. The point is traceability — each bank deposit should line up with one clearing entry that equals the payout total.