With statistics, you can see how your rentals are performing on different levels. Rentman's statistics module allows you to create custom views that display the statistics relevant to your business.
Add a new statistics view
In the statistics module, you can create preset views, which can be saved to view at a later point. The steps below will explain how to set up a new set of statistics and what points you need to keep in mind. Scroll down for a list of statistic types and applications.
Navigate to Statistics from the left navigation column.
You will find a list of preset statistic views. We are going to add a new view to this.
To start, click on th Add button.
Select a statistic type in the window that opens. This determines from what elements you will see the data. You can find a description of each in the list 'statistic types and applications' (above).
- Enter a name and description for the view you are creating. You can adjust this later. Use ALT + S to save your progress and continue.
Navigate to the Statistics tab.
You will get a data table with preset columns of the type you have selected in step 3.
Change the column set if you want to see information of another sort. The column set is a preset of columns specific to one topic (revenue, maintenance, subhire, etc.).
Change columns. Column views can be customized by adding or deleting certain columns.
Delete a column by clicking on the icon right of the column title and select the option from the fold out menu.
Add a column by clicking on the column button.
Set a period. In the left column, you can set the period from which you want to view the data in your columns. There are two ways to set a period:
> A relative period that shifts with each passing day. An example would be to set this to always show the coming 30 days.
> A static period. For example between the 1st of September and the 1st of October.
Apply filters to your view. By default, filters are not applied to your view. This means that canceled projects are also taken into account. That's why filters can be useful to only see relevant statistics
Click on the + next to filters in the left widget column to add a new filter.
Example: To see your future revenue you would have to select confirmed projects only. To do this, select the 'is confirmed' option from the list of filters.
Save your statistic view. Save your created view by using the shortcut ALT + S or by using the Save button in the top right corner.
- Export your results. Click on the column button to export the data in your screen. The data will be downloaded as a .XLSX file that can be opened and edited using Excel or Google Sheets.
Statistic view types and applications
Statistics in Rentman are divided into different categories. In the list below, you can find these types of categories including some examples of what they cover.
View how your projects are performing. These can be grouped by project type, account manager or client.
- Display revenue and earnings of your projects. See what types of projects are the most profitable.
- See which customer or project type offers the highest profit margins and determine what you should focus on.
- What is the expected revenue for your projects that are currently planned?
- Filter your project revenue by the account manager to see who brings in the most revenue.
Overview of worked hours, costs and revenue figures by crew member or crew member groups (by folder).
- Find out who works the most for you to decide if you want to invite him/her first next time.
- See who of your employees costs more than he/she brings in.
- Compare registered hours with planned hours.
Usage, repair and revenue figures grouped by equipment type or categories. Insight into rental and sales figures.
- Insight into usage, costs and revenue figures of your vehicles.
- Which vehicles are most used and would it save expenses to lease them?
- See what project types or customers result in most equipment repairs.
- See which equipment items frequently require maintenance.
List of invoices with prices including or excluding VAT. Can be grouped by client.
- Do the invoice amount and project price match? A deviation might indicate that a part of the project was not invoiced.
- Get insight into the payment behavior of your clients.
Insight into the costs and frequency of your subhires.
- See what equipment you need to subhire most and assess if the purchase of the item is more profitable
- See from which supplier you subhire the most equipment and decide if you could stipulate a discount.
For each type, you can adjust the view using different columns and filters. Each type has its own specific set of columns with fixed column values. You are free to add or delete certain columns to retrieve the data you want to see.