← All articles

·6 min read

Rental Equipment Tracking System for Small Rental Businesses: Know What's Out, What's Late and What Came Back Damaged

Still tracking rentals in a notebook? Here's how to know what's out, what's late and what came back damaged, and how to check availability before you promise items to the next customer.

  • equipment rental
  • rental management
  • asset tracking
  • security deposit
  • late fees
  • damage inspection
  • availability
  • sme
Rental Equipment Tracking System for Small Rental Businesses: Know What's Out, What's Late and What Came Back Damaged

If you run a rental business, you probably know this moment. A customer calls asking for 40 scaffolding sets next Monday and you say yes. Then on Sunday you discover that 15 of them are still at a project in Bekasi that was supposed to finish last week. Most small rental businesses in Indonesia still run on a notebook, a WhatsApp group and maybe a spreadsheet. That works when you own 30 items. It breaks when you own 300. A simple rental equipment tracking system answers the three questions that cost you money: what is out right now, what is late, and what came back damaged.

The steps below work for any kind of rental: scaffolding, event tents and chairs, camera gear or construction tools. You can start with a better spreadsheet this week and move to software later.

Step 1: Give every item an identity

You can't track what you can't tell apart. Your first job is to decide what counts as one trackable item.

Serialised items

Expensive items that differ from each other get their own code. This covers cameras, lenses, generators, concrete mixers, jack hammers and sound mixers. Use a code like CAM-012 or GEN-003 on a sturdy sticker or engraved label. Record the brand, serial number, purchase date and replacement value. When a lens comes back scratched, you want to know exactly which lens it was and who rented it before.

Bulk items

Cheap, identical items are tracked by quantity, not one by one. Think scaffolding frames, cross braces, plastic chairs and table skirts. You record “120 chairs out, 118 back.” Labelling every chair is rarely worth the effort. For scaffolding, a practical middle ground is to group parts into standard sets, for example 2 frames, 2 braces and 4 jack bases, so counting on return is faster.

One record per rental

Every rental becomes one record. It holds:

  • customer name and phone
  • site or delivery address
  • items with codes or quantities
  • date out and agreed return date
  • price and deposit
  • which staff member handed the items over

On return, the same record gets the actual return date, what came back, the condition, and who checked it. Everything else in this article builds on that one record.

Step 2: Make deposits and late fees predictable

Most arguments with customers are about money at the end of a rental. The fix is to agree the rules at the start and write them on the rental record, not keep them in your head.

  • Deposit: set one rule per category. For example, 30–50% of replacement value for camera gear, or a fixed amount per scaffolding set. Record how it was paid (cash, transfer, QRIS) and keep it visible until it's refunded or deducted.
  • ID as collateral: many rentals hold a KTP or SIM. If you photograph ID cards, store the photos where only the owner can access them, and delete them when the rental closes. Under Indonesia's personal data protection law (UU PDP), a pile of KTP photos sitting in a staff member's WhatsApp is a real risk to your business.
  • Late fees: pick one clear formula, such as the normal daily rate for each extra day, with a grace period of a few hours. Put it on the rental note the customer signs or receives on WhatsApp.

Once each record has an agreed return date, the system can do the boring work. Every morning it gives you a list of what's due back today and what's already overdue, with the late fee calculated. Your admin can then send a polite reminder the day before the due date, instead of chasing customers three days after.

Step 3: Inspect every return, with photos

If you have no evidence, there's no answer to “it was already like that when we got it.” The fix is photos at both ends of the rental.

  1. At check-out: take 2–4 photos of each serialised item and one photo of each group of bulk items. Attach them to the rental record. It takes about a minute per item.
  2. At return: use a short checklist for each category. For a camera, check the body, sensor, lens glass, battery count, charger and memory cards. For a generator, do a running test and check fuel level and cables. For a tent, count the poles and pegs and look for tears.
  3. Use standard condition levels: for example OK, needs cleaning, minor damage, needs repair and lost. Put the return photos next to the check-out photos.
  4. Settle the deposit: deduct either a pre-agreed amount for each damage level or the actual repair cost. Show the customer the before and after photos side by side.

Any item marked needs repair should automatically become unavailable until someone marks it fixed. This alone stops you from sending a broken mixer to the next customer.

Step 4: Check availability before you promise

Availability isn't what's in the warehouse today. It's what will be in the warehouse on the date the next customer needs it. A useful availability view shows these numbers for any date range:

  • total units owned
  • units already booked
  • units currently out and when they're expected back
  • units under repair
  • units actually free

Build in a buffer. Scaffolding returned from a site on Friday may need a day of counting and cleaning before it can go out again. Equipment from a Saturday wedding is often not ready until Monday. Set a turnaround time for each category, so the system doesn't show items as free the moment they're due back. Some customers will return late anyway.

When your sales staff can check availability on their phone before replying to a customer, double bookings stop. So do the last-minute calls to borrow stock from a competitor.

Choosing a rental equipment tracking system: spreadsheet, app or custom

There are three realistic routes, and each has trade-offs.

An improved spreadsheet

Use Google Sheets with an items tab, a rentals tab and a filter for due dates. It's essentially free. It works for up to roughly 100 rentals a month with one or two admins. The weak points: photos live in a separate folder, data is easy to overwrite by accident, and availability by date is hard to calculate.

Ready-made rental software

Subscription apps built for rental businesses often cost around Rp 300 thousand to Rp 1.5 million per month, depending on users and features. You can start quickly. Before you commit, check that the app supports rupiah, Indonesian-style invoices, bulk items like scaffolding sets and WhatsApp reminders. Many of these apps are designed for overseas markets.

A custom system

Custom is worth it when your process is unusual. Examples include scaffolding rented per project with partial returns, or rentals that also involve delivery and installation. A focused custom system for one location typically costs Rp 25–80 million to build, plus hosting and maintenance. It only pays back if lost items, unpaid late fees and double bookings already cost you that much each year. Calculate that number first.

Whichever route you choose, start with the process, not the tool. This week, pick your 20 most valuable items, give them codes, and start taking photos at check-out and return. Do that for a month and you'll see exactly where money is leaking. If you want help deciding between a spreadsheet, an off-the-shelf app or a custom system, talk to the CodeWorks team. We'll look at how you work today and tell you honestly what you actually need.