Blog · Board and management reporting
Shopping mall analytics compares occupied space, rent collections and tenant-reported sales. This worked operating review connects unit records to area occupancy, a rent receivables rollforward and comparable sales growth.
Shopping mall analytics compares occupied space, rent collections and tenant-reported sales from property operating reports. It helps a property manager distinguish vacant space, unpaid balances and weaker tenant trading. Those conditions need different follow-up, even when they appear in the same monthly review.
Occupancy describes space in use at a reporting date. Collections describe cash applied to tenant balances during a period. Tenant sales describe retailers' trading activity, which belongs beside property measures without becoming the property's own revenue.
The operating team should own unit status and occupied area; lease administration should maintain unit identifiers and billings; finance should own cash application and receivables; and the tenant liaison should follow up missing sales reports. Assign one report owner to reconcile the combined review and explain changes in definitions.
Record those definitions before comparing months. Versioned metric definitions help preserve the meaning of occupied, leased, due and reported when staff or reporting practices change. A signed lease for a unit awaiting handover should not silently become physical occupancy.
Start with the unit register, monthly rent ledger, applied-cash report and tenant sales submissions. Keep a stable unit identifier, tenant identifier, reporting period and currency. Separate rent from service charges, deposits, taxes and other balances unless your review explicitly includes them.
For sales, state whether figures are net of returns and exclude sales tax, and apply the same definition across periods. The Census Bureau's retail definitions describe sales net of refunds and allowances and exclude sales taxes collected directly from customers for payment to tax authorities. Lease reporting definitions can differ, so preserve the tenant submission basis rather than assuming every file follows Census definitions.
Retain due dates in the rent ledger. A closing receivable is overdue only when its due date has passed. Use an accounts receivable aging review to separate overdue debt from balances that are still within terms.
Consider an illustrative US mall at September 30, 2026. Areas are leasable square feet, with the same boundary for occupied and total area. The example's rent balances are all due by the cutoff; there are no credits, write-offs or transfers, and all listed receipts have been applied to rent.
| Unit | Leasable area, sq. ft. | Occupied area, sq. ft. | Opening rent due (USD) | Rent billed (USD) | Rent cash applied (USD) | Closing rent due (USD) |
|---|---|---|---|---|---|---|
| A | 10,000 | 10,000 | 2,000 | 12,000 | 11,000 | 3,000 |
| B | 6,000 | 6,000 | 1,000 | 8,000 | 7,000 | 2,000 |
| C, vacant | 4,000 | 0 | 0 | 0 | 0 | 0 |
| Total | 20,000 | 16,000 | 3,000 | 20,000 | 18,000 | 5,000 |
Area occupancy = Occupied leasable area / Total leasable area
Closing rent receivable = Opening rent receivable + Rent billed − Rent cash applied
Area occupancy is 16,000 / 20,000 = 80.0%. Counting units instead would give 2 / 3 = 66.7%; both calculations describe the table, but they answer different questions. Use the area figure for a space-weighted operating review.
Rent due reconciles as 3,000 + 20,000 − 18,000 = $5,000. The unit closing balances also sum to $5,000. In a spreadsheet with the table in columns A through G and data in rows 2 through 4, G2 is:
=D2+E2-F2
Fill down, then calculate occupancy and test the rollforward:
=SUM(C2:C4)/SUM(B2:B4)
=SUM(D2:D4)+SUM(E2:E4)-SUM(F2:F4)-SUM(G2:G4)
The reconciliation returns zero. Still tie closing rent due to the property ledger and cash applied to its application report. A zero spreadsheet check will not detect a whole unit missing from every input.
Units A and B submitted valid net sales for August and September 2026. Unit C was vacant throughout and has no sales submission. It is excluded from the comparable sales population rather than entered as a reporting tenant with zero sales.
| Unit | August tenant sales (USD) | September tenant sales (USD) | Change (USD) | Growth |
|---|---|---|---|---|
| A | 100,000 | 110,000 | 10,000 | 10.0% |
| B | 80,000 | 72,000 | -8,000 | -10.0% |
| Comparable total | 180,000 | 182,000 | 2,000 | 1.1% |
The comparable total grew by 2,000 / 180,000 = 1.1%, rounded to one decimal. Averaging the two unit growth rates would give 0.0%, because that method gives the smaller sales base equal weight. Use unrounded figures for all calculations.
Both occupied units supplied both reports, covering 16,000 / 16,000 = 100.0% of occupied area. If a report were missing, show the reduced reporting coverage before interpreting growth. For multi-property files, a property identifier lets you total the selected site's sales with SUMIFS, as documented by Microsoft. Covirage is not affiliated with Microsoft.
Unit C needs a leasing or readiness review. Units A and B need collection follow-up on their respective closing balances. Unit B also needs a discussion about the reported sales decline, but these rows do not establish its cause or show whether its trading calendar changed.
Keep this operating review separate from a property income statement. Net operating income versus EBITDA addresses another reporting boundary; tenant sales and cash collections alone cannot establish either measure.
Bring a sample of your own unit register, rent ledger, applied-cash report and tenant sales file; Covirage maps the columns, and its tools compute and check unit and period comparisons. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your reports.
See self-service analytics for business files for the supporting approach.
Divide occupied leasable area by total leasable area at a stated date, using the same space boundary in both figures. A unit-count occupancy rate is also possible, but it gives small and large units equal weight and should be labeled separately.
No. Tenant-reported sales describe the retailers' trading activity. The property's own income follows its leases and accounting policies, including rent and applicable charges. Keep tenant sales and property income in separate columns and reconcile each to its own source.
Keep them missing and report coverage separately. Calculate comparable growth only where both periods have valid reports on the same basis. Entering zero for a missing submission creates an apparent sales decline that may only reflect a reporting delay.