Skip to main content

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​

ReportDescription
Shortage reportProducts 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 invoicesOverview of all invoices with status Overdue, including customer name, invoice number, amount and number of days overdue
Top productsMost-rented products based on number of order lines or revenue in a chosen period
Top customersCustomers with the highest revenue or most orders in a chosen period
Revenue by monthMonthly revenue overview based on invoiced amounts
Utilisation per productPercentage of available days that a product was rented (utilisation rate)

Getting Started​

  1. Go to More → Reports.
  2. Choose the desired report from the list.
  3. Set any filters, such as:
    • Period (from / to date)
    • Product category
    • Warehouse location
  4. The report data loads immediately.
Exporting

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.

Periodic Billing

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