The verdict in three sentences
For a 120-tenant shopping mall in Dubai, managing leases, turnover rent and service charge recovery in Excel usually costs 2 to 4 % of rental income through missed escalations, late invoices and disputes. Custom mall management software costs between 300,000 and 550,000 AED in 2026, with a 4 to 5 month delivery. The project pays for itself through escalations applied on time, turnover rent calculated correctly and service charges recovered on the exact share.
Four flows Excel can no longer handle
With 120 retail leases, every month brings hundreds of operations: rent demands, sales reports, service charge reconciliations, renewal deadlines. Lease registration with Ejari and the Dubai tenancy rules make date tracking critical.
| Flow | Monthly volume (120 tenants) | Risk in Excel | Software function |
|---|---|---|---|
| Rent demands and receipts | 120 | Missed escalation, VAT error | Automatic schedule, escalation on date |
| Tenant sales reports | 120 | Late reports, no checks | Tenant portal, reminders, variance checks |
| Turnover rent calculation | 120 | Formula misapplied | Base rent + % of sales per lease |
| Service charges and annual reconciliation | 1 close, 120 statements | Disputed allocation key | Shares, budget, justified statement |
| Lease expiries and renewals | 5 to 10 | Unwanted silent renewal | Alerts at 12, 6 and 3 months |
| Footfall and events | Daily | Scattered data | Counter import, impact per event |
Turnover rent, the first source of gains
Most mall leases combine a base rent with a percentage of sales, often 5 to 10 % depending on the category. The tenant pays the higher of the two. Without a reporting portal and checks, some tenants report late or under-report, and the mall never invoices the difference.
| Category | Base rent (Dubai 2026 estimate) | Usual turnover rate | Indicative breakpoint |
|---|---|---|---|
| Fashion and apparel | 250 to 450 AED/sq ft/year | 7 to 9 % | Sales of 3,000 to 5,000 AED/sq ft/year |
| Quick service restaurants | 300 to 550 AED/sq ft/year | 8 to 10 % | Sales of 3,500 to 5,500 AED/sq ft/year |
| Hypermarket (anchor) | 40 to 90 AED/sq ft/year | 1.5 to 3 % | Negotiated case by case |
| Electronics | 200 to 400 AED/sq ft/year | 3 to 5 % | Sales of 6,000 to 9,000 AED/sq ft/year |
| Leisure and cinema | 60 to 150 AED/sq ft/year | 6 to 10 % of box office | Negotiated case by case |
The software compares each report with the base rent every month, applies the lease-specific formula and prepares the top-up invoice. It also flags gaps between measured footfall and reported sales.
Budget and timelines in 2026
| Option | Upfront cost (estimate) | Recurring cost | Lead time | Limit |
|---|---|---|---|---|
| Excel + accounting | 0 AED | Time of 2 staff | Immediate | No portal, no alerts |
| Property management package | 150,000 to 250,000 AED | 4,000 to 8,000 AED/month | 2 to 3 months | Weak turnover rent and events coverage |
| Custom: leases, rent, charges, portal | 300,000 to 420,000 AED | 5,000 to 8,000 AED/month | 4 months | Lease formulas must be specified |
| Custom + footfall + events | 420,000 to 550,000 AED | 7,000 to 11,000 AED/month | 5 months | Counter compatibility |
Mini case study
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Khalid, general manager of a 120-tenant mall in Dubai, collects 4,000,000 AED of rent a month. A 12-month audit reveals 18 leases where escalation was not applied (50,000 AED a month lost) and unbilled turnover rent on 10 tenants, about 65,000 AED a month. Badly allocated service charges create 30,000 AED a month of dropped disputes. Total: 145,000 AED a month, or 3.6 % of rent. With software at 450,000 AED and 8,000 AED of monthly maintenance, payback comes in a little over 3 months.
FAQ
Will tenants report their sales online?
Yes, when the lease requires it and reporting takes under 5 minutes. An automatic reminder at D+5 and a contractual penalty usually push on-time reporting above 90 %.
Does the software handle VAT and e-invoicing?
It applies 5 % UAE VAT on commercial rent and produces compliant tax invoices. Export to the existing accounting system is included in the scope.
Can we connect footfall counters?
Most counters export data in CSV or via API. A daily import measures the effect of an event, for example +12 % visitors over a weekend.
How long to load 120 leases?
Count 3 to 4 weeks to enter and check the financial clauses of 120 leases. This step often uncovers the first revenue leaks.
Let's scope your project. Tell us the number of leases, your turnover rent formulas and your accounting system: we price the scope in releases, with an indicative budget and 4 to 5 month delivery. Detailed quote within 48 h. WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.
