Your payout is not your sales number.
Shopify, Amazon, and Etsy deposits broken back into sales, fees, refunds, and sales tax, so your margins are real.
A deposit lands from Shopify or Amazon and it gets booked as sales. That's the most common mistake I see in a seller's books. The deposit is what's left after the platform took its fees, held back refunds, and passed along sales tax. Book the net number and your revenue is understated, your fees are invisible, and nothing matches the 1099-K the platform sends at year-end.
Signs the spreadsheet has stopped working
- You book the Shopify deposit as sales and move on
- Your 1099-K total and your books don't agree
- You're not sure which states you owe sales tax in
- You added a second sales channel and the spreadsheet broke
If two of those sound familiar, the books have become a job of their own. That's the point where most owners hand them off.
Why the deposit is the wrong number
Here's a made-up example. Shopify sends you $8,200. Behind it: $10,000 in sales, $700 in sales tax you collected, $600 in refunds, $300 in processing fees, and a $1,600 repayment on a Shopify Capital advance. Five different things, and only one of them is revenue. The 1099-K reports the gross amount, before fees and refunds. If your books only show the deposits, you and your CPA spend tax season explaining a gap that proper bookkeeping would have closed every month.
Built around how online sellers actually get paid
- Every payout reconciled through a clearing account for each channel: sales, refunds, fees, and tax tied out to the deposit
- Sales tax you collected held as a liability, tracked by state
- Tax that Amazon or Etsy collected and paid for you kept out of your own liability, so it isn't counted twice
- Inventory and cost of goods sold, including freight and duties on what you import
- Ad spend, shipping, and platform fees separated, so you can see margin by channel
- Merchant advances and platform loans booked as debt, not as lower sales
- Gift cards and store credit held as a liability until they're used
Five things hide inside one payout. Only one of them is revenue.
Sales tax: who collects what
On marketplaces like Amazon and Etsy, the marketplace collects and pays the sales tax in California and in most other states. On your own Shopify store, you're the seller, so you collect it. Other states start to expect you to register once your sales into that state pass their threshold, and each state sets its own. I track sales by state so you and your CPA can see a threshold coming. I record sales tax correctly. I don't file the returns. You or your CPA do that, and the books make it a short job. More on that in do I need to collect sales tax in California?
Common questions
Do you connect Shopify or Amazon to QuickBooks?
Yes. For low volume I post a summary entry for each payout from the platform's own reports. For higher volume a connector app posts the summaries and I reconcile them. Either way every payout ties out to the bank deposit.
I sell on more than one channel. Is that a problem?
No. Each channel gets its own clearing account and its own sales and fee lines, so you can compare them side by side.
Do you file my sales tax returns?
No. I record what you collected and what you owe, by state. You or your CPA file the returns from those numbers.
How much does it cost?
Monthly bookkeeping starts at $300 a month. The exact price depends on how many accounts and transactions you have, and you get it at the free consult before any work starts. New clients pay a one-time setup equal to the first month. There is no hourly meter and no long-term contract.
Flat pricing, quoted up front
Monthly bookkeeping starts at $300/mo, scoped to your actual volume at the consult. If your books haven't been touched in a while, cleanup comes first — see how that works. Wondering if the price is fair? See is $300 a month reasonable?
Other industries I keep books for
Manufacturers & makers · Retail shops · Restaurants · Salons & barbershops · Auto repair shops · Trucking owner-operators · Dental & medical practices · Law firms · Consultants & agencies · Real estate agents · Contractors · Real estate investors
Find out where your books really stand
Free 30-minute call. Bring your last bank statement or don't — either way you'll leave knowing what's actually going on.
Book a call with Elbert