How should Shopify sales, refunds, fees and payouts be recorded?
Most Shopify sellers run into the same problem in their books. The Shopify payout hits the bank and the full amount gets categorized as sales income. That deposit isn’t your sales. It’s what’s left after Shopify pulled out processing fees, refunds, and other adjustments. Recording it as revenue understates your gross sales, hides refunds and discounts entirely, ignores the sales tax you collected on behalf of the state, and produces financials that can’t tell you how the business is performing.
The right approach is to split each payout into its components and book each piece to the appropriate account.
Gross sales is what customers actually paid for products before any discounts, refunds, or fees. This is your real top-line revenue. If you sold $50,000 in products but only $42,000 in deposits landed in the bank, your books should still show $50,000 in sales.
Discounts belong in a contra-revenue account. When a customer uses a promo code or you run a 20% off sale, the reduction needs to be visible. It tells you how much margin you’re giving up to promotions.
Refunds also go to their own contra-revenue account, not netted against sales. Tracking returns separately lets you monitor return rates and catch problems early.
Shipping income collected from customers is its own revenue line. Some sellers offset it against shipping expense, which can work if you stay consistent. Tracking it separately gives a cleaner picture of whether shipping is a profit center or a money loser.
Sales tax collected is a liability, not income. The money belongs to the state and you’re just holding it until you remit. Booking it as revenue inflates sales and creates a mess when you try to reconcile what you owe. Tools like TaxJar help here, especially with multi-state nexus, and we cover sales tax workflows as part of our e-commerce bookkeeping work.
Payment processing fees are an expense. Shopify Payments, PayPal, Shop Pay Installments, and any other processor fees should hit a merchant fees expense account. Don’t bury these in cost of goods sold or net them against revenue. They add up to real money and deserve their own line so you can see what payment processing is actually costing you.
Net deposit is what hits the bank. Once everything above is recorded, the math should tie back to the payout amount. That’s how you know the entry balances.
The mechanics usually involve a monthly journal entry pulled from Shopify’s payout reports, or a tool like A2X that automates the breakdown. Either approach works. What doesn’t work is treating each deposit as revenue and hoping it sorts out later. It won’t. You end up with overstated revenue, hidden refunds, sales tax liabilities you can’t track, and books that don’t match reality.
For Shopify sellers across the Carolinas, our bookkeeping, tax and consulting services include payout breakdowns, sales tax tracking, and monthly reconciliation so the numbers actually mean something at the end of the month.
Trusted Accounting for Small Businesses
First Step:
Start With a Call
Tell us about your business and what you need help with. We'll ask a few questions, evaluate your current situation, and let you know how GMJ can support your books, taxes, and day-to-day operations.
More Questions
What is the difference between IRS tax representation and tax audit support?
Tax representation means an authorized professional communicates with the IRS on your behalf. Audit support is the work behind the scenes, preparing documents, drafting responses, and guiding you through what the IRS is asking for.
Read answerWhat bookkeeping cleanup should I do before applying for a business loan?
Reconcile every account through the most recent month, build an accurate debt schedule, categorize revenue and expenses properly, and separate owner draws from business expenses. Lenders need clean financials that show real cash flow before they'll approve.
Read answerHow should a dental practice track insurance payments and patient receivables?
Separate patient balances, insurance receivables, adjustments, refunds, and merchant deposits into distinct accounts. The practice management software tracks patient-level detail while accounting software needs summary entries that reconcile back to it.
Read answerHow are monthly bookkeeping prices usually based on average expenses?
Bookkeeping firms price by average monthly expenses because that number is a reliable proxy for how much work the books require. More dollars flowing through usually means more transactions, more accounts, and more complexity to reconcile each month.
Read answerHow can tax planning change when an owner is choosing LLC, S corp or partnership treatment?
Entity choice changes how income flows to your personal return, how much self-employment tax you pay, and what compensation rules apply. Each structure has trade-offs around payroll, distributions, basis tracking, and state filings that shape your planning every year.
Read answerWhat is the difference between Form 990, 990-EZ and the 990 postcard?
The three versions of Form 990 differ by the size of the nonprofit filing them. Small organizations file the postcard, mid-sized file 990-EZ, and larger ones file the full Form 990. The IRS sets thresholds based on gross receipts and total assets.
Read answer