finance – Page 4 – OLD SITE

Fees Overdue Report

25 May 202322 May 2023 by Siddharath Dugral

Main Dashboard > Finance Menu > Fees Overdue Report

The Fee Overdue Report will help you to manage overdue fees efficiently for students who have not paid their tuition fees within the specified deadline. It provides details on total overdue fees, commission, net overdue (after commission deduction), and the remaining amount owed. This report facilitates tracking and assessment of outstanding balances and enables timely fee recovery.

The purpose of the fee overdue report is to identify students who are behind on their payments and take appropriate actions to collect the outstanding fees. This may involve sending reminders or notifications to the students.

Fee Overdue Report Filters

Fee Overdue Report Data columns

Fee-Overdue-Report-Download

Invoices Report Filters

23 May 202322 May 2023 by Siddharath Dugral

The General and Advance Filters tab on the Invoices Report screen provides a list of filters that can be used to refine the data displayed in the report.

Below is a table that shows the filters and their explanations: Using these filters, you can customise the report to show only the information that is relevant to your needs, making it easier to analyse and take action based on the report data.

General Filters	Explanation
Report Based on	You will see three radio buttons under this section: *Invoice Date: When you select this button, the system will print invoices based on invoice dates Invoice Due Date: When you select this button, the system will print invoices based on the invoice due date Invoice Creation Date*: When you select this button, the system will print invoices based on the invoice creation date
Report Start Date	Select the report start date from the calendar icon.
Report End Date	Select the report end date from the calendar icon.
Campus	Select a specific campus or select multiple campuses for your RTO if you are submitting this report for multiple campuses.
Program	This is a magic search field and you can search for multiple Programs by typing the Program Code.
Fee Type	Select multiple Fee types from the dropdown field
Enrolments to include	You can select multiple types of enrolments such as Started/To Start and Finished/To Finish or select both under this field.
Include Cancelled Invoices	Check this tick box to include canceled invoices in the report.
Group By	Select a specific campus or multiple campuses for your RTO if you submit this report for multiple campuses.
Sort By	Please see TEAMS Basics
Asc/Desc	Please see TEAMS Basics

Advanced Filters	Explanation
Timetables and Classes	You can select the timetables or classes from the magic search field.
Include zero balance statements	Check this tick box to include zero balance statements in the report.
Enrolment Type	Select multiple Enrolment type from the dropdown field.
Enrolment Outcome	Select multiple Enrolment outcome from the dropdown field.
Agent	You can search and select the Agent from the magic search field

Select the “Print” Icon to generate the report, the system will direct you to the report dashboard screen. You can see the report status over there if it’s generated or not. Once it’s generated, download the report.

Fee Transactions Report Data Columns

22 May 202319 May 2023 by Siddharath Dugral

The Below table will show you the columns and their explanation that will get printed in the generated report.

Columns	Explanations
Student No	Student Number generated by TEAMS
Student Name	Student (First name)(Middle name)(Last name)
Enrolment No	Enrolment Number generated by TEAMS
Start Date	Start date of the enrolment
End Date	End date of the enrolment
Visa Type	The visa type will print under this column in the generated report
Campus Code	The system will show you the campus linked to the enrolment
Program	Program Name under which the student is enrolled
Fee Date	This column will show you Fee Date
Fee Name	The Fee Name will show under this column
Transaction Type	The Transaction type that you have selected on the filters screen
Transaction No	The Transaction number as per the transaction type selected on the filters screen
Discount	Discount amount made for the fee
GST Amount	The GST amount will print under this column
Debit	This column will print the Debited amount
Credit	This column will print the Credited amount
Transaction Creation Date	The transaction creation date will print under this column
Agent Commission Ex. GST	The agent commission amount exclusive of GST amount will print under this column
Transaction Due Date	The Transaction due date will print under this column
Transaction Date	The date of the Transaction will print under this column
Enrolment Type	Type of enrolment will print under this column
Agent Name	Agent name linked with the enrolment
GST on Commission	GST amount on agent commission
Bank Date	Bank type will print under this column
Enrolment Status	Status of the enrolment such as started, Not Yet Started
Enrolment Outcome	The enrolment outcome will print under this column

Fee Transactions Report Filters

24 May 202319 May 2023 by Siddharath Dugral

The General and Advance Filters tab on the Fee Transactions Report screen provides a list of filters that can be used to refine the data displayed in the report. Below is a table that shows the filters and their explanations: Using these filters, you can customise the report to show only the information that is relevant to your needs, making it easier to analyse and take action based on the report data.

General Filters	Explanation
Transaction Types	You can select multiple transactions types such as Invoices, Negative Invoice, Receipts, Refunds, Transfers or select All under this field
Report Start Date	Select the report start date from the calendar icon.
Report End Date	Select the report end date from the calendar icon.
Campus	Select a specific campus or select multiple campuses for your RTO if you are submitting this report for multiple campuses.
Tansactions Dates Based on	You will see three radio buttons under this section: *Transaction Date: When you select this button, the system will print transactions based on transaction dates Transaction Due Date: When you select this button, the system will print transactions based on the transaction due date Transaction Creation Date*: When you select this button, the system will print transactions based on the transaction creation date
Program	This is a magic search field and you can search for multiple Programs by typing the Program Code.
Include Cancelled Invoices	To view cancelled invoices in the report, select the option. However, cancelled invoices for enrolments where the cancel enrolment function was used will only be shown if the tick box for including cancelled enrolments is also selected.
Include Cancelled Enrolments	Selecting the cancel enrolment function includes cancelled enrolments with relevant transactions that meet selected parameters. However, if enrolment outcome is set as cancelled without using the cancel function, they won’t be included unless they meet all other report parameters.
Group By	Please see TEAMS Basics
Sort By	Please see TEAMS Basics
Asc/Desc	Please see TEAMS Basics

