Manual vs Automated Tenant Sales Reporting: What Indian Malls Lose with Excel and WhatsApp
By Escapade Technologies | Last updated: October 2026
Tenant sales reporting is the process a mall uses to collect each tenant’s sales figures, mainly to calculate revenue share rent and track store performance. Manual tenant sales reporting relies on tenants sending their own numbers, while automated tenant sales reporting pulls them directly from each tenant’s point-of-sale (POS) system every day.
Most Indian malls still use the manual method. This guide compares both approaches, shows where money and time leak out, and explains how to switch.
Key takeaways
- Manual reporting depends on self-reported Excel sheets and receipt photos, which are slow and hard to verify.
- The biggest losses are under-reported sales, late data, rent disputes and staff time.
- Automated reporting collects sales from each tenant’s POS daily and flags gaps.
- Switching usually does not require tenants to replace their billing systems.
How Does Manual Tenant Sales Reporting Work in Indian Malls?
In most malls, manual sales reporting follows the same monthly routine:
- Tenants type daily or monthly totals into an Excel sheet, or share a photo of the day-end sales report on WhatsApp or email.
- The mall’s finance team chases late submissions, often for a week or more after month end.
- Figures are copied into the mall’s own sheet or ERP to calculate turnover rent.
- Mismatches are settled through emails, calls and occasional audits.
This works for a handful of anchor stores. With a hundred or more outlets, food court counters and delivery orders, it breaks down.
What Do Malls Lose with Manual Tenant Sales Reporting?
Malls lose rent, time and visibility. The five most common losses are:
- Under-reported sales: Self-reported figures can leave out cash sales, discounts or delivery orders, which lowers revenue share rent.
- Late data: Numbers arrive weeks after month end, so leasing and marketing teams react late.
- Rent disputes: When a tenant’s figure and the mall’s estimate differ, revenue share reconciliation turns into a long back-and-forth.
- Staff time: Finance teams spend days every month on follow-ups, data entry and checks.
- Weak leasing decisions: Without reliable outlet-level sales, renewals and tenant mix choices rely on guesswork.
Illustrative example: if a tenant paying 10% revenue share above its minimum guarantee under-reports ₹20 lakh of monthly sales, the mall misses ₹2 lakh of rent that month from a single outlet.
Manual vs Automated Tenant Sales Reporting: Side-by-Side Comparison
Automated reporting is faster, more accurate and needs far less effort. Manual reporting’s only advantage is that it needs no setup.
Factor | Manual reporting | Automated reporting |
Data source | Excel sheets and receipt photos sent by tenants | Directly from the tenant’s POS and delivery apps |
Frequency | Monthly, often late | Daily or near real time |
Accuracy | Prone to typing errors and omissions | Far fewer errors; gaps flagged automatically |
Under-reporting risk | High and hard to prove | Much lower, as data comes from the source |
Turnover rent calculation | Manual, spreadsheet-based | Calculated from verified sales |
Effort for the mall team | Days of follow-ups each month | Review exceptions only |
Setup | None | One-time integration per tenant |
How Does Automated Tenant Sales Reporting Work?
Automated tenant sales reporting, also called ADSR software (Automated Daily Sales Reporting), connects to each tenant’s billing system and sends sales to the mall every day. POS integration captures in-store sales, aggregator integration adds Swiggy, Zomato and Uber Eats orders, and the software reconciles everything before showing it on one dashboard.
Exception alerts flag missing days or unusual drops, so the team checks only what needs attention. For food courts, where one operator manages many counters, the same approach powers food court sales tracking.
Why Does the Switch Matter More for Indian Malls in 2026?
Indian malls are filling up fast, so every outlet’s sales data now carries more weight.
- Retailers leased about 4.1 million sq ft of Grade A mall space in H1 2026 against just 0.9 million sq ft of new supply, and Grade A mall vacancy fell to 6.7%, the lowest since 2010, according to an ANAROCK report.
- Retail space take-up rose 20% to about 3.9 million sq ft in H1 2026, with food and beverage brands taking about 14% of it, according to CBRE.
Fuller malls and more F&B tenants mean more outlets, more delivery orders and more revenue share terms to verify. That is exactly where manual reporting struggles.
How to Move from Manual to Automated Tenant Sales Reporting
Most malls can switch in five practical steps:
- List lease terms: note each tenant’s revenue share percentage, minimum guarantee and reporting clause.
- Map tenant POS systems: record which billing software each outlet uses.
- Update lease clauses: add automated sales sharing to new leases and renewals.
- Run a pilot: connect a few tenants, such as the food court, and compare automated figures with reported ones.
- Roll out and review: extend to all tenants and review exceptions every week.
Planning the switch? Book a free PerSft demo to see how it would work for your mall.
How PerSft Automates Tenant Sales Reporting
PerSft by Escapade Technologies automates tenant sales data collection for Indian venues. It connects with tenant POS systems and with Swiggy, Zomato, Uber Eats, Razorpay, Stripe and Paytm, then shows net sales, gross sales and average order value for each outlet on one real-time dashboard. Explore our shopping mall revenue software to see how it fits your property.
Frequently Asked Questions
Manual tenant sales reporting relies on figures that tenants type or photograph themselves. These are easy to get wrong, hard to verify and often late, which can lead to under-reported sales, lower revenue share rent and frequent disputes between the mall and its tenants.
A mall can automate tenant sales collection with mall sales reporting software that connects to each tenant’s POS and delivery apps. Sales are sent daily, checked against other sources and shown on one dashboard, with alerts for missing or unusual data.
Usually not. Automated reporting is designed to connect with the billing systems tenants already use, through APIs or integrations. The exact setup depends on each tenant’s system, so it is worth checking compatibility before rollout.
Yes. Because sales come straight from the source every day, turnover rent can be calculated on verified figures instead of self-reported ones. This makes revenue share reconciliation faster and reduces month-end disputes between the mall’s finance team and tenants.
Conclusion
Manual tenant sales reporting costs Indian malls rent, time and trust. Automation replaces Excel sheets and WhatsApp receipts with daily, verified data that both the mall and its tenants can rely on. Book a free PerSft demo to make the switch.