Exporting item usage: how many times each item was rented in a date range

In short: the Item usage export gives you a spreadsheet with a row per item, showing how many times it was rented and how many days it was out over any date range you choose.

How to run it

1. Go to Reports → Export Data.
2. Set Type to Item usage.
3. Choose your Start date and End date, or use the Filters shortcuts (This month, This year, Last month, Last year).
4. Press Request report. It's emailed to you as a CSV shortly afterwards.

If you don't see Item usage in the Type list, it may not be switched on for your store yet — contact us and we'll enable it.

What's in the file

One row per item in your store, with:

• the item's reference and model;
• Rental count — how many times it was rented in the range;
• Days out — how many days within the range it was out on a hire.

Every item appears, including ones that weren't rented in the range (they show a count of zero), so you can spot under-used stock.

How "rented in the range" is defined

So a figure is never a surprise:

• Rental count counts every hire whose dates overlap the range at all — including a hire that started before the range or ends after it, as long as part of it falls inside.
• Days out counts only the days within the range the item was actually out. A hire that runs across the edge of the range contributes only its days inside the range, and a day the item was out on more than one overlapping hire is counted once.

Only genuine customer hires count. Cancelled bookings, unaccepted quotes and workshop/maintenance bookings are all excluded, so the figures match what customers were actually charged for.

Related

• How many times has a bike been rented? (item usage report) — the same kind of figures per calendar year, as a chart, under Reports → Graphs.