How to Track Food Hall Vendor Rent in a Spreadsheet

Food halls blend base rent and percent-of-sales deals — operators who track only base rent underbill busy stalls and overcharge slow ones. A free food hall vendor rent roll spreadsheet tracks stalls, vendors, base rent, percent rent, paid, and outstanding balances.

One row per vendor per billing period

1. Stall / vendor
2. Base rent — monthly minimum
3. Percent rent — from reported sales (see sales tracker)
4. Total due — greater of base or percent deal terms
5. Paid and balance

Document deal structure in notes — triple-net vs. gross, marketing fees, CAM charges if applicable.

Percent rent needs sales input

Pull stall sales from the food hall sales tracker before invoicing — guessing percent rent from memory is how operators lose vendor trust and audit disputes.

Align with lease terms

Base rent and percent thresholds should match the lease tracker — renewal rent bumps without lease updates cause invoice arguments.

When food hall / property software wins

POS consolidation, automated percent-rent calculation, and tenant portals justify platforms at multi-hall scale. Single-hall operators often invoice from a sheet until vendor count or percent-deal complexity exceeds comfort.

These templates are rent billing logs, not legal lease documents or accounting systems.