It's the first of the month. You open Shopify, see $62,000 in total sales, and feel the warm glow of a person who sells things on the internet. Then you check the bank. Then you check it again, because surely that's not right.
It is right. Shopify is good at telling you what customers bought. It was never designed to tell you what you kept.
This piece covers what your store's sales report leaves out, how ecommerce accounting closes the gap, and a simple example of the same month seen two ways.
What ecommerce accounting actually covers
Ecommerce accounting is ordinary accounting with a few extra moving parts. You still need a chart of accounts, reconciled bank and credit card accounts, and a monthly close. On top of that, an online store adds:
- Payouts that arrive net of fees, refunds and chargebacks, so the deposit never matches the sales figure.
- Sales tax collected from customers, which belongs to the state and isn't your income.
- Inventory, which is an asset until it sells and then becomes cost of goods sold (COGS, the cost of the products you actually sold).
- Multiple channels (your site, Amazon, wholesale) with different fee structures and timing.
- Gift cards and store credit, which are money you owe in product, not revenue yet.
Good ecommerce bookkeeping takes all of that and produces three statements you can trust: an income statement, a balance sheet and a cash flow statement.
Why Shopify's numbers and your P&L disagree
Shopify accounting reports are built for merchandising decisions: what sold, when, through which channel. That's useful. It's just a different job.
Here's what typically causes the gap:
- Sales tax and shipping. The headline sales figure in Shopify analytics can include tax and shipping charged to customers. Tax is a liability. Shipping charged is revenue, but the shipping you paid the carrier is a cost that lives somewhere else entirely.
- Product cost. Shopify only knows your product cost if you entered it, and entered cost per item rarely includes freight, duties and packaging.
- Fees. Payment processing fees come out of payouts before the cash reaches your bank.
- Ad spend. Meta, Google and TikTok bill your card, not your store.
- Apps and subscriptions. That review app, the upsell app, the email platform. They add up like streaming services you forgot you signed up for.
- Timing. Returns and refunds can land in a different month from the original sale.
None of this means Shopify is wrong. It means the sales report and the P&L are answering different questions.
The same month, two ways
Say you sell candles. Here's one hypothetical month.
What the Shopify sales report shows:
| Line | Amount |
|---|---|
| Gross sales | $58,000 |
| Discounts | ($4,500) |
| Returns | ($1,800) |
| Shipping charged | $4,200 |
| Sales tax collected | $3,100 |
| Total sales | $59,000 |
What a reconciled P&L shows for the same month:
| Line | Amount |
|---|---|
| Net product sales | $51,700 |
| Shipping income | $4,200 |
| Total revenue | $55,900 |
| Cost of goods sold | ($19,400) |
| Shipping and fulfillment costs | ($6,800) |
| Payment processing fees | ($1,750) |
| Gross profit | $27,950 |
| Advertising | ($14,200) |
| Apps and software | ($1,300) |
| Payroll and other overhead | ($9,600) |
| Net income | $2,850 |
The store showed $59,000. The business made $2,850. The sales tax went to the state (or will, when it's filed), and most of the rest went to wax, jars, carriers, ads and apps.
That's a working business, by the way. It just isn't the business the sales report suggested.
Where to start: reconcile the payouts
The bridge between your store and your books is the payout. Each deposit from Shopify Payments is a bundle of sales, minus fees, minus refunds, plus or minus adjustments. If you record deposits as "sales," your revenue is understated, your fees disappear, and sales tax gets tangled into income.
The fix is to break each payout into its parts so the books record gross sales, fees, refunds and tax separately, then tie the net to the bank deposit. We walk through it step by step in our guide to Shopify payouts reconciliation.
Then get COGS right
After payouts, the biggest source of fiction in an ecommerce P&L is cost of goods sold. Plenty of stores expense inventory when they buy it, which makes a big restocking month look like a loss and the following month look like a miracle.
A cleaner approach records inventory as an asset when it arrives, includes landed cost (the product price plus freight, duties and fees to get it to your warehouse), and moves cost to COGS as units sell. Our article on inventory, COGS and knowing your real margin explains how.
If you also sell on Amazon, the settlement reports add their own puzzle, which we untangle in reading Amazon settlement reports without tears.
A monthly checklist for store owners
Here's a reasonable monthly routine for a small store:
- Reconcile every bank and credit card account to its statement.
- Break each platform payout into sales, fees, refunds, tax and adjustments.
- Count or confirm inventory, and update COGS for units sold.
- Record ad spend, app subscriptions and shipping costs to their own accounts.
- Check the sales tax liability against what the platform says you collected.
- Review the P&L against last month and ask why anything moved more than you expected.
Steps one through five are bookkeeping. Step six is where owners make decisions, and it only works if the first five are done.
Questions owners ask
Can I use Shopify reports instead of accounting software?
Shopify reports are good for sales analysis, but they aren't a general ledger. You still need accounting software for expenses, inventory, liabilities and the balance sheet, and your CPA will need statements from it at tax time.
Is sales tax collected on Shopify part of my revenue?
No. Sales tax you collect from customers is a liability you hold for the state until it's remitted. It should sit on the balance sheet, not in income. Your CPA or a sales tax specialist can advise on where you're required to collect.
How often should an ecommerce business reconcile its books?
Monthly at minimum. High-volume stores often reconcile payouts weekly so problems like missing deposits or unexpected chargebacks show up while they're still easy to trace.
Want a P&L that matches reality?
Our ecommerce accounting service handles payout reconciliation, inventory and COGS, and a monthly close reviewed before you see it, with a Client Accounting Manager keeping the work on schedule. Request a consultation to talk through your store, or use the pricing estimator to see a planning range first.