What a monthly P&L actually shows for a store
A profit and loss statement (P&L, or income statement) answers one question each month: did the store make money, and where did the money go? For a running store, you build it monthly so you can catch a margin problem in weeks, not at tax time.
The free templates you'll find — Smartsheet's, CFI's Excel model, Xero's, Drip Capital's — all give you the same bones: revenue, cost of goods sold, gross profit, operating expenses, net profit. That structure is correct. What they don't do is show you a store's numbers in it, or tell you which line a Printify charge or a Meta invoice belongs on. That's where most store owners get it wrong.
So copy any of those blank templates, then build it the way below.
The line-by-line skeleton
Here is the order every line sits in, top to bottom. Keep this exact sequence in your template.
- Gross sales — the total value of orders placed this month, counted when the sale happens, not when Shopify deposits cash. This is booked before any fees or refunds come out.
- Less: discounts — coupon codes, automatic discounts, sale markdowns.
- 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.
- Cost of goods sold (COGS) — the direct cost of the units you actually sold. For a print-on-demand store that's the supplier's production charge plus their shipping to the customer, and (your call) payment processing.
- = Gross profit — net sales minus COGS. Divide by net sales for your gross margin percent, the measure of product economics.
- Operating expenses (OpEx) — everything else it takes to run the business: ad spend, your Shopify plan and apps, design and email tools, contractors, owner pay.
- = Operating profit — gross profit minus OpEx. This is the number that tells you the business works, not just the product.
- Below that — interest and taxes, landing at net profit, the bottom line.
The one rule that keeps a template honest: direct, per-unit costs go in COGS; costs that keep the business running go in OpEx. For a deeper walkthrough of each line, the ecommerce P&L guide covers the full structure.
Put ad spend in OpEx, not COGS
This is the mistake the blank templates let you make. Ad spend scales with revenue, so it feels like a cost of the sale — but burying it in COGS inflates your gross margin and hides that customer acquisition is your real risk. Keep every Meta and Google dollar in OpEx, visible and separate, so the P&L can scream "watch your CAC" when it needs to.
Worked example: one month at an operating store
Say you run a t-shirt store doing 300 orders this month at a $32 average order value, with $3,000 in Meta and Google spend. Here is the month in the template. Processing is figured at roughly 2.9% plus 30 cents per transaction, a common Shopify Payments rate for lower-tier plans (verify your own plan's rate before you lock it in).
| Line | Amount |
|---|---|
| Gross sales (300 × $32) | $9,600 |
| Less: discounts (a 10%-off code) | −$480 |
| Less: refunds (9 orders) | −$290 |
| Net sales | $8,830 |
| COGS — POD production (300 × ~$12) | −$3,600 |
| COGS — payment processing (~2.9% + 30¢ × 300) | −$346 |
| Gross profit | $4,884 |
| Gross margin % | 55.3% |
| OpEx — ad spend (Meta + Google) | −$3,000 |
| OpEx — Shopify plan + apps | −$180 |
| OpEx — email + design tools | −$90 |
| OpEx — owner draw / contractor | −$500 |
| Operating profit | $1,114 |
| Operating margin % | 12.6% |
Reading your numbers
Work the arithmetic and the story jumps out. The product is healthy: $4,884 ÷ $8,830 = 55.3% gross margin. But ad spend eats most of that gross profit, and the store nets about $1,114 on $8,830 of net sales.
Now stress it. If ad costs rise 20% — $3,000 × 1.2 = $3,600, another $600 out — operating profit nearly halves to around $514. That fragility is invisible if ad spend is hidden inside COGS. This is the whole reason the template keeps acquisition cost on its own OpEx line.
The payout-is-not-revenue trap
The single most common way a store's books go wrong: treating the Shopify deposit as the month's sales. It isn't.
Your payout is a net settlement — sales, minus processing fees, minus refunds, plus or minus adjustments and chargebacks — paid on a rolling delay that doesn't match the calendar month. Booking that deposit as "revenue" understates your true sales and hides your fees entirely, so the P&L can never reconcile.
In your template, always book gross sales at the top and put fees, refunds, and discounts on their own lines. The net payout is a cash consequence at the bottom, not a revenue figure. One more cost to track: when you refund an order, the original processing fee generally isn't returned to you, and a disputed charge carries a $15 chargeback fee on Shopify Payments in the US, refunded only if you win. Give refunds and disputes their own rows so the template still ties out.
Profit on paper is not cash in the bank
Your monthly P&L shows profit. It does not show cash. A store can post $1,114 of profit and still be short this week, because profit is booked on the sale date while cash moves on the payout schedule.
The gap is simple: ad spend leaves your card daily, suppliers charge you when each order is produced, but Shopify payouts arrive on a delay. The faster you scale ad spend, the wider that float gets. A monthly P&L won't warn you — that's a cash flow question, and it's worth running a cash flow forecast alongside the P&L so a profitable month doesn't drain the account. Once you're reconciling monthly, a yearly P&L template rolls the twelve months into one view for taxes and trends.
Make the template fill itself
A free template is a blank grid. The hard part is feeding it accurate numbers every month: pulling gross sales before fees, splitting each Shopify payout back into sales and fees and refunds, pricing COGS per order from your supplier, and keeping ad spend in the right column.
That's the work Victor, the AI employee inside PodVector AI, does for you. Victor connects to Shopify, Meta Ads, Google Ads, Printify, Printful, Gelato, and Klaviyo, and he computes the true per-order profit — product cost, fees, shipping, and ad spend together — so every line of your P&L is real, not estimated. He knows your Printify and Printful product costs before the first sale, reprices thin-margin SKUs in Shopify, and pauses the ad set that's dragging operating profit down. He delivers the finished report to your Google Drive each month.
Victor is not a dashboard you read and interpret. He sees every order, every ad dollar, and every supplier cost in one place, then does something about the losing lines. If you'd rather stop rebuilding a spreadsheet and get a P&L that stays true, start with PodVector AI. For stores that have outgrown the manual approach entirely, compare cash flow software for small business.
FAQs
Is a free monthly P&L template good enough for a real store?
Yes, as a format. A free Excel or Google Sheets template from Smartsheet, CFI, or Xero gives you the right line structure, and that's all a P&L is. The limitation isn't the template — it's keeping it accurate. The numbers you type in have to be gross sales (not payouts), per-order COGS, and ad spend in OpEx, or the clean-looking sheet will lie to you.
What's the difference between a monthly and a yearly P&L template?
A monthly template has one column per month so you catch margin and CAC problems while you can still fix them. A yearly template rolls those twelve months into annual totals for tax filing and trend lines. Most operators keep the monthly version live and use the yearly template at year-end — they're the same skeleton at different zoom levels.
Where does payment processing go — COGS or OpEx?
Either is defensible as long as you're consistent month to month. Many stores put per-transaction processing in COGS because it's a direct cost of each sale; others keep it in OpEx. Pick one and never move it, or your gross margin trend becomes meaningless from month to month.
Does the 1099-K I get match my P&L revenue?
No. A 1099-K reports gross payment volume before fees, refunds, and COGS, so it will be higher than both your net sales and your profit. For 2025 and 2026, a processor must issue one only when payments exceed $20,000 and transactions exceed 200, but you owe income tax on your profit whether or not you get the form. This is general information, not tax advice — rules change and vary by situation, so consult a licensed CPA or tax professional before acting.
Why does my template show a profit when my bank account is nearly empty?
Because profit and cash are different clocks. Your P&L books a sale the day it happens; the cash lands days later when Shopify settles, while your ad card and suppliers are charged now. A profitable month can still be cash-tight if you're scaling ad spend faster than payouts refill the account. Run a cash flow forecast next to the P&L to see the squeeze before it hits.