The verdict in three sentences
A 120-store mall in the New York area that manages leases, percentage rent and CAM recoveries in spreadsheets piles up calculation errors, late invoices and tenant disputes. Custom commercial lease management software, with a tenant sales reporting portal and automatic percentage rent calculation, cuts monthly billing from several days to a few hours. At Kolonell, this project costs 2.5 to 15M+ FCFA (about USD 4,400 to 26,500+, or EUR 3,810 to 22,870+), far below the USD 50,000 to 120,000 of integrated market suites.
Why spreadsheets no longer work for 120 leases
Across Queens, Brooklyn, Staten Island and the suburbs, mall base rents range from USD 40 to 150 per square foot per year depending on location, level and unit size. Most national and regional retailer leases combine a minimum base rent with percentage rent of 6 to 10% of sales above a breakpoint. Every month, management must collect sales reports, apply the right clause, escalate, bill common area maintenance (CAM), real estate taxes and insurance. A formula error on a single 4,000 sq ft lease can cost tens of thousands of dollars a year.
| Indicator (120 stores, 350,000 sq ft GLA) | Spreadsheet | Dedicated software | 2026 order of magnitude |
|---|---|---|---|
| Monthly billing cycle | 6 to 9 days | 1 day | 5 to 8 days of cash gained |
| Sales reports received on time | 60 to 70% | 90 to 95% via portal | Percentage rent billed on time |
| Percentage rent calculation errors | 3 to 5% of leases | Under 0.5% | USD 60,000 to 160,000 recovered per year |
| Annual CAM reconciliation | 2 to 3 months | 2 to 3 weeks | Fewer audits and disputes |
| 60-day delinquency rate | 6 to 10% | 3 to 5% | Automated reminders |
| Lease expiry tracking | Manual calendar | Alerts at 12, 6 and 3 months | Earlier renegotiations |
On a center collecting about USD 25 to 35 million in rent per year, recovering just 1% of miscalculated or late percentage rent and CAM represents USD 250,000 to 350,000.
Modules and budget
The software covers the full cycle: lease, invoice, collection, recoveries and tenant relationship. The tenant portal is the centerpiece: each store reports monthly gross sales, downloads invoices and opens maintenance requests.
| Module | Key features | Indicative Kolonell budget | Timeline |
|---|---|---|---|
| Lease register | Areas, clauses, breakpoints, escalations, guarantees, expiries | 2.5 to 4M FCFA (USD 4,400 to 7,100) | 3 to 4 weeks |
| Percentage rent | Automatic tiered calculation, natural and artificial breakpoints, consistency checks | 2 to 4M FCFA (USD 3,500 to 7,100) | 3 to 5 weeks |
| Tenant portal | Sales reports, invoices, tickets, documents | 3 to 5M FCFA (USD 5,300 to 8,800) | 4 to 6 weeks |
| CAM and recoveries | Pro rata shares, budget, annual reconciliation, caps | 2 to 4M FCFA (USD 3,500 to 7,100) | 3 to 4 weeks |
| Accounting and sales tax | Export to QuickBooks, Yardi or current ledger | Custom quote | Variable |
| Multi-center platform | Several properties, portfolio reporting, investor dashboard | 15M+ FCFA (USD 26,500+) | 4 to 6 months |
A core of leases, percentage rent and portal usually starts between 8 and 12M FCFA (USD 14,000 to 21,000). Accounting connectors and footfall counter integrations are quoted separately.
Legal and operational watch points
Commercial leases in New York are governed mainly by contract, so the software must trace every amendment, escalation and audit right. Tenant sales reports must be timestamped and, for larger tenants, reconciled with the annual certified sales statement. Plan for data security consistent with the New York SHIELD Act for tenant contact data, and separate access rights for management, accounting and operations.
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.
Michael, general manager of a 120-store mall in Queens, bills USD 2.3 million in rent per month, including USD 300,000 of percentage rent. He estimates 6% of percentage rent slips each month (late reports, wrong breakpoint), or USD 18,000, and his team spends 7 days a month on billing. With software at 10M FCFA (about USD 17,600), leakage falls to 1%, recovering USD 15,000 per month, and billing takes 1 day. Adding 5 freed working days (about USD 4,000 of payroll), the gain reaches USD 19,000 per month: payback in roughly one month, before any effect on delinquencies.
FAQ
Will retailers agree to report sales through a portal?
Yes, most national chains already do so for other landlords. Automated reminders at D+5 and D+10 push on-time reporting to 90% and above.
How much does mall management software cost at Kolonell?
From 2.5 to 15M+ FCFA (about USD 4,400 to 26,500+) depending on complexity. A complete core for one center sits around 8 to 12M FCFA; the rest is quoted separately.
Does the software handle percentage rent breakpoints?
Yes, each lease can have a base rent, a breakpoint and several tiers, for example 6% up to USD 2 million then 8% above. Calculations are checked against history to flag variances above 20%.
Can it connect to our accounting system?
Yes, through export or API to QuickBooks, Yardi or your current ledger. Invoices are generated with the right tax lines and entries are ready to post.
How long does it take to go live?
Allow 10 to 14 weeks for the core, including migration of the 120 leases, then one month of parallel run before retiring spreadsheets.
Let's scope your project. Tell us your number of leases, clause types and accounting tool: we will price the scope, indicative budget and migration 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.
