Receipts Report

Introduction

Receipts Report is present under TEAMS > Setup > Financial Reports II. This report is used to generate a list of student receipts which falls within the date range entered.

Following are the parameters which are present on the report parameter screen:-

GENERAL TAB

Print Based On – A user can select that what should be the date range criteria i.e. Receipt Date OR Create Date, etc. Based on this option the system will search for student receipts within the specified date range accordingly.

Report Start and End Date – This is a date range field and a user can enter a date range for report generation. Once a date range has been entered then the system looks for any student receipts which falls during the date range period specified by the user.

Bank Start and End Date – This is a date range field and a user can enter a bank date range for report generation. Once a date range has been entered then the system looks for any student receipts for which the bank date falls during the date range period specified by the user.

Enrolment Start Date – A user can enter a date in this field and only those enrolments will be picked up in the report whose enrolment start date matches the date range entered.

Visa Type – This is a multi-select option for which a user can select one or more visa types.

Campus Name – This is a multi-select option for which a user can select one or more campuses.

Timetable – This is a look up option from which a user can select a specific timetable/academic schedule for which this report has to be generated. The timetable listings in this look up option change depending upon the radio button selected i.e. Active, Inactive or Both.

Agent Name – This is a look up option from which a user can select a specific agent for which this report has to be generated and only those student enrolments will appear which are linked to the selected agent.

Username– This is a drop down option from which a user can select a specific username for which this report has to be generated and only those receipts will appear which have been created by that user.

Account Manager – This is a drop down option from which a user can select a specific account manager for which this report has to be generated and only those student enrolments will appear which are linked to the selected account manager.

Country – This is a drop down option and a user can select a specific country then only those student enrolments will appear which are linked to the selected country.

Enrolment Type – This is a multi-select option from which a user can select one or more enrolment types for report generation. The enrolment type user code listings in this look up option change depending upon the radio button selected i.e. Active, Inactive or Both.

Include Enrolments – This is a multi-select option and a user can select options such as STARTED, NOT YET STARTED and FINISHED. Depending upon the option selected, student enrolments will appear in the report.

Exclude Enrolments With Agent – This is a tick box and if selected enrolments which do not have any agent linked to them will not appear in the report.

Group By – This is a drop down option and a user can select how they wish to group the generated list of student enrolments i.e. By Campus Name, Course Name, etc.

Sort By 1 – This is a drop down option and a user can select how they wish to sort the generated list of student enrolments i.e. By Campus, Course Code, etc. User can also specify that whether they want to sort their search results in Ascending or Descending order.

Sort By 2 – This is a drop down option and a user can select how they wish to sort the generated list of student enrolments i.e. By Campus, Course Code, etc. User can also specify that whether they want to sort their search results in Ascending or Descending order.

Please Note – You cannot select same sort by option in Sort By 1 and Sort By 2. The selected option must be different.

Generate in CSV Mode – A new tick box ‘Generate in CSV Mode’ has been added on the Parameter screen for this report. While generating these reports, a user can tick this tick box, GENERATE and the report will be generated in .csv format.

Schedule Report Generation – A tick box for ‘Schedule Report Generation’ has been added in the report parameter screen for every report that can be generated server side. A user can tick this tick box and can select ‘Overnight’ or ‘Deliver By’ option. If ‘Overnight’ option is selected then the system would generate the report for the user overnight and if ‘Deliver By’ option is selected then a user has to define a date and time at which the report has to be generated in the future.

Please Note – The time which you are entering would be the QLD time because that’s where our servers are located.

IMPORTANT – Only those reports can be scheduled for future generation which are being generated on our servers (i.e. server side). Those reports cannot be scheduled for future generation which are being generated on your computer (i.e. client side).

Template – A user can select the report template from this drop down. Customised report templates can be added in the Report Template screen (TEAMS > Setup > Organisation > Report Template Screen) and selected from this drop down.

ADVANCED TAB

Payment Mode – This is a multi-select and a user can select one or more payment modes. Once selected only those receipts will appear in the report which are linked to the selected payment modes.

Once the report is generated, following are the columns which are printed in the report output:-

Bank Date

Receipt Date

Rect #

Stud #

Enr #

Student Name

Campus

Cricos Code

Course

Enrolment Type

Enrolment Start Date

Enrolment End Date

Started

Visa Type

Agent Name

Country

Account Manager

Timetable

Payment Type

Reference #

User

Process Date

Receipt Amount

Transfer Receipt Amount

Bad Debt Amount

GST on Receipt

Over Paid Amount

Surcharge Amount

Bank Charges

Total Gross

Receipt Amount

GST on Comm.

Comm. Deducted

Total Net Receipt Amount

Total Tuition Fee

Enrolment Balance

Notes

Invoice No.

Invoice Date

Due Date

Duration

ECOE #

Enrolment Date

Title

First Name

Last Name

Status

Bank Account Name