What's the right way to record Shopify sales in my books?
The most common mistake is recording the Shopify payout deposit as revenue. That deposit is a net number. Shopify has already subtracted payment processing fees, refunds, and sometimes shipping label costs before sending money to your bank account. If you book the deposit as sales, your revenue is understated, those expenses are invisible, and your financial statements don’t reflect what actually happened.
The right approach is to record everything at gross amounts so each component lands in its proper account. Gross sales go to a revenue account reflecting the full amount customers paid. Shopify fees like payment processing, transaction fees, and subscription costs go to an expense account so you can see what the platform actually costs you. Sales tax collected goes to a liability account because that money belongs to the state. It is not your revenue. When you remit it, you reduce the liability. Refunds should reduce revenue directly rather than showing up as an expense, because a refund is revenue that didn’t happen.
Shipping adds another layer. What customers pay you for shipping can be recorded as revenue or as an offset to your shipping costs. Just be consistent. Shipping labels you purchase through Shopify are an expense.
The tricky part is that Shopify bundles everything into a single payout. One bank deposit might represent several days of sales minus fees, minus refunds, minus a few shipping labels. Breaking that apart manually every time gets old fast. Apps like A2X or Synder connect Shopify to QuickBooks Online and automatically create summary journal entries that split each payout into the correct accounts. The monthly cost of those tools pays for itself in time saved and accuracy gained. If you prefer doing it manually, use Shopify’s Finances Summary report. It breaks down gross sales, discounts, returns, shipping, taxes, and fees for any date range. Create a journal entry matching those totals and reconcile to your bank deposits for the same period.
Getting this right matters more than most e-commerce sellers realize. A store showing $50,000 in monthly Shopify deposits might actually have $58,000 in gross sales with $4,000 in processing fees, $3,000 in refunds, and $1,000 in shipping costs buried in those payouts. Without proper recording, you can’t see the true cost structure and you can’t make smart decisions about pricing, ad spend, or which products to keep selling.
However you handle it, reconcile at least monthly. Your Shopify reports and your books should agree down to the penny. If they don’t, something was recorded wrong, and small discrepancies compound over twelve months into numbers that throw off your tax return.
If your books currently show Shopify deposits as a single line of income, it is worth going back and fixing. Our bookkeeping services can help clean that up and set you up with a system that captures the full picture going forward. Once the structure is right, maintaining it becomes routine rather than a headache every month.
Greater Nashville's Trusted Financial Partner
The Next Step:
A Quick Conversation
Tell us about your business and where you need support. We'll listen, figure out what makes sense for your situation, and give you a straightforward quote.
More Questions
What forms do I need to file for my small business taxes?
The forms you need depend on your business entity type. Sole proprietors file Schedule C, partnerships file Form 1065, S-corps file Form 1120-S, and C-corps file Form 1120. Most businesses also need to file payroll returns and 1099s.
Read answerWhat's a Schedule C and do I need to file one?
Schedule C is the IRS form that reports profit or loss from a business you run as a sole proprietor or single-member LLC. If you earned more than $400 in net self-employment income during the year, you're required to file one.
Read answerCan a bookkeeper fix my messy QuickBooks file?
Yes. A skilled bookkeeper can clean up uncategorized transactions, fix miscoded entries, remove duplicates, and reconcile your accounts so the data is actually reliable. Most messy files follow predictable patterns that an experienced bookkeeper has seen many times.
Read answerWhat's the best business structure for tax savings — LLC, S-Corp, or C-Corp?
There's no universally best structure. It depends on your income level, how you use profits, and your growth plans. For most small businesses, the real question is when to elect S-Corp status to reduce self-employment taxes.
Read answerShould I switch from an LLC to an S-Corp to save on taxes?
It depends on your net profit. The S-Corp election reduces self-employment taxes by splitting income into salary and distributions, but it adds compliance costs. For most business owners, the switch makes sense once net profit consistently exceeds $60,000 to $80,000 per year.
Read answerI haven't done my bookkeeping in two years — is it too late?
It's not too late. Two years of backlogged bookkeeping is more common than you'd think, and it can absolutely be cleaned up. The longer you wait though, the harder and more expensive the process becomes.
Read answer
