9 columnsCSV
Planning a month
Monthly break-even worksheet
What this file is
A break-even worksheet answers the month's first question: how many orders must come in before fixed costs are covered and profit begins. It takes three inputs you already have, fixed costs, average order value and contribution per order, and turns them into an order count and a revenue figure.
What is inside
One header row, one filled example.
Fixed costs on one side, contribution margin per order on the other, and the number of orders that clears them. It answers the question every operator asks on the first of the month.
Rows 1 and 2 are the file. Click any cell to read it; the foot of the sheet says what its column is for.
A22026-10
| Row | A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|---|
| 1 | month | fixed_costs | average_order_value | contribution_margin_pct | contribution_per_order | break_even_orders | break_even_revenue | |
| 2 | 2026-10 | 7000.00 | 85.00 | 0.276 | 23.43 | 299 | 25415.00 | |
| 3 | ||||||||
| 4 | ||||||||
| 5 | ||||||||
| 6 | ||||||||
| 7 |
nouz-break-even
A · monthThe month being planned, as year and month.
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 arithmetic is short. Contribution per order is what an average order leaves after its own variable costs: goods, shipping, packaging, payment fees, advertising. Divide the month's fixed costs by that contribution and you have the orders that clear them; multiply by average order value and you have the revenue the month must take.
The worksheet's honesty depends on which margin you feed it. Use CM3 per order, the contribution after marketing, never a gross margin: an order that has not yet paid for its own advertising has not really contributed. The example row is the example store the calculators use: €7.000 of fixed costs against €23,43 of contribution per order means 299 orders before the first profitable one. If the ad budget is committed for the month whatever sales do, move it into fixed_costs and use the contribution before marketing instead: €22.000 against €44,68 an order is 493 orders.
The interactive ecommerce break-even calculator runs this arithmetic live with your own numbers, both ways, and the break-even point entry in the glossary explains the trap in choosing the wrong margin for it.
More templates
More free files, same format.
11 columnsCSV
The first working day of a month
Monthly close checklist
The eleven things to check before a month is finished.
6 columnsCSV
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,00
Card needed to startNone
Access to your storeRead-only
Due today€0,00