Most free P&L templates are built for a corner store, not a store that runs paid traffic. They give you a tidy grid for "revenue" and "expenses" and leave you to guess where ad spend, supplier charges, and processing fees belong. Guess wrong and the template reports a healthy business that is quietly bleeding.
This is the operating version. You already have sales history and a monthly ad bill, so you need a template that shows where the money actually goes — and the profit line those generic grids skip. For the full structure behind this, see the ecommerce P&L guide.
What a profit and loss income statement template actually is
A profit and loss statement — also called an income statement — answers one question: did the store make money this period, and where did it go? The template is just that question, broken into a fixed stack of lines you fill in each month.
Build it monthly, not yearly. A yearly view hides the month your ad costs spiked and your margin collapsed. The order of the lines is not decorative — each subtotal (net sales, gross profit, operating profit) tells you about a different part of the business.
Generic templates stop at "revenue minus expenses equals net income." That works for a dentist. It fails for you, because your biggest controllable cost — paid acquisition — needs to sit in a specific place, or the whole statement misleads you.
The line-by-line template for a POD store
Here is the skeleton. Copy it into a sheet and use the same line order every month so your trends stay comparable.
- Gross sales — total order value booked when the sale happens, before any fee or refund comes out.
- Less: discounts — coupon codes and automatic sale discounts.
- Less: returns and refunds — the value of refunded orders. This reduces revenue; it is not an expense.
- = Net sales — gross sales minus discounts minus refunds. Your honest top line.
- Less: COGS — the direct cost of the units you sold: the supplier's production charge plus their shipping to the customer, and you can include payment processing here if you do it consistently.
- = Gross profit — net sales minus COGS. Divide by net sales for gross margin %, your product economics.
- Less: operating expenses — ad spend, Shopify plan and apps, email and design tools, contractor or owner pay, professional services.
- = Operating profit — gross profit minus operating expenses. This tells you if the business, not just the product, works.
- Less: interest and taxes → net profit, the bottom line.
The rule of thumb for every line: direct, per-unit costs go in COGS; costs that keep the business running regardless of any single sale go in operating expenses.
Worked example: one month in an operating store
The figures below are an illustrative example, not market data — plug in your own. Say your store does 340 orders a month at a $31 average order value, and you spend $2,800 on Meta that month.
| Line | Amount |
|---|---|
| Gross sales (340 × $31) | $10,540 |
| Less: discounts (a 10%-off code) | −$520 |
| Less: refunds (10 orders) | −$310 |
| Net sales | $9,710 |
| COGS — production + supplier shipping (340 × ~$12.50) | −$4,250 |
| COGS — payment processing | −$407 |
| Gross profit | $5,053 |
| Gross margin % | 52% |
| Operating expenses — Meta ad spend | −$2,800 |
| Operating expenses — Shopify plan + apps | −$180 |
| Operating expenses — email + design tools | −$90 |
| Operating expenses — owner draw | −$600 |
| Operating profit | $1,383 |
For the processing line, commodity card rates commonly run around 2.9% plus 30 cents per online transaction on lower-tier plans, according to A2X's breakdown of Shopify fees; on 340 orders that is roughly 340 × (0.029 × $31 + $0.30) = about $407. Verify your own rate on your plan before you trust a number.
Read it the way an operator reads it: the product is healthy at 52% gross margin, but ad spend eats more than half of gross profit, and the store nets about $1,383. Now raise Meta spend 20% — another $560 — and operating profit drops to roughly $823. That is the whole point of the layout: the statement should scream "your risk is acquisition cost," and it can only scream it if ad spend sits visibly in operating expenses.
For a filled-in reference you can print, the profit and loss statement example PDF and the monthly profit and loss statement PDF walk the same structure.
Where to put ad spend — the line most templates bury
Ad spend scales with revenue, so it feels like a cost of goods. It is not. Paid acquisition belongs in operating expenses, below the gross-profit line.
Bury Meta and Google spend inside COGS and your gross margin looks inflated, and the one cost that can sink you disappears into "product cost." Keep it on its own operating-expense line and you can watch your true margin after acquisition every single month.
This is the single most common mistake in self-built templates, and it is why a store can stare at a "55% margin" and still run dry.
Your Shopify payout is not your revenue line
The deposit that lands in your bank from Shopify is a net settlement: sales, minus processing fees, minus refunds, plus or minus adjustments and disputes, batched on a rolling delay. It almost never equals your sales for the same window.
So do not book the payout as revenue. Book gross sales at the top of the template, record fees and refunds on their own lines, and treat the net payout as a cash consequence at the bottom. Book the deposit as "sales" and you understate revenue, hide your fees entirely, and build a statement that cannot be reconciled at tax time.
One gotcha for the refund line: when you refund a $31 order, the original processing fee is generally not returned to you, so a refund costs you that fee even though you kept none of the sale.
Profit on the template is not cash in the bank
Your template can show $1,383 of profit and your bank can still be tight this week. Profit is booked on the sale date; cash moves on its own schedule.
Ad spend leaves your card daily. Supplier charges hit when a print-on-demand order is produced — right after the customer buys. But Shopify payouts settle on a delay, and never on weekends. The faster you scale ad spend, the wider that gap grows, and a profitable store can go cash-negative while it pre-funds its own growth.
That timing gap is why cash flow matters so much for a small business, and why the P&L is only half the picture — you also need a view of when cash actually moves.
A quick note on taxes
The number on your P&L is where your income tax starts, not a form you wait for. You owe income tax on your profit whether or not a processor sends you a 1099-K. For 2025 and 2026 a processor must issue a 1099-K only when gross payments exceed $20,000 and transactions exceed 200, per the IRS after the One Big Beautiful Bill reverted the threshold — but no form does not mean no tax.
This is general information, not tax advice. Rules change and vary by situation — consult a licensed CPA or tax professional before acting.
How Victor keeps this template filled in
The hard part of this template is not the layout — it is getting honest numbers onto every line, every month, from four different places. Your orders live in Shopify. Your ad spend lives in Meta and Google. Your true product cost lives in Printify, Printful, or Gelato.
Victor is the AI employee from PodVector AI who sees every order, every ad dollar, and every supplier cost together, so he computes the true per-order profit for each product — not a blended guess. He pulls from Shopify, Meta Ads, Google Ads, Printify, Printful, Gelato, and Klaviyo, and delivers the numbers as a report to your Google Drive.
Victor is not a dashboard you log into. When the margin math says a campaign is losing money, he can pause it or move the budget in Meta or Google, change a price or discount in Shopify, or build an email flow in Klaviyo — and every write action waits for your approval before anything executes. Start with Victor and let the P&L lines fill themselves.
If you would rather see the tooling landscape first, here is a look at cash flow software for a small business.
FAQs
What is the difference between a profit and loss statement and an income statement?
There is none — they are two names for the same report. "Income statement" is the formal accounting term and "profit and loss statement" (or P&L) is the common business one. Both show revenue, costs, and profit over a period.
What line items should a POD profit and loss template include?
Gross sales, discounts, refunds, net sales, COGS (supplier production plus their shipping to the customer, optionally processing fees), gross profit, then operating expenses (ad spend, Shopify plan and apps, email and design tools, owner or contractor pay), and operating profit. Keep the exact same lines every month so trends stay readable.
Does ad spend go in COGS or operating expenses?
Operating expenses, every time. Ad spend is paid acquisition, not a direct per-unit production cost. Putting it in COGS inflates your gross margin and hides the cost most likely to sink the business. The only costs in COGS are the direct cost of the units you actually sold.
Should I build my P&L monthly or yearly?
Monthly. A yearly P&L averages away the month your ad costs spiked or your refund rate jumped, which are exactly the signals you need to catch early. Build it monthly and roll twelve months up for the annual view when you need it.
Why doesn't my Shopify payout match my P&L revenue?
Because the payout is a net settlement — sales minus fees minus refunds, plus or minus adjustments — deposited on a rolling delay, not a calendar month. Your P&L revenue is gross sales booked when the order is placed. Book gross sales at the top and treat the payout as a cash figure at the bottom; the two are supposed to differ.
Can I be profitable on my P&L and still run out of cash?
Yes. Profit is recorded on the sale date, but cash moves on a different schedule: ad spend and supplier charges leave now, while payouts settle on a delay. Scale ad spend faster than payouts refill your account and you can show a profit while the bank balance runs dry. Watch both the P&L and your cash timing.