Shelf™|
Shelf Logo

Getting Started with Reports

Run your first report in Shelf — pick a report, set the timeframe, apply filters, and export the result to CSV or PDF.

Reports turn the data Shelf already captures — bookings, custody, assets — into answers you can read, filter, and export. This guide walks through running your first report.

Open the Reports Index

In the sidebar, click Reports. The index lists every available report grouped by category:

  • Bookings — Booking Compliance, Top Booked Assets, Top Booked Kits, Monthly Booking Trends, Overdue Items
  • Assets — Asset Inventory, Asset Activity Summary, Asset Utilization, Idle Assets, Asset Distribution
  • Custody — Custody Snapshot
  • Audits — Audit Completion

Each card describes what the report shows. Click any enabled card to run it.

Reports index in Shelf showing the grid of reports grouped by category

Pick a Timeframe

Time-based reports — Booking Compliance, Top Booked Assets, Top Booked Kits, Monthly Booking Trends, Asset Activity Summary, Asset Utilization, Idle Assets, Audit Completion — include a timeframe picker at the top of the page.

  1. Click the timeframe picker.
  2. Choose a preset — Today, Last 7 days, Last 30 days (the default), Last 90 days, This month, Last month, This quarter, This year, All time, or define a custom range.
  3. The report re-runs against the new timeframe.

Snapshot reports — Asset Inventory, Custody Snapshot, Overdue Items — always reflect the current state of the workspace, so they do not show a timeframe picker.

Apply Filters

Every report except Audit Completion has a filter bar above it, next to the timeframe picker (and, on Idle Assets, the idle-threshold selector). It offers the filters that report supports as dropdowns:

ReportFilters in the bar
Booking ComplianceCategory, Location, Custodian, Status, Asset model, Custom field
Top Booked AssetsCategory, Location, Asset model, Custom field
Top Booked KitsCategory and Location show in the bar but do not change the result yet: the report always ranks every kit
Monthly Booking TrendsCategory, Location, Asset model, Custom field
Overdue ItemsCategory, Location, Custodian, Asset model, Custom field
Asset InventoryCategory, Location, Status, Asset model, Custom field
Asset Activity SummaryCategory, Location, Asset model, Custom field
Asset UtilizationCategory, Location, Asset model, Custom field
Idle AssetsCategory, Location, Asset model, Custom field
Asset DistributionCategory, Location, Asset model, Custom field
Custody SnapshotCategory, Location, Custodian, Asset model, Custom field
Audit CompletionNone. The timeframe is the only control

The Asset Distribution report with its filter bar (Category, Location, Asset model, Custom field) above four donut breakdowns, including the new By Asset Model

Applied filters show as chips above the report; remove one, or use Clear all filters. The headline numbers, charts and tables all follow the filters, and so do the CSV and PDF exports.

Custom field filters. Pick the field, then one of the values that field holds in your workspace. Text, option (dropdown) and yes/no fields can be filtered this way; a text field with more than 200 different values also takes an exact value you type. Add several custom field filters and a row has to match all of them. Date, number, amount and multi-line text fields are not offered.

Asset model filters any asset-based report to the units of one or more asset models, and Asset Distribution has a fourth breakdown, By Asset Model, next to category, location and status.

Filters live in the URL. A filtered report is a link you can bookmark and send to a colleague, which is what makes "Idle Assets in the Amsterdam warehouse, last 90 days" one click away. Links made before October 2026 with the old parameter spellings (categories=, custodian=) still open filtered. One filter has no dropdown and works from the URL only: the single asset on Asset Activity Summary.

Until 21 October 2026 these filters existed only as URL parameters, and Monthly Booking Trends accepted category and location without applying them. It now applies every filter in its bar.

Read the Result

Reports are laid out in three layers:

  1. KPI cards at the top — headline numbers like total bookings, on-time rate, or assets outstanding.
  2. Charts in the middle — trends, distributions, or compliance breakdowns.
  3. Tables at the bottom — the underlying records that make up the numbers.

Compliance and utilization reports use color to flag entries that need attention — late bookings, idle assets that have not moved in months, or custodians with overdue items.

How Booking Compliance Decides On Time or Late

Booking Compliance answers one question: was the deadline the custodian agreed to honoured? The report says so in its own words, in the How it's calculated line under the headline rate.

The Booking Compliance report showing the On-Time Return Rate, the How it's calculated explainer, and the Return Status column with late durations

Four rules govern every number on the page.

It measures against the planned end date, not the current one. A booking's planned period is recorded when the booking is created, still moves with any edit made while it is a draft, and is fixed from the moment it is reserved. Extending a booking, or checking it in early, moves the live dates and leaves the planned dates alone. So a booking that was due Friday and came back Monday is a late return, whether or not someone extended it to Monday first.

A return inside 15 minutes of the scheduled end is on time. That grace absorbs the walk back to the counter and the scan at the desk, so a queue at the cage does not read as a compliance failure.

