Operator guides

Missing sales and zero sales in a mall daily report

At 10 am the shopping centre manager sees yesterday’s footwear sales fall by half. One large store shows zero sales. Before calling the tenant about demand, the manager needs one piece of evidence. Did the store send a return showing zero sales, or has the mall received nothing for that date? Both situations can look identical in a spreadsheet. They call for different people and different follow-up.

Start with the trading calendar

Build the list of shops due to report for the business date. A kiosk that opened on Friday has no obligation for Thursday. A shop closed for an approved refit can also be excluded for the dates covered by that closure. Keep the reason and effective dates with the shop record so operations can explain the denominator later.

Now compare the expected list with accepted submissions. Give each expected shop a state such as received with sales, explicitly reported zero, received but awaiting validation, or missing. A file that stops halfway through the evening may need a partial status. A blank row, an empty export, or a timeout needs investigation before anyone records a zero.

Read the amount alongside coverage

Consider an illustrative close at a British shopping centre. Of 40 occupied units, two had approved closures. Of the 38 shops due, 34 submitted positive values totalling £184,000 and two submitted explicit zero declarations. The other two have yet to report. Coverage is 36 of 38, or 94.7%. The morning brief can state “£184,000 received, two shops outstanding, as of 10 am.” That gives management both a number and a reason to treat it as provisional.

The operations team can contact the two outstanding stores by name. For each declared zero, check whether the shop traded, which business date the declaration covers, and who provided it. If the shop confirms the figure, retain its declaration. A weekend closure discovered during the call belongs with the closure history and merits a correction to the expected list.

Keep the first close and the revised close

Suppose a late fashion store sends £12,500 at noon. The updated total becomes £196,500 and coverage reaches 37 of 38. Retain the time of arrival and the earlier morning figure. The general manager can then explain why the morning message and the afternoon dashboard differ.

Mall Metrics includes separate Missing Sales Days and Zero Sales Days report views. In a walkthrough, use the same shop and period in both, then check which store needs a submission and which needs confirmation. A useful morning handover leaves each open item with an owner and a next contact time.

Explore daily sales reporting · Set a reporting cut-off

A filtered missing-sales report shows five rows, including counts of one, two and eight missing dates. Shop names and shop types are concealed.
Missing Sales Data by Brand Use the missing dates and day counts to direct follow-up. Five anonymised demo rows show how a single absent day and a run of eight days appear in the report.
Product walkthrough

Bring one mall.
Follow one trading day.

See how tenant submissions become a finance review and a management brief.

Book a demo
Product screen

Open full resolution ↗
Book a demo

Mall Metrics advisor

ADSR product support and demo enquiries

What would you like to know about Mall Metrics?
Book a demo

Fundle stores this conversation so the team can follow up.