Free template · .xlsx · no sign-up
A monthly P&L for
your Shopify store.
Twelve months side by side: sales down to net profit, with contribution margin and break-even ROAS worked out for you. Opens in Google Sheets and Excel.
- You type10 figuresa month, in the yellow cells
- It works out12 linesfrom VAT to break-even orders
- Example inside€2,521the example store’s July 2026
01 / Three steps
From download to your own month
Download the file
One .xlsx file, about 6 KB. No sign-up, no email.
Open it in Google Sheets
In Google Sheets: File → Import → Upload, and choose the file. It also opens in Excel and Numbers as it is.
Type in the yellow cells
A month per column. Everything else — VAT, contribution, net profit, break-even ROAS — fills in by itself.
02 / Every line, explained
The words in the sheet
03 / More free tools
The same arithmetic, as calculators
Profit calculator
What a month keeps after ads, fees, returns, goods and shipping.
Use it →Discount break-even
How deep a sale can go, and how many more units it has to sell.
Use it →Break-even ROAS
The ROAS below which an ad loses money on every order.
Use it →Shopify fees
What Shopify, the payment providers and the apps take from a month’s sales.
Use it →Price calculator
What to charge so a unit keeps the margin you want, after VAT, goods, shipping and fees.
Use it →Free-shipping threshold
The order value above which free shipping still earns the margin you want.
Use it →Store check
What a store’s own public pages show about its prices and stock.
Use it →
A spreadsheet is typed. Profflow is measured.
The template needs your figures each month. A connected store fills every line from its orders, ads and costs, order by order — read-only, in about ten minutes.