In this guide 6 sections
A unit sheet works for a small site. Software pays off once you run several sites, gate access, automatic rent billing or lien notices, and one person can no longer hold it all in their head. Switch when the mistakes start costing you tenants or rent, after comparing both on availability, billing, gate codes and auction paperwork.
Where a unit sheet still works
A kept sheet suits a small yard. Each row holds one unit, with columns for size, rate, tenant, move-in date, padlock number and paid-to date, so the owner can answer most questions in seconds. The owner knows every tenant by name.
It costs nothing and needs no training, and anyone who can open the file can read the rate for unit 14 without asking you. That wins for a few dozen units.
Trouble starts when a second person edits the file, when you open a second site, or when a tenant disputes the rate agreed last spring. Then the cracks show.
Availability and bookings
A sheet says vacant or let. It cannot show that a customer reserved unit 14 for Friday, or that a vacant unit still waits for a sweep after its last move-out.
Software holds one status per unit: vacant, reserved, occupied, overlocked or under repair, tied to a size class and a rate card. Counter staff then quote one price.
Online enquiries expose the other gap, because a customer who finds a unit on your website expects it to be there when the van arrives. A web form can drop a row into a sheet, but nobody sees the double booking until two tenants turn up at the same roller shutter.
- Reserved and cleaning statuses beyond vacant or let
- Rate cards by size class and season
- Waiting list for popular sizes
- Move-in checklist with photos of the empty unit
Tenant billing and collections
Billing is where sheets leak rent. Someone must spot the due date, key the invoice, chase the late payer and add the late fee, month after month, between all the other counter jobs. One missed month starts an argument.
Software raises the invoice on the billing day, applies the deposit, sends the reminder and records a part payment against a ledger kept by tenant. A dispute ends with the payment history.
Prepaid months, first-month discounts and insurance add-ons each need their own rule, and a sheet needs a formula for every one of them. One careless sort breaks them.
- Recurring invoices on the billing day
- Late fee applied once, not twice
- Prepaid months and move-in discounts
- Tenant ledger with every payment
- Reminders by days overdue
Gate codes, locks and auction notices
Gate access is a security matter. When a tenant falls behind, the code should stop working until they pay, but on a sheet someone does that by hand and sometimes forgets. The tenants notice first.
Software can link tenant status to the gate keypad controller, or at least print the list of who should be locked out today. The change log matters after a break-in.
Lien and auction steps follow a strict order in most places: late notice, final notice, public advertisement and sale, with rules that differ by region. A lawyer should confirm the dates. Software keeps the dates and a copy of each notice, so the file is ready if the tenant objects or the auctioneer asks for proof of each step. Paperwork sinks auctions, not the day.
A fair test before you switch
Take one month of your sheet and count the mistakes: a wrong rate, a missed reminder, a unit let twice, a deposit never banked. A small count means stay put.
If the count is large, ask a vendor to load your units and tenants on a test copy and run one billing cycle. Compare their totals with yours, tenant by tenant, and chase every difference back to its cause, whether it was a rate, a date or a deposit.
Keep the sheet running alongside. Retire it only when both agree.
Sheet versus software comparison grid
Print one page with five rows: unit availability, tenant billing, gate access, auction notices and reports, plus a verdict cell at the end of each row. A column holds what your spreadsheet does today, another what the vendor demo showed, and a third the mistakes counted in the last billing month. The fourth holds your decision.
Open a blank worksheet to printQuestions owners ask
When is a sheet no longer enough for a storage business?
When more than one person edits it, when you add a second site, or when late payments and gate codes need chasing every day. One costly mistake is the signal.
Can software control the gate automatically?
Some systems connect to an access controller and others only produce a list, so ask which controller models are supported before you buy.
Do we still need a lawyer for auctions?
Yes, always, for every auction. Notice periods and sale rules depend on your location, and software stores the dates and copies but cannot replace legal advice on the wording.
How long does it take to move off a sheet?
Loading units and tenants is quick if the sheet is clean, but merging duplicate tenants and settling unclear rates takes far longer, so begin with those two jobs. Start with the mess.