Edition: Enterprise
User level: Director and above
The Financials dashboard will assist you in reporting on aged debtors and aged WIP so you can easily keep track of your finances. You can filter the financials dashboard by Office and also choose to include invoices that are 'not due' yet.
Aged WIP by Ageing Category
The Aged WIP by ageing category will show aged WIP > 60 days and the customised age ranges (>60 days, >90 days, +90 days). These represent the amount of invoices that have been issued but not yet paid.
In this case WIP is the total chargeable value including transactions in WIP or draft invoice status, excluding non billable stages.
Aged WIP per Project Manager, Client or Project by Ageing Category
This is Aged WIP simply grouped instead by an alternative factor including Project Manager, Client or Project, although still in the ageing debtor categories that have been set up in Configuration.
Aged Debtors by Ageing Category
The Aged Debtors by ageing category will show debtors > 60 days and the customised debtor ranges (>60 days, >90 days, +90 days). This is sum of invoice owing including tax, where the invoice status “Owing", and is categorised by aged debtor categories. An ageing category is defined in Organisation > Configuration Settings. How overdue an invoice is, is also calculated in Organisation > Configuration Settings, but also could be calculated from invoice date or due date.
NOTE: To include "not due" category you will need to enable the filter which is located in the bottom right corner of the dashboard report. Not due will only apply to the Organisations which are calculating their aged debtors using the invoice due date.
Aged Debtors by Project Manager, Client or Project by Ageing Category
This is Aged Debtors simply grouped instead by an alternative factor including Project Manager, Client or Project. The data is still shown within the ageing categories. It's the sum of an invoice owing (including tax), where the invoice status "Owing".
Metric Definitions
Metric | Definition |
WIP Total | The sum of Transaction Value where the Transaction Status is ‘WIP’ or ‘Draft Invoice’ excluding the ‘Internal’ project. |
WIP > 60 Days | The sum of Transaction Value where the Transaction Status is ‘WIP’ or ‘Draft Invoice’ excluding the ‘Internal’ project and the Transaction Date is 60 days or greater from today. |
Debtors Total | The sum of Invoice Owing Inc Tax. |
Debtors > 60 Days | The sum of Invoice Owing Inc Tax where the ‘Invoice Date’ is 60 days or greater from today. |