The verdict in three sentences
A Dubai mall with 160 units that calculates percentage rent on tenant sales and service charge recovery in spreadsheets loses time, money and tenant trust at the same time. A lease and tenant sales platform at 90,000 to 160,000 USD, delivered in about 5 months, automates rent escalations, sales reporting, service charge budgets and reconciliations, and collections. The measurable target is clear: collect 12 days faster and stop missing percentage rent from the best-performing tenants.
Why spreadsheets break at 160 units
The CFO of a mall this size manages 160 leases that all differ: base rent, percentage rent above a breakpoint, rent-free periods at opening, fixed or indexed escalations, security deposits, service charge share by leasable area. Every month the team collects tenant sales, checks them, calculates, invoices and chases.
Typical errors found in 2026 in these files:
- escalations missed on 5 to 10% of leases on their anniversary date;
- percentage rent calculated on incomplete sales reports because nobody chased;
- service charges recovered on outdated area splits after units were reconfigured;
- annual service charge reconciliation sent 4 to 6 months late, triggering disputes;
- no consolidated view of arrears by tenant and by age.
| Monthly process | In spreadsheets | With a lease platform |
|---|---|---|
| Collecting tenant sales reports | Emails and calls, 6 days | Tenant portal or POS feed, 2 days |
| Base and percentage rent calculation | 3 days, manual checks | Automatic, 2 hours of review |
| Annual escalations | Tracked by memory and calendar | Alert and calculation on lease date |
| Quarterly service charge invoices | 2 days | Generated automatically |
| Annual service charge reconciliation | 4 to 6 months after year end | 6 to 8 weeks after year end |
| Arrears chasing | Ad hoc | Scheduled at day 5, 15, 30 |
| Average collection time | 40 days | 28 days targeted |
These are 2026 orders of magnitude for a 4-person finance team at the mall.
Off-the-shelf platform or custom build
Large commercial real estate suites are widely used in the Gulf, but licence costs, implementation partners and customisation for local practice add up: 5% UAE VAT, Ejari registration data, AED and USD reporting, POS integrations with tenant systems. Residential property tools ignore percentage rent altogether.
| Option | Indicative 2026 cost | Strengths | Limits |
|---|---|---|---|
| Spreadsheets with macros | 3,000 to 8,000 USD | Fast, cheap | Fragile, key-person risk |
| Global commercial real estate suite | Annual licences often above 40,000 USD plus implementation | Complete features | Long configuration, partner dependency |
| Residential property management tool | 3,000 to 10,000 USD a year | Simple | No percentage rent or weighted areas |
| Custom platform | 90,000 to 160,000 USD | Mall rules, AED, VAT, POS feeds, tenant portal | 5-month project, maintenance to budget |
For a 160-unit mall, a custom build is justified once more than 40 leases carry percentage rent or service charges use several allocation keys (area, frontage, metered usage). See our approach to custom web applications.
Essential modules and timeline
- Lease register: units, weighted areas, dates, base rent, percentage rent breakpoints, rent-free periods, deposits, escalations.
- Tenant portal and POS feeds: daily or monthly sales, certified annual sales statement, invoice access.
- Billing engine: base rent, percentage rent top-ups, service charges, VAT, credit notes.
- Service charges: budget, allocation keys, annual reconciliation with supporting documents.
- Collections: aged debt, scheduled reminders, payment plans, post-dated cheque tracking.
- Dashboards: occupancy, sales per square foot by tenant, occupancy cost ratio, arrears.
| Phase | Duration | Output |
|---|---|---|
| Audit of 160 leases and service charge rules | 4 weeks | Validated lease register |
| Portal and finance screen mock-ups | 3 weeks | Approved flows |
| Development and POS connectors | 9 weeks | Test version |
| Migration of 24 months of history | 2 weeks | Balances and arrears loaded |
| Parallel billing with spreadsheets for one month | 4 weeks | Differences explained, cutover |
The occupancy cost ratio (rent and charges divided by tenant sales) becomes visible every month. It is the best early warning before a tenant falls into arrears or asks to renegotiate.
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Mini case study
Omar, CFO of a community mall in Dubai, bills 160 units for a monthly total of 9,500,000 AED in rent and service charges. He chooses a custom platform at 130,000 USD (about 477,000 AED).
- Collecting 12 days faster on 9,500,000 AED a month raises average available cash by about 9,500,000 × 12 / 30, so 3,800,000 AED permanently.
- Percentage rent: 45 tenants concerned. Systematic sales checks recover 1% of missed top-ups on a yearly percentage rent volume of 18,000,000 AED, so 180,000 AED a year.
- Missed escalations: 10 leases at 60,000 AED a month under-escalated by 5%, so about 360,000 AED a year.
- Direct yearly gain excluding cash: about 540,000 AED. The project pays back in under 11 months, before counting the value of the cash released.
FAQ
Will tenants report sales through a portal?
Yes if the lease requires it and reporting takes under 5 minutes a month. Large brands often prefer an automated POS feed, which covers 60 to 70% of sales volume in a typical mall.
Does the platform handle UAE VAT and credit notes?
It must be configured for 5% VAT on commercial rent and service charges, compliant tax invoices and credit notes. Settings are validated with your tax adviser before go-live.
Can it connect to our accounting system?
Yes, through journal exports or an API to your ERP, daily or monthly. This bridge typically represents 5 to 10% of the project budget.
What does maintenance cost?
Budget roughly 10 to 15% of the initial cost per year for hosting, fixes and regulatory updates. Major new features are quoted separately.
What if a lease has an unusual clause?
The register supports multiple breakpoints, stepped rent-free periods and manual clauses flagged for review. Across 160 leases, 5 to 10 atypical cases are common and are handled during the initial audit.
Let's scope your project. Send us an anonymised sample of your leases and your service charge file, and we will define priority modules and a realistic cutover plan. 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.
