Guide · 8 min read · November 9, 2026
Shopify bookkeeping: reconciling payouts, fees and refunds
Your Shopify dashboard says you sold $12,400 last week, but the bank shows a deposit for a lot less. That gap is where most eCommerce books go wrong. This guide is for Shopify store owners and finance leads who want revenue, fees and refunds recorded correctly, with a clearing-account method and a payout-by-payout reconciliation you can run every month.
What's inside
- · Why a Shopify payout never matches your sales
- · How to set up a Shopify clearing account
- · Reconciling a payout, with a worked example
- · Recording refunds, chargebacks and negative balances
- · A monthly checklist and how to fix a clearing account that won't zero out
Why a Shopify payout never matches your sales
A Shopify Payments payout is a net number. Shopify deducts processing fees from each transaction before the payout is sent, takes refunds out of the next available payout, and can hold back funds for chargebacks or a reserve. One deposit in your bank can bundle several days of orders, and in the US, payments captured on Friday, Saturday and Sunday are grouped into a single payout.
Timing adds another layer. For US merchants, payouts typically land within 3 to 5 business days after a customer's payment is captured, so sales from the last days of a month often reach your bank in the next one. If your bookkeeper records each deposit as sales, revenue ends up understated by your fees and refunds, and spread across the wrong months.
Charges
The full amount customers paid: product price, shipping and the sales tax you collected. This is your gross, before anything comes out.
Fees
Card processing fees, deducted per transaction. They belong in an expense account, not netted against revenue.
Refunds and adjustments
Refunds, chargebacks, chargeback fees and other adjustments that reduce what Shopify sends you.
Reserves and holds
Funds Shopify keeps back to cover possible disputes or refunds. Still your money, just not in your bank yet.
Set up a Shopify clearing account
The fix is a clearing account: a current asset account in QuickBooks Online or Xero, called something like "Shopify Payments Clearing", that stands in for the money Shopify is holding for you. Sales go in at gross, fees and refunds come out, and each payout moves the net amount to your bank. When everything is recorded correctly, the clearing account's balance equals the funds Shopify still owes you.
| Account | Type | What goes in it |
|---|---|---|
| Shopify Payments Clearing | Current asset | Gross charges in, fees, refunds and payouts out |
| Product Sales | Income | Item revenue, before discounts and refunds |
| Shipping Income | Income | Shipping charged to customers |
| Refunds and Returns | Contra income | Refunded product and shipping amounts |
| Sales Tax Payable | Current liability | Sales tax collected from customers |
| Merchant Processing Fees | Expense | Shopify Payments transaction fees |
| Chargeback Losses and Fees | Expense | Lost disputes and chargeback fees |
Keep sales tax out of income. Tax you collect from customers is money you owe a state, so it belongs in a liability account until you remit it. If you also sell through PayPal, Amazon or another channel, give each one its own clearing account so the balances never blend.
Reconcile a payout, step by step
Shopify gives you what you need for this. In the admin, go to Finance, then Payouts, open a payout and export its transactions to CSV. The file lists each transaction with its type, order number, amount, fee and net, and Shopify's payout details guide explains every field. Work through each payout like this:
- 01
Export the payout's transactions
Download the CSV for one payout at a time. Its net total should equal the deposit amount in your bank.
- 02
Summarize by type
Total the charges, refunds, adjustments and fees. A pivot table on the Type column takes a minute.
- 03
Record the gross sales
Debit the clearing account for total charges and credit product sales, shipping income and sales tax payable. Your order or sales report gives you that split.
- 04
Record fees, refunds and adjustments
Credit the clearing account for each and debit the matching expense or contra-income account.
- 05
Match the deposit
Record the bank deposit as a transfer from the clearing account to your bank account, not as income. The clearing account should drop by exactly the payout amount.
A worked example
Say a DTC skincare brand gets a Monday payout of $11,317.80. The hypothetical CSV totals look like this:
| Line | Amount | Where it goes |
|---|---|---|
| Charges | $12,400.00 | Product sales $11,050, shipping income $600, sales tax payable $750 |
| Refunds | -$600.00 | Refunds and Returns |
| Processing fees | -$387.20 | Merchant Processing Fees |
| Chargeback: disputed order | -$80.00 | Chargeback Losses and Fees |
| Chargeback fee | -$15.00 | Chargeback Losses and Fees |
| Payout to bank | $11,317.80 | Transfer from clearing to checking |
Check the math before you post anything: $12,400.00 minus $600.00, $387.20, $80.00 and $15.00 equals $11,317.80, which matches the deposit. Revenue is recorded at the full $11,650 of product and shipping sales, fees show up as a real expense, and the clearing account goes back to the balance it had before this batch of orders.
Refunds, chargebacks and negative balances
These are the entries that most often throw a Shopify reconciliation off. Each follows Shopify's own rules, so record them the way the money actually moves.
Refunds keep the fee
Shopify doesn't return the original processing fee when you refund an order. Book the full refund against revenue and leave the original fee in expenses, where it was already recorded.
Refunds come from the next payout
A refund issued today reduces the next available payout, which may contain completely different orders. Record it in the period you issued it, not the period of the original sale.
Chargebacks pull money immediately
When a US customer files a chargeback, Shopify withdraws the disputed amount plus a $15 fee right away. Both come back if you win the dispute, so reverse the entries then rather than writing them off early.
Negative balances hit your bank
If refunds, disputes or fees exceed your Shopify balance, Shopify can debit your bank account outside the normal payout schedule. Record that debit as a transfer from your bank into the clearing account, not as an expense.
Shopify's refunds and payouts page covers the details, including how bank debits are retried if the first attempt fails.
A monthly Shopify bookkeeping checklist
- 01
Reconcile every payout
Match each deposit in the month to its payout CSV and post the gross, fee, refund and adjustment entries.
- 02
Account for money in transit
Sales from the last few days of the month will pay out next month. They should sit in the clearing account at month-end, not vanish.
- 03
Tie out the clearing balance
Compare the clearing account to Shopify's balance, including pending and reserved funds. The Shopify Payments activity report under Finance, then Documents, summarizes balance activity over a date range.
- 04
Record Shopify's own bill separately
Your Shopify plan, app charges and any third-party transaction fees appear on your Shopify bill. The activity report excludes Shopify billing fees, so record each bill as its own expense from the invoice.
- 05
Review refunds and open disputes
List refunds issued and chargebacks still under review, so you know which entries may reverse next month.
When the clearing account won't zero out
Some balance in the clearing account at month-end is normal: it's the money Shopify still holds. A balance that keeps growing, or one that turns negative, means something was missed. The usual causes:
- Deposits recorded as income through a bank rule, so sales were counted twice
- Sales recorded net of fees, which understates both revenue and expenses
- Refunds booked against the wrong month, or not booked at all
- Bank debits for negative balances categorized as an expense
- Reserves or held funds treated as lost money instead of an asset
- Orders paid through PayPal or another gateway posted to the Shopify Payments clearing account
Fixing these one payout at a time is slow, which is why a clean month-end routine matters. Our month-end close checklist shows where payout reconciliation fits in the close, and our reconciliation services cover Shopify clearing accounts alongside your bank and card accounts. See how we work with online brands on our eCommerce bookkeeping page.
Frequently asked questions
- Should I record Shopify sales from the bank deposit?
- No. The deposit is net of fees and refunds and can cover several days of orders. Record gross sales through a clearing account, then record the deposit as a transfer from that account to your bank.
- Does Shopify refund processing fees when I refund an order?
- No. Shopify doesn't return the original transaction fee when you issue a refund, though it doesn't charge an extra fee for the refund itself. The original fee stays in your processing fee expense.
- How long does a Shopify payout take to reach my bank?
- For US merchants using Shopify Payments, payouts typically arrive within 3 to 5 business days after the customer's payment is captured. Weekend payments are grouped into one payout, and new stores can wait longer.
- Where do I find the details of a Shopify payout?
- In the Shopify admin, go to Finance, then Payouts, and open the payout. You can see its charges, refunds, adjustments and fees, and export the transactions to a CSV that is emailed to you.
