- Excel works for 1–2 properties with a clean template — beyond that, error rates and admin time increase sharply.
- Moroccan landlords spend an average of 6–10 hours per month on manual tasks that dedicated software handles in minutes.
- Aqarrati auto-generates rent receipts, leases and owner statements compliant with Law 67-12, in Arabic, French and English.
- The real cost of Excel — time lost, missed annual rent reviews, and tax filing errors — exceeds the price of a subscription from the third property onwards.
- Migrating from Excel to Aqarrati takes under one hour for a 10-property portfolio.
Most landlords and small property agencies in Morocco still manage their rentals with Excel — or, in many cases, a paper notebook and carbon-copy receipts. That approach works for a single apartment. It breaks down the moment your portfolio grows. This guide compares Excel vs property management software for the Moroccan market, accounting for local regulations (Law 67-12, IR foncier rental income tax, standardised lease templates) and how they affect your daily operations.
Why Excel is still common among Moroccan landlords
Excel — or Google Sheets — has real advantages. It requires no specialist training, costs nothing if you already have Microsoft 365, and can be shared instantly with an accountant or business partner. For a landlord with one or two apartments in Casablanca or Rabat, a well-structured spreadsheet is enough to track rent payments and produce rent receipts (quittances de loyer) manually each month.
The problem is not Excel itself — it is what you ask Excel to do as your portfolio grows. Managing five tenants on different lease start dates, five security deposits, annual rent reviews on different schedules, IR foncier tax declarations and overdue-payment follow-ups inside a single file is asking more than a spreadsheet can reliably deliver. Formulas break, versions multiply, and errors accumulate silently.
7 critical limitations of Excel for property management in Morocco
1. No automatic generation of Law 67-12 compliant receipts
Moroccan Law 67-12 (Loi relative aux rapports locatifs) sets mandatory fields for every rent receipt: landlord and tenant identity, base rent amount, recoverable charges, period covered, payment method. In Excel, you fill in these fields manually every month, or maintain a separate Word/PDF template — which inevitably falls out of sync and introduces errors.
2. No real-time alert for missed payments
An overdue rent in Excel triggers nothing. You have to check row by row, manually, whether every payment arrived this month. For a landlord managing eight apartments across Casablanca and Marrakech, that weekly audit is a real cognitive load — and it is easy to let a late payment slide for weeks without noticing.
3. Annual rent reviews are routinely forgotten
Annual rent adjustment is governed by Law 67-12. Many landlords simply forget to apply it because Excel has no reminder system. On a monthly rent of 4 500 MAD, a missed review for three consecutive years represents thousands of dirhams in foregone income — a silent drain on the rental yield your investment actually delivers.
4. Formula errors are invisible until they cost you
Research on financial spreadsheets consistently shows the majority contain significant undetected errors. A misreferenced cell or a SUM formula that skips one row can lead to under-reporting rental income to the Direction Générale des Impôts (DGI), creating exposure to tax reassessment under the IR foncier regime.
5. No native multilingual documents (AR/FR/EN)
If you manage Arabic-speaking local tenants alongside foreign investors — common in Marrakech, Tangier or Casablanca-Anfa — you need lease and receipt documents in Arabic, French and English. Maintaining three synchronised versions of every document in Excel is essentially impossible without version drift.
6. Security deposit management is fully manual
Tracking which deposits (avances sur loyer) need to be returned, when, and under what conditions based on the move-out inspection requires precise records. Excel has no native workflow for this, and errors create legal exposure for the landlord.
7. No automated owner statements
If you manage properties on behalf of an owner, or simply want a profitability dashboard for your own portfolio, Excel requires building and maintaining complex pivot tables by hand. No monthly owner statement generates itself — every report is another hour of unpaid work.
Manage your rentals without spreadsheets. Aqarrati automates rent receipts, leases, payment reminders and owner statements in Arabic, French and English — Law 67-12 compliant out of the box. Try free
What Aqarrati does that Excel cannot
One-click documents compliant with Law 67-12
Aqarrati generates rent receipts (quittances), residential leases (baux d'habitation) and move-in/move-out inspections compliant with Law 67-12 in a single click, as a trilingual PDF. A Casablanca-based manager handling six apartments estimated spending 8 hours per month on admin tasks with Excel. After migrating to Aqarrati, that time dropped to under one hour.
Late payment dashboard with integrated reminders
The moment a rent payment is overdue, Aqarrati flags it automatically. You can send the tenant an SMS or email reminder in one click from the same interface. Arrears, partial payments and payment plans are tracked centrally — no row-by-row spreadsheet monitoring required.
Automatic rent review reminders
Aqarrati calculates the annual review date for every lease and notifies you in advance. You never miss a review, and you apply your legal right to adjust rent every year without additional effort.
Owner statements generated automatically
For property agencies and mandated managers, Aqarrati produces a monthly statement per owner: rents collected, deductible charges, management fees, net balance for transfer — as a PDF, without any manual report-building each month.
IR foncier reporting support
Aqarrati consolidates all rental income for the fiscal year in one click, broken down by property and tenant — exactly in the format needed to file the annual IR foncier declaration with the DGI. No manual year-end consolidation, no risk of under-reporting.
Full comparison: Excel vs Aqarrati
| Feature | Excel / Google Sheets | Aqarrati |
|---|---|---|
| Rent payment tracking | Manual, monthly data entry | Automatic with late payment alerts |
| Rent receipt generation | Separate Word/PDF template | 1 click — AR/FR/EN PDF, Law 67-12 compliant |
| Annual rent review | No automatic reminder | Automatic notification and calculation |
| Lease management | Unlinked separate files | Centralised with expiry alerts |
| Monthly owner statement | Manual construction | Auto-generated PDF |
| Trilingual documents (AR/FR/EN) | 3 files to synchronise manually | Native — same document in 3 languages |
| IR foncier annual summary | Manual consolidation | One-click annual report |
| Late payment reminders | Manual call or email | SMS and email from the interface |
| Multi-user access | Version conflicts | Separate roles and permissions |
| Digital move-in/out inspection | Not available | Structured form with photos |
| Apparent cost | 0 MAD | Monthly subscription |
| Real cost for 5 properties | ~975 MAD/month in time | Lower than Excel cost from property 3 |
Which tool matches your landlord profile?
1–2 properties: Excel can still work
If you own one or two apartments and manage them directly, a well-structured Excel file can be sufficient — provided you never modify formulas without double-checking, keep a tidy folder per tenant, and set aside time each month for admin tasks. The main constraint is the absence of automatic reminders and the need to handle every document manually.
3–10 properties: Excel's danger zone
This is where Moroccan landlords lose the most time and money. A portfolio of five apartments with different tenants, leases on different start dates, reviews at different times of year — Excel was not built for this level of complexity. Error risk and management time become real costs that quickly exceed the price of an Aqarrati subscription.
10+ properties or property agencies: dedicated software is essential
For Moroccan property agencies managing rental mandates, Excel is a direct operational bottleneck. Generating owner statements, tracking dozens of tenants simultaneously and maintaining document compliance require a dedicated tool. Aqarrati was designed for this reality — with agency-specific features: multi-owner management, consolidated reports and approval workflows.
The real cost of Excel: calculate what you lose
Most landlords assume Excel is free. Here is what manual admin time actually represents for a five-property portfolio:
Monthly time with Excel — 5-property estimate
Logging rent payments : 1h30
Producing and sending receipts : 2h00
Late payment follow-up : 1h00
Lease updates and rent reviews : 0h45
IR foncier monthly preparation : 0h30
Formula checking and corrections : 0h45
Total : 6h30/month
Hourly cost (conservative estimate) : 150 MAD/h
Real monthly cost of Excel : ~975 MAD/month for 5 properties
This estimate excludes potential tax errors and foregone income from missed rent reviews. In this context, an Aqarrati subscription that automates these tasks delivers a fast return on investment for any landlord managing three properties or more.
How to migrate from Excel to Aqarrati in under an hour
- Export your tenant list from Excel as a CSV with the following fields: full name, CIN (Moroccan national ID), phone, email.
- Import into Aqarrati in a few clicks — the platform auto-detects your column headers.
- Create the leases by entering the key details for each contract: start date, duration, monthly rent, security deposit amount, reference index.
- Log payment history for the current months — Aqarrati can generate receipts retroactively where needed.
In practice, a landlord with 8 apartments and a well-organised Excel file can complete this migration in under 45 minutes. Agencies with 40+ properties can use Aqarrati's assisted migration service.
Aqarrati vs other software available in Morocco
Several property management software options exist in the Moroccan market: Kiraty, Qalimo, Darify, Primmosoft. What differentiates Aqarrati for foreign investors and multilingual agencies:
- Native trilingual interface (AR/FR/EN): essential for agencies managing both Arabic-speaking local tenants and English-speaking foreign investors in Marrakech or Casablanca.
- Law 67-12 compliance built in: lease and receipt templates include all legally required fields with no additional configuration.
- Integrated IR foncier reporting: annual income summary formatted for the DGI declaration — rare at this price point.
- Cloud SaaS, accessible anywhere: no local installation; works on any device from any city in Morocco.
Switch to Aqarrati today. Manage your Moroccan properties without spreadsheets, without errors, and without wasted time. Get 40% off for life with our launch offer. Start free