If you searched for a profit and loss statement template for self employed people in Excel, you have already seen the usual results: a tidy sheet with Income at the top, a stack of expense rows, and Net Profit at the bottom. That layout is fine for a freelance designer invoicing three clients.
It falls apart the moment you run an operating store. A store has order volume, payment processing fees, refunds, ad platforms billing you daily, and a supplier charging you per unit. The generic template has nowhere correct to put any of that.
This guide keeps the Excel format you want and rebuilds the lines that matter for a seller with real sales history.
Why the generic self-employed template fails an operating store
The freelancer template assumes money is simple: a client pays you, you log the deposit as income, you subtract a few expenses. For a Shopify store, each of those assumptions is wrong in a way that inflates your reported profit.
The deposit that hits your bank is a net payout, not revenue. Shopify nets out processing fees and refunds before it pays you, so booking the deposit as "income" silently hides your fees and understates your sales. Build the sheet from gross sales at the top instead, the way our ecommerce P&L guide lays out line by line.
The second trap is ad spend. The third is where your Printify or Printful charge lands. Get those two placements right and your Excel sheet finally separates "is my product profitable" from "is my business profitable" — two different questions the generic template smears together.
The line-by-line structure your Excel sheet actually needs
Build this monthly, one column per month, accrual basis (count the sale when it happens, not when the payout clears). Each label below is a row in column A.
- Gross sales — total order value for the month, before anything is subtracted.
- Less: discounts — coupon and automatic-discount dollars.
- Less: refunds — the value of refunded orders (this reduces revenue; it is not an expense).
- = Net sales — gross sales minus discounts and refunds.
- COGS: supplier production + shipping — what Printify, Printful or Gelato charged you to make and ship the units you sold.
- COGS: payment processing — the per-transaction card fee.
- = Gross profit — net sales minus the two COGS rows.
- OpEx: ad spend — Meta and Google, on their own row, below gross profit.
- OpEx: platform + apps, tools, owner pay — Shopify plan, email tool, contractors, your draw.
- = Operating profit — gross profit minus operating expenses. This is the number that tells you the business works.
The rule for where a cost goes: a direct per-unit cost (the blank and the print) is COGS; a cost that keeps the business running regardless of any single sale (ads, subscriptions, your pay) is operating expense. You can build your own version of this from scratch — our walkthrough on making your own profit and loss statement covers the formulas cell by cell.
Worked example: one month for an operating store
Say you run a t-shirt store doing 340 orders a month at a $31 average order value, with $2,800 going to Meta and $600 to Google. The arithmetic below is all illustrative except the card-processing rate, which comes from A2X's breakdown of Shopify fees at roughly 2.9% plus 30¢ per online transaction.
| Line | Amount |
|---|---|
| Gross sales (340 × $31) | $10,540 |
| Less: discounts (8%-off code) | −$420 |
| Less: refunds (11 orders × $31) | −$341 |
| Net sales | $9,779 |
| COGS — supplier production + shipping (340 × $12.50) | −$4,250 |
| COGS — payment processing (2.9% × $10,540 + 30¢ × 340) | −$408 |
| Gross profit | $5,121 |
| Gross margin | 52% |
| OpEx — ad spend (Meta + Google) | −$3,400 |
| OpEx — Shopify plan + apps | −$160 |
| OpEx — email + design tools | −$90 |
| OpEx — owner draw | −$800 |
| Operating profit | $671 |
| Operating margin | 7% |
Read it the way an operator should: the product is healthy at a 52% gross margin, but ad spend eats most of the gross profit. The store clears about $671 on $9,779 in net sales. If ad costs climb 20% — another $680 — the operating profit nearly vanishes.
That is exactly why ad spend sits in operating expenses, not COGS. Bury it inside cost of goods and your gross margin looks like 20-something percent, your true 52% product margin disappears, and the sheet stops warning you that customer acquisition cost is your real risk. Note the sheet shows profit, not cash — more on that below.
The column your freelancer template is missing: per-order profit
A monthly P&L tells you the store made $671. It does not tell you which products earned it and which ones lost money on every sale. That gap is where most print-on-demand stores quietly bleed.
To get per-order profit in Excel you would need every order's revenue, its exact supplier cost, its processing fee, and a fair slice of ad spend — joined together per order. Doing that by hand across hundreds of orders and two ad platforms is where the spreadsheet stops being practical.
This is the one job PodVector AI's AI employee, Victor, exists to do. Victor connects your Shopify store, Meta Ads, Google Ads and your Printify, Printful or Gelato account, sees every order, every ad dollar and every supplier cost together, and computes the true profit on each order — then delivers the report to your Google Drive. Your Excel P&L still anchors the month; Victor fills in the per-order detail a spreadsheet can't.
Don't confuse the Excel P&L with your bank balance
Your rebuilt template can show a healthy operating profit while your bank account runs dry the same week. Profit is booked on the sale date; cash moves on the payout schedule — and for an ad-driven store those two schedules fight each other.
Ad platforms charge your card daily. Supplier charges hit when an order is produced, often before the matching payout lands. Shopify then pays you on a delay, batched. The faster you scale ad spend, the wider that gap grows — a profitable store can still be cash-negative at any given moment.
That is why a P&L alone is not enough; you also need a cash-flow view. Our piece on cash flow software for small business covers the timing problem and how to size a buffer against it.
What this P&L feeds at tax time
A clean monthly P&L is also your tax backbone. As a sole proprietor or single-member LLC, the operating-profit line is what flows toward your taxable income — and it is why you cannot just file off your 1099-K.
The 1099-K reports gross payment volume, not profit, and a processor only issues one once you exceed $20,000 and 200 transactions, per the IRS after the One Big Beautiful Bill reverted the threshold. You owe income tax on your net profit whether or not a form shows up, which is exactly why your reconciled P&L matters.
Self-employment tax is the other surprise: sole proprietors owe about 15.3% on net self-employment earnings on top of income tax, according to the IRS, and usually must pay it in quarterly estimates. Keep your Excel COGS and OpEx rows categorized the same way every month so the numbers tie out.
This is general information, not tax advice. Rules change and vary by situation — consult a licensed CPA or tax professional before acting.
A note on naming
If the words trip you up, "profit and loss statement," "income statement," and "P&L" are the same report — our explainer on another name for a profit and loss statement walks through the synonyms so you can match whatever your accountant or template calls it.
FAQs
Is an Excel template good enough for a self-employed store owner's P&L?
Yes, for the monthly summary — as long as you rebuild the three lines above. Excel handles gross sales, discounts, refunds, COGS and OpEx perfectly well for one column per month. Where it strains is per-order profit and tying hundreds of payouts back to sales; that volume is what pushes most operating stores toward connected tooling.
Where do I put Shopify fees on a self-employed P&L template?
Payment processing fees go in COGS as a direct per-transaction cost, on their own row under supplier production. Your monthly Shopify subscription is different — that is a fixed operating expense, so it belongs in OpEx with your apps and tools. Keeping them split lets you see product margin and running costs separately.
Why shouldn't ad spend go in cost of goods sold?
Because it hides your real risk. Ad spend scales with revenue, which tempts people to file it under COGS, but putting it there inflates your gross margin and buries customer acquisition cost — the thing most likely to sink a scaling store. Keep it in operating expenses so the P&L shows both whether the product is profitable and whether the business is.
Do I record my Shopify payout or my sales as income?
Sales. The payout is a net settlement — Shopify subtracts fees and refunds before depositing — so logging the deposit as income understates revenue and erases your fees. Book gross sales at the top of the sheet and treat the payout as a cash figure you reconcile against, not a revenue line. You can see this structure in a complete profit and loss statement sheet.
How often should I update the template?
Monthly is the baseline for an operating store, because trends only show up across months. Reconcile each month against your Shopify finance reports so the sheet ties out, and review product-level profit more often than that if you are actively changing ads or prices — those decisions move faster than a monthly close.