Cost category over time
The Cost category over time tab of a budget follows one cost category month by month, with a line for each of the budget's projects. Where the P&L by tags adds a category up for the whole budget, this tab compares the projects with one another: which building pays the most for cleaning per square metre, and in which months that changed.
Opening the tab
- Go to Budgets in the main menu and open a budget.
- Select the Cost category over time tab.
Choosing what to compare
- Category picks the cost category. The categories offered are the tags on the budget's costs; costs with no tag are not offered.
- Measure switches between Cost / m², the default, and Amount. Cost per square metre divides each project's cost by its surface. A budget that does not show figures per square metre offers no measure choice and shows amounts.
- Year switches between this year and last year. A budget with dates of its own covers those dates, and the year choice is not offered.
- Projects in the comparison lists the budget's projects as chips. Every project starts selected; select a chip to take its project off the chart or to put it back. With none selected, the chart asks you to select at least one project.
All figures are net.
Reading the chart
Each project has its own line, with a marker shape and a colour that stay with the project when you switch others off. Labels at the end of the lines and a legend name the projects. With more than six projects selected, the first six keep their own lines and the rest are drawn as one grey dashed line, Others, the average of those projects.
- A month with no invoices breaks the line. It is not a zero. A cost that was booked at zero is drawn as zero.
- The month still being booked is drawn open, with a dotted segment, and is left out of the totals, so a half-booked month does not look like a drop in cost.
- A project without a usable surface has no cost per m². It shows no figure in that measure.
The table
Below the chart, a table lists the months down the side and the projects across. Each project drawn as part of Others still has a column of its own.
- A month with no invoices reads no invoices this month, the month still being booked is marked open, and a project without a surface reads no surface.
- Every figure opens the cost rows behind it, for that project and month, so you can see which invoices make up a figure before questioning it.
- The totals row counts closed months only. It is headed with how many closed months it covers, and where a project has months with no invoices, its total says how many of the months it is made of, for example 10 of 11 months.
When there is nothing to draw
- This budget has no cost categories yet. The tab says so, and no category choice is shown.
- No invoices in this category. No costs were booked in the chosen category in the chosen year.
- Some figures could not be converted into the budget's currency. The chart is not shown, so a total in mixed currencies is never drawn.
- Loading fails. The tab offers to try again.
Example use cases
- A property manager compares cleaning cost per square metre across the buildings of one budget and finds the one that costs twice the others.
- A controller follows the energy category month by month and sees that a gap in one building's line is a month with no invoice yet, not a saving.
- A finance manager opens the figure for one building and month to see which invoices make it up before asking the supplier about it.