Reports
Reports provide insight into the financial performance and operational situation of the rental business. They are available to staff with the appropriate role and can be accessed directly from the app.
Quick Overview
Via More → Reports you find an overview of all available reports. Reports are based on current data and always show the most recent state of affairs.
Available Reports
| Report | Description |
|---|---|
| Shortage report | Products with insufficient stock per day in a chosen period; per day it shows which orders and quotes hold the product (red = confirmed, orange = options) |
| Overdue invoices | Overview of all invoices with status Overdue, including customer name, invoice number, amount and number of days overdue |
| Top products | Most-rented products based on number of order lines or revenue in a chosen period |
| Top customers | Customers with the highest revenue or most orders in a chosen period |
| Revenue by month | Monthly revenue overview based on invoiced amounts |
| Utilisation per product | Percentage of available days that a product was rented (utilisation rate) |
Getting Started
- Go to More → Reports.
- Choose the desired report from the list.
- Set any filters, such as:
- Period (from / to date)
- Product category
- Warehouse location
- The report data loads immediately.
Reports can be exported as a CSV file for use in Excel or other analysis software. Tap the export icon in the top right of the report.
In Depth
Shortage Report
The shortage report lists every product that, on at least one day in the chosen period, is needed more than it is available. It counts exactly like the availability calendar: bulk stock, coupled products, custom line dates, repairs and quotes (in option) are all included. Use it to plan sub-rentals.
- Select a period (default: today to 30 days ahead, at most 366 days)
- Per product with a shortage, the affected days are shown with how many units are confirmed, in option and under repair
- Red = shortage caused by confirmed orders; orange = shortage that only arises because of quotes
- Tap a day to see which orders and quotes hold the product (order number, customer, quantity, "in optie")
Overdue Invoices
This report is the most urgent daily overview. It shows invoices where the payment term has expired and the full amount or a portion is still outstanding. Use this report as a basis for accounts receivable management.
Columns: customer, invoice number, invoice date, due date, total amount, outstanding amount, days overdue.
Utilisation Rate
The utilisation rate calculates per product what percentage of available days the product was actually rented out. This is a valuable indicator for investment decisions:
- A high utilisation rate (>80%) suggests additional procurement is worthwhile.
- A low utilisation rate (<20%) may signal that a product is less popular.
The calculation is based on orders with status Out (Uitgegeven) and Returned (Retour ontvangen) for the selected period.
Revenue by Month
This report shows a bar chart of monthly revenue based on invoiced amounts (invoice status Sent, Partially paid or Paid). Revenue is grouped by invoice date, not by reservation period.
For customers with monthly periodic billing, the revenue report shows each monthly invoice separately. Revenue figures are therefore consistent, even for long-term rental contracts.
Role Restrictions
Which reports are visible depends on the role:
- Admin and Owner: all reports
- Planner and Sales: revenue report, top customers, top products
- Warehouse: utilisation rate, top products
- Viewer: read-only, no export