property management moroccorental softwareexcellaw 67-12ir foncierlandlord morocco

Excel vs Property Management Software Morocco 2026

A

Aqarrati Team

Moroccan Property Management Experts

·

Property management software is a cloud SaaS platform that automates rent tracking, receipt generation, late payment alerts and owner statements — replacing Excel spreadsheets for landlords and property agencies managing rentals in Morocco.

Key Takeaways
  • 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

  1. Export your tenant list from Excel as a CSV with the following fields: full name, CIN (Moroccan national ID), phone, email.
  2. Import into Aqarrati in a few clicks — the platform auto-detects your column headers.
  3. Create the leases by entering the key details for each contract: start date, duration, monthly rent, security deposit amount, reference index.
  4. 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

Frequently asked questions

Is Excel enough to manage 3 rental properties in Morocco?

Excel can work for 1-2 properties with a clean template. From 3 properties onwards, managing multiple tenants, lease dates, annual rent reviews and IR foncier tax declarations in a single spreadsheet creates significant error risk and time overhead that typically exceeds the cost of a dedicated tool like Aqarrati.

What is the real cost of using Excel for rental management in Morocco?

Excel appears free but represents approximately 6h30 of manual work per month for a 5-property portfolio, equivalent to around 975 MAD/month at a conservative 150 MAD/h. This excludes potential tax errors and foregone income from missed annual rent reviews, which compound silently over time.

How does Aqarrati generate receipts compliant with Law 67-12?

Aqarrati builds all mandatory fields required under Moroccan Law 67-12 directly into its receipt templates: landlord and tenant identity, rent and charge amounts, period covered, payment method. The receipt is generated in one click and delivered as a PDF in Arabic, French and English.

Can I migrate my Excel data to Aqarrati easily?

Yes. Migration takes 4 steps: export your tenant list as CSV, import into Aqarrati (the platform auto-detects columns), create the leases with key contract details, and log current payment history. A well-documented 10-property portfolio migrates in under one hour.

Does Aqarrati work in Arabic?

Yes. Aqarrati is natively trilingual: Arabic, French and English. The interface, leases, receipts and owner statements are all available in all three languages, including right-to-left Arabic PDF layout.

What is the IR foncier tax on rental income in Morocco?

The IR foncier (Impôt sur le Revenu foncier) is Morocco's rental income tax, levied by the Direction Générale des Impôts. Rates range from 10% to 40% depending on annual rental income, with a 40% flat-rate deduction for charges under the simplified regime. Aqarrati produces an annual income summary in the format required for the DGI declaration.

Is Aqarrati suitable for foreign investors managing Moroccan properties?

Yes. Aqarrati is particularly well-suited to foreign investors managing Moroccan properties: the platform is fully available in English, all lease and receipt templates are compliant with Moroccan law (Law 67-12), and the IR foncier reporting feature simplifies the annual tax declaration for non-resident landlords.

Manage your properties with Aqarrati

Compliant contracts, payment tracking, and automatic reminders — all in one dashboard.

Try for free
Excel vs Property Management Software Morocco 2026