AI Report Builder

Edited

The AI Report Builder allows you to create custom reports in HirePOS simply by asking a question in everyday language.

Instead of manually selecting report fields, filters and grouping options, describe the information you need, and HirePOS AI will generate a report using your business data.

You can preview the results and export them to CSV for further analysis in Microsoft Excel or other spreadsheet applications.

Beta Feature: The AI Report Builder is currently in beta. Additional reporting datasets and functionality will be introduced progressively.

How to Use the AI Report Builder

  1. Open AI Report Builder in HirePOS.

  2. Enter a question describing the information you want to report on.

  3. Submit your question to generate the report.

  4. Review the results displayed in the report preview.

  5. Select Export CSV if you want to download the results.

You can also use the suggested report questions to get started.

Example Questions

Try questions such as:

  • Show customers located in Victoria.

  • List active customers grouped by category.

  • Show invoiced sales for the current month.

  • Show monthly sales totals for this financial year.

  • Which equipment had the lowest utilisation last month?

  • Show hire revenue by equipment category.

  • Show the top 20 items by sales excluding GST this year.

Tip: Include a date range, category, location or other relevant criteria to help the AI generate a more specific report.

Available Reporting Datasets

The AI Report Builder currently supports four reporting datasets.

A dataset is a collection of related business information that the AI can use to generate reports.

1. Customers

Create reports using your customer records.

Available reporting options include:

  • Customer names and company details.

  • Customer categories.

  • Customer locations, including city and state.

  • Active and inactive customers.

  • Customer counts and summaries.

Example questions:

  • Show all customers in Queensland.

  • List inactive customers.

  • How many customers do we have in each state?

  • Show customers grouped by category.

2. Sales by Date

Analyse invoiced sales over a selected reporting period.

Available reporting options include:

  • Invoiced sales by date.

  • Monthly sales summaries.

  • Sales by customer.

  • Invoice counts.

  • Invoiced amounts, payments and outstanding balances.

  • Sales rankings and summaries.

Example questions:

  • Show invoiced sales for last month.

  • What were our total invoiced sales this financial year?

  • Show monthly invoiced sales totals.

  • Which customers generated the most invoiced sales this year?

Note: Sales by Date reports use invoice dates rather than payment dates. Credit notes are included as negative amounts where applicable.

3. Hire Item Utilisation

Analyse how frequently hire equipment is used and how much revenue it generates.

Available reporting options include:

  • Equipment code and description.

  • Item type and equipment categories.

  • Days on hire during a selected period.

  • Equipment utilisation percentage.

  • Number of hires.

  • Meter usage.

  • Hire revenue including and excluding GST.

  • Active and inactive equipment.

Example questions:

  • Show hire item utilisation for last month.

  • Which 20 items had the lowest utilisation last month?

  • Show utilisation by equipment category.

  • Which equipment generated the most hire revenue?

  • Show inactive equipment with no hire activity last month.

Note: Utilisation is calculated using the time equipment was on hire during the reporting period. Hire revenue is allocated proportionally to the relevant reporting period.

4. Sales by Item

Analyse sales performance by individual item, item type or reporting month.

Available reporting options include:

  • Item code and description.

  • Item type.

  • Monthly item sales.

  • Sales totals including GST.

  • Sales totals excluding GST.

  • Item sales rankings.

  • Grouped sales summaries.

Example questions:

  • Show sales by item for last month.

  • Which 20 items generated the most sales this year?

  • Show monthly sales by item type.

  • Show sales excluding GST by item.

  • Which items generated the least revenue last month?

Note: Sales by Item includes invoices and credit notes, excluding cancelled transactions. Credit notes reduce the reported sales totals.

Filtering and Grouping Reports

You can refine your reports by including additional instructions in your question.

Filtering

Ask the AI to return only records matching particular criteria.

For example:

  • Show customers in New South Wales.

  • Show sales for the previous month.

  • Show inactive hire equipment.

  • Show sales for a particular item type.

Grouping

Ask the AI to summarise information by a particular field.

For example:

  • Group customers by state.

  • Show invoiced sales by month.

  • Group equipment utilisation by category.

  • Show sales totals by item type.

Sorting and Limiting Results

You can also request results in a particular order or limit the number of records displayed.

For example:

  • Show the top 10 customers by invoiced sales.

  • Show the 20 least utilised hire items.

  • Sort sales by highest total first.

Previewing Report Results

Once your question has been processed, the AI Report Builder displays the results in a report preview.

The preview allows you to review the information before exporting it.

Depending on the report, results may include individual records or grouped summaries.

For large reports, the preview may be limited to a maximum number of rows.

Exporting Reports to CSV

Select Export CSV to download the report results.

CSV files can be opened in Microsoft Excel and other spreadsheet applications.

CSV exports are useful for:

  • Further analysis and calculations.

  • Creating charts and pivot tables.

  • Sharing reporting information outside HirePOS.

  • Keeping a copy of report results.

The CSV export may contain more rows than the on-screen preview, subject to reporting limits.

Important: Exported reports may contain sensitive customer or financial information. Store and share downloaded files appropriately.

Report Permissions and Security

The AI Report Builder uses your HirePOS business data and is subject to user access restrictions.

Access to the beta feature currently requires the relevant Reports and Payment Reports permissions.

The AI Report Builder uses approved reporting datasets and fields. It does not allow users to execute arbitrary SQL queries.

Report requests and CSV exports are recorded for auditing purposes.

Reporting Limitations

As the AI Report Builder is currently in beta, some limitations apply:

  • Only the datasets listed in this guide are currently supported.

  • Questions involving information outside these datasets may not be available.

  • Some datasets require a reporting date range.

  • Reporting date ranges and result sizes may be limited.

  • Not all combinations of fields, calculations and grouping options are supported.

  • Reports combining information across multiple datasets are not yet supported.

If a report cannot be generated, try simplifying the question or selecting a more specific reporting period.

Always review important financial or operational results before relying on them for business decisions.

Frequently Asked Questions

Can I ask questions in everyday language?

Yes. Simply describe the report you need. You do not need to know SQL or how HirePOS stores its data.

Can I export the results to Excel?

Yes. Use Export CSV to download the results, then open the file in Microsoft Excel.

Can I report on equipment utilisation?

Yes. The Hire Item Utilisation dataset supports equipment utilisation, days on hire, hire counts, meter usage and allocated hire revenue.

Can I report on sales by individual item?

Yes. The Sales by Item dataset allows you to analyse item-level sales, monthly sales and sales by item type.

Can I save my favourite reports?

Not yet. Saved reports are planned for a future release.

Can I share a report with another HirePOS user?

Report sharing is planned for a future release, alongside saved reports.

Can I create reports using other areas of HirePOS?

Additional datasets are being developed. Planned areas include current hires, outstanding invoices, bookings, equipment inventory, maintenance, payments and deliveries.

What if the AI generates an unexpected result?

Try rewording your question, specifying a date range or using more precise reporting criteria. As this is a beta feature, we encourage users to report unexpected results through HirePOS support or feedback.

Coming Soon

We are continuing to expand the AI Report Builder with:

  • Additional reporting datasets covering more areas of HirePOS.

  • The ability to save frequently used reports.

  • The ability to copy saved reports to other HirePOS users.

  • Further improvements to reporting flexibility and usability.

The goal is to make reporting more accessible, allowing HirePOS users to retrieve meaningful business information without needing to build complex reports manually.

Was this article helpful?

Sorry about that! Care to tell us more?

Thanks for the feedback!

There was an issue submitting your feedback
Please check your connection and try again.