Inventory basics

How to Track Rental Equipment and Inventory

Start with two records: what you own and what happens to it. Keep those records connected, and your inventory becomes much easier to check.

By Anaïs

1. Build an inventory list you can reconcile

Count your physical equipment before importing an old list. Start with one storage area or category, and record items that are missing, broken, or awaiting inspection separately from usable stock.

A useful inventory record answers: what is it, how much do we own, where is it stored, and can it be used? You can start in a spreadsheet or a Notion database. The naming and counting rules matter more than the tool.

General inventory example — these are not the Free template’s fields
Equipment IDItemTrackingOwnedCondition / location
CAM-001Mirrorless camera bodyIndividual unit1Ready / case A
CAM-002Same camera modelIndividual unit1Needs inspection / bench
CHAIR-WHTWhite folding chairQuantity pool4038 usable, 2 in repair / rack C

Add serial numbers for high-value gear, a category for filtering, and a storage location that someone else can follow. Keep purchase cost and replacement value separate from rental rates if you record both.

2. Decide what one record represents

Track individual units when their identity matters

Two cameras of the same model may have different serial numbers, service histories, or accessories. Give each camera a stable internal ID and label the physical unit. Keep that ID when you rename the equipment.

A simple convention such as CAM-001 or LIGHT-014 is enough. Do not use a row number that changes when you sort the sheet. A serial number is useful evidence, but a short internal label is easier to read during pickup and return.

Use quantities for interchangeable stock

Matching chairs or cables can use a shared record if staff can substitute one for another without changing the booking. Record the usable pool and the quantity committed to each rental.

If chairs have different colors, sizes, or conditions that affect a customer's order, separate the pools. “40 chairs” is not a reliable promise if the customer needs 40 matching white chairs and you own only 25.

3. Keep a rental log alongside the inventory

The inventory describes the equipment. The rental log records transactions: which customer gets which equipment, when it leaves, when it is due back, and what actually returns.

Use one booking record for the job and one line for each equipment assignment. That lets a booking include a camera, two lights, and a tripod without mixing their quantities or returns.

Example rental log fields
FieldExamplePurpose
Rental / customerR-104 / Example StudioConnect all lines to the same job.
Equipment ID / quantityCAM-001 / 1Identify the committed unit or stock pool.
Pickup / due backMay 8, 9 a.m. / May 10, 5 p.m.Define the time it is unavailable.
Booking stateConfirmedSeparate holds, confirmed rentals, and cancellations.
Actual returnMay 10, 4:30 p.m.Record what happened, not just what was planned.
Condition / shortageLens cap missingGive the return check a record.

Keep agreed rates and quantities with the transaction. Do not overwrite old rental rates when you change the price on your equipment list. If you record payments, link each deposit or balance payment to the rental it belongs to.

4. Separate status from date-based availability

An item can be physically on the shelf and already reserved for tomorrow. It can also be back from a rental and still unavailable because it needs inspection. A single “available” checkbox cannot represent all of those facts.

  • Equipment condition: ready, awaiting inspection, in repair, retired.
  • Rental state: draft or hold, confirmed, checked out, returned, canceled.
  • Availability for a date range: usable stock minus concurrent commitments during that range.

Choose which booking states reserve stock and make the rule visible to your team. If holds reserve stock, give them an expiry and review them. If they do not, explain that availability can change before confirmation.

For the chair pool above, start with 38 usable chairs, not all 40 owned. If 20 are committed while a new rental is out, there are 18 left for that overlapping period. Add cleaning, transport, or inspection time before checking the next booking. See the date-overlap and stock-checking guide for cases with several rentals.

5. Close the loop on returns and damaged equipment

  1. Count and identify the returned equipment. Check IDs for individual units and quantities for shared stock.
  2. Compare it with the rental lines. Record a partial return rather than marking the whole order returned.
  3. Inspect the equipment and accessories. Note missing cables, cases, damage, or cleaning needed.
  4. Update actual return details and condition. Keep affected equipment out of usable stock until someone clears it.
  5. Review the next commitment. A late or damaged return can affect the following customer even if the original booking dates did not overlap.

For example, if 40 chairs leave and 38 return, keep the two missing chairs unresolved in the rental record. If three of the returned chairs need repair, the usable pool is 35 until the missing or repaired stock is cleared. Do not reset it to 40 because the due date has passed.

For individually tracked gear, add dated condition notes and photos where useful. Keep the old notes so you can tell whether damage was recorded before or after a particular rental.

6. Avoid the tracking mistakes that create extra work

  • Different names for the same item. Use stable IDs and one equipment record to prevent “LED panel” and “panel light” from becoming separate stock.
  • Changing totals to reflect a checkout. Keep owned quantity separate from current rental commitments so the inventory count does not disappear into booking edits.
  • Deleting canceled or returned rentals. Close their status and retain the history. Decide which statuses affect availability.
  • Relying on memory for accessories. List the kit contents in the equipment record and check them at return.
  • Keeping several live copies. Choose one working inventory and booking log, with a clear owner for updates.

Use a regular reconciliation: compare physical equipment with records, clear stale holds, check overdue returns, and investigate negative or unexplained quantities.

7. Choose a system you can maintain

A spreadsheet can work well when a small team follows one process and bookings are easy to review. Validation, formulas, filters, protected cells, and shared editing can make it a capable rental tracker.

Consider a connected database when customer details, equipment assignments, payment records, and booking history are being copied across several tabs. In Notion, relations can connect records, while views show the same underlying data in different ways. You still need to design and test date and quantity calculations; a calendar view alone does not calculate stock.

The spreadsheet vs. Notion comparison covers the tradeoffs, including when dedicated rental software makes more sense.

Notion reference: database relations and rollups. The examples in this guide illustrate a general rental workflow; suggested fields are not a specification of either template.