Most templates you'll find in a Google search are built for a freelancer logging invoices and a software subscription. If you run a store with real order volume and real ad spend, that layout hides the one thing you need to see. This guide gives you the template and the reasoning, then walks a full month of numbers through it.
This is general information, not tax advice. Rules change and vary by situation — consult a licensed CPA or tax professional before acting.
What's a profit and loss statement, really
A profit and loss statement (also called an income statement, or P&L) answers one question over a period: did the store make money, and where did the money go? Build it monthly. It is not the same as your bank balance or your payout deposit — it's the accrual picture of the sales you made and the costs those sales carried.
The generic templates get the skeleton right but stop at "Revenue − Expenses = Net Profit." That single subtraction is too coarse for an operating store, because it lets you bury the most dangerous cost — paid acquisition — anywhere you like. The template below refuses to let you do that.
For the deeper mechanics behind every line here, our ecommerce P&L guide is the hub; this page is the fill-in-the-blanks version.
The template, line by line
Copy this structure into a sheet. Each block is a section, top to bottom.
Revenue block
- Gross sales — total order value for the month, booked when the sale happens, before any fees or refunds
- Less: discounts — coupon and automatic-discount value
- Less: returns and refunds — a contra-revenue line, not an expense
- Net sales — gross sales minus discounts minus refunds
Cost of goods sold (COGS) block — the direct, per-order cost of what you sold
- Supplier production charge (blank product plus printing, plus supplier shipping to the customer)
- Payment processing fees, if you choose to sit them here (just be consistent)
- Gross profit — net sales minus COGS, and gross margin % is gross profit ÷ net sales
Operating expenses (OpEx) block — everything it takes to run the business regardless of any single sale
- Ad spend / paid acquisition (Meta, Google) — this belongs here, never in COGS
- Platform and app subscriptions (your store plan, apps, email tool)
- Software and design tools
- Owner pay or contractors
- Operating profit — gross profit minus OpEx, and operating margin % is operating profit ÷ net sales
The rule that separates a useful template from a pretty one: direct per-unit costs go in COGS, and costs that keep the lights on go in OpEx. If you want the ready-made spreadsheet, our Google Sheets P&L template has this exact structure with the formulas already wired in, and the P&L account statement format walks through the accounting conventions for each row.
A small business profit and loss statement example
Say you run a t-shirt store doing 340 orders a month at a $31 average order value, spending $2,800/month on Meta. Here's the month.
Gross sales: 340 × $31 = $10,540. Say a 10%-off code pulled $520 off, and 11 refunds pulled another $340. Net sales = $10,540 − $520 − $340 = $9,680.
Now COGS. Say each shirt costs you about $12 all-in from your supplier (garment, printing, and shipping to the customer): 340 × $12 = $4,080. Payment processing on card orders commonly runs around 2.9% plus 30¢ per transaction, according to A2X's breakdown of Shopify fees — on 340 orders totaling $10,540 that's about $306 + $102 = roughly $408. Total COGS ≈ $4,080 + $408 = $4,488.
Gross profit = $9,680 − $4,488 = $5,192. Gross margin = $5,192 ÷ $9,680 = 53.6%. The product looks healthy.
Then OpEx:
- Ad spend: $2,800
- Store plan + apps: $180
- Email + design tools: $90
- Owner draw: $600
OpEx total = $3,670. Operating profit = $5,192 − $3,670 = $1,522. Operating margin = $1,522 ÷ $9,680 = 15.7%.
Read it the way an operator should: the shirt is fine, but paid acquisition eats more than half your gross profit. If your Meta cost climbs 20% (another $560), operating profit drops to about $962 — a one-fifth rise in ad cost nearly cuts your profit by a third. That story is only visible because ad spend sits in OpEx. Bury it in COGS and your gross margin looks like a fantasy while your real risk — CAC — hides in plain sight. That's why the placement rule is the whole point of the template.
The two mistakes this template exists to prevent
Mistake one: booking your payout as revenue. The deposit that lands in your bank is a net settlement — sales minus fees, minus refunds, plus or minus adjustments and chargebacks — on a delayed, rolling schedule. It almost never equals your sales for the same window. Book gross sales at the top; the payout is a cash consequence, not a revenue line. A disputed charge, by the way, carries a $15 fee in the US that's refunded only if you win, per A2X — another item that lives nowhere on a naive template.
Mistake two: reading a profitable P&L as "I have cash." Your example month showed $1,522 in profit. It says nothing about whether you can cover next week's ad card. Ad spend leaves daily; payouts arrive on a delay; supplier charges hit at production. The faster you scale, the wider that gap. Profit and cash are two different statements — see why small businesses hit cash flow problems while showing profit on paper.
Where the template stops and software starts
A monthly template is the right tool for understanding the shape of your business. It stops being enough the moment you're pulling numbers from your store, your ad accounts, and your supplier by hand — because by the time the month is reconciled, the decisions are already three weeks stale, and per-order profit is nearly impossible to hand-calculate across hundreds of orders.
That's the gap PodVector AI closes. Victor is an AI employee that connects your live data — Shopify for full store ops, Meta Ads and Google Ads, and print suppliers like Printify, Printful, and Gelato — and computes true per-order profit for you, then delivers the reports to your Google Drive. Victor is not a dashboard you have to go read; it's an employee that does the work, and every write action it takes is approval-gated, so nothing executes until you say so. When you're ready to stop rebuilding the same spreadsheet every month, start with PodVector AI.
If you're weighing tools before that, our rundown of cash flow software for small business compares the options operators actually consider.
FAQs
What's a profit and loss statement in one sentence?
It's a period report that stacks your revenue, your cost of goods sold, and your operating expenses to show whether your store made an operating profit — and, just as importantly, where the money went along the way.
How is this different from a normal self-employed P&L template?
A standard self-employed template treats every cost as one bucket of "expenses." An operating store's template splits direct per-order costs (supplier, processing) into COGS and running costs (ads, subscriptions, pay) into OpEx. That split is what lets you separate product economics from business economics.
Where does ad spend go on a profit and loss statement?
Operating expenses, always — never COGS. Ad spend scales with revenue, which tempts people to file it as a cost of goods, but doing so inflates your gross margin and hides that customer acquisition cost is your real risk. Keeping it in OpEx makes the P&L tell the truth.
Do I owe tax based on my 1099-K number?
No. A 1099-K reports gross payment volume, not profit, and you owe income tax on your net profit whether or not you ever receive one. For 2025 and 2026, a processor issues a 1099-K only when payments exceed $20,000 and transactions exceed 200, per the IRS. This is general information, not tax advice — confirm your situation with a CPA.
How often should I build one?
Monthly. A month is short enough to catch a rising ad cost before it eats a quarter, and long enough to smooth out the day-to-day noise of individual orders and refunds.
What's a good operating margin for a POD store?
There's no guaranteed benchmark — it depends entirely on your product cost and CAC. The point of the template isn't to hit a magic number; it's to make your own margin visible so you can see which lever (price, supplier cost, or ad efficiency) moves it most.