Introduction Integrator Student Debtors
Subsystem {FRM-21}
-
GENERAL INFORMATION
This
is the
User
Manual
for the
ITS Student
Debtors Subsystem, also known as the
Student
Accounts Subsystem. It is one of a series of
user and technical
manuals that is available for the ITS systems.
The contents of this subsystem are:
Operate Subsystem |
Maintain Subsystem |
Code Structures |
Correspondence |
3rd Party Payments |
Vouchers |
Debt Collection |
The reader is referred to
Section
3 for an overview of this subsystem.
It is assumed that the reader is already familiar with the
general
operation of the menus and the keyboard. These
matters are fully
discussed in the “
Operational
Aspects
of ITS Systems - Integrator" Manual.
The reader is reminded that the
copyright
of the ITS systems and
documentation remains with ITS, and that users thereof are
contractually prohibited from providing information thereof to third
parties, such as other educational institutions.
-
OVERVIEW OF FINANCIAL
SYSTEM
The
ITS Financial
System consists of the following
modules:
Starting
Menu
Option |
1st
Characters of
Subsystem
Menu Options |
Subsystems |
{FRM-1} |
FCT% |
Counter
Subsystem |
{FRM-2} |
FCM% |
Mail Recording |
{FRM-3} |
FAC% |
ACB System |
{FRM-5} |
FEBC |
Electronic Bank Conversion |
{FRM-6} |
FPME% |
E-Procurement B2B Vendors |
{FRM-7} |
FPM% |
Procurement Management |
{FRM-21} |
FSA% |
Student Accounts |
{FRM-22} |
FBL% |
Bursaries and Loans |
{FRM-23} |
FAR% |
Accounts Receivable |
{FRM-24} |
FSDC |
Debt Collection Interface |
{FRM-27} |
FCS% |
Code Structures |
{FRM-28} |
FGL% |
General Ledger |
{FRM-29} |
MEB% |
Income and Expense Budgeting |
All of these modules are
fully integrated
with one another, and also
with the other ITS Systems such as Human Resources, Student
Information, and Asset Inventory. More details on the individual
modules are found in the appropriate user manuals.
A
comprehensive
system
of access
control applies
to these modules
(refer to manual of options {
USERS-2,
3,
4 &
5} and {
FCSM-4 &
5} for more detail)
-
OVERVIEW OF STUDENT
ACCOUNTS SUBSYSTEM
The
subsystem is accessed via {FRM-21} of the Financial System, and
provides on-line input and query facilities for student academic and
residence fees, deposits and other debtor transactions.
Application
The facility to generate quotation when students applied.
Academic and Residence
Registration
Student fees are automatically raised during the registration process.
This facility allows statements, registration confirmations,
student cards etc. to be produced when students are registered.
Study Guide
The cost of study material is automatically raised on the student
account if the study material is not requested/issued free of charge.
Student Account Fees
The subsystem calculates fees (E.g. academic, residences), applies
payment agreements, and generates student accounts and
statements. It
establishes in a single source a financial picture for each student
including all deposits, charges, payments, adjustments and
disbursements. It also handles the necessary accounting
controls
and links to the General Ledger, Counter, Cashbook, Procurement
Management, Card,
Costing, Payroll, Library and Student Subsystems. Different payment
agreements
can be negotiated with students and aging is done relative to
individual agreements.
Student Account Deposits
Deposits payable by a student forms part of his overall account but
separate records are kept of deposits by differentiating between
deposit and fee account types.
Student Account Structure
A student account has four level structure. After the second level it
is mainly for internal use, although some client it use to inform the
student via the statement.
The first level is divided in a Fee or Deposit account.
Fee is the mainly debtor
and deposit the creditor.
The statement program does not consolidate them in one statement, they
are printed either separate or if in one document fist the deposit and
then the fee account.
Each first level account may have multiple account types on the second
level.
There are many reason way
the client needs this function. The reason may be:
To have different control
account for balance sheet purpose.
To distinguish between the faculty and/or department debtors.
To distinguish between the paying parties of the contract, not payable
by the student is not displayed to the student.
Etc.
To nullify this function
the client must create only one account type.
Each Account type may have multiple payment agreements on the third
level.
Payment agreement
Specify the aging or
forecast of payment.
Can be payable parallel or
sequential regardless of the account type.
Can be set for specific reason to cater for student needs or specific
transactions.
The Last level is the
student/debtor transactions.
Each transaction is like
with a student number, account type and payment agreement.
There is a exception where the payment agreement is null. In these case
the system will control that the student account type combination is
always in credit or zero.
Statuses
A powerful way to set indicators on the student or student account type.
The system is sensitive for certain actions linked to the status.
A number of reports can be run where specific status/es is use to
select data.
Reports
The
subsystem produces
several reports, varying from student statements
to audit reports.
Journals
There
are two ways in
which a student's account may be debited or
credited, namely:
- Manual
journals via a journal screen {FSAO-1}
and other options.
- Automatic
journals
which are triggered by a variety of specific events.
To
ensure
the automatic debiting and crediting of an account, the following
information must be specified correctly:
a) |
Cost
Centres |
{FCSO-1} |
b) |
General Ledger
Accounts |
{FCSO-3} |
c) |
General Ledger
Allocations |
{FCSO-6} |
d) |
Transaction
Types |
{FCSO-7} |
e) |
Financial Debit
Values |
{FSAM-1} |
f) |
Cancellation
Credits |
{FSAM-1} |
g) |
Transaction
Events |
{FSAC-21} |
h) |
Maintain System
Cycles |
{SMNT-2} |
Automatic journals are
fully discussed in this manual. Actions
are recorded in a log file that can be printed under
{
FSAMR1-1}.
User procedures should be established to reconcile this file with the
actual transactions or lack thereof.
Every
institution must
decide whether students will be debited per
subject or per qualification. The system can handle either of
these two methods.
Debiting per qualification and/or
subject offers
significant advantages in view of the
automatic journalising capabilities of the system, and also because a
percentage increase in tuition fees can be handled easily by merely
setting the norm (i.e. standard) cost for a subject.
Commissions, Royalties and
Institutional fees
Can setup, maintain and pay:
Commissions for agent
student recruitment.
Royalty responsibility for other tertiary institutions.
Institutional fees between tertiary institutions.
Contract
Maintaining
contract between the tertiary institutions and other entities/parties.
Up to two entities/parties can be involved, included the student.
A Contract can:
Control maximums.
Control Qualification and Subject registration.
Split the fees between the entities/parties and/or the student.
Do premiums/discounts on fees.
3rd Party Payments
Fees for 3rd party payments can be maintained on the fees structure and
raised during registration as accruals.
As soon as the student academic
achievement
reaches the level of the 3rd party rules, payments and reports can
be generated for the 3rd party, using the accruals or it can be to
the expense of the client
Vouchers
Marketing recruitment, incentive, etc. voucher can be printed and
handed out to students.
The system maintaining the voucher definition and processing on the
student account.
Bursary and/or Loans
Awarded amounts is process to the student account.
Correspondence
The subsystem maintain and produce correspondence between the student
and client.
Debt Collection
The subsystem maintain and do processing of overdue student accounts
for the handover to the collection agent.
-
LINKING WITH OTHER
ITS SYSTEMS
The
Integrator systems are
designed to eliminate the entering of duplicate
information in different systems, which causes the systems to be
integrated with and interdependent upon one another. The
implications for the Student Debtor Subsystem will be
discussed
in the rest of this Section.
- Information Obtained from other Systems
The
debits and credits
generated by the Financial System are posted to
specific General Ledger Allocations, which must be pre-defined, in the
Financial Code Structure Subsystem.
The
Financial Systems are
driven by user-defined
Transaction
Types,
which are used whether a transaction is automatically generated or
manually inserted. Transaction types must be defined via
{
FCSO-7}
in the Financial Code Structure. By defining the most commonly
recurring types, the process of entering transactions is considerably
accelerated.
There
are some indirect
controls on the operation of this subsystem in
the sense that the System Cycles {
SMNT-2}
will control the time windows
during which debits may be raised.
- Information Supplied to other Systems
This
subsystem supplies
information for displaying on screens in other
portions of the Student System.
The
cost of qualifications
and
subjects is maintained in {
FSAM-1},
TAB -
Fee Values.
The subjects and qualifications are defined on the Academic Structure
in {
SACAD-13},
TAB - Offering Types and {
SACAD-14},
TAB - Offering Types respectively. A basic record consisting
of Qualification/Subject code and description is created in {
FSAM-1}
when the academic structure is updated, and the user, for fee
generation purposes, must complete this record. The data
elements
of the Academic Structure are not updateable in the finance
options. The cost of a qualification and a subject could
differ
between a variety of combinations, for example offering type, block
code and student type, requiring the maintenance of the fee structure
to be done at that level.
Laboratory deposits
that are required for specific subjects are
maintained in the finance subsystem and will be charged when the
subject is registered and a fee for laboratory is linked to the subject.
Residence fees are
maintained within this subsystem by linking a fee to
a residence if all the rooms will cost the same, or to a specific room
if the fees for the rooms differ. The fee linked to the specific
residence / room will be charged when the room is allocated to a
student.
-
NOTES TO USERS OF
NON-ITS
GENERAL LEDGERS
The Student Debtors Subsystem is fully integrated with the ITS General
Ledger Subsystem. If the latter is not in use at an
institution,
the interface between the Student Debtors module and the users' own
General Ledger must be created through an Interim Transaction File
(ITF), which may then be used to update the user's own
General Ledger
regularly.
Given
the file
specifications by the user, ITS can write a program to
create the ITF in the exact format required by the user's General
Ledger. If the latter has a Batch Journal Facility, this
offers
an easy way of importing the data; otherwise the user should write an
in-house program to update his own General Ledger from the ITF.
-
IMPLEMENTATION
SEQUENCE
Assuming that the information in other Systems and Subsystems exists as
described above and they are in the manuals of the manual links below,
the following sequence of prerequisite actions should
be completed within the Student Accounts Subsystem before student
accounts can be maintained. The client must implement where applicable
to there implementation:
Financial Code Structure
{FCS%}
This subsystem must be
fully installed.
Student Account Code
Structure.
Option |
Menu
Name |
Description |
{FSAC-1} |
Financial Status Code |
Work through the action of statuses and setup the
initial financial statuses required by the client. |
{FSAC-2} |
Payroll Regions |
Required if client have South African
Government (PERSAL) students. |
{FSAC-3
& 4} |
Commission Codes and E/d's |
If client has agents to recruit student and receive
commission. |
{FSAC-5
& 6} |
Royalty Codes and Levels |
To pay royalties to other institution. |
{FSAC-7
& 8} |
Institute Fees |
If payable on Student Fees. |
{FSAC-9} |
Interest Codes |
Charge interest on overdue student accounts, setup
interest codes. |
{FSAC-10,
11 & 12} |
Contracts |
If there is parties sharing the student account debt,
contracts may be necessary. |
{FSAC-21} |
Query Transaction Events |
Take note of all the SD fee structure events that are
available |
{FSAC-22} |
Query 3rd Party Audit
Trail Record Types |
Take note of all the 3rd party audit trail records
types available |
{FSAC-23
& 24} |
Transaction Type Groups
and Consolidation |
If the client going to use Student Statement option
{FSAOR2-8
or 9} this can help you to group the SD transaction and/or consolidate
them. |
Student Account Maintenance
Option |
Menu
Name |
Description |
{FSAM-3} |
Validation Control |
Set the financial validation functions to the clients
requirements |
{FSAM-24} |
Payment Agreement |
Student Accounts Subsystem has quit an unique way of
doing
aging. These payment agreements may differ up to and even in SD
Transaction level per student account type.
The client must setup payment Agreement to suit you requirements. |
{FSAM-31}
{FSAM-29}
{FSAM-30}
{FSAM-1}
{FSAM1-10}
{FSAM-6}
{FSAM-21}
{FSAM-4}
{FSAM-25}
{FSAMR2-1 up to 8} |
Cancellation Credit Codes
Navigable Fields for Fee Structure
Department Default Values
Financial Debit Values
Fee Weight Calc. on Subject Credit Value
Discounts
Fee Structure Validation
Curriculum Acct Types
Default Agreement Codes
Add and/or Remove a Key Field |
All option in the left hand column is part of the SD
Fee Structure.
They are listed, plus minus, in the sequence of implementation.
Inside each manual is ample information of its part and function in the
SD Fee Structure and also look at paragraph Procedure
Regarding Fees below.
To implement the client must work closely with the ITS financial
implementation
officer and ITS.
|
Student Account Operational
Option |
Menu
Name |
Description |
{FSAO-20} |
Student Debtor EP |
Adapt this single entry point screen to the client
requirement. The client can develop your own single entry
point
screens than is tailor to suit specific users or group of users. |
Student Account 3rd Party
Payments.
Not
mandatory
Option |
Menu
Name |
Description |
{FSATPP-1} |
3rd Party Codes |
Specify the 3rd parties to be payed and/or
notify |
{FSATPP-2} |
3rd Party Report Rules |
Make a study of the available 3rd party report rules
and decide which will suit you. |
{FSATPP-3} |
3rd Party Report
Definitions |
If the client has 3rd parties and 3rd party rule then
this setup is required. |
Student Account Voucher
Campaign
Option |
Menu
Name |
Description |
{FSAV-1} |
Voucher Campaign |
Specify the campaign voucher that is approved.
If
handed in by students, they will received credit on the student
account. |
Student Account Correspondence
Option |
Menu
Name |
Description |
{FCSO-1} |
Document Text |
Setup document text for correspondence option
{FCSOR1-%} |
{GMNT-5} |
Style Sheets |
Setup style sheets for correspondence option {FSCOM1-%} |
Option |
Menu
Name |
Description |
{FSDC-1} |
Debt Collection Parameters |
Specify the parameters to be used by option {FSDC-4} |
{FSDC-4} |
Debt Collection Flag
Students - Batch |
Setup the code structures required before you can run
the program. |
- RECOMMENDED SD FEE STRUCTURE IMPLEMENTATION
This action must be done
with your ITS financial implementation
officer and ITS.
Implement the academic structure and all other code structures that
needed to register a student for academic and/or residence or must be
as close as possible to final design. Cannot start with the SD
Fee
structure if the academic side is not sorted out.
In your current system there should be a code structure that is used in
registration and then result into student fees raised.
Practically note the
attributes used from registration that was passed on the the fees
raised program.
Map these attributes to the attributes of integrator registration.
Map the attributes of integrator registration to the navigable fields
of option {
FSAM-29} block
1 and this starts the fees structure implementation.
Above is very high lever guidelines, SD Fee Structure is normally
difficult and might be problematic to get to the same fee raised result
as on the previous system. Some compromises might be at the order of
the day.
-
RAISING DEBTS
This
Section discusses
the raising of debits during the following
processes, menu options being indicated:
- Handling Applications
- Academic Registration of
Students
- Second Semester
Re-Registration
- Residence Registration
- Vehicle
Registration
- Award
Qualification
- Handling Applications
- To debit
a student's account with an application fee, the
following steps must be followed:
- Set Transaction Event “01”
(“Enter
Application Information”) to (Y)es, and
link the
appropriate transaction code, with the indicator set to (D)ebit, to the
event through option {FSAC-21}.
- Enter the application information
(option {SNAPPA-1}).
On <COMMIT> the student's
account is
debited with the application fee specified on the transaction
code. It is possible to obtain an account for this student
through option {FSAOR2-1}
and a query could be made through option
{FSAO-7} to show this
transaction. In option {FSAOR2-2},
“Students
Balances”, these students will be treated
as
“students not registered”
- Produce a statement for the student (option {FSAOR2-1})
showing the application fee as a debit.
- To credit
the application fee to
students who have cancelled their applications, the
following steps are
required:
- Set Transaction Event “02”
(“Cancel
Application”) to (Y)es and link this
event
to an
appropriate transaction code (option {FSAC-21}).
- Enter the cancellation date on the student's application
information (option {SNAPPA-1}/{SNAPPA-3}).
- Query the status of the student's account (option {FSAO-7}).
- Academic
Registration of Students
Certain
fees can be
automatically generated during registration when
using options {
SREGAR-1},
{
SREGAR-2} and {
SREGC-5} if the following
procedures are adhered to:
- Set Transaction Event “03”
(“Register as
Studentt”) to (Y)es,
and link the
applicable
transaction code, with the indicator set to (D)ebit, to the
event. Do the qualification registration of a
student. On
<COMMIT>,
the system will debit the student's account
with the
default amount defined for the transaction code.
- Set Transaction Event “05”
(“Register for
Qualification”) to (Y)es, and link
an
applicable transaction code, with the indicator set to (D)ebit, to the
event. Do the qualification registration of a
student. If
the institution debits per qualification and the qualification cost for
the qualification/offering type combination was specified under
option {FSAM-1},
TAB - Individual
Residence Room Fee Weights, the system will debit the
student's account with that
particular amount on <COMMIT>.
- Set Transaction Event “07”
(“Register for
a Subject”) to (Y)es, and link
applicable
transaction codes (one for every examination type), with the indicator
set to (D)ebit,
to the event. Do the qualification
registration
of a student. If the institution debits per subject and the
subject/offering type costs were specified under option {FSAM-1}, TAB -
Individual
Residence Room Fee Weights, or a
default value was specified on the Transaction Type, the student's
account will be debited with that particular amount on
<COMMIT>ting the Subjects Block.
NOTE:
If the “Generate Subjects on Commit”
option in the Qualification Block is used, the student's account is
debited with the cost of the subjects on <COMMIT>ting the
Qualification Block.
- Set Transaction Event “17”
(“Register for
Laboratory Subject”) to (Y)es. Two
transaction codes can be linked to the event. The indicator of the one
set to (D)ebit
and (F)ee
and the other set to (C)redit
and
(D)eposit.
The system will debit the student's fee account
and
credit his deposit account with the laboratory deposit specified under
option {FSAM-1},
TAB - Individual
Residence Room Fee Weights, if such a deposit was
specified for that particular
subject/offering type combination.
- Set Transaction Event
“18”
(“Register for
Exemption Subject”) to (Y)es, and
link the
appropriate transaction code to the event. When a student is
registered for a subject for exemption purposes only, the student's
account will be debited with the default amount specified for that
transaction code.
- Second Semester
Re-Registration
If
a student who has been
enrolled during the first semester
must
re-register
during the 2nd semester (rather
than only enrolling for
more subjects), the following fees may be raised:
- Transaction Event “03”
(“Register as
Student”) will be in effect, and the
linked
transaction code will be used. Use option {SREGAR-1} to
register
the student again. The system will raise a registration fee
debit
on the student's account.
- Transaction Event “05”
(“Register for
Qualification”) will be in effect
and the
linked transaction type will be used. Use option {SREGAR-1}
to
register the student. The normal qualification fee as
specified
under option {FSAM-1},
TAB - Individual
Residence Room Fee Weights} will be raised.
- Set Transaction Event
“07”
(“Registration
Fees”) to (Y)es.
Do the
qualification
registration of a student. If the institution debits per
subject
and the subject/offering type costs were specified under
option {FSAM-1},
TAB - Individual
Residence Room Fee Weights, the student's account will be
debited with that particular
amount on <COMMIT>ting the Subjects
Block.
NOTE:
If the “Generate Subjects on Commit”
option in the Qualification Block is used, the student's account is
debited with the cost of the subjects on <COMMIT>ting the
Qualification Block.
- Residence Registration
- Set Transaction Event “13”
(“Residence Fee”)
to (Y)es,
and link an appropriate
transaction code, with the indicator set to (D)ebit, to the
event. The system will debit the student's account on
registration of a student in a residence through option {SREG-4},
provided that the cost of the residence rooms were specified under
options {FSAM-1},
TAB - Individual
Residence Room Fee Weights.
- Vehicle Registration
It
is possible to charge
a parking fee to a student's account, and to
update this fee every year by using the following procedures:
- Set Transaction Event “14”
(“Vehicle
Registration”) to (Y)es, and link an
appropriate
transaction code to the event. To trigger this fee, the
vehicle
registration number must be entered under option {FSAO-3}.
- Set Transaction Event “15”
(“Vehicle
Re-registration”) to (Y)es, and link an
appropriate transaction code to the event. To trigger this
fee,
the vehicle registration number must be entered into a field with a
“null” value. Thus, if a parking fee must
be
triggered again, the field must first be cleared and
<COMMIT>ted,
then the registration number must be entered again and
<COMMIT>ted.
- Award Qualification
- It is possible to raise a fee for the
rental of gowns against a student's account, by setting Transaction
Event “16”
(“Qualification
Awarded”) to (Y)es
and linking an appropriate transaction code to the event. Use
option {SSTUD7-2}, TAB -
Qualification Results, to enter the qualification result of the
student. When this option is <COMMIT>ted, the
fee will be
raised.
It is not possible for the
user to create any additional transaction
events. Any other fees to be debited against a student's
account
must be entered manually by way of a journal. It
such cases
the
Registration Section should advise the Financial Section, who will
enter the required manual journal.
-
RAISING CREDITS
This
Section discusses the
raising of credits during the following
processes:
- Change Student Qualification
- Delete a Subject from the
Registration Block
- Cancel Enrolment
- Cancel a Subject
- Cancel Enrolment
after Cancelling some Subjects
Certain
credits are
automatically triggered when the options as
discussed are used:
Note that
cancellations with regard to class fees, registration fees
and laboratory deposits will always take the cancellation liability as
specified into account. Option {FSAM-2},
“Cancellation
Credits”, must, therefore, be specified for a particular
cycle,
with a start/end date where the liability % will be applicable, before
cancellations of any nature are done.
- Cancel Enrolment and Correct
Erroneous Registration {SREGC-1}/{SREGC-3}
This
option is used when
a student was registered for the wrong
qualification, or whenever any information on the qualification block
was entered incorrectly.
- Set Transaction Event “20”
(“Cancel
Registration Fee”) to (Y)es, and link an
appropriate transaction code, with the indicator set to (C)redit, to
the event. Do the qualification changes and the system will
generate all financial credits for the student's current registration
fee, taking into account the cancellation credits.
- Set Transaction Event “21”
(“Cancel
Qualification Fee”) to (Y)es, and link an
appropriate transaction code, with the indicator set to (C)redit, to
the event. Do the qualification changes and the system will
generate all financial credits for the student's current enrolment,
taking into account the cancellation credits and deleting the
qualification and subjects enrolment from the student's academic
record.
- Set Transaction Event “22”
(“Cancel
Subject Fee”) to (Y)es, and link an
appropriate
Transaction Code, with the indicator set to (C)redit, to the
event. Do the subject changes and the system will generate
all
financial credits for the student's current enrolment, taking into
account the cancellation credits and deleting the qualification and
subjects enrolment from the student's academic record.
- Set Transaction Event “23”
(“Cancel
Laboratory Deposit”) to (Y)es. Two
Transaction
Codes can be linked to the event. On one the indicator must be set to
(C)redit and
(F)ee and on
the other to (D)ebit
and (D)eposit.
Do
the subject changes and the system will generate all financial credits
for the student's deposits, taking into account the cancellation
credits.
- The account will display all debits
raised originally, the credits passed when the enrolment was cancelled
and the new debits if the student registers again.
- Delete a
Subject from the Registration Block {SREGAR-1},
TAB - Subject Information
The
system will only
allow the user to delete a subject from the
enrolment record on the same day that the particular subject was
registered. To erase all traces of the subject's original
debit, the following procedure must be adhered to.
- Set Transaction Event
“08”
(“Delete
Subject Same Day”) to (Y)es, and link an
appropriate Transaction Code, with the indicator set to (C)redit, to
the event. Query the subject on the student's enrolment
record,
use <DELETE RECORD> to delete the subject, and
<COMMIT>.
- Cancel
Enrolment {SREGC-1}/{SREGC-3}
- If a
student was debited per subject,
the credits will be passed according to the liability set under
cancellation credits either per year, 1st semester or 2nd semester
subjects at subject level.
- If a student was debited
per
qualification, the system takes into account the cancellation credits
as specified for the year cycle and the date, when passing a credit.
- Cancel a Subject
{SREGC-3}/{SREGC-4}
- If a student was debited per
qualification, this option will not pass any credit to the student's
account. The credit, if any, will have to be passed manually.
- If a student was debited per subject,
this option will pass the applicable credit to the student's account
(taking the cancellation credits into account).
- Cancel Enrolment
After Cancelling Some Subjects
- If a student was debited per
qualification, the system does not take into account any credit passed
for the cancellation of a subject, but will pass the credits according
to the cancellation credits for the year cycle.
- If a student was debited per subject
and he cancels his enrolment after some subjects were cancelled
previously, the system will first check which subjects were already
cancelled, and pass credits only for the remaining subjects.
-
PROPOSED
BALANCING/RECONCILIATION PROCEDURES
-
GENERAL
Reconciliation
on the
Student Debtor Subsystem is very important, but
it is no simple process since most of the transactions are generated
automatically. The problem is not the reconciliation of
generated
transactions, but rather the confirmation that all transactions, which
were supposed to be generated, were actually generated. This
section is only meant to be a guideline, and the client
should
design their own procedures in consultation with their
auditors.
The interval and/or period of a reconciliation depends on the
procedures and requirements of the client.
The
reconciliation process
can be divided into 5 phases:
- Balancing of Inputs (Phase 1)
In
this phase the manual input transaction amounts is reconciled with
there source document amounts.
This is not a mandatory process.
It is a modern way of doing batch balancing of batch input.
The amounts processed ignore there Debit or Credit sign.
It is recommended to do this phase daily for processed data up to the
previous day.
Reports:
User Work Report {
FSAMR1-24} in summary.
Use detail if a user does not balance.
Transaction per Type {
FSAOR1-1}
in summary (Phase 2).
- Balancing Inputs with Generated Transactions (Phase 2)
It
is done on the same sheet as for phase 1.
With this you validate that the user work summary report balance with
the transaction type report. In other words make sure that the non
debit/credit values convert correctly to debit credit values.
Keeping a accumulation total that will be carried forward to phase 3 at
month end.
- Balancing of SD System and there GL Control Account
(Phase 3)
This
phase reconcile the SD System between the Transaction and the Student
Balances using three reports.
Reports
Transaction per Type {
FSAOR1-1} in summary
Audit Report {
FSAMR1-23}
For the subsystem balance Total Debit and Credit Balance {
FSAOR2-4}
Lastly the Transactions is reconcile with the General Ledger control
accounts.
Do phase 4 if the
transaction total is not equal to control account total.
Report
Summary Cost Centre Report
{
FGLOR1-4} for the SD
control accounts.
or
Summary Account Cost Report {
FGLOR1-24}
for the SD control accounts.
- Balancing SD with GL Control Account Summary
Transaction Type (Phase 4)
This
phase is only needed if the transaction total is not equal to SD
control account total.
Reports
Transaction per Type {
FSAOR1-1} in summary
Transaction per Type {
FGLOR1-21}
in summary exception report for the SD control accounts.
- Balancing Account Type with there GL Control Accounts
(Phase 5)
If
the client use different control accounts in the account type
definition, then this phase is need to reconcile the SD system with
each of the GL control accounts. It also assist to allocate the
imbalance of phase 4 to the correct control account if applicable.
Reports
Total Debit and Credit
Balance {
FSAOR2-4}
Summary Cost Centre Report {
FGLOR1-4}
for the SD control accounts.
or
Summary Account Cost Report {
FGLOR1-24}
for the SD control accounts.
-
PREPARATION FOR A NEW FINANCIAL YEAR.
It is important that the
institution reconciles the student accounts during the year and at
the end of a year, and it would be a requirement before the Ledgers can
be closed for year end. We shall assume that this
reconciliation
has been done.
A number of month before year end the
academic structure for the next year {
SACAD-3}
is created, this function also create the SD Fee structure for the next
year. Maintain the following option to ensure your SD Fee structure is
ready for next year applications and registration:
Other options that may have maintenance for the next year:
Each client must have there own business process to prepare for the
next year, it is not prescribe by Integrator..
History Of Changes
Date |
System Version |
By Whom |
Job |
Description |
29-May-2008 |
v01.0.0.0 |
Charlene van der Schyff |
t145484 |
New manual format. |
06-Jul-2009 |
v01.0.0.1 |
Ernie van den Berg |
t157364 |
Review the manual. |
05-12-2016 |
V04.0.0.0 |
Ntshabele Morgan |
T208911 |
Removed any reference to discontinued "Investment" and "Long Term Loans" Subsystems |