How I Ran My Storage Lot Off a Spreadsheet (and Why I Stopped)
I store RVs, boats, and campers on my own place south of Grand Forks. For years the whole operation lived in a spreadsheet and a notebook. This is where that broke, and what I did about it.
The Spreadsheet Era
My system was the same one most small storage operations run: a spreadsheet with a row per client, a notebook in the shop, and my memory filling the gaps between them.
It mostly worked. That's the trap. A spreadsheet mostly works right up until the day it costs you real money, and you usually don't find out which day that was until months later.
Where It Broke
1. I couldn't answer "who owes me money?" without a project
That question is the whole business. Storage is a simple trade: people park things on your property and pay you for the months they're there. But answering it meant cross-checking the spreadsheet against the checkbook against the notebook. So I did it once a month at best. Every month I was slow, somebody sat unpaid for free.
2. Payments and spots drifted apart
A check would come in and I'd note it in one place but not the other. A camper would move from the gravel row into the building for winter and the spreadsheet row wouldn't move with it. Twice I had two clients assigned to the same bay on paper. The lot knew the truth. My records didn't.
3. Date math is sneakier than it looks
Someone pays for three months on January 31st. When are they paid until? If you said April 30th, congratulations, but my spreadsheet said May 1st one year and April 28th another, depending on who typed it. Small errors, but they compound, and every one is an awkward phone call.
4. Winter burial
Up here, big rigs get buried in the back of the building for the season. If the client in the back corner quits paying in December, you can't exactly ask them to leave until spring. I needed to see, in one glance, who was buried where and whether the back rows were paid through April. The spreadsheet had no idea what "the back" meant.
What I Actually Needed
When I finally sat down to fix it, I wrote a short list. Any storage owner's list probably looks close to this:
- A picture of the property where every spot shows who's in it and whether they're paid
- A call list of exactly who's overdue or coming due, with phone numbers
- Date math that handles month-ends correctly, every time
- A record that survives a client moving spots
- An export for the accountant at tax time
Notice what's not on the list: nightly reservations, gate integrations, dynamic pricing, a mobile app. Small seasonal and monthly storage doesn't need any of that. It needs to know who's paid.
So I Built the Map
I build websites and software for a living, so I built my own fix: my whole property drawn to scale on one screen. Every rig, unit, and campsite is a rectangle, and the rectangles color themselves from each client's paid-until date. Green is paid. Amber means due within three weeks. Red is overdue. Blue means I never set a date.
The morning routine went from an hour of cross-checking to a ten-second glance. If the map is green, everybody's paid. If something's red, I click it, the client's record opens, and their phone number is right there.
Every problem from the spreadsheet era got a specific fix. Moves keep history: drag the rig to the new spot and the old spot closes with a date instead of being erased. The "+1 month" button lands on the right day even from January 31st. The overdue call list writes itself. And when a payment comes in online, it gets verified with Stripe on the server and matched to exactly one client, or it waits in a review queue for me to look at. The software never guesses about money.
It Runs My Lot Today
That map has run my own storage business for a while now, real clients and real paid-until dates. Eventually I cleaned it up, loaded a fictional business into it, and put it on this site as storage management software I sell and set up for other owners: RV and boat lots, small self-storage buildings, and seasonal campgrounds.
It's self-hosted with no monthly fee, because the last thing a lot with 40 clients needs is per-unit SaaS pricing. If you want to see whether it beats your spreadsheet, the live demo is public: fake clients, published password, nothing to break.
If You're Staying on the Spreadsheet
No hard feelings, mine lasted years. Three habits that would have saved me real money:
- Track paid-until dates, not payments. The question is never "did they pay in March," it's "when does their time run out."
- Reconcile spots monthly, not yearly. Walk the lot with the list. The lot is the truth.
- Write down month-end rules once and follow them exactly, or the same client will get a different answer twice.
Run a Lot? Kick the Tires on Mine
The demo is a fictional business with a public password. Click an amber rig, add a month, watch it turn green. Then tell me about your property and I'll quote a setup.