How many times has a bike been rented? (item usage report)

Created by Emily Campbell, Modified on Fri, 24 Jul at 4:20 PM by Emily Campbell

Seeing how much use an item has had

BRM has an Item usage report that shows how many times each item has been rented, how many days it was out, and how much revenue it earned.

How to run it

  1. Go to ReportsGraphs.
  2. Set Report type to Item usage per year.
  3. Choose your Start year and End year, or use one of the shortcuts under FiltersThis year, Last year, Last two years, Last three years.
  4. Press Search.

Below the chart you'll get a table with a row per item — its ID and Store ref, then for each year a Rental count, Days usage and Revenue.

Use Download to export it as CSV if you want to work with it in a spreadsheet.


What this report can't do

It's worth knowing its limits before you go looking:

  • Whole calendar years only. There's no way to ask for a custom date range, so a question like "how many times was this bike rented in June and July?" can't be answered from this report.
  • Every item at once. You can't filter it to a single bike. To look at just one, export the CSV and filter by its Store ref, or find its row in the table.
  • Items with no rentals that year don't appear at all, rather than showing a count of zero. If a bike is missing from the list, that means it wasn't rented in that year.


Related

If what you actually want is who had a particular bike rather than how often, see "How do I find out who rented a particular bike?" — that's a reservation search rather than a report.


Still stuck?

If you need usage figures broken down in a way this report doesn't offer, contact support and tell us what you're trying to work out — it helps us prioritise better reporting.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article