Only finished or overdue bookings are counted. Complete and Archived bookings are measured against their check-in time. Overdue bookings are always late, by definition. Drafts, reservations, bookings currently Ongoing and cancelled bookings are left out: they have not run yet, are still inside their window, or never happened. A reservation archived without ever being checked out is excluded too, so it neither helps nor hurts your rate. See what archiving means for reports.

A booking is counted in the period its planned end falls in. Because the planned end never moves, a booking stays in the same period for its whole life instead of sliding into the next month when someone extends it.

The Return Status column shows the verdict per booking: On time, or how far past the deadline it came back, as 1d 8h late.

Why Booking Compliance and Overdue Items Can Disagree

The two reports ask different questions, so for an extended booking they will legitimately give different answers.

Booking ComplianceOverdue Items
QuestionWas the agreed plan honoured?What is late right now?
Measures againstThe planned end dateThe current end date
An extended bookingStill measured against the original deadlineMeasured against the new deadline

An overdue booking extended to next week disappears from Overdue Items straight away, because it is no longer late against its current deadline. It still counts as a late return in Booking Compliance once it comes back, because the deadline it was agreed to has already passed. Extending a booking is a way to keep operations moving, not a way to clear a late return from the record.

What Counts as a Booking in Each Report

The booking reports used to disagree about their own headline. Three of them could give three different answers to "how many bookings?" for the same workspace and the same window. They now share one set of rules, and the rules are worth knowing because they explain figures that will have moved.

Drafts and cancelled bookings are not usage. A draft is a plan and a cancellation never happened, so neither is counted in Top Booked Assets, Monthly Booking Trends or Asset Utilization. "Total Bookings" means the same thing in Top Booked and in Trends: real bookings, not plans.

Booking Compliance keeps its own, narrower definition on purpose, because it answers a different question: only bookings with a measurable outcome (returned or overdue) can tell you whether a deadline was honoured. Its hero says so on the page.

A booking that spans the window counts in it. Top Booked Assets, Asset Utilization and Top Booked Kits select bookings that overlap the timeframe rather than bookings that start inside it. A month-long booking viewed through a one-week lens is a booking that week, which is what anyone reading the report already assumed.

One booking counts once per asset. An asset can reach one booking twice, loose and again inside a kit. It is now counted once for that booking, so a pack-out that happens to include a kit no longer inflates the asset's rank.

Archiving no longer erases history. Archiving rewrites a booking's status, so reports that matched on Complete used to lose every completed booking the moment it aged into the archive. Both Monthly Booking Trends ("Completed") and Idle Assets ("last used") now count an archived booking as a real, returned use, as long as it was actually checked in. An archive that went straight from Reserved without ever being checked out still counts as nothing, because nothing went out. See what archiving means for reports.

Utilization cannot exceed 100%. Days in use is the merged union of a booking's days inside the window, not the sum of them, so two overlapping bookings of the same asset no longer count the same Tuesday twice.

Kit rankings are frozen at the time of booking. Top Booked Kits credits a kit from what the booking itself recorded when the gear went out, not from the kit's membership today. Two consequences: booking an asset on its own no longer credits a kit that happens to contain it, and editing a kit's contents no longer rewrites its booking history. Bookings made before Shelf started recording that provenance fall back to current membership.

"Unique Assets Booked" works. The Monthly Booking Trends CSV has carried this column since launch and it read 0 for everyone. It is now populated with the count of distinct assets booked in each month.

Your numbers will have moved. These are corrections, not new features, so a report you ran last week and run again today can legitimately give a different figure. Utilization and trend volumes generally go down (drafts and cancellations dropped out); Trends "Completed" and Idle Assets "last used" generally improve (archived bookings came back); kit rankings can reshuffle.

How Money Is Counted

Several reports put a value on things: Asset Distribution, Overdue Items, Asset Inventory and Custody Snapshot. Shelf stores one value per unit on an asset, and every money figure in a report is that per-unit value multiplied by the quantity the figure is actually about.

Which quantity that is depends on what the number is answering:

Where you see itWhat it multiplies by
Overdue Items, value at riskThe units booked on the overdue booking
Asset Distribution, category and status bucketsThe asset's workspace stock
Asset Distribution, location bucketsThe units placed at that location
Asset InventoryThe asset's workspace stock
Custody SnapshotThe units that custodian holds

For an individually tracked asset all of these are one, so its value appears once and the distinction never comes up. For quantity-tracked stock it is the difference between a report that adds up and one that does not: a $100 item with 5 units booked is $500 of value at risk, not $100.

A headline figure and the breakdown underneath it now agree. A pool split across two locations has its value split with it rather than counted at full value in both, so the category and status breakdowns each add back up to the headline.

