Most of the free templates ranking for this keyword — from Smartsheet, QuickBooks, and Paycor — hand you an empty grid with generic "revenue" and "expenses" rows. They work for a plumber or a consultant. They fall apart for a store running paid traffic against a supplier that bills per order, because they never tell you which line ad spend belongs on or why your Shopify payout doesn't match your sales.
This guide gives you the same standard structure, then fills it with operating numbers so you can copy the layout into a sheet today.
What a profit and loss statement actually shows
A profit and loss statement (also called a P&L, an income statement, or a loss and profit statement) answers one question: did the store make money over a period, and where did the money go? Build it monthly so you can compare month to month and catch a trend before it becomes a problem.
The order of the lines is the whole point. Each subtotal isolates a different question — is the product healthy, is the business healthy, are you actually keeping anything.
Here is the standard ecommerce skeleton, top to bottom. This mirrors the ecommerce income statement layout used by specialist accountants:
- Gross sales — total order value for the month, booked when the sale happens, before any fees or refunds.
- Less discounts — coupon codes and automatic sales.
- Less returns and refunds — a contra-revenue line, not an expense.
- Net sales — gross sales minus discounts minus refunds. Your honest top line.
- Cost of goods sold (COGS) — the direct cost of the units you actually sold: supplier production plus supplier shipping, and often payment processing.
- Gross profit — net sales minus COGS. Divide by net sales for gross margin %, the core measure of product economics.
- Operating expenses (OpEx) — everything else it takes to run the store: ad spend, Shopify plan, apps, tools, contractors, owner pay.
- Operating profit — gross profit minus OpEx. This tells you if the business works, not just the product.
- Net profit — the bottom line after interest and taxes.
The one rule that saves you: direct, per-unit costs go in COGS; costs that keep the business running regardless of a specific sale go in OpEx. Where exactly you park payment processing is a judgment call — just keep it consistent every month or your trends become meaningless.
A profit and loss statement example, one month
Say you run a t-shirt store on Shopify doing 340 orders in a month at a $31 average order value, with $2,800 in Meta and Google spend. Here is how those numbers flow through the template. All figures are illustrative.
| Line | Amount |
|---|---|
| Gross sales (340 orders × $31) | $10,540 |
| Less: discounts (a 10%-off code) | −$520 |
| Less: refunds (10 orders) | −$310 |
| Net sales | $9,710 |
| COGS — POD production + supplier shipping (340 × ~$12.50) | −$4,250 |
| COGS — payment processing (~2.9% + 30¢ × 340) | −$407 |
| Gross profit | $5,053 |
| Gross margin % | 52% |
| OpEx — ad spend (Meta + Google) | −$2,800 |
| OpEx — Shopify plan + apps | −$180 |
| OpEx — email + design tools | −$95 |
| OpEx — owner draw / contractor | −$500 |
| Operating profit | $1,478 |
| Operating margin % | 15% |
The ~2.9% + 30¢ processing fee used above is the rate commonly quoted for Shopify Payments on lower-tier plans; verify the exact rate for your plan before you rely on it. The rest of the table is plain arithmetic you can reproduce.
Read it the way an operator should. The product is healthy — a 52% gross margin means each shirt earns its keep. But ad spend swallows more than half of gross profit, and the store nets about $1,478 on $9,710 of net sales. If your cost per acquisition rises 20% — another $560 of spend for the same orders — operating profit drops by more than a third. That is why paid acquisition sits visibly in OpEx: the statement should scream "your risk is CAC," and it can't if that cost is buried inside COGS.
For the deeper walkthrough of every line and the margin benchmarks behind it, see our full ecommerce P&L guide.
How to make a profit and loss statement, step by step
If you want to know how to do a profit and loss statement from your own store data, work top to bottom:
- Pull gross sales for the month from Shopify's reports — the order total, not the bank deposit.
- Subtract discounts and refunds to get net sales. Refunds are a reduction of revenue, never an expense line.
- Add up COGS for the units sold that month: every supplier production charge plus their shipping, plus processing if you put it here.
- Subtract COGS from net sales for gross profit, then divide by net sales for your gross margin %.
- List every operating expense — ad spend first, then subscriptions, tools, and pay.
- Subtract OpEx for operating profit. That is the number that tells you whether the business is viable.
A year to date profit and loss statement is just twelve of these monthly columns added across, letting you see seasonality and whether margins are drifting. If you'd rather start from a printable free blank profit and loss statement PDF than a spreadsheet, our profit and loss statement PDF walkthrough covers the layout and where to find a clean blank form.
The mistake every template lets you make: payout is not revenue
The single most common error in small-store books is treating the Shopify deposit as your sales. It isn't. A Shopify payout is a net settlement — sales minus processing fees, minus refunds, plus or minus adjustments and chargebacks — landing on a rolling delay, so it almost never equals your sales for the same window.
Book gross sales at the top of the statement and record fees and refunds on their own lines. The net payout is a cash consequence that belongs at the bottom, not a revenue figure. Booking the deposit as "sales" understates revenue, hides your fees entirely, and produces a P&L you can't reconcile at tax time.
Two fees worth naming: when a customer disputes a charge, Shopify Payments charges a $15 dispute fee in the US, refunded to you if you win. And when you refund an order, the original processing fee is generally not returned — so a refunded $31 order still costs you its ~$1.20 fee even though you kept none of the sale.
Why a profitable P&L can still leave you cash-short
Your profit and loss statement shows profit, not cash. Those are different things, and the gap is where fast-growing ad-driven stores hit a wall.
Ad spend leaves your card daily, and for print on demand the supplier charges you at production — often before the matching payout has settled. Payouts arrive on a delay, and they don't settle on weekends while your ads keep running. So the store in the example above could show a $1,478 profit for the month and still be short on cash the week you scale spend, because you are pre-funding growth out of your own pocket.
The fix is to watch cash conversion, not just margin, and to hold a buffer sized to your worst-case gap. Our guide to small business cash flow management walks through sizing that buffer for a store on a payout delay.
Where PodVector AI fits
Building this statement by hand every month means pulling Shopify orders, matching Meta and Google spend, and reconciling supplier charges from Printify, Printful, or Gelato — line by line. PodVector AI's AI employee, Victor, computes true per-order profit from your live data across Shopify, Meta Ads, Google Ads, and your POD supplier, then delivers the report to your Google Drive. It is not a dashboard you have to read; it does the assembling for you, and every write action is approval-gated so nothing runs without your sign-off.
If you want the P&L math handled automatically instead of rebuilt in a spreadsheet each month, start with PodVector AI and connect your store. For a comparison of doing this by hand versus with software, see our rundown of cash flow software for small business.
This is general information, not tax or accounting advice. Rules change and vary by situation — consult a licensed CPA or tax professional before acting.
FAQs
What is the difference between gross profit and operating profit on a P&L?
Gross profit is net sales minus cost of goods sold — it measures whether your product makes money. Operating profit is gross profit minus all your operating expenses, including ad spend — it measures whether the business makes money. A store can have a great gross margin and a thin operating margin if acquisition costs are high, which is exactly why the two lines are separated.
Should ad spend go in COGS or operating expenses?
Operating expenses, always. Ad spend scales with revenue, which tempts people to file it under COGS, but burying it there inflates your gross margin and hides that customer acquisition cost is your real risk. Keeping it in OpEx makes the statement honest about where the money goes.
Why doesn't my Shopify payout match my sales?
Because a payout is a net settlement, not a sales figure. It bundles your sales minus processing fees, minus refunds, plus or minus adjustments and chargebacks, and it arrives on a delay covering a prior window. Book gross sales at the top of your P&L and treat the payout as the cash result at the bottom.
What is a year to date profit and loss statement?
It is a P&L that sums every month from the start of your fiscal year through the current month, usually shown as monthly columns with a running total. It lets you see seasonality, track whether margins are drifting, and estimate your tax position before year-end.
Do I owe taxes on the gross number a payment processor reports?
No — you owe income tax on your profit, not on gross payment volume. A processor issues a 1099-K only when gross payments exceed $20,000 and transactions exceed 200 under current federal rules, and that form reports gross dollars before fees, refunds, and COGS. Your taxable income is your net profit, which is far lower — another reason a reconciled P&L matters. This is general information, not tax advice; confirm your situation with a CPA.