Financial & Accounting

Aging Analysis

Synonyms: Aging Report، Aging Analysis، Receivables Aging، Past Due Aging

Last updated: 2026-05-07

Short Definition

Report categorizing arrears by delay period: 30, 60, 90, 120+ days, helping prioritize collection and assess risks.

Overview

Rent Arrears Aging in the Saudi real estate sector is an accounting analysis classifying rental arrears by their time period, enabling management to evaluate severity of each delay and take appropriate action for each category. Aging Analysis is a pivotal tool in professional property management, revealing health of owner's financial portfolio and helping predict potential losses. Arrears aging is usually divided into categories: (1) 0-30 days: recent delay, high collection probability (90-95%). (2) 31-60 days: medium delay, requires serious follow-up, collection probability 70-85%. (3) 61-90 days: old delay, requires escalation, collection probability 40-60%. (4) 91-180 days: very dangerous, collection probability 20-40%. (5) More than 180 days: bad delay, collection probability less than 20%, may need write-off. Aging analysis has multiple uses in property management: identifying arrears deserving legal escalation, calculating Bad Debt Provision in financial statements, evaluating collection team performance, directing contract renewal decisions (tenant with repeated delay record may not be renewed), and determining focus in collection efforts. Modern property management systems automatically generate aging reports with every status update. Monthly owner report must always include aging table to give realistic picture of portfolio health, not just positive numbers.

Legal Basis

Arrears aging analysis is based on accounting standards adopted by SOCPA and IFRS 9 (Financial Instruments - Provisions) standards applied in Saudi Arabia, requiring estimating doubtful debts based on debt age. For registered real estate entities, ZATCA requires keeping aging records for tax purposes. SAMA and banks also benefit from aging reports in evaluating real estate loan portfolios. The arrears list documented via Ejar facilitates analysis, with each delay case automatically dated.

Practical Example

Al-Waha Real Estate office manages commercial complex with 30 shops in Riyadh. Aging report on March 31, 2026 shows: (1) 0-30 days: two shops (SAR 24,000) - recent delay, official notice sent, 95% collection probability = SAR 22,800 expected. (2) 31-60 days: one shop (SAR 15,000) - intensive communication, 80% probability = SAR 12,000. (3) 61-90 days: one shop (SAR 22,000) - escalation soon, 50% probability = SAR 11,000. (4) 91-180 days: one shop (SAR 45,000) - in court, 30% probability = SAR 13,500. (5) Over 180 days: none. Nominal total arrears: SAR 106,000. Real expected value: SAR 59,300. Doubtful debt provision: 106,000 - 59,300 = SAR 46,700 (recorded in financial statements). This analysis gives realistic picture, enables owner to make decisions based on accurate information, and determines for office where to focus collection efforts.

Common Mistakes

  • Failing to prepare regular aging report — without it, owner becomes blind to real portfolio health.
  • Mixing time categories without distinction — each category has different handling strategy; mixing wastes time.
  • Assuming recent arrears don't deserve follow-up — best time for collection is early days.
  • Ignoring old arrears instead of writing off or escalating — they remain in numbers distorting reality.
  • Not calculating doubtful debt provision in financial statements — gives misleading optimistic numbers.

International Differences

Aging analysis is a global accounting standard. In the UAE, Aging Reports are mandatory in monthly Mollak reports. In Turkey, aging analysis is used in large companies but less regulated. In Egypt, practice is in slow development. In the UK, Arrears Aging is part of any respectable PMS (Property Management System), with Section 8 Notice regulations linked. In the US, Aging Schedule is essential part of every accounting report, used by AppFolio, Yardi, and Buildium automatically. The Saudi advantage in aging analysis is integration with Ejar platform (dates automatically documented), full IFRS compliance (accounting professionalism), speed in judicial escalation (60-day average), and low total arrears in organized sector (Fal offices) compared to unorganized sector.

FAQs

When should aging report be prepared?
Monthly at minimum, weekly for large portfolios, daily in critical periods (fiscal year end, contract renewals).
What is the difference between recent and old arrears?
Recent (0-30 days): high collection probability, require quiet follow-up. Old (90+ days): lower probability, require escalation or write-off.
How do I calculate doubtful debt provision?
By applying percentage to each category: 5% for recent, 15% for medium, 50% for old, 80% for dangerous, 100% for oldest. Total = debt provision.
When do I escalate arrears to judicial committee?
When exceeding 60-90 days without response, or clear bad behavior. Too early escalation may harm relationship, too late weakens collection chances.
What is the relationship between arrears aging and contract renewal?
Tenant with repeated delay record (3+ times yearly) may not have contract renewed. Aging analysis clearly reveals behavior pattern.

In Other Languages

Arabic
تحليل أعمار الديون

تقرير يصنف المتأخرات حسب فترة التأخير: 30، 60، 90، 120+ يوماً، يساعد في تحديد أولويات التحصيل والمخاطر.

English
Aging Analysis

Report categorizing arrears by delay period: 30, 60, 90, 120+ days, helping prioritize collection and assess risks.

Turkish
Yaş Analizi

Gecikmeleri gecikme dönemine göre kategorize eden rapor: 30, 60, 90, 120+ gün; tahsilatı önceliklendirmeye ve riskleri değerlendirmeye yardımcı olur.

Related Terms

Amlaki

About Amlaki

Amlaki is an integrated Saudi real estate management system, supporting agencies and owners in managing rentals, maintenance, and reports with high efficiency, fully compliant with the Ejar platform and Kingdom regulations.

Learn More