Get the month's net profit without rebuilding a spreadsheet.
Sales down to net profit as a waterfall, month by month and per branch. One export gives an editable workbook with live formulas.
Built for a retailer with three branches and an online store.
The screen.
Profit report
September 2026 · all branches
| Month | Sales | Gross profit | Expenses | Stock out | Net profit | Margin |
|---|---|---|---|---|---|---|
| September | $96,418.20 | $45,157.35 | $18,442.70 | $1,847.35 | $24,867.30 | 25.8% |
| August | $91,632.75 | $42,604.30 | $19,571.85 | $2,034.10 | $20,998.35 | 22.9% |
| July | $88,240.10 | $40,918.45 | $17,806.20 | $1,214.60 | $21,897.65 | 24.8% |
| June | $84,915.60 | $39,286.40 | $21,206.15 | $976.85 | $17,103.40 | 20.1% |
By hand, and with Keystone OS.
By hand today
At month end, someone exports sales from each shop, pulls costs from supplier invoices, copies expenses off the bank statement, and rebuilds the profit report in Excel. The formulas break whenever a branch or a category is added.
Stock given away, used as samples or written off never makes it in, so the profit figure is higher than the bank balance suggests. The owner sees the report well into the next month, too late to change anything.
With Keystone OS
Sales, cost of goods, expenses and stock that left without a sale are recorded as they happen, so the report is ready when the month ends. The waterfall shows how sales become gross profit and then net profit, and the table lines months up with their margin.
Each branch shows its share of net profit. When the accountant or a partner wants to work the numbers, export the workbook: one sheet per branch, with live formulas rather than pasted values. For the multi-branch retailer we built it for, the report that was rebuilt by hand in Excel each month is now one export.
How it runs.
Pick the period
Month, quarter or year. The figures come from what was already recorded.
Read the waterfall
Sales, minus cost of goods, minus expenses, minus stock out, leaves net profit.
Compare branches
See which branch carries the month and which months moved the margin.
Export the workbook
One file, one sheet per branch, formulas intact for whoever edits it next.
Where it stops.
It does not
- Does not prepare tax returns; the accountant pack is the handover to your accountant.
- Does not include spending nobody recorded; the report is only as complete as the expenses entered.
Start with Land
One workflow automated, live in about a month. Quoted after a scoping call.
You approve a one-page system design before we build, so you see exactly what this screen will do in your business first.
