If you run a store with real sales history, a P&L (profit and loss statement, also called an income statement) answers one question: did the business make money this month, and where did it go? You do not need paid software to build one. You need the right structure and honest inputs.
The free ways to create a P&L online
There are three practical free routes, and the right one depends on how your data lives today.
Spreadsheet templates. The most common free option. Microsoft offers a small-business profit and loss template in Excel, and bookkeeping firms like Bench and Xero publish free downloadable versions in Excel and Google Sheets. You copy the sheet, type your numbers into the labeled rows, and the totals calculate themselves. Free, flexible, and yours forever.
Online generators. Form-based tools like JotForm let you fill a few fields and export a clean PDF without touching a formula. Faster to a shareable document, less flexible when you want to add a line.
Built-in accounting reports. If you already use QuickBooks Online or Xero, both generate a P&L from your categorized transactions in a few clicks. The report is only as good as your categorization — garbage in, garbage out.
Any of these produces a valid P&L. The format is not where store owners go wrong. The inputs are.
The line-by-line structure (and where stores break it)
Every correct P&L runs top to bottom in the same order. Build yours monthly.
Start with gross sales, not your payout
Gross sales is the total value of orders placed in the month, booked when the sale happens — not when money hits your bank. This is the single most-abused line in store bookkeeping.
The deposit Shopify sends you is a net settlement: sales minus processing fees, minus refunds, plus or minus adjustments, on a rolling delay. It almost never equals your sales for the same window. If you type the payout into the "revenue" box, you understate sales and hide your fees entirely. The cash-flow-vs-profit-and-loss-statement breakdown walks through why the payout belongs at the bottom as a cash consequence, never at the top as revenue.
Subtract discounts and refunds to get net sales
Below gross sales, subtract your discount codes and your refunds. Refunds are contra-revenue — they reduce revenue, they are not an expense. What's left is net sales, your honest top line.
One gotcha: when you refund an order, the original payment processing fee generally is not returned to you, so a refunded sale still costs you that fee. Leave the fee where you booked it and record the refund separately.
Cost of goods sold — the direct cost of what sold
COGS is the direct cost of the units you actually sold this month: for a print-on-demand store, the supplier's production charge plus their shipping to the customer, plus payment processing if you choose to put it there. Net sales minus COGS is gross profit, and gross profit as a percentage of net sales is your gross margin — the core read on product economics.
Operating expenses — and where ad spend goes
Everything else it takes to run the store sits below gross profit as operating expenses: your Shopify plan and apps, email and design tools, contractor or owner pay, and — this is the one stores get wrong — paid acquisition. Put Meta and Google ad spend in OpEx, not COGS. Burying it in COGS inflates your gross margin and hides that customer acquisition cost is your real risk.
Gross profit minus OpEx is operating profit — the number that tells you whether the business, not just the product, works.
A worked example for an operating store
Say you run a t-shirt store doing 300 orders in a month at roughly a $32 average order value. Here is the full statement. The figures are illustrative; the structure is exactly what you'd type into any free template.
| 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 — supplier production + shipping (300 × ~$12) | −$3,600 |
| COGS — payment processing | −$346 |
| Gross profit | $4,884 |
| 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 |
The processing line uses Shopify Payments' commonly quoted online rate of about 2.9% plus 30¢ per transaction, per A2X's breakdown of Shopify fees — roughly 2.9% of $9,600 plus 30¢ across ~300 orders lands near $346 (verify the exact rate for your plan on Shopify's pricing page). Everything else is plain arithmetic.
Read what the statement is telling you: the product is healthy at a 55% gross margin ($4,884 ÷ $8,830), but ad spend eats most of the gross profit. The store nets about $1,114 on $8,830 of net sales. If your ad costs rise 20% — another $600 — operating profit nearly halves. That is exactly why acquisition cost has to sit visibly in OpEx: a well-built P&L should scream where the risk is, and it can't if that cost is hidden.
The number your free template won't warn you about
A P&L shows profit, not cash. Your store can post $1,114 in profit and still be short this week, because ad spend leaves your card daily while Shopify payouts arrive on a multi-day delay. That timing gap is the float problem, and it's the number-one reason profitable, growing stores hit a wall. No blank template models it — see the deeper treatment in the ecommerce P&L guide and the roundup of cash flow apps for small business when you want to track the gap, not just the profit.
If you want to model next quarter instead of last month, the structure shifts slightly toward projections — the pro forma profit and loss statement walkthrough covers that version.
From a free template to a statement that reconciles itself
A free template is a blank container. The work is pulling true gross sales out of Shopify, pulling real per-unit cost from Printify, Printful, or Gelato, splitting every payout into its sales, fees, and refunds, and tagging ad spend to the right line. Do that by hand each month and the template takes an afternoon and still risks a miscategorized payout.
This is the gap PodVector AI closes. Victor is an AI employee who connects your Shopify store, your Meta Ads and Google Ads accounts, and Printify, Printful, or Gelato, then computes true per-order profit across all of them — every order, every ad dollar, every supplier cost in one view. He builds the profit report and delivers it to your Google Drive, so the statement reflects reality instead of your payout total. And because Victor also works inside Shopify, Meta, Google Ads, and Klaviyo, he acts on what the numbers show — repricing a thin-margin SKU, pausing an ad set that's dragging operating profit down.
Start with PodVector AI if you'd rather have the statement built from your live data than retype it into a spreadsheet.
When it is time to graduate from templates entirely, compare the options in our guide to cash flow software for small business.
FAQs
Can I really create a profit and loss statement online for free?
Yes. A free spreadsheet template from Microsoft, Bench, or Xero, a form generator like JotForm, or the built-in P&L report in QuickBooks or Xero will all produce a valid statement at no cost. The free part is never the problem — feeding it accurate gross sales, real COGS, and correctly placed ad spend is.
What's the difference between gross sales and my Shopify payout?
Gross sales is the full value of orders placed, booked when the sale happens. Your payout is a net deposit — sales minus fees, refunds, and adjustments — that arrives on a delay. They rarely match. Always put gross sales at the top of the P&L and treat the payout as a cash figure, not revenue.
Where does ad spend go on a profit and loss statement?
In operating expenses, below gross profit — not in cost of goods sold. Ad spend is paid acquisition, not a direct cost of producing a unit. Putting it in COGS inflates your gross margin and hides that acquisition cost is your real risk.
Do I include payment processing fees in COGS or operating expenses?
Either placement is defensible — processing fees are a judgment call. The rule that matters is consistency: pick one spot and keep it there every month, or your margin trends become meaningless. Many stores book processing inside COGS because it scales directly with each sale.
Does a free P&L template cover taxes?
No — and this is general information, not tax advice; rules change and vary by situation, so consult a licensed CPA before acting. Worth knowing: you owe income tax on your profit whether or not a processor sends you a 1099-K, and the federal 1099-K reporting threshold reverted to gross payments over twenty thousand dollars and more than two hundred transactions, per the IRS. The form reports gross dollars, not profit, which is why a reconciled P&L matters at tax time.
How often should an operating store build a P&L?
Monthly. A monthly statement surfaces a rising acquisition cost or a thinning margin while you can still act on it. Quarterly or annual-only reporting means you find out a product stopped being profitable months after the fact.