What does the debtor days column do on the aged debtors report?
Article ID
ias-1807
Article Name
What does the debtor days column do on the aged debtors report?
Created Date
3rd December 2004
Product
IRIS Time and Fees
Problem
What does the debtor days column do on the aged debtors report?
Resolution
There is an optional debtor days column available on the aged debtor report.
This calculates the debtor days using:
Debtor days = (Account balance/Total amount of invoices) x Time Span in days
The time span is calculated by the number of units entered on the options screen of the aged debtors. For example: days, months, or periods. If not already days, the unit entered is converted into days.
If you select to age in periods, then the end date is the last date in the current or
specified period. The start date is the start date of the earliest fees period calculated from what is in the Time Span field. This uses the “actual dates” entered against each Fees Period.
If you select to age in months or days, the end date is today or the end date that you have entered. The start date is the end date, subtracting the Time Span. Therefore the Time Span is always the end date minus the start date.
The Total amount of invoices are the invoices raised between these two dates.
The Account balance is the account balance at the end of the period the end date falls in.
We are sorry you did not find this KB article helpful. Please use the box below to let us know how we can improve it.