Shopify payout reconciliation starts with understanding what you’re comparing. Your dashboard shows sales activity. Your payout shows money being sent. Your bank shows money received. Those numbers describe different things, and their dates don’t always line up. Book the deposit as revenue, and your P&L loses the detail needed to explain what you earned.
When I look at the books, I want to follow the money from the sale through the payout to the bank. I also want fees, refunds, and other deductions recorded where they belong.
That’s part of our Shopify bookkeeping. The goal is straightforward: you should know what you made after the costs, without rebuilding the story yourself every month.
What’s inside a Shopify payout
A Shopify Payments payout is a settlement of payment activity. Depending on your setup, one deposit can cover several days of orders. It can also include deductions connected to earlier sales.
Here’s what I look for:
- Customer payments: Money collected on orders. Discounts already reduce what customers pay; they aren’t another payout fee.
- Refunds: Money returned to customers, potentially for orders from an earlier period.
- Shopify Payments fees: Processing costs deducted before the money reaches you.
- Chargebacks and chargeback fees: Disputed payments and related charges.
- Adjustments and reserves: Changes to the amount available for payout, including money held back or released.
Shopify explains the deductions associated with chargebacks and how reserves hold funds.
A reserve isn’t automatically an expense. It can be money still owed to you but temporarily unavailable. An adjustment also needs an explanation before it gets an account in the books.
Gross sales, net sales, and the payout aren’t interchangeable. I use the sales detail to explain what was sold and the payout detail to explain what moved.
What isn’t in the payout
Not every payment method follows the same path. A separately settled gateway needs its own reconciliation. But I wouldn’t assume every alternative checkout option pays separately.
Depending on your setup, PayPal may settle separately or run through Shopify Payments. Check which version you use. Shopify explains the integrated option in its PayPal Wallet documentation.
Shopify’s current documentation also says Shop Pay Installments is included in Shopify Payments payouts. Amazon Pay through Shopify Payments pays through Shopify Payments too. The payment method’s name alone doesn’t tell you where to look for the deposit.
Your Shopify subscription and app charges are billed separately from payment processing deductions. Some apps bill you directly. Those expenses still need to reach the books, even though they don’t appear in the payout breakdown. See Shopify’s billing explanation.
Gift card proceeds can arrive in a payout, but selling a gift card creates a liability until it’s redeemed for goods. Don’t treat that receipt as product revenue and count it again at redemption. Shopify tracks gift card activity in its finance reports.
Sales tax collected isn’t revenue.
Shopify payout reconciliation: how to match payouts to the bank
1. Pull the payout details and transaction export
Start with the payout you’re trying to explain. Pull its details and export the transactions behind it. Shopify provides instructions for viewing and exporting payout information.
Keep the sales detail available too. You may need it to separate gross sales, discounts, and returns correctly.
Check the dates and currency before comparing totals. A sales report for one calendar period won’t necessarily equal payouts received during that same period.
2. Match each payout to its deposit
Find the corresponding bank deposit using the amount, payout reference, currency, and date. Allow for the difference between when a payout is sent and when the bank records it.
If something doesn’t match, investigate it. Check whether the payout is still pending, failed, or affected by an adjustment. Don’t create an expense called “difference” just to finish.
3. Put each component in its own account
Record sales, refunds, discounts, processing fees, and chargeback activity separately enough that you can understand them.
Discounts and refunds reduce sales. Processing fees are expenses. Track disputed amounts separately from dispute fees, and account for any later recovery without duplicating the original sale.
If your import already records sales after discounts, don’t deduct those discounts again. The entries need to explain the activity once.
4. Clear settled activity and explain what remains
A clearing account tracks money between the customer payment and the bank deposit. Think of it as a waiting room.
When the related transactions, deductions, and deposit are recorded, that completed payout should clear to zero.
The entire account doesn’t have to be zero at month-end. Pending payouts or reserves can leave a legitimate balance. I want that balance tied to identifiable amounts still outstanding—not forced to zero with an unexplained entry.
5. Reconcile each separately settled gateway
Repeat the process for every gateway that sends money separately. Use its transaction records, fees, refunds, and transfers.
Be careful with connectors and bank feeds. If Shopify activity already recorded the sale, the gateway deposit should settle the balance owed. It shouldn’t create revenue again.
Where a connector helps and where it stops
A2X and similar tools can turn payout activity into accounting summaries. That reduces manual work and gives you a consistent way to bring the detail into your books.
But the tool needs instructions about where transactions belong. A2X’s setup documentation explains that account mapping is part of the process.
Those mappings can stop fitting as your store changes. A new payment method or transaction type may need attention.
I still want someone checking the fees, investigating clearing balances, and confirming that inventory costs are recorded correctly. A payout matching the bank doesn’t prove the whole P&L is right.
Cost of goods sold needs particular care. Payment data explains what customers paid. It doesn’t, by itself, establish what those products cost you.
Selling on Amazon too
Amazon settlements have their own structure and deductions. I explain that process in Amazon payout reconciliation.
Keep each channel’s settlement activity traceable, then bring both into one reconciled set of books.
Shared inventory needs one set of cost records. If the same product sells through Amazon and Shopify, its cost shouldn’t change because two separate spreadsheets use different assumptions. Record the cost of each unit sold once.
That’s why I treat ecommerce bookkeeping as one connected job. Reconciling the deposits matters, but so does making sure both channels use the same inventory records.
Common mistakes
- Booking net deposits as sales. This hides the deductions inside a revenue number and makes the P&L harder to understand.
- Lumping every fee together. Processing costs, app charges, and dispute fees become harder to review when they all disappear into one vague category.
- Ignoring chargebacks. The missing cash gets treated as a mystery instead of a transaction that needs tracking.
- Not reconciling separately settled PayPal activity. Sales may be recorded while fees, refunds, or money still held in the account go unchecked.
- Letting the clearing account drift. An unexplained balance carries forward until nobody knows which payouts or entries created it.
FAQ
Why doesn’t my Shopify payout match my sales?
Sales and payouts measure different activity. Discounts, refunds, processing fees, disputes, reserves, and timing can all affect the comparison. I start with the transactions inside the payout instead of expecting it to equal a dashboard total.
How often should I reconcile Shopify payouts?
I recommend matching payouts regularly and completing the reconciliation as part of your monthly bookkeeping. If you have frequent transactions or unexplained differences, check more often so problems don’t accumulate.
Do I need A2X for Shopify?
No. You need a reliable process for recording the activity and matching it to the bank. A2X can reduce manual work, but someone still needs to review the mapping and finished books.
Where do Shopify fees go in my books?
Processing fees belong in an expense account, separate from sales. Subscription and app charges should go into appropriate expense categories, with chargeback fees tracked clearly too. I want you to see what each cost is doing to profit.
We keep your books reconciled, reviewed, and consistently up to date, so you can see your profit after platform fees, ad spend, and the cost of inventory sold. See how we handle Shopify bookkeeping and Amazon bookkeeping.
The same payout-to-bank discipline applies across channels: reconcile each platform’s activity to its deposits, then bring the results together in one set of books.
