Partner, SDO CPA LLC / CEO, Growthy
Your Shopify payout hits the bank: $1,847.32. Your Shopify sales dashboard says $2,100.00. The gap isn't missing money. It's Shopify Payments fees, refunds you issued, and shipping you collected, all netted before the deposit hits. The bank shows you the result. Bookkeeping requires you to show the work.
That gap is where most Shopify bookkeeping breaks down. Merchants book the net deposit as revenue. Fees disappear. Refunds never make it to the books. The numbers look clean until the accountant asks why gross profit doesn't match sales reports.
This guide walks one real Shopify payout from gross sales to net deposit, shows the journal-entry pattern that reconciles it cleanly, and explains why the calendar is the wrong unit for Shopify reconciliation.
What is Shopify payout reconciliation?
Shopify payout reconciliation is the process of matching each Shopify payout to the specific sales, fees, refunds, and shipping charges that make up that deposit. Shopify Payments charges 2.4% to 2.9% plus $0.30 per transaction depending on your plan. Refunds, returns, and chargeback holds come out before the deposit. A $2,100 gross sales period might produce a $1,847.32 payout after $61.20 in fees, $87.50 in refunds, and a $104 shipping offset. The goal is a Shopify Clearing account that hits exactly $0.00 after each payout settles. If the balance is not zero, there is an open item that needs a name.
The Shopify payout report is the source document for reconciliation. It is not the bank statement. The bank statement shows one number: $1,847.32. The payout report shows how Shopify got there.
Here is what a real payout contains, using a single 30-day payout period as the example:
Line item | Amount |
|---|---|
Gross sales | $2,100.00 |
Shopify Payments fees | ($61.20) |
Refunds issued | ($87.50) |
Shipping collected (net) | ($104.00) |
Chargebacks | $0.00 |
Net deposit | $1,847.32 |
Four deductions came out before the money moved. None of them appear as separate lines on the bank feed. Booking the deposit as revenue misses all four.
Shopify Payments fees are a percentage of each transaction plus a flat amount. On the Basic Shopify plan, that is 2.9% plus $0.30. On Shopify plan, 2.6% plus $0.30. On Advanced, 2.4% plus $0.30. The math on 30 transactions totaling $2,100 at 2.9% plus $0.30 per transaction: (0.029 × $2,100) + (30 × $0.30) = $60.90 + $9.00 = $69.90. The example uses $61.20 for a higher-tier plan. Always pull the exact figure from the payout report, not an estimate.
Refunds issued reduce the payout for returns that settled during the period. A $87.50 refund during the period means $87.50 that already hit revenue now needs to come back out. If you booked the original sale, you need to book the refund.
Shipping collected is money your customers paid for shipping that Shopify holds and disburses through the payout. This often nets close to zero because Shopify subtracts shipping label costs from what was collected. The net amount appears in the payout report. It is not revenue and it is not an expense. It is a pass-through.
Chargebacks and dispute holds can appear in a current period or arrive in a later payout after the dispute window closes. A chargeback freezes the disputed amount for up to 75 days. The resolution shows up as an adjustment in a future payout. If you do not track dispute holds, that adjustment looks like unexplained income or expense when it finally clears.
Shopify Capital advances appear in the payout dashboard as positive numbers. They are debt, not income.
A $10,000 Shopify Capital advance is a loan Shopify recovers by taking a fixed percentage of your daily sales until the total is repaid. The entry is simple: debit Cash $10,000, credit Loan Payable $10,000. When Shopify recoups the daily percentage, debit Loan Payable, credit the cleared amount. None of this is revenue.
Booking an advance as revenue inflates income and hides a liability on the balance sheet. If it shows up in the payout report, treat it as financing from the start.
Shopify does not pay out once a month. Payouts run on a cycle tied to business days, typically every one to three business days depending on your bank. That schedule does not align with the calendar.
A payout initiated on January 30 may not settle in your bank account until February 1 or February 2 depending on your bank's processing time. If you close your books on January 31 and match deposits to calendar month, that payout is either missing from January (if it hasn't hit yet) or double-counted in February (if you reconcile what lands in the bank each month without matching it back to the Shopify payout period).
For clean reconciliation, you match by payout ID, not by deposit date. Shopify Admin → Finances → Payouts lists every payout with a unique ID, the date range it covers, and the gross and net amounts. That report is the anchor. The bank feed is the confirmation.
Here is the practical difference:
Payout #98765 covers sales from January 28 through January 30. It initiates January 30 and settles in the bank on February 1. If you reconcile by calendar month, you have two choices, both wrong: include it in January (it hasn't settled) or include it in February (it belonged to January sales).
The right approach: reconcile Payout #98765 as a January payout because that is the period it covers. Match the payout ID from the Shopify report to the $1,847.32 bank deposit dated February 1. Note the settlement date. Move on.
The payout ID is the reconciliation anchor. The deposit date is the confirmation.
Some payouts cover sales that span two calendar months. A payout period from January 29 through February 1 includes sales from two different months.
For cash-basis bookkeeping, book it on the deposit date and note the period. For accrual-basis, split the gross sales by the dates they occurred, match fees proportionally, and book the revenue in the right month. Document which payout period each line covers. You will not remember in March what the split looked like in January.
This is why looking at a bank feed alone misses most of the ecommerce bookkeeping picture. The feed shows one number on one date. The reconciliation is in the payout report.
The mechanics of a clean Shopify close use three entries per payout period. All three route through a Shopify Clearing account, which is a current asset account set up specifically to hold the in-transit amount between recording sales and recording the bank deposit. The clearing account should hit $0.00 after the third entry. That zero is the signal that everything reconciled.
Using the example from the first section: $2,100.00 in gross sales, $61.20 in fees, $87.50 in refunds, $104.00 shipping net, $1,847.32 net deposit.
When the payout period closes (or at the time of sale for accrual-basis), record the full gross revenue:
1Debit Accounts Receivable $2,100.002Credit Sales Revenue $2,100.00
For cash-basis bookkeeping, this entry records when the payout initiates rather than when each individual sale occurs. Either way, record the full $2,100.00 — not the net deposit amount.
Record the deductions that Shopify took before paying:
1Debit Shopify Fees Expense $61.202Debit Sales Returns & Allowances $87.503Debit Shopify Clearing $1,847.324 Credit Accounts Receivable $2,100.005 Credit Shipping Collected (liability) ($104.00 already netted in Clearing)
The Shopify Clearing account now has a debit balance of $1,847.32. It represents the money Shopify owes you: the payout that has not hit the bank yet. The fees and refunds are now on the books separately as expenses and contra-revenue.
Note: the shipping collected line nets to near zero in this example. Include it explicitly in your chart of accounts so it does not hide inside revenue or clearing. If shipping collected exceeds shipping costs, the net goes to a Shipping Revenue account.
When the deposit hits the bank account:
1Debit Checking Account $1,847.322 Credit Shopify Clearing $1,847.32
After this entry, the Shopify Clearing account balance is $0.00.
A $0.00 clearing account balance after payout settlement means every dollar reconciled. Every deduction has a named entry. The bank deposit matches the books.
A non-zero balance after settlement means something does not have a name yet. A $0.03 balance is usually fee-calculation rounding between Shopify's math and your books. A $47.00 balance is an open item that needs investigation. Common causes: a refund that was issued but not booked, a chargeback hold that released in this period, or a shipping collected offset that landed in the wrong account.
The clearing account tracks the in-transit amount between the payout period and the bank settlement. When it does not zero, the work is not done.
Connecting this entry pattern to the broader ecommerce inventory and COGS cycle gives you the complete close: revenue decomposed from payouts, cost matched to units sold, and the balance sheet telling you what you have and what you owe.
Two practical approaches exist for Shopify bookkeeping automation, and they serve different use cases.
Connector tools like A2X map Shopify payout data directly to QuickBooks Online or Xero. They automate the journal entries described above by pulling from the Shopify payout report and writing to the GL on a schedule. For a merchant keeping their own books on one or two Shopify stores, this is a reasonable automation.
The tradeoff: connectors generate entries automatically, but someone still needs to review them. Fee categorizations can drift. Refund entries can land in the wrong period. The automation reduces manual entry but does not eliminate the need to understand what the entries mean. Pricing and features change; verify directly with the vendor.
For a comparison of how different tools handle ecommerce bookkeeping, this guide to ecommerce accounting software walks through the category.
Bookkeepers managing 10 or 20 Shopify clients in the same period need a model that does not require per-store manual entry for every payout. The connector model built for individual merchants does not scale when you are running the same close across multiple stores with different payout schedules and different plan tiers.
Growthy is built for this workflow. The import layer handles payout-level data for multiple stores. Accuracy on first import is 85%. You review the rest. That means a bookkeeper spends time on the 15% that needs judgment, not on entering the 85% that follows the same pattern every period.
This is the one place Growthy belongs in this article. If you are a merchant keeping your own books, a connector tool or a clean spreadsheet approach works. If you are a bookkeeper running multiple Shopify clients, Growthy is designed for that volume.
Every Shopify payout reconciliation comes down to the same question: does the Shopify Clearing account balance return to $0.00 after settlement?
If it does, every deduction has a name. Revenue is gross. Fees are in the right expense account. Refunds are contra-revenue. The deposit ties to the payout report. The books match.
If it does not, there is an open item. The most common causes are a refund that was not booked, a chargeback hold that released in the current period, or a fee-rounding difference. The size of the balance tells you how urgent the investigation is.
The payout report is the source document. The bank feed confirms settlement. The clearing account bridges the two. Get that pattern working on one payout period and it repeats the same way every period after.
Growthy is bookkeeping software, not a CPA firm. This content is educational, not professional advice.
Free during alpha. Read-only access. You review every sync.
Bobby Huang • Partner, SDO CPA LLC / CEO, Growthy
CPA firm partner who got tired of watching bookkeepers click categorize 500 times a day. Built Growthy to fix it.
View author profileGrowthy is dedicated to helping businesses of all sizes make informed decisions. We adhere to strict editorial guidelines to ensure that our content meets and maintains our high standards.
You set up QBO for an ecommerce client. The default chart looks fine. Then the Shopify payout lands. You have one "Product Revenue" account. No line for Amazon fees. Sales tax in income where it has no place.
Most ecommerce sellers get paid two to three weeks after a sale. That delay is fine for cash flow planning. But many sellers let that same delay drive how they record costs. That's a much more expensive mistake.
You open one Shopify store. You sell to buyers across the country. It feels like one business, in one place, with one ecommerce sales tax nexus problem.