Credit Facility Analysis
Facility terms extracted from the customer statement and compared with current exposure and post-dated cheques.
Visual Collection Analytics
Charts update automatically from imported Excel aging balances and manually entered collection records.
Aging exposure by bucket
Positive outstanding balances grouped by aging period.
Top customer exposure
Customers ranked by gross positive outstanding balance.
Exposure by collection priority
Priority considers invoice aging, balance value, collection status and SOA-level credit risk.
Expected collections by week
Positive balances expected within the next eight weeks from the aging date.
Invoice & Aging Collection Register
Enter individual invoices manually, import customer-level aging balances, or analyze a detailed customer statement from Excel.
| # | Customer | Account No. | Invoice No. | Invoice Date | Due Date | Invoice Amount | Amount Received | Outstanding | Overdue Days | Aging Bucket | Source / Import Bucket | Status | Promised Date | Expected Collection | Priority | Owner | Next Follow-up | Notes |
|---|
Aging Analysis
Outstanding balances grouped by overdue status.
Customer Exposure
Total outstanding and overdue exposure by customer.
Follow-up Schedule
Suggested collection activity ordered by next follow-up date and priority.