alongside New under Outflows on the sub-menu on the left. Additional options will be displayed.Report of the payments for a specified period
From the Beneficiary Fund menu, click alongside New under Outflows on the sub-menu on the left. Additional options will be displayed.
Click New below Outflows. The Outflows Report screen will be displayed.
Capture or select the relevant details as follows:
|
From Date |
The date from which outflows must be extracted. The system defaults to the current date as being the From Date. Capture a new date if required. |
|
To Date |
The date up to which outflows must be extracted. The system defaults to the current date as being the To Date. Capture a new date if required. |
|
Include Year to Date |
Click the check box to include year to date figures. |
|
|
The email address to which the extract must be sent. |
Click GENERATE REPORT.
The current report detail will be displayed on the lower portion of the screen.
A message will indicate once the job has been successfully submitted (and an e-mail will be sent to the e-mail address provided).
A The system will retrieve the Business Transactions from the Members’ BENEFITS account with the Accounting Activity REGULAR PMT and for which the Transaction Date is less than or equal to the To Date and greater than or equal to the From Date.
The system will read the Accounting Activity Association with a Purpose Type of OUTFLOW REPORT and retrieve the Business Transactions with the Accounting Activities associated to REGULAR PMT.
For each Membership for which Business Transactions are retrieved, the system will find the Paycentre (Previous Fund) to which the Membership is linked and find the Benefit Type (Product) on the Membership Payment record linked to the Membership.
The Business Transactions per combination of Benefit Type and Paycentre will be summed.
B The number of Memberships for which transactions were retrieved per combination of Benefit Type and Paycentre will be counted.
C The average value per Benefit Type and Paycentre (A / B) will be calculated.
If the value for Include Year to Date is Y, the system will read the Financial Year-End on the Scheme Details and:
D The Business Transactions as per above but for which the Transaction Date is less than or equal to the To Date and Greater than the last Financial Year-End will be retrieved.
For each Membership for which Business Transactions are retrieved, the system will find the Paycentre (Previous Fund) to which the Membership is linked and find the Benefit Type (Product) on the Membership Payment record linked to the Membership. The Business Transactions per combination of Benefit Type and Paycentre will be summed.
E The number of Memberships for which transactions were retrieved per combination of Benefit Type and Paycentre will be counted.
F The average value per Benefit Type and Paycentre (D / E) will be calculated.
Click View below Outflows. The Report Selection screen will be displayed.
The following columns are displayed:
- Timestamp
- Date Captured
- Report Type
- Sequence Number
- Action
To select a report, click on the hyperlinked display in the Action column alongside the appropriate report.
The Report Selection screen will be displayed.
The following columns are displayed:
- Fund / Product
For the Month
- Number of Accounts
- Capital Received
- Average Value
Year to Date
- Number of Accounts
- Capital Received
- Average Value
Previous Year
- Number of Accounts
- Capital Received
- Average Value