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
How can a tax advisor help me save money year-round?
A tax advisor saves you money by making proactive decisions throughout the year instead of scrambling at filing time. Entity structure, timing of expenses, retirement contributions, and quarterly projections all create savings that disappear once December 31 passes.
Read answerWhen are business tax returns due?
It depends on your entity type. Partnerships and S-corporations file by March 15, while C-corporations and sole proprietors file by April 15. Extensions give you more time to file but not more time to pay.
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 answerWhat payroll taxes am I responsible for as an employer?
As an employer, you pay your share of Social Security, Medicare, and federal and state unemployment taxes on top of what you pay employees. You also withhold federal income tax and the employee's share of Social Security and Medicare from their paychecks. Tennessee employers don't need to withhold state income tax, which simplifies things.
Read answerHow much does catch-up bookkeeping cost?
Catch-up bookkeeping typically runs $200 to $500 per month of cleanup for straightforward businesses, and more for complex situations. The price depends on how far behind you are, your transaction volume, and the state of your records.
Read answerWhich QuickBooks plan is right for my business?
It depends on how many users you need, whether you track inventory or projects, and how detailed your reporting needs to be. Most small businesses land on Essentials or Plus.
Read answer
