Profitability report
Shows what the business actually earned over a period: revenue, cost of goods sold, gross profit and net profit per organization.
Other things people look for in this report: gross profit, net profit, margin, profitability, profit and expenses.
How to open
Menu → Reports → Profitability report.
Route: /warehouse/reports/profitability
Quick actions:
Overview
This is the only report that brings three sources together: sales, the cost of the goods that were sold, and the expenses paid from cash registers and bank accounts. Every other report shows just one of them.
Rows are organizations (legal entities or branches). Each organization expands into its expense items (cash-flow items): rent, utilities, payroll, goods, and so on. The bottom row is Total.
Filters
| Filter | Description | Required |
|---|---|---|
| Trade point | One point or all | No |
| Period | Date range or a specific shift | Yes |
| Organization | One legal entity or all | No |
Press Build after choosing the filters.
Columns
| Column | What it means |
|---|---|
| Organization | Legal entity or branch |
| Revenue | Money earned including all taxes and service charges |
| Cost | What was spent buying the goods that were sold (direct purchase cost) |
| Gross profit | Revenue − Cost. Expenses are not deducted yet, but taxes are already inside revenue |
| Expenses | The cash-flow item and its amount: rent, utilities, goods, cleaning, etc. |
| Net profit | Gross profit − Expenses (the sum of all expense items) |
| Net profit, % | Profitability: (Net profit ÷ Revenue) × 100% |
Hints inside the report
Click any column header for a tooltip with its formula — the same definitions as the table above.
How to read it
Gross profit answers "how much do we make on the goods themselves". It ignores rent, payroll and other expenses — it is purely the difference between the selling price and the purchase price.
Net profit answers "what is left in the end". All expenses posted through cash registers and bank accounts during the period are subtracted from gross profit.
Net profit, % is profitability. It shows what share of revenue you kept after all costs. Use it to compare points and periods: the absolute profit depends on scale, the percentage does not.
Common problems
Cost is zero or clearly too low. Cost comes from the warehouse ledger. If goods were sold but the receipt document was never posted, the system has no purchase price to use. Check that all receipt documents for the period are posted, and re-post if needed — see Material statement.
Expenses are empty. Only expenses posted as cash or bank documents reach this report. If you pay rent outside the system, the report cannot know about it — record it as Cash outcome or Bank outcome.
Net profit is negative although there were sales. That is a normal result when expenses for the period exceeded gross profit — for example in a month when equipment was purchased. Expand the organization row to see which expense item carried the weight.
The numbers do not match the sales report. Revenue here includes service charges and taxes. Sales reports may show the amount before or after them — compare like with like.
FAQ
How is this different from Sales analysis?
Sales analysis shows what was sold and how much. This report shows how much you earned on it after cost and expenses.
Where do I see the margin on a specific product?
Margin here is calculated for the organization as a whole. For individual products see Warehouse summary and Calculation card.
Can I see profitability for a single trade point?
Yes, pick the point in the filter. The breakdown inside the report is by organization, so if one point has one legal entity, you see exactly that point.