Finance > Aged Debtors Report> Aged Debtors Report Filters
The General Filters tab on the Aged Debtors Report screen provides a range of filters that allow you to refine the data displayed in the report.
The table below outlines each filter and its purpose. By using these filters, you can customise the report to display only the information relevant to your needs, making it easier to review and analyse outstanding student fees.
| General Filters | Explanation |
|---|---|
| Dates based on Date | This option allows you to define how the system determines the age of outstanding invoices in the Aged Debtors Report. You will see two radio button options: Invoice Due Date Select this option to generate the report based on the due dates of invoices. The system will calculate how long each payment has been overdue from its respective due date. Invoice Date Select this option to generate the report based on the original invoice dates. The system will calculate the ageing of the debt starting from the date the invoice was issued, regardless of its due date. |
| As on Date | Select the As on Date from the calendar. This date is typically set to today’s date and determines the point in time at which the system calculates outstanding balances for the report. |
| Campus | Select a specific campus or select multiple campuses for your RTO if you are submitting this report for multiple campuses. |
| Program | Select a specific campus from the list, or choose multiple campuses if your RTO operates across multiple locations and you wish to include them in the report. This allows the report to reflect data relevant to the selected campus or campuses. |
| Enrolments to include | Use this option to specify which enrolments should be included in the report. You can select one or both of the following tick boxes: Started – Includes students with active or ongoing enrolments. Finished – Includes students who have completed their enrolments. Tick the relevant boxes based on the enrolment statuses you wish to include in the Aged Debtors Report. |
| Show accounts in credit | Tick this checkbox to include student accounts that have a credit balance in the report. This allows you to identify accounts where the amount paid exceeds the amount owed. |
| Sort By | Please see TEAMS Basics |
| Asc/Desc | Please see TEAMS Basics |
| Advance Filters | Explanation |
|---|---|
| Timetables and Classes | This is a magic search field that allows you to quickly find and select timetables and classes by typing either the name or code. As you type, the system will automatically suggest matching entries for easy selection. |
| Account Manager | This is a user code in TEAMS, and based on the User Code created, you can select multiple account managers from the dropdown |
| Enrolment Type | This is a user code in TEAMS, and based on the User Code created, you can select multiple enrolment types from the dropdown |
Click the Print icon to generate the report. The system will redirect you to the Report Dashboard screen, where you can view the report’s status. Once the report has been successfully generated, you can download it directly from the dashboard.