Advanced Filters	Explanation
Timetables and Classes	You can select the timetables or classes from the magic search field
Enrolment Type	Select multiple Enrolment type from the dropdown field
Enrolment Outcome	Select multiple Enrolment outcome from the dropdown field
Agent	You can select the Agent from the magic search field

Fee Transactions Report

25 May 202319 May 2023 by Siddharath Dugral

Main Dashboard > Finance Menu > Fee Transactions Report

The Fee Transactions report provides information about the financial transactions related to student fees. It includes transaction dates, invoice and receipt amounts, agent invoices, and commission amounts. This report assists in tracking transactions accurately, maintaining financial records, and facilitating data-driven decision-making. Overall, the Fee Transactions Report provides detailed information for managing financial transactions effectively.

Fee Transactions Report Filters

Fee Transactions Report Data Columns

Fee-Transactions-Report Download

Aged Debtors Report Data Columns

22 May 202319 May 2023 by Siddharath Dugral

The Below table will show you the columns and their explanation that will get printed in the generated report.

Columns	Explanations
Student No	Student Number generated by TEAMS.
Enrolment No	Enrolment Number generated by TEAMS.
Student Name	Student (First name)(Middle name)(Last name).
Invoice Creation Date	Date when the invoice is created.
Timetable	The invoice date will print under this column.
Start Date	Start date of the enrolment.
Agent Name	Agent linked with the enrolment.
Campus Name	The system will show you the campus linked to the enrolment.
Program	Program Name under which the student is enrolled.
Invoice Date	Invoice date will print under this column.
Enrolment Status	The Enrolment status will print under this field.
End Date	The type of enrolment will print under this column.
Nationality	Nationality of the student.
Enrolment Type	The type of enrolment will print under this column.
Payment Plan	The system will print yes or no if there is any payment plan linked with this enrolment.
Invoice No	Invoice number will print under this column.
Invoice Due Date	Due date of the invoice will print under this column.
Total Due Date	The total amount due will print under this column.
Total Due	The total amount due will print under this column.
0-30	This column will display the amount of aged debtors overdue within 0-30 days.
31-60	This column will display the amount of aged debtors overdue within 31 to 60 days.
61-90	This column will display the amount of aged debtors overdue within 61 to 90 days.
90+	This column will display the amount of aged debtors overdue for more then 90 days.
Over Paid Amount	Over Paid amount will print under this column.
Enrolment Outcome	Enrolment outcome will print under this column.
level of Student	The level of student will print under this column.
Visa Type	The visa type will print under this column in the generated report.
Local Address	The local address of the student.
Mobile No	Mobile number of the student.
Email Address	Email address of the student.
Secondary Email Address	Secondary email of the student.
Phone No	Phone number of the student.
DOB	Date of birth of the student.
Payment Type	Payment type .
Student Period Start Date	Study period start date will print under this column.
Student Period End Date	Payment type.

Aged Debtors Report Filters

22 May 20234 May 2023 by Siddharath Dugral

The General Filters tab on the Aged Debtors Report screen provides a list of filters that can be used to refine the data displayed in the report.

General Filters	Explanation
Dates based on Date	You will see two radio buttons under this section: *Invoice Due Date* – When you select this, the system will print the report based on the Invoice Due Date. *Invoice Date* – When you select this radio button, the system will print the report based on the Invoice Date.
As on Date	select the As on date from the calendar which is today’s date.
Campus	Select a specific campus or select multiple campuses for your RTO if you are submitting this report for multiple campuses.
Program	This is a magic search field and you can search for multiple Programs by typing the Program Code.
Enrolments to include	You can include enrolments such as Finished and Started tick boxes, Select Enrolment to include, Finished and Starter
Show accounts in credit	Select this check box to show accounts in the credit
Sort By	Please see TEAMS Basics
Asc/Desc	Please see TEAMS Basics

Advance Filters	Explanation
Timetables and Classes	This is a magic search field and you can search for Timetable and Classes by typing the name and Code.
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

Select the Print Icon to generate the report, the system will direct you to the report dashboard screen. You can see the report status over there if it’s generated or not. Once it’s generated, download the report.

Aged Debtors Report

25 May 202326 April 2023 by Siddharath Dugral

Main Dashboard > Finance Menu > Aged Debtors Report

The Aged Debtors report is a financial report that provides you with an overview of the outstanding fees owed by students.

The report will assist the finance department in monitoring and managing outstanding fees owed by students. It allows you to identify which students have overdue payments, how long the payments have been outstanding, and the total amount owed by each student.

The report typically categorises the outstanding receivables into different time periods, commonly 30 days, 60 days, 90 days, and over 90 days. Each category represents the age of the debt from the invoice due date, indicating how long it has been outstanding. The report shows the total amount owed in each category.

Aged Debtors Report Filters

Aged Debtors Report Data Columns

Aged-Debtors-Report Download

Fee

20 April 2023 by Sukhchain Singh

Main Dashboard > Finance > Fee

This screen is called the Fee Welcome screen and it will show you the list of active Fees in the grid that is already in your database. You can search for the Fee by the Code or Name of the fee in the search field, you can select Fee Type from the drop-down list, you can select the Object Type from the drop-down list and also if you want to see any inactive fees then you can select the Include inactive fees tick box.

You can select the +Add button to add the new fee to the system.

Finance Reports

18 August 202320 April 2023 by Mani Gill

Below is a list of all the reports available under this menu option in the system. You can see the name of the report with an icon that has the letters CSV in it. Generally, all reports in the system generate a CSV (Comma-separated values) file.

Each report listed below is a link to a post where you can understand the report, and its parameters and view an example of the report.