Calculates Debtors/Credits Balance and the ageing of Debtors up to the selected date.

NOTE: 

Invoices that were outstanding on the specified 'At Date' are included, even if they've been paid since.

Filters results to include only matters assigned to any of the selected Billing Categories. By default, all Billing Categories are selected.

Includes the following five filters, which work together to refine matters. Only matters that meet all selected staff criteria in their specified roles will be displayed.

• Inc. Inactive Staff: Provides an option to either include or exclude Inactive Staff Members from the lists of 'Staff Responsible', 'Staff Acting', 'Staff Assisting' and 'Credit'. 

NOTE:

• • • A Staff member is considered Inactive if their Current Staff Member option is togged off under the Access & Permissions in the Staff Details window (Menu > Settings > Application Settings > Firm > Staff > Members).
    • The below four staff lists dynamically update based on the 'Include Inactive Staff' option setting.
• Staff Responsible: Filters results to include only matters where the selected staff member(s) are assigned as the Person Responsible. All staff members are included by default.
• Staff Acting: Filters results to include only matters where the selected staff member(s) are assigned as the Person Acting. All staff members are included by default.
• Staff Assisting: Filters results to include only matters where the selected staff member(s) are assigned as the Person Assisting. All staff members are included by default.
• Credit: Filters results to include only matters where the selected staff member(s) are assigned as the Credit. All staff members are included by default.

NOTE:

All four filters must simultaneously match for a matter to be included in the report. Depending on your needs, you can keep one or more of these filters in their default 'All Selected' setting. For example, if you want the report to show all matters where the Acting Staff is Staff A, select Staff A under 'Staff Acting' while leaving the other three filters set to 'All Selected'.

Filters results to include only matters assigned to any of the selected Reporting Groups. By default, all Reporting Groups are selected.

Provides the option to Select All invoice statuses or limit the invoices listed to certain status(es):

• Draft Unapproved
• Draft Approved
• Printed Sent (Final)

Includes the following display option: 

1. Phone No: 

• Yes: Includes debtor phone numbers within the 'Debtor' field in the report.
• No: Excludes debtor phone numbers within the 'Debtor' field in the report.

2. Group By: Offers the following grouping options:

• None: No additional grouping is applied.
• Billing Category
• Client
• Credit
• Debtor
• Matter Type
• Reporting Group
• Staff Acting
• Staff Assisting
• Staff Responsible

3. Expand Row Groups: Provides an option to expand all row groups, displaying details down to the level of individual invoices.

The name of Debtor(s) on the matter.

NOTE: 

• If the 'Phone No' display option is set to Yes, the field will include the debtor phone number.  
• In most cases, a matter's Debtor is the same as its Client, but it can also be assigned to a different party. If you would like to set a different party already listed in the Matter Table, go to the Matter Table, right click the party and then click 'Set Debtor'.

Provides the following information: 

• The matter description set in the Matter Type window.
•  Debtor Note, if there is any. 

NOTE:

Debtor Note is based on the Debtor Comment entered under the Accounting tab of the Matter Details window. 

The transaction date of the invoice. The field is only available when the row group is expanded. 

The transaction number of the invoice. The field is only available when the row group is expanded. 

Displays the following information:

• The total Debtor balance for the matter as of the specified 'At Date', calculated by subtracting the matter's Credits amount from its total outstanding invoice balance.
• If the list is expanded, the field also displays the amount for each invoice or Credit under the matter. 

The total outstanding invoice balance.

• If the list is expanded, the field displays the total outstanding amount of each invoice.

The total amount of Credits on the matter.

Lists the debtor’s value based on their ageing period (e.g., Current, >30 Days, >60 Days or >90 Days). 

NOTE:

• The Ageing Period refer to the number of days the invoice has remained unpaid since its transaction date up to the 'At Date'. The Ageing Period will be updated based on your input for the 'At Date'.
• Ageing Periods catetories can be customised via: LEAP Menu > Settings > Application Settings > Accounting > Reports.