Docs · File formats
Lease Charge Review CSV format
Header names are matched automatically, in any order and any case. Extra columns are ignored.
| Column | Required | Also accepted as | Example |
|---|---|---|---|
| Location | Yes | location, store, site, premises, unit | Store 112 |
| Landlord | landlord, owner, property manager | Northgate Properties | |
| Period start | period start, period_start, year start | 2025-01-01 | |
| Period end | Yes | period end, period_end, year end, reconciliation period | 2025-12-31 |
| Expense category | Yes | category, expense, line item, cost head | Security |
| Building total | Yes | building total, total cost, pool amount, total | 70000.00 |
| Tenant share billed | Yes | tenant share, billed, amount billed, your share, billed share | 3500.00 |
| Pro rata billed % | billed pro rata, pro rata billed, share %, billed pct | 5.0% | |
| Tenant area | tenant sqft, tenant area, nla, gla tenant | 4000 | |
| Building area | building sqft, building area, total area | 100000 | |
| Lease pro rata % | lease pro rata, lease share %, lease pct | 4.0% | |
| Admin fee % | admin fee %, administrative fee %, admin fee pct | 10% | |
| Management fee % | management fee %, mgmt fee %, mgmt fee pct | 4% | |
| Controllable cap % | cap %, controllable cap %, cap pct | 5% | |
| Prior-year controllable | prior year controllable, last year controllable, prior controllable | 150000.00 | |
| Excluded by lease (Y/N) | excluded, lease excluded | N | |
| Capital item (Y/N) | capital, capital item | N | |
| Controllable (Y/N) | controllable, controllable y/n | Y | |
| Statement date | statement date, reconciliation date | 2026-05-20 | |
| Objection window (days) | objection days, audit window days | 90 |