Shopify Bookkeeping 101: How to Reconcile Payouts, Fees, and Refunds
Shopify payouts rarely match your sales numbers - and that's normal. Here's how to reconcile Shopify payouts, fees, and refunds so your books actually make sense.
7/25/20263 min read
If you've ever looked at a Shopify payout in your bank account and thought "that's not what I expected," you're not alone. Shopify bookkeeping trips up even experienced business owners, mainly because a single sale actually involves several moving pieces - sales tax, processing fees, refunds, and payout timing - before it ever lands as one lump sum in your bank.
Here's how to make sense of it.
Why your bank deposit never matches your sales total
This is the single most common source of confusion in Shopify bookkeeping. Say you made $1,000 in sales this week. Your bank deposit almost never shows $1,000 - it might show $947, or $1,020, or some other number that seems to come from nowhere.
That's because your payout is actually:
Sales − Refunds − Shopify Fees + Sales Tax Collected (held or remitted) = Your Actual Payout
If you only track the deposit amount, you're missing the details of what actually happened - and your books will slowly drift out of sync with reality.
Reconciling Shopify payouts, step by step
1. Pull your Shopify Payout Report, not just your bank statement. Shopify provides a detailed payout report showing gross sales, fees, refunds, and adjustments for each payout period. This is your source of truth - your bank statement only shows the net result.
2. Record gross sales, not net deposits, as revenue. Your actual revenue is what customers paid before fees were deducted. Recording only the net deposit as revenue understates your sales and distorts your margins.
3. Track Shopify fees as a separate expense line. Processing fees, subscription costs, and app fees should be recorded as their own expense category - not silently netted out of revenue. This matters for understanding your true profit margins.
4. Match refunds to the original sale. Refunds should reduce the revenue from the period the original sale happened in, not just show up as a random deduction in the period the refund occurred. This keeps your monthly reports accurate.
5. Reconcile the payout total against your bank deposit. Once gross sales, fees, and refunds are recorded, the resulting net figure should match what actually landed in your bank account. If it doesn't, that mismatch is your signal something was missed or miscategorized.
Sales tax adds another layer
If Shopify is collecting and remitting sales tax on your behalf in certain states or regions, that collected tax typically isn't your revenue and isn't your expense - it passes through your books rather than sitting in either category. Recording it incorrectly is one of the most common Shopify bookkeeping mistakes, and it can quietly overstate your revenue if left unchecked.
Multi-currency makes this even trickier
If you sell internationally, add currency conversion into the mix. A sale made in CAD or GBP gets converted to your home currency at the time of payout - not at the time of sale - which means the exact dollar amount can shift slightly between when the order was placed and when the payout actually arrived. Left untracked, this creates small, recurring discrepancies that are hard to trace after the fact.
A simple monthly Shopify bookkeeping checklist
Pull the Shopify Payout Report for the period
Record gross sales (not net deposits) as revenue
Record Shopify fees as a separate expense
Match refunds back to their original sale period
Confirm sales tax is tracked as pass-through, not revenue
Reconcile the final numbers against your actual bank deposit
Flag and investigate any unexplained differences
The bottom line
Shopify bookkeeping isn't complicated once you understand the moving parts - but it does require tracking gross activity, not just the number that lands in your bank account. Businesses that only record net deposits often end up with understated revenue, inflated margins, and numbers that quietly drift further from reality every month.
Selling on Shopify and tired of numbers that don't add up? Desmic Solutions specializes in e-commerce accounting - Shopify payout reconciliation, multi-currency handling, and clean monthly books for sellers across the US, Canada, and UK. Schedule a free consultation to see what accurate Shopify bookkeeping actually looks like.