How to Track Food Hall Stall Sales and Percent Rent in a Spreadsheet

Percent-rent food hall deals fail when sales live in fifteen vendor spreadsheets — operators either skip percent billing or fight over numbers every month. A free food hall sales tracker spreadsheet records daily sales by stall, percent rent owed, and hall-wide totals with underperformer flags.

Daily or weekly sales entry

1. Date
2. Stall / vendor
3. Gross sales — from vendor report or POS export
4. Percent rent rate — from lease terms
5. Percent rent owed — template calculates from deal rules
6. Hall total — roll-up for operator KPIs

Collect vendor sales on a fixed schedule — same day each week — so percent rent invoicing stays predictable.

Underperformer flags drive leasing decisions

Stalls with chronically low sales despite marketing support inform renewal conversations on the lease tracker — sometimes the concept fails, sometimes the stall location fails.

Hand off to rent roll billing

Monthly percent rent owed sums feed the vendor rent roll — base vs. percent greater-of logic should match each vendor’s contract column.

When integrated POS wins

Centralized POS, automated sales import, and real-time dashboards justify investment at high-volume halls. Operators with vendor-reported sales often reconcile in a sheet until dispute volume or investor audits force integration.

These templates are sales consolidation tools, not tax or GAAP revenue systems. Verify sales reporting obligations in each vendor lease.