How to move a self-storage facility off spreadsheets

Before you move anything, list the jobs the sheet does. For most facilities it is four: the rent roll (who is in which unit at what rate), the payment record (what came in, when and how), the collections list (who is behind), and a catch-all for gate codes, phones, plates and notes. A fifth job usually hides in your head: the rule for when a late fee gets added and when a lock goes on.

Write that rule down in plain words before you set up anything. "Rent is due on the 1st. Five days grace. $20 late fee on the 6th. Overlock at 30 days." Those numbers are examples; yours will differ. If you cannot write it in two lines, software cannot apply it either.

Most software asks for grace days, the late fee and the default deposit when you create the facility, then applies them from that point on. Set them from the rule you wrote down, not from whatever the software suggests. If you have never charged a late fee, set one and leave it switched off for now.

Late fees, lien timelines and auctions are governed by your state's self-storage statute, and the limits and notice requirements vary from state to state. Check the statute, or ask your state self-storage association, before you set a late fee or rely on any lien date. Software can track the dates; it cannot make the fee legal.

In Storage Facility Creator the facility creation wizard asks for grace days, a flat or percentage late fee and a default deposit, all editable later in facility settings. Automatic late fees are a per-facility switch, off by default: while it is off the app only marks who is late, and when it is on the fee posts after the grace period, never more than once a month. Rent posts to every tenant's ledger automatically on the 1st. SFC shows who is past due and by how many days, but it does not prepare or send lien notices or run auctions, so that part stays on your checklist.

This is the step people skip, and it decides whether tenants trust the first statement. The quick way is paid-through: mark every current tenant paid through last month, or this month if they have already paid, and a prepaid tenant through the month they have covered. The software starts charging from the next month and everyone's balance begins at zero. Where most people pay on time, this handles most of the roster in minutes.

The careful way is to enter history. For tenants who are behind, on a payment plan, or who always ask what they paid in March, type in their past charges and payments with the real dates so the ledger shows what the sheet showed. Go back to the last month you are both sure about, not five years.

SFC does both. Owners and managers can mark one tenant or a whole selection paid through a month from the tenant list, and late status, late fees and reminders start from that date. Enter past history lets you type a tenant's past rent and payments with their original dates; the ledger and paid-through date update together, with an undo if you slip. Then print statements for every tenant in one PDF and read them against the sheet before you go live.

The last reason a spreadsheet survives is that it is the only place your part-timer can look. Give each person their own login with the right role: the counter can take payments and move people in, the bookkeeper can read without changing anything. Turn on two-factor for the owner account, because it can now refund money. Move the odd columns last: gate codes, plates, emergency contacts and notes go on the tenant record. Once a month has closed cleanly in the new system, rename the spreadsheet OLD and stop opening it.

SFC includes unlimited users at $75 per facility per month, with owner, manager, employee and viewer roles assigned by email invite, and two-factor authentication by emailed code as a per-user switch. Each tenant's record holds contacts, ID, vehicles, gate code, autopay, contracts and contact history, and changes to tenants, units, payments and ledgers are recorded in a per-facility audit log that cannot be edited. Gate codes are per tenant and switch off at move-out; SFC does not connect to gate hardware, so you still key codes into your gate controller. It runs in any current browser with nothing to install.