A simple profit and loss statement format stacks five lines in order: net sales at the top, cost of goods sold, gross profit, operating expenses, and operating profit at the bottom. For a Shopify or print-on-demand store, the layout matters less than one discipline most templates skip — ad spend goes in operating expenses, never in cost of goods sold, so your real risk (customer acquisition cost) stays visible instead of hiding inside an inflated gross margin.

Search "simple profit and loss statement format" and you get a wall of blank Excel templates. They show the right skeleton — revenue, costs, profit — but they stop there. None of them tell an operating store owner where ad spend sits, why a Shopify payout isn't revenue, or how a store can post a profit and still be short on cash. This page fixes that.

The simple P&L format, line by line

A profit and loss statement (also called an income statement) answers one question: did the store make money this period, and where did the money go? Build it monthly, top to bottom, like this.

  • Gross sales (revenue) — total order value for the month, booked when the sale happens, not when Shopify deposits cash.
  • Less: discounts — coupon codes, automatic discounts, sales.
  • Less: returns and refunds — the value of refunded orders. This reduces revenue (it's contra-revenue), 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 units you sold. For print-on-demand that's the supplier's production charge (blank garment plus printing) plus their shipping to the customer, and optionally payment processing.
  • = Gross profit — net sales minus COGS. Divide by net sales for your gross margin %, the core measure of product economics.
  • Operating expenses (OpEx) — everything else it takes to run the business: ad spend, Shopify plan and apps, software, contractor or owner pay.
  • = Operating profit — gross profit minus OpEx. This is the number that tells you the business works, not just the product.

The placement rule is simple: direct, per-unit costs go in COGS; costs that keep the business running regardless of any single sale go in OpEx. The A2X ecommerce income statement guide lays out this same structure for online stores. Our own ecommerce P&L guide walks each line in more depth if you want the full build.

A 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, spending $2,800 on Meta ads. Here's the P&L (figures are illustrative, but the structure is exactly what you'd use).

Line Amount
Gross sales (340 orders × $31) $10,540
Less: discounts (a 10%-off code) −$620
Less: refunds (10 orders) −$310
Net sales $9,610
COGS — production (330 units × $12.50) −$4,125
COGS — payment processing −$408
Gross profit $5,077
Gross margin % 52.8%
OpEx — Meta ad spend −$2,800
OpEx — Shopify plan + apps −$180
OpEx — email/design tools −$90
OpEx — owner draw / contractor −$600
Operating profit $1,407
Operating margin % 14.6%

The processing line uses the roughly 2.9% + 30¢ per online transaction that Shopify Payments charges on lower-tier plans, per the A2X breakdown of Shopify fees: 2.9% of $10,540 is about $306, plus 340 transactions × 30¢ is $102, which rounds to roughly $408. Verify your own plan's rate before you lock a number in.

Now read the statement. The product is healthy — a 52.8% gross margin ($5,077 ÷ $9,610). But ad spend eats more than half of that gross profit, and the store nets about $1,400 on $9,610 in net sales. Push Meta spend up 20% ($560) with no lift in sales and operating profit nearly halves. That is the whole reason to keep ad spend in OpEx where you can see it.

Where the generic templates fail

Ad spend belongs in operating expenses

The most common mistake is burying paid acquisition inside COGS because "it scales with revenue." Do that and the example above would show a gross margin near 20% instead of 52.8% — which hides the fact that your real risk is customer acquisition cost, not product cost. Keep ad spend in OpEx so the P&L screams the truth: the margin is fine, the ads are the lever.

Your Shopify payout is not your revenue

The second trap is booking the bank deposit as "sales." A Shopify payout is a net settlement — sales minus fees, minus refunds, plus or minus adjustments — on a delayed, rolling schedule, so it almost never equals your sales for the same window. Book gross sales at the top of the P&L and record fees and refunds on their own lines. The net payout is a cash consequence at the bottom, not a revenue figure. (A refunded order is doubly annoying here: the original processing fee generally isn't returned, and chargebacks carry a $15 Shopify Payments dispute fee in the US, refunded only if you win.)

Profit on paper vs. cash in the bank

This P&L shows profit, not cash. The store above could post $1,407 in profit and still be tight on cash this week, because the timing of money out (ad spend, charged daily) and money in (payouts, settled on a delay) don't line up. The faster you scale ads, the wider that float gap gets — you pre-fund growth before the payouts catch up.

That's why a profitable store can still hit a wall, and why you track cash conversion alongside margin. If the squeeze is real for you, cash flow software built for small stores will model the gap better than a spreadsheet.

When one month isn't enough

A single-month P&L tells you if this month worked. To see a trend — seasonality, rising CAC, a slow margin slide — stack several periods side by side. A multi-year profit and loss statement template does that, and if you ever need to show the numbers to a lender, a P&L formatted for a loan application follows a stricter layout.

One tax note, since the P&L feeds your return: you owe income tax on your profit whether or not a processor sends you a 1099-K, which only reports gross payment volume above a threshold, not your taxable profit. This is general information, not tax advice — rules change and vary by situation, so consult a licensed CPA before acting.

Let Victor keep the P&L for you

The hard part of a store P&L isn't the layout — it's getting every number right every month. Supplier production costs, ad spend across platforms, fees, refunds, discounts: they live in different places, and a template makes you stitch them by hand.

Victor is the AI employee inside PodVector AI. He connects to Shopify, Meta Ads, Google Ads, Printify, Printful, Gelato and Klaviyo, sees every order, every ad dollar and every supplier cost together, and computes the true per-order profit — so your COGS and OpEx lines are already separated the way this article describes. He pauses the losing ad set, reprices thin-margin SKUs, and delivers the finished report to your Google Drive. Start with PodVector AI and let Victor keep the statement current while you run the store.

FAQs

What is the simplest profit and loss statement format?

Five stacked lines: net sales, cost of goods sold, gross profit, operating expenses, and operating profit. Net sales minus COGS gives gross profit; gross profit minus OpEx gives operating profit. Everything else is detail you add under those headers.

Where does ad spend go on a P&L — COGS or operating expenses?

Operating expenses. Even though ad spend rises and falls with sales, it's paid acquisition, not a direct per-unit product cost. Putting it in COGS inflates your gross margin and hides that customer acquisition cost is your real risk.

Is my Shopify payout the same as my revenue?

No. The payout is a net settlement — sales minus fees, refunds, and adjustments — deposited on a delay. Book gross sales at the top of the P&L and treat the payout as the cash result at the bottom. Booking the deposit as "sales" understates revenue and hides your fees.

What's the difference between gross profit and operating profit?

Gross profit is net sales minus COGS — it measures whether your product makes money. Operating profit subtracts operating expenses (ads, subscriptions, pay) from gross profit — it measures whether the business makes money. A store can have a strong gross margin and a thin operating margin if ad spend is heavy.

How often should I build a P&L for my store?

Monthly. A monthly P&L catches a margin slide or a jump in ad costs while you can still act on it. Stack several months to see the trend, and reconcile each month against your Shopify finance reports so the statement ties out at tax time.

Can I be profitable and still run out of cash?

Yes. Profit is booked on the sale date; cash moves on the payout schedule. If you scale ad spend faster than payouts refill your account, you can show a profit on the P&L and still be short on cash — which is why you watch cash flow, not just margin.