The verdict in three sentences
A 90-unit mall run on spreadsheets loses hundreds of thousands of dollars a year in unclaimed turnover rent, missed escalations and service charges reconciled too late. A custom tenant management platform centralises leases, calculates percentage rent automatically and produces a service charge statement per tenant. For a mall of this size the build sits in the medium to complex range of Kolonell applications and usually pays back in well under 18 months.
What spreadsheet management really costs in Dubai
In Dubai community and neighbourhood malls, 2026 base rents range in order of magnitude from USD 400 to 1,500 per m2 per year depending on footfall, frontage and unit size, with prime super-regional malls far higher. A 90-unit centre with an average unit of 80 m2 therefore bills roughly USD 3 to 9 million a year in base rent, plus service charges (security, chilled water, cleaning, common area power) that commonly run at USD 60 to 150 per m2 per year, and for anchors and F&B a turnover rent clause above a minimum guaranteed rent.
The difficulty is the variety of clauses rather than the volume. Each lease has its own expiry, escalation rate, rent-free period, turnover percentage and service charge share. Missing a single 5% escalation on a 150 m2 unit at USD 900 per m2 costs about USD 6,750 a year.
| Leakage item | Typical frequency on spreadsheets | Estimated annual loss (90 units) |
|---|---|---|
| Missed or late annual escalation | 8 to 12 leases a year | USD 60,000 to 120,000 |
| Unclaimed turnover rent | 30 to 50% of tenants with a TO clause | USD 50,000 to 200,000 |
| Service charge reconciliation 6+ months late | Systematic | USD 150,000 to 300,000 of tied-up cash |
| Arrears spotted after 60 days | 5 to 10% of tenants | USD 40,000 to 90,000 of doubtful debt |
| Manual billing workload | 4 to 6 days a month | 2 finance FTEs partly tied up |
| Service charge disputes | 10 to 20 a year | Strained tenant relations, lost renewals |
These are 2026 orders of magnitude for comparable centres. They show that the real question is which scope to launch first, not whether a platform pays.
Features that matter to a mall manager
- Lease register: areas, terms, expiries, escalation clauses, rent-free periods, security deposits, alerts 6 and 3 months before expiry, and Ejari registration references.
- Turnover rent: a tenant portal for monthly sales declarations, automatic calculation of the top-up above base rent, reminders for missing returns, POS integration for large tenants.
- Service charge budgets: apportionment by area or usage, quarterly advance billing, annual reconciliation statement per tenant, aligned with RICS service charge good practice.
- Billing and collection: invoices with 5% UAE VAT, bank reconciliation, post-dated cheque tracking, card and transfer payments.
- Footfall counting: entrance sensors feeding visitor counts, crossed with tenant sales to support renewals and leasing decisions.
- Management dashboard: occupancy, collection rate, average rent per m2, vacancy, NOI by wing or floor.
| Project level | Functional scope | Kolonell 2026 range | Indicative timeline |
|---|---|---|---|
| Simple application | Lease register, rent roll, base rent billing | 2,500,000 to 4,000,000 FCFA (EUR 3,810 to 6,100) | 6 to 8 weeks |
| Medium application | + turnover rent, tenant portal, service charges and reconciliation | 4,000,000 to 7,000,000 FCFA (EUR 6,100 to 10,670) | 10 to 14 weeks |
| Complex application | + footfall, multi-mall, ERP interface, advanced dashboards | 7,000,000 to 15,000,000+ FCFA (EUR 10,670 to 22,870+) | 4 to 6 months |
| Monthly maintenance | Basic, Standard or Premium | 35,000 / 75,000 / 120,000 FCFA a month (EUR 53 / 114 / 183) | Ongoing |
| Hosting, sensor integration, data migration | Depends on volume and existing hardware | On quote | After audit |
For comparison, an international mall management software licence costs in 2026 order of magnitude USD 10,000 to 40,000 a year per centre, plus implementation partner fees that often exceed the licence itself.
Legal and tax points to design in
In Dubai, commercial leases are governed by Law No. 26 of 2007 as amended, with rent increases linked to the RERA rental index and disputes heard by the Rental Disputes Centre. Lease registration through Ejari is mandatory. The platform must therefore keep a full history of every escalation and notice served, store Ejari numbers and produce VAT-compliant tax invoices, because those are the documents that matter in a dispute or an FTA audit.
Mini case study
Omar, general manager of a 90-unit community mall in Dubai, runs everything from spreadsheets with two accountants. An audit reveals 9 leases not escalated since 2024, 14 tenants with a turnover clause of whom only 5 report sales on time, and service charges reconciled 8 months late.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
- Recovered escalations: 9 leases × USD 550 a month × 12 = USD 59,400 a year.
- Recovered turnover rent from 9 non-reporting tenants: 9 × USD 4,000 = USD 36,000 a year.
- Finance time freed: 4 days a month, about 48 days a year.
With a medium application at 6,000,000 FCFA (about EUR 9,150) and Standard maintenance at 75,000 FCFA a month (EUR 114, so about EUR 1,370 a year), the first-year cost is around EUR 10,500 against direct gains of roughly USD 95,000. Payback comes in a matter of weeks.
FAQ
How long does it take to migrate 90 existing leases?
Migrating leases, rent rolls and tenant balances usually takes 2 to 3 weeks, including one week of cross-checking with finance. Plan one month of parallel running before switching off the spreadsheets.
Can tenants submit their sales figures themselves?
Yes, through a secure portal with one login per tenant. On-time reporting typically rises from about 35% to over 85% within three months thanks to automatic reminders.
Does the platform handle UAE VAT?
Yes, invoices carry the 5% VAT, your TRN and the tenant's TRN where applicable. Exports for your VAT return are generated monthly or quarterly.
Will it connect to our accounting system?
An export of journal entries in your accounting format is included from the medium level. A live interface with SAP, Oracle or Microsoft Dynamics is priced on quote after analysis.
What if we take on a second mall?
Multi-mall architecture is part of the complex level. Planning it from day one avoids a rebuild and lets you compare both centres on the same KPIs.
Let's scope your project. We will define with you the scope (leases, turnover rent, service charges, footfall) and the go-live plan for your mall. 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.
