Reading the Asset P&L Report
Every piece of equipment you own earns rental income and racks up costs — service, repairs, parts. The Asset P&L report puts both sides on one line so you can see, at a glance, which stock units are profitable and which are dragging you down. Use it to decide what to buy more of, what to retire, and where your service spend is eating your margins.
Where it lives: Open Reports from the main menu, then click the Asset P&L card (the dollar-sign tile). The report opens at
/reports/asset-pnl.
Before You Start
The Reports & Analytics area — including Asset P&L — is a Growth+ feature. You’ll only see it if:
- Your plan includes the Reports & Analytics subscription module, and
- Your role has the reports.read permission.
If the Reports menu item or the Asset P&L card isn’t showing, ask your administrator to check your plan and role.
What the Report Measures
Asset P&L is calculated per stock unit — each individual item you rent out, not just the product type. That means two identical drills can show very different profit if one has needed more repairs than the other.
For every stock unit, Rentablez compares:
- Revenue it has earned from rentals, against
- Total Cost spent keeping it in service (maintenance, parts, and other service costs).
The difference is the unit’s Net Profit, and the ratios give you Margin % and ROI %.
Reading the Summary Cards
Across the top of the report, five cards summarise every stock unit that matches your current filters:
| Card | What it tells you |
|---|---|
| Total Revenue | Combined rental income across all matching units. |
| Total Cost | Combined service and parts spend across those units. |
| Net Profit | Total Revenue minus Total Cost. |
| Avg Margin | The average profit margin across the units, as a percentage. |
| Profitable | How many units are in the black — shown as a profitable / total count. |
These figures update automatically whenever you change the date range or filters.
Reading the Table
Below the summary, each row is one stock unit. The columns are:
| Column | Meaning |
|---|---|
| Equipment | The item’s name, its asset tag or serial number, and location. Kit components are marked with a Kit badge. |
| Revenue | Rental income the unit earned in the selected period. |
| Total Cost | Money spent on the unit. When there’s service or parts spend, a small subline breaks it out (for example, Maint and Parts). |
| Net Profit | Revenue minus Total Cost. Shown in green when positive, red when negative. |
| Margin % | Net Profit as a share of revenue. Colour shifts from green (healthy) toward amber and red as it drops. |
| ROI % | Return relative to what the unit cost you to acquire. Shows N/A when no acquisition cost is on record. |
| Orders | How many rental orders included this unit. |
| Rental Days | Total days the unit was out on rent. |
| Rev/Day | Average revenue earned per rental day. |
Why does ROI show N/A? ROI needs a purchase or acquisition cost recorded for the stock unit. If that value is missing, Rentablez can’t calculate a return, so it shows N/A rather than a misleading number. Add the cost on the asset’s stock record to see ROI.
Sorting and Paging
Click a column header — Revenue, Total Cost, Net Profit, Margin %, or ROI % — to sort by it. The report opens sorted by Revenue by default, so your biggest earners are on top. Use the paging controls at the bottom to move through the full list.
Focusing the Report with Filters
Click Show Filters to narrow the results. Asset P&L supports:
- Search — find a specific item by name or ID.
- Date Range — choose a preset (Last 7 Days, Last 30 Days, Last 3 / 6 / 12 Months, Current Year, Previous Year) or pick Custom Range. The report defaults to Last 30 Days.
- Categories — limit the report to one or more asset categories.
Date limits: Custom ranges can’t reach into the future and are capped at the last five years for performance. If you pick a start date later than the end date, Rentablez nudges the other date to keep the range valid.
Use Clear Filters to return to the defaults.
For the full filtering and export walkthrough that applies to every report, see Filtering, Drilling Into, and Exporting Reports.
Exporting
Click Export to download the current results as an Excel (.xlsx) file, using whatever filters and date range you have applied. This is handy for sharing a profitability snapshot with your accountant or building your own pivot analysis.
How to Use It
A few ways teams read this report:
- Find your losers. Sort by Net Profit ascending to surface units in the red — often the ones with heavy repair histories. These are candidates to retire or re-price.
- Spot your best buys. Sort by ROI % to see which purchases have paid back the most, so you know what to restock.
- Watch service creep. A healthy Revenue with a thin Margin usually means the Total Cost subline (Maint / Parts) is climbing — a sign a unit needs attention or replacement.
Tip: Pair this report with the Service & Repair Report to see the full maintenance history behind a unit’s Total Cost.