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 shows aged WIP broken down into customisable age ranges (e.g. >60 days, >90 days). It represents the total chargeable value of work that has not yet been invoiced.
WIP is calculated as the total chargeable value including transactions in WIP or draft invoice status, excluding non-billable stages.
Aged WIP by Project Manager, Primary Contact or Project.
Shows aged WIP broken down by Project Manager, Primary Contact, or Project, grouped by the ageing categories set up in Organisation > Configuration Settings.
Drill down through these options to see WIP values by Project Manager, Primary Contact, or Project.
Aged Debtors by Ageing Category
This chart shows aged debtors broken down into customisable age ranges (e.g. >60 days, >90 days). It represents the sum of invoice amounts owing, including tax, for invoices with a status of "Owing", categorised by ageing category.
Ageing categories are defined in Organisation > Configuration Settings. This is also where you set how an invoice's overdue status is calculated, either from the invoice date or the due date.
Note: To include the "Not Due" category, enable the filter in the bottom right corner of the dashboard. This filter only applies to organisations that calculate aged debtors using the invoice due date.
Aged Debtors by Project Manager, invoice or Project by Ageing Category
Shows aged debtors broken down by Project Manager, Client, or Project, grouped by the ageing categories set up in Organisation > Configuration Settings.
Drill down through these options to see debtor values by Project Manager, Client, or Project.
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. |