Advanced reports
The Expenses report and the Order profitability report: how much the company has spent, where, and how individual projects are earning.
Advanced reports belong to the All for business tariff. In the menu they are in the Reports section as Expenses and Order profitability, next to them is the Ziskovost strojů (Machine profitability) report. Only the administrator sees them in the menu, because they work with figures for the whole company.
A general description of reports, period selection and how costs are created is on the Reports page.
Expenses report
An overview of all company costs for the selected period: wage costs from approved work reports, machines, trips, and received invoices and receipts.
- Open Reports → Expenses.
- Select the period with the Select period button or in the calendar. Without a selection, the report shows the last 14 days.
- Optionally narrow the report down with the Nákladová kategorie (Expense category) filter (on a computer) or by clicking a category or project in the list.
What the report shows:
- Cena celkem (Total price) - the sum of all costs in the period.
- Hodin celkem (Total hours) - hours from the approved work reports from which the costs arose, each report counted once (even if it has machines).
- Průměrný náklad na mh (Average cost per man-hour) - the total price divided by the hours, i.e. how much one hour worked costs the company including the other costs.
- Nákladové kategorie (Expense categories) - amounts by expense category.
- Stavby (Projects) - amounts by project with hours and price per hour. Costs that do not belong to any project (such as overheads) are in the Neznámý (Unknown) row.
- Graf podle nákladových kategorií (Chart by expense categories) - a bar chart of the distribution of costs by expense category.
Costs are assigned to the date on which they arose: work reports to the day of work, trips to the day of the trip, received invoices to the date of taxable supply. An invoice in a category of the Provozní náklady do více dní (Overhead costs over multiple days) type is spread evenly over all days of its period, so the report shows only the part that falls within the selected period.
Order profitability report
A table of all projects with invoicing, costs and profit. It is calculated over the entire duration of each project; there is no period selection here.
- Open Reports → Order profitability. The report opens with the Aktivní (Active) switch turned on, i.e. only with active projects (in the Příprava (Preparation) or Realizace (Realization) phase). Turn the switch off to see all projects. When no project matches the filter, the report says Žádné stavby neodpovídají filtru (No projects match the filter) and the switch stays available.
- For the detail of one project, select it in the Projects filter (on a computer).
- With a large amount of data, the report takes a while to load.
| Column | Meaning |
|---|---|
| Stavba (Project) | project name |
| Fakturováno celkem (Total invoiced) | the sum of the Fakturováno (Invoiced) amounts for the project categories |
| Počet hodin (Number of hours) | hours from approved work reports on the project, each report counted once (even with machines) |
| Náklad práce (Labour cost) | wage costs from approved work reports |
| Náklad strojů (Machine cost) | costs of machines on the work reports (machine hours × the machine's cost rate) |
| Přijaté faktury (Received invoices) | costs from received invoices and receipts assigned to the project |
| Provozní náklady (Overhead costs) | the share of the company's operating overhead attributable to the project |
| Náklady celkem (Total costs) | all project costs: work reports, received invoices and trips |
| Zisk (Profit) | Fakturováno celkem - Náklady celkem; green when positive, red when negative, orange when zero |
| Čistý zisk (Net profit) | Zisk - Provozní náklady |
| Zisk/h, Čistý zisk/h (Profit/h, Net profit/h) | profit and net profit per hour worked |
When you select one project in the filter, the table breaks down by Stavební kategorie (construction categories) with the same columns. The project's overhead costs are divided among the categories according to the hours worked.
Overhead costs
Overhead costs are company costs that do not belong to a specific project, typically rent, energy or accounting. The report includes received invoices in expense categories of the Provozní náklady and Provozní náklady do více dní types. For each month in which work was done on the project, the company's overhead costs are divided among the projects according to the number of work reports created on them in that month.
The Project report uses the same calculation.
For the numbers to make sense
- Fill in Fakturováno for the project categories. Without it, the profit is always negative.
- Fill in Hod. hrubá mzda (Hourly gross wage) for users, otherwise their work reports have zero wage cost.
- Fill in Nákladová sazba (h) (Cost rate (h)) and Nákladová sazba (km) (Cost rate (km)) for machines and vehicles, see Machines.
- Assign received invoices to a project and construction category and choose the correct expense category, see Purchase invoices.
- Only approved work reports and trips are counted. Whatever is waiting for approval is not in the reports yet.
A breakdown of one project's work reports by day and person and of its received invoices, with export to CSV and XLSX, is opened from the project list with the Rozpis (Breakdown) button, see Project breakdown. Hours and work cost by person are shown in the Work reports report.