How to Track Food Hall Vendor Lease Terms in a Spreadsheet

Food hall vendors churn quietly when lease ends are tracked on calendar reminders — stalls sit empty while operators thought “they’re renewing.” A free food hall lease tracker spreadsheet lists vendors, stall, lease start/end, renewal status, deposit, and expiring-soon flags.

Lease columns operators actually need

1. Vendor and stall id
2. Lease start and end
3. Base rent and percent rent terms — summary, not full contract
4. Deposit held
5. Renewal status — negotiating, signed, vacating
6. Escalation notes — annual bumps, option periods

Filter expiring within 90 days monthly — pipeline replacement vendors before the stall goes dark.

Mirror rent roll after renewals

Accepted renewal rent must update the vendor rent roll the same week — invoicing old rent on a new lease erodes vendor relationships.

Vacating vendors affect sales tracking

When status = vacating, stop expecting sales on the sales tracker after move-out date — clean handoffs keep percent-rent math honest.

When commercial lease software wins

E-sign, abstracting, and CAM reconciliation justify tools at portfolio scale. Independent food halls often manage leases in a sheet until vendor turnover or investor reporting demands more.

These templates are lease administration tools, not substitute for attorney-drafted commercial leases.