Overview
The Reports > Departments menu is available to both department managers and administrators. Here, an administrator can generate various reports across all departments. A department manager can generate reports specific to their department(s).
If the Invoicing module is used, there is an additional section called Invoicing, where a department manager (or an administrator) can access all reports related to invoices for projects within their department.
Times Overview departments
Under Reports > Departments > Time, a department manager can display a monthly time overview for their department(s), either individually or including sub-departments. An administrator can generate reports for all departments.
This report allows you to compare departments. In the upper table, the following information is displayed for all employees within a department:
The total working hours of all employees in the department.
If the Absences & Overtime module is enabled, the following additional data is displayed per department and as totals:
Annual leave (in days)
Unpaid absences (in days)
Paid absences (in days)
Total overtime
In the lower table, the time spent on all projects of the selected department(s) is shown — regardless of the employees’ departmental affiliation.
Department Cost overview
Under the menu Reports > Departments > Costs, a department manager can view a detailed list of all internal and external costs incurred by their department per month. An administrator can generate reports for all departments.
Flat-rate projects cannot be broken down by employees’ departments; they are assigned to the department of the project.
Optionally, you can activate the checkbox “Calculate billable total rates for fixed price projects and tasks from the hourly rates of the price table”— this calculates the time spent on flat-rate tasks/projects using the hourly rate defined in the applicable price table for this report.
For each department, a detailed breakdown is displayed:
Internal projects (projects without a customer) + employees of the department, including internal wages and other costs
Customer projects + employees of the department, including internal and external costs
Projects of the department + employees from other departments
Projects from other departments + employees of the department
Mixed projects that include both flat-rate and time-based tasks are marked with an asterisk (*). Projects without recorded time entries or receipts during the reporting period are not displayed.
Cost Allocation Department
The results table is structured as follows:
First column / Subheading: Receiving Department – all departments whose projects, during the selected period, have recorded time entries or expenses by employees from other departments.
Second column (nested under the first): Providing Department – departments whose employees have booked time or expenses on the projects of the department listed in the first column.
Third column: Number of hours that employees from the department in column two have booked to the projects of the department in column one.
Fourth column: Internal labor costs – calculated as the number of hours multiplied by the employee’s internal hourly rate.
Fifth column: Other internal costs – includes internal amounts from receipts, mileage reimbursements, and meal allowances.
Sixth column: Total internal costs – the sum of the previous two columns.
Subtotal lines are displayed for each department listed in the first column.
Total Rates Internal Department
The report Reports > Departments > Total Rates Internal Department functions as a type of “cost balance” — an internal cost allocation that distributes internal project costs between departments. (Labor costs are calculated using each employee’s internal hourly rate.)
You can select one, several, or all departments, and choose a specific project type (for example, include only internal projects, only customer projects, or all projects). Define the desired reporting period and click “Run” to generate the report.
For each department, the following data is displayed:
For projects belonging to the department:
Internal labor costs of the department’s own employees
Plus
Internal labor costs of employees from other departmentsEquals: the total internal costs incurred in this department.
For projects belonging to other departments:
Internal labor costs of the department’s own employees
(These costs are not incurred within the department itself, but in other departments.)
Total: Equals the internal costs minus the internal labor costs of the department’s own employees.
Employment Periods
Here you can view a graphical report of your employees’ employment periods. For the selected time frame (by default, from the first day of the previous month to the last day of the month four months ahead — a total of five full months), the employment periods of individual employees are displayed as bars in a chart.
Run report in the background and schedule as a task
You can also run this report in the background.
Instead of selecting Preview, choose Excel or CSV (CSV-comma or CSV-semicolon), and then click the “Execute in background” button to execute or schedule it as a task.
Invoicing
Reports > Invoicing (with the Invoicing module)
The Invoicing menu item provides a quick overview of all invoices and invoice line items for the department’s projects.
Additionally, reports on Outstanding Items, Incoming Payments, and Revenue Forecasts are available at the department level.
Users with the role Department Manager (for their assigned departments), Administrator, or Controller have access to this menu item.
Invoice items
Enter the date up to which planned invoice items and from which billed invoice line items should be displayed.
At a glance, you can see which customer and which project have approved invoice line items that are waiting to be invoiced.
To create an invoice, go to the corresponding customer by clicking on the customer number.
Missing invoice items
Here you can identify whether any efforts have been recorded for which no invoice items have been planned yet. By clicking on the project name, you are taken directly to the project sub-menu Invoice Line Items, where you can immediately create the corresponding entries.
Invoices
Under Invoices, you can view all invoices from your department and optionally restrict the list to invoices in a specific currency.
Open Items
For Administrators, Controllers, and Department Managers.
This report gives you a clear overview of how long each invoice has remained unpaid. You can optionally filter the results by the customer’s industry.
If you only want to view invoices with overdue payments, activate the checkbox “Exceeded term of payment.”
Specify either:
The number of days since the current payment due date (i.e., since the due date of the reminder, or if no reminder exists, since the due date of the original invoice), or
The number of days since the invoice due date.
The day intervals displayed as columns in the table can be defined under Administration > Invoicing > Settings.
You can also find this report in:
the sub-menu of a customer project,
the sub-menu of a customer, and
under Invoicing > Outstanding Items.
Incoming Payment
The Incoming Payments report shows which payments were received within a selected time period.
You can filter the payments by department, reporting period, customer, and currency. Optionally, you can specify the currency or choose to convert all amounts into your base currency.
In the Outstanding Items report, the conversion rate at the invoice date is always used.
If you do not select “Convert all amounts into EUR (or another base currency),” the amounts will be displayed in the respective invoice currency.
The report displays the following details:
Customer
Invoice number
Invoice date
Discount date
Payment due date
Net amount
Gross amount
Payment received date
Amount received
Reduction (if applicable)
VAT
Comment
If the invoice has not been fully paid, or if no reduction has been recorded, the remaining amount will appear in the open Items report.
Sales forecast
The Sales Forecast estimates future revenue for the coming months, years, or any selected period. It is based on the recurrence and planned or invoiced amounts specified in the invoice items, as well as any missing invoice items.
You can optionally filter the results by customer industry.
Select a currency if you want to include only invoices issued in that specific currency.
You can also choose to convert all amounts into EUR (or your company’s base currency).
Additionally, you can restrict the forecast to invoice items by status.
You can specify whether the amount for uninvoiced items should be taken from the planned amount or calculated based on currently recorded time and expense entries.
How are the figures calculated?
Planned and approved invoice items (with planned invoice date):
The amount is taken either from the planned amount, or
calculated based on the current actual effort (depending on your settings).
Fixed-price items are always calculated using the planned amount.
Invoiced items (including canceled invoices):
Are listed with their actual billed amount.
Missing effort-based items:
The amount is always calculated from the current actual effort.
Surcharge items (%):
Are always shown using the planned amount.




