Debtors Age Analysis for SYSPRO is a Microsoft Power BI app for accounts receivable (AR) aging, aged debtors reporting and credit control on SYSPRO ERP, with charts that follow the International Business Communication Standards (IBCS). It calculates outstanding balances, overdue invoices and collections from SYSPRO invoice and payment history for any selected month-end.
One As Of Date slicer sets the reporting date for the whole report. When a past month-end is selected, every report page shows the debtors position as it stood on that date: the outstanding balance, the age of each invoice, the overdue amount and the amounts collected.
KPIs
Total outstanding, Not yet due and Overdue balances, with the change against the prior month-end
Overdue ageing: overdue amounts by days past the due date
Invoice ageing: outstanding amounts by invoice month
% Overdue and Due in next 30 days
Days sales outstanding (DSO), Collection effectiveness, Avg days delinquent and Avg days to pay
Planned collections against amounts collected, and balances rolled to older age buckets
Credit used, Credit available, Amount over limit and Days until limit reached
Drill-through from a customer to the open invoices and the payments allocated to them
Subscribe to our mailing list for insider news, product launches, and more.
Choosing a selection results in a full page refresh.
Opens in a new window.
Syspro® is a registered trademark of Syspro Software Ltd. Foresight SA is an independent company and is not affiliated with, endorsed by, or sponsored by Syspro Software Ltd.
