How to Keep Track of Rental Equipment (Rental Inventory Template for Google Sheets)
If you run a small rental business (chairs, tables, tents, decor, linens), you have probably seen ads for rental software with online booking, contracts and payments. For a one- or two-person shop that can feel like too much: another monthly bill, another login, and features you will never use.
You don't need expensive software to keep track of your rental equipment. You need a few clear habits, a rental inventory list, and one place to write bookings down. This guide shows you how, starting with pen and paper.
What keeping track of rental equipment really means
For a rental business, tracking inventory comes down to three questions:
- What do I own? The full list of items and how many of each.
- Where is it right now? In the shed, out at an event, or waiting for repair.
- What is free on a given date? This is the question that matters most when a customer asks.
If you can answer those three quickly, you are tracking your inventory. The tool is up to you.
Step 1: Make one party rental inventory list
List every item you rent and how many you own. Be specific: "chairs" is not enough if you have white folding and gold chiavari chairs. A simple rental inventory template looks like this:
| Item | Category | Owned | Notes |
|---|---|---|---|
| Chair, white folding | Seating | 120 | |
| Chair, gold chiavari | Seating | 60 | 2 with loose legs |
| Table, 6 ft rectangle | Tables | 12 | |
| Backdrop arch | Decor | 2 |
Keep it in one place and update it when you buy or retire items. Skipping this step causes most "I thought we had more" problems.
Step 2: Write every booking the same way
Each booking needs the same four things:
- the item,
- the quantity,
- the start date,
- the end date (including delivery and pickup days if the items are out).
Keep all bookings in one place, and update them as soon as a customer changes their order. Bookings spread across chats, a wall calendar and memory are where mistakes start.
Step 3: Check dates before you say yes
When a new request comes in, find every booking that overlaps the requested dates. Add up how many of that item are already out, then subtract from what you own. If the answer is smaller than what the customer wants, you have a shortage. It is better to find out now than on event day. Our guide on how to avoid double-booking party rental equipment walks through this check in detail.
Step 4: Record returns and damage honestly
When items come back, count them. If 50 chairs went out and 47 came back, write 47, not "all back". Keep the 3 missing chairs counted as out until you find them. If some items are damaged, put them on hold and do not rent them until they are fixed.
The notebook version
All of this works on paper: one page per item, owned quantity at the top, bookings below with dates, and a note for anything damaged or missing. It costs nothing. The weak spot is the math: every request means scanning pages by hand, and one missed line can cause a double-booking.
The free spreadsheet version
A Google Sheet keeps the same habits but does the math for you. It is free with a Google account, works on a computer, and your data stays in your own Google Drive. Think of it as your notebook, but one that warns you when something doesn't add up.
To build your own, make three tabs:
- Items: item, category, owned.
- Bookings: customer, item, quantity, start date, end date.
- Check: type an item and a date range, and add up overlapping bookings with a formula such as SUMIFS(Bookings!C:C, Bookings!B:B, item, Bookings!D:D, "<="&end, Bookings!E:E, ">="&start). Owned minus that total is what is free.
That overlap rule (a booking starts on or before your end date and ends on or after your start date) is the key idea. Get it right and the sheet catches clashes you would miss on paper.
If you sell or use up stock rather than rent it, see our stock in/out Google Sheets template guide instead.
When should you upgrade to real software?
Consider dedicated rental software when you need online booking and payments, contracts or e-signatures, deposit tracking, or you have outgrown a few hundred items. Until then, simple habits plus a sheet go a long way. Our honest comparison of free party rental software and a spreadsheet can help you decide.
Quick recap
- Keep one rental inventory list of what you own.
- Record every booking with item, quantity and dates.
- Check overlapping dates before saying yes.
- Count returns and put damaged items on hold.
- Paper works. A free Google Sheet does the math and warns you.
Start with the habit today, even if it's just a clean page in your notebook.