Most "free profit and loss statement" templates were built for a consultant or a corner store. They have a revenue row, an expenses row, and a profit row. For a store that runs paid ads and dropships from a print-on-demand supplier, that structure quietly hides the two things that decide whether you keep any money: where your fees go and where your ad spend goes.
This guide gives you a template you can rebuild in any spreadsheet in ten minutes, fills it with a worked monthly example, and flags the three mistakes that make a generic P&L lie to you.
What a profit and loss statement actually answers
A profit and loss statement (P&L, also called an income statement) answers one question: did the store make money over a period, and where did the money go? For a small store, build it monthly so you can see trends before they become problems.
The structure runs top to bottom, from the money that came in to the profit left over. Each line subtracts from the one above it. Build it in this order and the template works for any store.
The line-by-line skeleton
- Gross sales (revenue) — the total value of orders placed this month, booked when the sale happens, not when Shopify deposits cash. This is the single most-abused line in small-store bookkeeping.
- Less: discounts — coupon codes, automatic discounts, sales.
- Less: returns and refunds — the value of refunded orders. This reduces revenue; it is not an expense.
- = Net sales — your honest top-line: gross sales minus discounts minus refunds.
- Cost of goods sold (COGS) — the direct cost of the products you sold. For print-on-demand that is the supplier's production charge plus shipping to the customer, and (your call) payment processing.
- = Gross profit — net sales minus COGS. Divide by net sales for your gross margin %, 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 operating profit sit interest and taxes, which bring you to net profit — the real bottom line.
A worked monthly example you can copy
Say you run a t-shirt store doing 300 orders a month at about a $32 average order value, with $3,000 in combined Meta and Google spend. Here is what the filled-in template looks like. All figures are illustrative — swap in your own.
| Line | Amount |
|---|---|
| Gross sales (300 orders × ~$32) | $9,600 |
| Less: discounts (a 10%-off code) | −$480 |
| Less: refunds (9 orders) | −$290 |
| Net sales | $8,830 |
| COGS — production (300 units × ~$12) | −$3,600 |
| COGS — payment processing | −$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% |
The processing line uses the commonly quoted online rate of around 2.9% plus 30 cents per transaction, per A2X's breakdown of Shopify fees — verify the exact rate for your plan before you trust the number, since it drops on higher tiers.
Now read the statement. The product is healthy at a 55% gross margin. But ad spend eats most of the gross profit, so the store nets about $1,100 on $8,830 of net sales. If your ad costs rise 20% — another $600 — operating profit nearly halves. That is the single most useful thing a store P&L can show you, and the generic templates bury it.
The three lines generic templates get wrong
1. Your payout is not your revenue
The deposit Shopify sends your bank is a net settlement: sales, minus processing fees, minus refunds, plus or minus adjustments and chargebacks, batched on a rolling delay. It almost never equals your sales for the same window.
Book gross sales at the top of the P&L, then record fees and refunds on their own lines. The payout belongs at the bottom as the cash consequence, not as a revenue figure. Drop the net deposit into a "sales" cell and you understate revenue, hide your fees entirely, and build a statement you can't reconcile at tax time. If you want the full reconciliation walk-through, our ecommerce P&L guide covers it line by line.
2. Ad spend goes in OpEx, not COGS
Paid acquisition scales with revenue, so it feels like a cost of goods. Put it there and you inflate gross margin and hide that customer acquisition cost is your real risk. In the example above, moving $3,000 of ad spend into COGS would show a "gross margin" near 20% and make the product look broken when it is actually fine — the risk is the ads, and the P&L should scream it.
Keep COGS to direct per-unit costs: the supplier's production and shipping charge. Everything that keeps the business running regardless of a specific sale lives in OpEx.
3. The statement shows profit, not cash
Your example store shows $1,114 of profit and can still be short on cash this week. Profit is booked on the sale date; cash moves on the payout schedule. Ad spend leaves your card daily while Shopify Payments settles on a delay, so a growing, ad-driven store is constantly pre-funding orders before the payouts land.
That gap is the float problem, and it is the number-one reason profitable stores hit a wall. A P&L alone won't catch it — you need a cash view beside it, which is why we break out accrual versus cash accounting as its own topic and why pairing the P&L with cash flow software for a small business matters once you scale ad spend.
Which free template should you download?
Any of the big ones — Xero, Brixx, Financial Edge — give you a clean grid and automatic sums. They are fine as a starting shell. The work is adapting them: rename the revenue block to gross sales, add discount and refund rows beneath it, split COGS from OpEx, and move ad spend into OpEx. Once you have done that, you can rebuild it from memory in any spreadsheet.
If your store sells across more than a handful of products, the bigger problem isn't the template — it's filling it accurately every month. True COGS lives in your Printify, Printful, or Gelato account; ad spend lives in Meta and Google; sales and fees live in Shopify. Pulling those four sources together by hand, every month, is where most operators give up and go back to eyeballing the payout. Our Shopify dropshipping profit margin breakdown shows how far off a payout-based margin can be.
Where Victor fits
PodVector AI's Victor is an AI employee who keeps this statement real without you rebuilding a spreadsheet every month. Victor sees every Shopify order, every Meta and Google ad dollar, and every Printify, Printful, and Gelato supplier cost together, so he computes the true per-order profit — the exact bottom-of-the-P&L number the example above walks through. Victor delivers the report to your Google Drive.
Victor doesn't stop at the number. When a line in your P&L goes the wrong way, he acts on the cause: he pauses the losing Meta ad set, shifts budget on Google, reprices the thin-margin SKUs in Shopify, and builds the Klaviyo win-back flow to lift repeat revenue. Victor is not a dashboard you have to read — he does the work the statement points to.
Start with PodVector AI and let Victor build your store's P&L →
FAQs
What is a profit and loss statement in simple terms?
It is a monthly scorecard of your store's money. It starts with the sales you made, subtracts discounts, refunds, product costs, and running costs in order, and ends with the profit you actually kept. Read top to bottom, each line explains where a chunk of your revenue went.
Is a free downloadable template good enough for a Shopify store?
As a shell, yes. The grid and the automatic math are fine. You have to adapt it, though: book gross sales (not your payout) at the top, add refund and discount rows, and put ad spend in operating expenses rather than cost of goods. Without those three changes, a generic template will tell you a comforting story that isn't true.
Should payment processing fees go in COGS or OpEx?
Either works as long as you are consistent every month. Many stores fold processing into COGS because it scales per order; others keep it in OpEx. The rule that matters more: ad spend always belongs in OpEx, never COGS, so your gross margin reflects product economics alone.
Why does my P&L show a profit when my bank account is low?
Because profit and cash move on different clocks. Profit is booked when the sale happens; cash arrives when Shopify's payout settles, on a delay, while your ad card is charged daily. A profitable store that is scaling ad spend can be cash-tight all month. Track a cash view alongside the P&L so the gap never surprises you.
Do I owe tax on store income even without a 1099-K?
Yes. You owe income tax on your profit whether or not a form shows up. For 2025 and 2026 a processor only has to issue a 1099-K when gross payments exceed $20,000 and transactions exceed 200, per the IRS FAQ on the reverted threshold — but the form governs reporting, not whether the income is taxable. This is general information, not tax advice. Rules change and vary by situation — consult a licensed CPA or tax professional before acting.