Any online store
Monthly P&L template
What this file is
A P&L template is a spreadsheet that takes one period's sales down to profit, line by line: returns and VAT out, then the goods, shipping, payment fees, marketing and running costs. This one holds the 34 lines nouz computes, the cell formula of every line worked out from the others, and October 2026 of a small store filled in.
What is inside
One header row, 34 filled rows.
The whole profit and loss statement as a spreadsheet: one row per line from GMV down to EBITDA, every line worked out from the ones above it with its cell formula, and a real month filled in.
Rows 1 to 35 are the file, and the sheet scrolls to show them all. Click any cell to read it; the foot of the sheet says what its column is for.
| Row | A | B | C | D | E | F | G | H | I |
|---|---|---|---|---|---|---|---|---|---|
| 1 | line | line_name | month | formula | in_words | ||||
| 2 | 1 | Gross Merchandise Value (GMV) | 80000.00 | input | Every item sold at its original price (the compare-at price where one is set), VAT included, shipping excluded | ||||
| 3 | 2 | Price Reductions | 3200.00 | input | What items sold below their compare-at price gave away: (compare-at price - price) x quantity | ||||
| 4 | 3 | Price Reductions % of GMV | 0.0400 | C3/C2 | Price Reductions / Gross Merchandise Value (GMV) | ||||
| 5 | 4 | Discount Codes | 4000.00 | input | Discount codes and automatic discounts on the items | ||||
| 6 | 5 | Discount Codes % of GMV | 0.0500 | C5/C2 | Discount Codes / Gross Merchandise Value (GMV) | ||||
| 7 | 6 | Shipping Revenue | 5740.00 | input | Shipping charged to customers, VAT included, after shipping discounts | ||||
| 8 | 7 | Gross Revenue | 78540.00 | C2-C3-C5+C7 | Gross Merchandise Value (GMV) - Price Reductions - Discount Codes + Shipping Revenue | ||||
| 9 | 8 | Gross Orders | 740 | input | Orders placed in the month, without cancelled and test orders | ||||
| 10 | 9 | Gross AOV | 106.14 | C8/C9 | Gross Revenue / Gross Orders | ||||
| 11 | 10 | Returns | 7140.00 | input | Refunds issued in the month, products and shipping, VAT included, whenever the order was placed | ||||
| 12 | 11 | Return Value % of Gross Revenue | 0.0909 | C11/C8 | Returns / Gross Revenue | ||||
| 13 | 12 | Taxes | 11400.00 | input | The VAT inside Gross Revenue - Returns | ||||
| 14 | 13 | Tax % | 0.1597 | C13/(C8-C11) | Taxes / (Gross Revenue - Returns) | ||||
| 15 | 14 | Net Revenue | 60000.00 | C8-C11-C13 | Gross Revenue - Returns - Taxes | ||||
| 16 | 15 | Net Orders | 706 | input | Gross Orders - fully refunded orders | ||||
| 17 | 16 | Net AOV | 84.99 | C15/C16 | Net Revenue / Net Orders | ||||
| 18 | 17 | COGS | 22880.00 | input | Units sold at the unit cost on their order date, less refunded units that came back to stock or never shipped | ||||
| 19 | 18 | COGS % | 0.3813 | C18/C15 | COGS / Net Revenue | ||||
| 20 | 19 | CM1 | 37120.00 | C15-C18 | Net Revenue - COGS | ||||
| 21 | 20 | CM1 % | 0.6187 | C20/C15 | CM1 / Net Revenue | ||||
| 22 | 21 | Logistic Costs | 4736.00 | input | Shipping, pick and pack, packaging and return handling | ||||
| 23 | 22 | Logistic Costs % | 0.0789 | C22/C15 | Logistic Costs / Net Revenue | ||||
| 24 | 23 | Transaction Costs | 1363.10 | input | Payment fees: a share of each amount charged plus the fixed fee per payment | ||||
| 25 | 24 | Transaction Costs % | 0.0227 | C24/C15 | Transaction Costs / Net Revenue | ||||
| 26 | 25 | CM2 | 31020.90 | C20-C22-C24 | CM1 - Logistic Costs - Transaction Costs | ||||
| 27 | 26 | CM2 % | 0.5170 | C26/C15 | CM2 / Net Revenue | ||||
| 28 | 27 | Marketing Costs | 15000.00 | input | Ad spend on the day it was spent, plus any other marketing | ||||
| 29 | 28 | Marketing Costs % | 0.2500 | C28/C15 | Marketing Costs / Net Revenue | ||||
| 30 | 29 | CM3 | 16020.90 | C26-C28 | CM2 - Marketing Costs | ||||
| 31 | 30 | CM3 % | 0.2670 | C30/C15 | CM3 / Net Revenue | ||||
| 32 | 31 | Overhead Costs | 7134.25 | input | Running costs spread over the days, one-off costs on their own day | ||||
| 33 | 32 | Overhead % | 0.1189 | C32/C15 | Overhead Costs / Net Revenue | ||||
| 34 | 33 | EBITDA | 8886.65 | C30-C32 | CM3 - Overhead Costs | ||||
| 35 | 34 | EBITDA % | 0.1481 | C34/C15 | EBITDA / Net Revenue | ||||
| 36 | |||||||||
| 37 |
A · lineThe line's number on the statement, 1 to 34. Line n sits in row n + 1 of the sheet.
Every column, explained.
In the order they sit in the file. Point at one and it is outlined in the sheet.
Behind the file
Why it is built this way.
The rows follow the statement in its own order. Lines 1 to 16 are revenue and orders: what the items were worth, what discounts and returns took back, the VAT that was never yours, and net revenue, the first figure that is really the store's. Lines 17 to 34 take the costs off in the order they happen: the goods to CM1, shipping and payment fees to CM2, marketing to CM3 and running costs to EBITDA, each with its share. Every cost share divides by net revenue; the shares above it are defined on their own lines, price reductions and discount codes against GMV, returns against gross revenue and VAT against what was kept after returns. The contribution margin formula behind CM1 to CM3 is the same subtraction each time, stopped after a different cost, which is why the template keeps the three apart.
The month filled in is October 2026 of a small apparel store selling in Germany. €80.000,00 of GMV becomes €78.540,00 of gross revenue, and €60.000,00 of net revenue once €7.140,00 of returns and €11.400,00 of VAT are out. The goods take 38,1% of that, parcels and payment fees another 10,2%, ads 25,0%, and €7.134,25 of running costs leaves €8.886,65 of EBITDA, 14,8% of net revenue. Read top to bottom, the file is what a P&L is: one question answered in 34 steps.
21 of the lines are worked out from the lines above them, and their formula column holds the cell formula for the month column: line 7, gross revenue, is C2-C3-C5+C7. It is text without its equals sign, so the file opens without running anything; type = in front of it in the month cell and the line is live. The formulas use no function, only signs, so they read the same in an English or a German Excel and in Google Sheets. The other 13 lines are typed in, and their last column says what goes into each.
A month answers whether the store made money. A day answers what to change by tomorrow, which is what the daily P&L template is for: the same order of costs, one row per day. For one product rather than the whole store, the margin formula sheet works a price down to its contribution, and CM1, CM2 and CM3 explained walks through what each margin tells you.
More templates
More free files, same format.
Margin formula sheet
Gross margin, markup and contribution per order, every formula for Excel and Google Sheets.
Monthly break-even worksheet
How much you have to sell before the month pays for itself.
Your daily P&L, without the spreadsheet.
nouz works out your real profit every night, after product costs, shipping, payment fees, ad spend and running costs, and sends it to your inbox each morning.