Locations carry one deliberate exception. No Location is the bucket for assets with no placement recorded anywhere, and it holds their full value, but the unplaced remainder of a partly placed pool is not added to it — six units at a location and four not yet put anywhere contribute six. That keeps the bucket describing exactly the assets you reach by clicking it. On a workspace that keeps partly-placed stock, then, the location buckets can total less than the headline. Category and status always account for every unit.

How Audit Completion Counts

Audit Completion answers "are audits getting done, and what did they find?" for workspaces using the Audits add-on. Its hero is the completion rate, written out as "3 of 4 audits completed · Last 30 days", with Overdue and Assets Missing beside it. The Audit Sessions table underneath lists every audit in the window, newest first, 50 to a page, with its status, Expected, Found, Missing and Unexpected counts, an Accuracy bar, who created it, and its started, due and completed dates. Click a row to open the audit. Export CSV writes the same rows to a file.

The Audit Completion report, with the completion rate hero, the overdue and assets-missing figures, and one row per audit session

The numbers follow a few rules worth knowing:

  • An audit belongs to the period it was created in, whatever happened to it afterwards. A count started in September and finished in October is a September audit.
  • Completed means the audit has a completion date. Archiving a completed audit does not take it out of the count, so the rate does not drop as old audits move to the archive.
  • Cancelled audits are left out of the total and the rate, and an archived cancelled audit stays left out.
  • Overdue means past its due date and neither completed nor cancelled.
  • Assets Missing adds up the missing counts of completed audits only, because a running audit's missing counter is still moving as people scan. In the table, an audit still running shows Not scanned in its Missing cell and a cancelled one shows Cancelled.
  • Accuracy is found divided by expected, for completed audits with at least one expected asset. An audit with nothing expected has no accuracy figure.

A workspace without the Audits add-on has no audit sessions, so the report shows its empty state.

Export the Result

Every report supports CSV export. Click Export at the top right of any report to download the data shown.

An export carries the same filters the page is showing. Whatever the filter bar and the chips say, the CSV and the PDF run with exactly that, and the Booking Compliance CSV keeps the sort order you were reading. The page, the CSV and the PDF go through one filter resolver, so a filtered view on screen and the file it produces are always the same report.

Two of those files spell the value arithmetic out rather than leaving you to redo it in a spreadsheet:

  • Asset Inventory carries Quantity, Unit Value and Total Value.
  • Custody Snapshot carries Units Held, Unit Value and Total Value.

The PDF versions total the same way, so a printed report and the CSV behind it never disagree.

Money reads in your workspace's currency. Every monetary KPI now formats through the workspace currency set in Settings → General, on the page and in both exports. A handful of headline figures were still printing a hard-coded $ regardless of that setting; they are not any more, so a EUR workspace no longer sees dollar signs on top of euro amounts. Number grouping stays US-style on purpose so a report file parses the same way wherever it is opened.

Report CSVs are written as UTF-8 with a byte order mark, so category, location and custodian names in any alphabet open correctly in Excel without an import wizard. See How the file is encoded.

Reports with charts also support PDF download — Shelf renders the charts and tables into a print-ready document. PDF download is available for chart-based reports (Booking Compliance, Top Booked Assets, Monthly Booking Trends, Asset Activity Summary, Asset Utilization, Asset Distribution); reports without a chart — Asset Inventory, Idle Assets, Overdue Items, Custody Snapshot, Top Booked Kits, and Audit Completion — export to CSV. PDFs are useful for board packs, audit trails, and sharing with people outside the workspace.

Who Can Run Reports

Reports are part of the Plus and Team plans. The plan is the workspace's, so an Administrator invited into a Team workspace runs reports there whatever their own plan is. On a Free workspace, Reports stays in the sidebar and shows which plans include it; your asset list, filters and counts stay available on every plan.

Reports are for Administrators and Owners. A report reads across every booking, custodian and asset value in the workspace at once, which is a wider question than any single page answers, so the whole area is theirs.

Reports has never appeared in the sidebar for Self-service and Base users. It is now refused by direct link as well: the report pages, the CSV export and the PDF export all turn those two roles away, so a bookmarked or forwarded report URL no longer opens for them. Neither of the workspace visibility toggles changes this.

What each report shows is still scoped to the workspace it was run in.

Common Reports by Use Case

  • "What's overdue right now?" → Overdue Items
  • "Which assets are getting the most use?" → Top Booked Assets, Asset Utilization
  • "Which kits get booked most often?" → Top Booked Kits
  • "What can we redistribute or retire?" → Idle Assets, Asset Distribution
  • "How well are we returning bookings on time?" → Booking Compliance
  • "Who has what right now?" → Custody Snapshot
  • "What's the inventory state for an audit?" → Asset Inventory
  • "How are bookings trending month over month?" → Monthly Booking Trends
  • "Are audits getting done, and what did they find?" → Audit Completion

Ready to try Shelf?

Put what you're learning into practice. Free plan available — no credit card required.