How Small Businesses Should Reconcile Shopify Payouts, Fees, and Chargebacks

Your Shopify dashboard shows $48,000 in sales for the month. Your bank account received $44,100 in Shopify payouts. And the 1099-K Shopify sends the IRS at year-end will show the full $48,000 — a number your books never recorded, because your accounting software dutifully imported the bank feed and called $44,100 your revenue. Three numbers, one month of selling, and the gap between them is where ecommerce bookkeeping quietly breaks.

The fix is not complicated, but it is specific: record gross sales, split every fee into its own expense account, treat collected sales tax as a liability, and reconcile each payout against the settlement detail instead of trusting the deposit. This guide walks through what a Shopify payout actually contains, how chargebacks move through your books when you win and when you lose, and why sales tax on shipping deserves its own line of attention.

What a Shopify Payout Actually Contains​

A Shopify Payments payout is a net settlement, not a revenue figure. For each payout period, Shopify takes everything customers paid, subtracts its processing fees, refunds, adjustments, and chargebacks, and deposits the remainder. In the US, payouts land on a rolling schedule — typically two business days after a transaction clears — and you can set the cadence to daily, weekly, or monthly in your payment settings.

A typical daily payout might assemble like this:

• Gross card sales of about $2,300
• Less processing fees of about $70 (2.9% plus 30 cents per online transaction on the Basic plan; lower rates on higher-tier plans)
• Less a $120 refund issued that day
• Less a $15 chargeback fee on a disputed order
• Net deposit: about $2,095

Book that $2,095 as revenue and two things go wrong at once: revenue is understated by more than $200, and $85 of deductible fees plus a $120 refund never appear anywhere in your books. Multiply that across a year and your profit-and-loss statement describes a smaller, more profitable-looking business than the one you actually run — while your 1099-K tells the IRS about the bigger one.

Three complications make Shopify payouts harder to reconcile than they first look:

Multiple gateways, multiple streams. If you accept PayPal, Klarna, Shop Pay Installments, or a third-party processor alongside Shopify Payments, each gateway pays out on its own schedule with its own fee structure. PayPal in particular passes no fee data back to Shopify, so its deductions are invisible unless you reconcile the PayPal statement separately.

Refunds cross payout boundaries. A refund issued today is deducted from the next available payout, which may fall in a different week or even a different month than the original sale. Matching refunds to their sales by payout alone will misplace them.

Shopify Capital repayments look like fees. If you carry a Shopify Capital loan or cash advance, repayments are withheld as a percentage of daily sales and appear as deductions in the payout. That withholding is loan repayment — part principal, part cost — not an operating expense. Book it as a fee and you overstate deductions while the loan balance never shrinks on your balance sheet.

Gross vs. Net: The One Rule That Fixes Most Shopify Books​

Record gross sales as revenue. Record every deduction — processing fees, refunds, chargebacks, adjustments — in its own account. Then prove the payout ties out. The net deposit in your bank is the check figure at the end, never the starting entry.

Here is the pattern, using the payout above:

1. Record $2,300 of gross sales to revenue when the orders occur, not when the payout lands.
2. Record the $70 processing fee to a merchant-fees expense account.
3. Record the $120 refund as a reduction of revenue (or a refunds contra-revenue account), dated when you issued it.
4. Record the $15 chargeback fee to the same merchant-fees account.
5. When the $2,095 deposit arrives, match it against those entries. Gross minus deductions should equal the deposit to the penny.

The cleanest way to run this month after month is a clearing account — sometimes called a "Shopify clearing" or "funds in transit" account. Post all Shopify sales activity into the clearing account as it happens, then post each payout out of it when the deposit lands. At any moment the clearing balance represents money Shopify owes you but has not paid yet: sales from the last couple of days still inside the payout window. If the clearing balance grows month after month, or carries stale entries older than a payout cycle, something is unreconciled — a missing refund, a duplicated sale, or a fee posted twice.

One more separation matters enormously: sales tax you collect is not revenue. It is money you hold for the state. Post it to a sales-tax-payable liability account when collected and clear it when you remit. Sellers who let collected tax sit inside revenue overstate income and then scramble at filing time to back the liability out. This matters doubly for Shopify sellers because, unlike Amazon, Shopify is generally not a marketplace facilitator — in most states you are the party responsible for collecting and remitting, and Shopify's tax engine only does what you configure it to do.

Chargebacks: The Lifecycle Most Sellers Book Wrong​

A chargeback is not a refund. A refund is you returning money voluntarily; a chargeback is the customer's bank pulling money back after the customer disputes the charge. Each follows a different path through your books, and conflating them is one of the most common ecommerce errors.

The lifecycle runs in stages:

