Self Storage Occupancy Tracker (Excel Template)

Know your occupancy, revenue, and vacancy loss — the moment you open the file.

This Excel template tracks every unit in your self storage facility and turns it into a live dashboard: occupancy rate, monthly revenue, revenue lost to vacancy, and a full breakdown by unit type. Change a unit's status from Vacant to Occupied and every number on the dashboard updates instantly — no formulas to fix, no manual math.

What's inside:

• Unit Inventory — every unit, size, type, monthly rate, tenant, and status in one sheet
• Move-In / Move-Out Log — a clean audit trail of every move as it happens
• Occupancy Dashboard — occupancy rate, potential vs. actual revenue, and revenue lost to vacancy, calculated automatically
• Breakdown by unit type — occupancy and revenue split across Small, Medium, Large, Climate-Controlled, and Vehicle/RV units

Who it's for:

Self storage facility owners, operators, and property managers who want a clear, always-current picture of occupancy and revenue without building a tracker from scratch or paying for management software.

Format:

One Excel workbook (.xlsx), pre-built with formulas, dropdowns for status and unit type, and a starter set of example units. Just replace the examples with your own units and start logging moves. A short README is included with setup instructions.

Compatible with Excel and Google Sheets.