Spreadsheets for self-storage reporting, and where they stop.

A spreadsheet answers any question you can write as a formula. Everyone on the team can open one, nobody needs a login, and a new column takes a minute. For a one-off analysis, or a store you have just taken on, it is often the right tool.

The spreadsheet is not the problem. Making it the system is.

• Retyping. Each month's figures are copied by hand from each store's report, and a typo looks exactly like a real number.
• Version drift. Copies are emailed, edited and renamed until nobody is sure which one the owner received.
• No checks. Nothing confirms that the receipt lines add to the printed total, or that move-ins and move-outs reconcile to the tenant count.
• One store at a time. Each book is its own island, so comparing stores means building another spreadsheet.

The management summary is read, not retyped. Every figure lands on one set of fields and passes the report's own arithmetic, and a figure that fails is held instead of mailed. Every store sits in one place, so ranking them is a view, not a project.

Each owner report sent is kept on a delivery ledger, the exact letter and the workbook, so the question of which version went out has one answer.

The owner report is still an Excel workbook, and every calculated cell carries its answer, so it reads correctly even in a mail preview. Prior years come in from the workbooks you already keep, including a manager's own layout, matched by row label rather than position.