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.

nouz-profit-and-loss-template.csv5 columns
A21
nouz-profit-and-loss-template.csv: 5 columns, the header in row 1 and 34 filled rows in rows 2 to 35
RowABCDEFGHI
1lineline_namemonthformulain_words
21Gross Merchandise Value (GMV)80000.00inputEvery item sold at its original price (the compare-at price where one is set), VAT included, shipping excluded
32Price Reductions3200.00inputWhat items sold below their compare-at price gave away: (compare-at price - price) x quantity
43Price Reductions % of GMV0.0400C3/C2Price Reductions / Gross Merchandise Value (GMV)
54Discount Codes4000.00inputDiscount codes and automatic discounts on the items
65Discount Codes % of GMV0.0500C5/C2Discount Codes / Gross Merchandise Value (GMV)
76Shipping Revenue5740.00inputShipping charged to customers, VAT included, after shipping discounts
87Gross Revenue78540.00C2-C3-C5+C7Gross Merchandise Value (GMV) - Price Reductions - Discount Codes + Shipping Revenue
98Gross Orders740inputOrders placed in the month, without cancelled and test orders
109Gross AOV106.14C8/C9Gross Revenue / Gross Orders
1110Returns7140.00inputRefunds issued in the month, products and shipping, VAT included, whenever the order was placed
1211Return Value % of Gross Revenue0.0909C11/C8Returns / Gross Revenue
1312Taxes11400.00inputThe VAT inside Gross Revenue - Returns
1413Tax %0.1597C13/(C8-C11)Taxes / (Gross Revenue - Returns)
1514Net Revenue60000.00C8-C11-C13Gross Revenue - Returns - Taxes
1615Net Orders706inputGross Orders - fully refunded orders
1716Net AOV84.99C15/C16Net Revenue / Net Orders
1817COGS22880.00inputUnits sold at the unit cost on their order date, less refunded units that came back to stock or never shipped
1918COGS %0.3813C18/C15COGS / Net Revenue
2019CM137120.00C15-C18Net Revenue - COGS
2120CM1 %0.6187C20/C15CM1 / Net Revenue
2221Logistic Costs4736.00inputShipping, pick and pack, packaging and return handling
2322Logistic Costs %0.0789C22/C15Logistic Costs / Net Revenue
2423Transaction Costs1363.10inputPayment fees: a share of each amount charged plus the fixed fee per payment
2524Transaction Costs %0.0227C24/C15Transaction Costs / Net Revenue
2625CM231020.90C20-C22-C24CM1 - Logistic Costs - Transaction Costs
2726CM2 %0.5170C26/C15CM2 / Net Revenue
2827Marketing Costs15000.00inputAd spend on the day it was spent, plus any other marketing
2928Marketing Costs %0.2500C28/C15Marketing Costs / Net Revenue
3029CM316020.90C26-C28CM2 - Marketing Costs
3130CM3 %0.2670C30/C15CM3 / Net Revenue
3231Overhead Costs7134.25inputRunning costs spread over the days, one-off costs on their own day
3332Overhead %0.1189C32/C15Overhead Costs / Net Revenue
3433EBITDA8886.65C30-C32CM3 - Overhead Costs
3534EBITDA %0.1481C34/C15EBITDA / Net Revenue
36
37
nouz-profit-and-loss-template

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.

All 17 templates

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.

Your trialToday
14 days of nouz, every feature$0
Card needed to startNone
Access to your storeRead-only
Due today$0