1. The dispute opens. Shopify notifies you and pulls the disputed amount, plus a fixed dispute fee (typically $15 in the US), from your upcoming payout. At this point, debit a chargebacks-receivable or disputes account and credit the clearing account for the pulled amount, and expense the fee. Do not reverse the original sale yet — the dispute is unresolved, and the money may come back.
2. You submit evidence. Through the Shopify admin you can add tracking numbers, delivery confirmation, customer correspondence, and your refund policy before Shopify forwards the response to the card company. Orders covered by Shopify Protect are reimbursed automatically, fee included, without this step.
3. The dispute resolves — won or lost. If you win, Shopify returns the disputed amount and refunds the fee; reverse the receivable and the fee expense. If you lose, the loss is final: reverse the original sale (or write the receivable off to a chargeback-loss expense account) and leave the fee expensed.

Why the staging matters: sellers who reverse the sale the day the dispute opens understate revenue for every dispute they go on to win, and sellers who never reverse a lost dispute carry phantom revenue and a receivable that will never collect. Track win and loss rates by status — pending, won, lost — the same way Shopify reports them, and review them monthly.

There is also a threshold worth respecting. Card networks watch your dispute rate, and crossing roughly 1% of transactions can trigger a reserve — Shopify holding back a portion of your payouts — or an account review. Monitoring the rate is a cash-flow discipline as much as an accounting one: a reserve quietly changes what each payout contains, and unexplained shortfalls are how stale clearing balances are born.

Sales Tax on Shipping: The Line Everyone Misconfigures​

Whether you must collect sales tax on shipping charges depends on the state — and the rules split three ways:

• Always taxable. States including Texas, Florida, Illinois, Connecticut, and Washington treat delivery charges on taxable goods as part of the sale price, whether or not you list shipping as a separate line.
• Exempt when separately stated. States including California, Virginia, and Arizona let shipping go untaxed when it appears as its own line item and the goods travel by common carrier — but fold it back into the taxable price when you bury it in the item cost.
• Conditional on the goods. In many states, shipping is taxable when the items in the box are taxable and exempt when they are not.

Two traps sit inside those rules. First, handling is not shipping. Several states exempt delivery charges but tax handling, packing, or "shipping and handling" as a combined line — so a single combined line can make an otherwise exempt charge taxable. Second, shipping tax follows nexus: you only owe collection in states where you have nexus, but economic-nexus thresholds mean a growing store can cross into a new state's rules mid-year without noticing.

For your books, the treatment mirrors product sales tax: tax collected on shipping posts to the same sales-tax-payable liability account, never to revenue. In Shopify, verify that your tax settings charge tax on shipping rates where required — the platform can automate this per region, but only from the nexus footprint you give it. Then reconcile the liability account against actual filings each period; a payable balance that drifts ever upward usually means shipping tax (or a whole state) was collected but never remitted.

Mistakes That Corrupt Shopify Books​

Most cleanup engagements trace back to a short list. Check yours against it:

• Booking net payouts as revenue. The deposit is gross sales minus everything. Record the gross and each deduction separately.
• Letting the bank feed do the bookkeeping. An imported deposit line knows nothing about fees, refunds, or tax. It is a reconciliation input, not a journal entry.
• Recording collected sales tax as income. It is a liability from the moment the customer pays it.
• Treating Shopify Capital withholdings as fees. Split each withholding between loan principal and cost.
• Reversing disputed sales before they resolve. Stage chargebacks through a receivable; reverse only on loss.
• Ignoring gateway streams outside Shopify Payments. PayPal and third-party processors need their own reconciliation pass.
• Skipping the clearing account. Without it, there is no balance that proves payouts and sales agree.

A Monthly Reconciliation Routine That Holds Up​

Set aside time each month — or each week at higher volume — and run the same pass:

1. Pull the Shopify Payments payout report and the order-level transaction detail for the period.
2. Post gross sales, discounts, refunds, fees, and collected tax to their accounts from the transaction detail, not from the bank feed.
3. Match each bank deposit to its payout, confirming gross minus deductions equals the deposit.
4. Review the clearing account: the balance should approximate only the last payout window's unpaid sales. Investigate anything older.
5. Age open chargebacks, confirm won disputes were reversed and lost ones written off, and check your dispute rate against the 1% line.
6. Reconcile sales-tax payable to what you filed and remitted, state by state, including tax on shipping.

Done consistently, this routine does more than keep the books clean. It surfaces fee creep, flags refund problems early, keeps 1099-K totals reconcilable to your revenue, and gives you SKU-level margins you can actually price from — because every fee finally lives where it belongs.

Keep Your Shopify Books Reconciled From Day One​

As your store grows across gateways and states, the payout math only gets more layered — and the sellers who stay accurate are the ones who built the gross-up habit early. Beancount.io provides plain-text accounting that gives you complete transparency and control over your financial data — no black boxes, no vendor lock-in. Get started for free and see why developers and finance professionals are switching to plain-text accounting.