The trial balance produced using this facility contains all transactions, whether or not they have been posted.
A trial balance can also be generated from the Scheme Reports menu, but this version contains only transactions that have been posted. Refer to
Reports
Financial
Trial Balance
From the Enquiries sub-menu, select Trial Balance.
The JU2CB Trial Balance screen will be displayed.
Capture details for the screen as follows:
|
Scheme Code |
Click LIST to display the JU1BK List screen. Select a Scheme from the list and click SELECT. |
|
Purpose Class |
Click LIST to display the JU2AK Purpose Class List screen. Select an Purpose Class from the list and click SELECT. |
|
Transactions as at |
Capture the date of the transactions that must appear in the trial balance. |
The following trial balances may be selected from the sub-menu on the left.
Select Detailed Trial Balance from the menu. The JU2CB Trial Balance screen will be displayed.
Each Account Code displayed is a hyperlink. Click on the hyperlink to display all business transactions with a transaction date less than or equal to the effective date of the trial balance and greater than the scheme’s last financial year-end date. The JU2CB Business Transaction List screen will be displayed.
The following columns are displayed on this screen:
Accounting Activity
Membership
Monetary Amount
Unit Value
Transaction Date
Effective Date
Due Date
Reconciled Date
BT Type
Income Type
Income Type Description
Portfolio Code
Portfolio Description
Pay Centre
Document Number
Select Summarized Trial Balance from the menu. The JU2CB Trial Balance screen will be displayed.
Each Account Code displayed is a hyperlink. Click on the hyperlink to display all business transactions with a transaction date less than or equal to the effective date of the Trial Balance, and greater than the scheme’s last financial year-end date. The JU2CB Business Transaction List screen will be displayed.
The following columns are displayed on this screen:
Accounting Activity
Membership
Monetary Amount
Unit Value
Transaction Date
Effective Date
Due Date
Reconciled Date
BT Type
Income Type
Income Type Description
Portfolio Code
Portfolio Description
Pay Centre
Document Number
Select Summarized by Sub-Fund from the menu. The JU2CB Sub-Fund Trial Balance screen will be displayed.
Note:
This menu option will only be enabled when the pooling status for the scheme selected is MAIN UMBRELLA.
The system will sum the balances for each account and scheme with a status of SUB UMBRELLA that is associated to the scheme selected. The balances will be displayed per account and sub-scheme.
Click EXCEL to view the data in an Excel spreadsheet.
For examples of accounting transactions (T-accounts), refer to
Supplements
Accounting Transaction Examples