Payable Ageing Reports

Payable Ageing reports show how long your unpaid bills have been outstanding — grouped by vendor and bucketed by age. Use them to plan payments, avoid late fees, and maintain good vendor relationships.

---

Two Variants

Report	Best For
Payable Ageing Summary	One total row per vendor across age buckets — quick overview
Payable Ageing Detail	Every individual unpaid bill — full drill-down

---

How to View

1. Go to Reports
2. Select Payable Ageing Summary or Payable Ageing Detail
3. Set the As On date (defaults to today)
4. Optionally adjust the interval (days per bucket) and number of buckets
5. The report loads automatically

---

Ageing Buckets

By default the report uses 30-day intervals across 4 buckets:

Bucket	Meaning
1–30 Days	Bill is up to 30 days old — within normal payment terms
31–60 Days	Overdue — pay promptly to avoid late fees
61–90 Days	Significantly overdue — vendor may suspend credit
> 90 Days	Seriously overdue — risk of legal action or supply disruption

---

How Age Is Calculated

Age is based on the bill date, measured from the bill date to the As On date you set.

---

Summary vs Detail

Ageing Summary

VENDOR                1-30 Days   31-60 Days   61-90 Days   > 90 Days
─────────────────────────────────────────────────────────────────────
Supplier A            AED 8,000       —              —            —
Supplier B                —       AED 4,000    AED 2,000        —
─────────────────────────────────────────────────────────────────────
Totals                AED 8,000   AED 4,000    AED 2,000        —

Ageing Detail

Same structure but with one row per bill, showing the bill number, date, and outstanding amount in its age bucket.

---

Common Use Cases

• Payment run planning — identify which vendors to pay this week based on age
• Cash flow management — see total payables due in each period
• Vendor relationship management — prioritise long-standing vendors in the older buckets
• Period-end review — reconcile total payables against your Balance Sheet's Accounts Payable balance

---

Frequently Asked Questions

Only unpaid bills appear — is that correct?
Yes. Fully paid bills are excluded. Partially paid bills show only the remaining outstanding amount.

What does "As On" mean?
The report shows unpaid bills as of that date. Setting it to a past date lets you see what your payables looked like at that point in time.

How do I see all the bills for a specific vendor?
Run the Party Account Statement for that vendor — it shows every transaction in chronological order with a running balance.