Oracle FLEXCUBE Investor Servicing provides an extensive reporting facility. You can query the database to obtain pre-defined reports relating to any aspect of fund management, entity management, transaction processing or security.
The reports are grouped into the following categories:
This chapter contains the following sections:
This section contains the following topics:
The reports in this section display data regarding the logging of activities performed by the users that access the Oracle FLEXCUBE system. These are mainly security management related reports.
This report will print the Activity Summary or Super Sheet of the fund for the day. It is printed on request. You can invoke the ‘Fund Activity Detail’ screen by typing ‘UTR00033’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Enter the search criteria and click ‘Ok’ button to generate the report.
Subscription
The sum of the total subscription, in units and amounts that have been made.
Switch To
The sum of the total Switch transactions, in units and amounts that have been made to this fund.
Total Subscriptions
The sum of the total Subscription, in units and amounts that have been made. This includes Subscriptions and Switch To this fund.
Redemption
The sum of the total redemption, in units and amounts that have been made.
Switch From
The sum of the total Switches, in units and amounts that have been made from this fund.
Dividends
The sum of the total Dividends, in units and amounts that have been declared.
Total Redemption
The sum of the total Redemption, in units and amounts that have been made. This includes redemption, switch from this fund, dividends.
Net
This is the Total Subscriptions minus the Total Redemption made.
This report is generated to view the details of the inactive users.
The ‘Inactive Users Report’ screen is as shown below. You can invoke the ‘Inactive Users List’ screen by typing ‘UTR00193’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Enter the search criteria and click ‘Ok’ button to generate the report.
In this screen, the following are the parameters for the generation of the report:
This report is generated to view the details of the inactive users. You can invoke the ‘User Profile Info’ screen by typing ‘UTR00192’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Enter the search criteria and click ‘Ok’ button to generate the report.
In this screen, the following are the parameters for the generation of the report:
This report is generated to view the details of the events logged by the user. You can invoke the ‘SMS event log report’ screen by typing ‘UTRPEVLG’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify the following details:
User ID
Optional
Select the user ID from the list of values. The list consists of all user IDs maintained in the system.
From Date
Date Format; Mandatory
Select From date from the adjoining calendar.
To Date
Date Format; Mandatory
Select To date from the adjoining calendar.
Format
Optional
Select the format from the drop-down list. The list displays the following values:
Output
Optional
Select the output from the drop-down list. The list displays the following values:
Print At
Optional
Select the printing location from the drop-down list. The list displays the following values:
Printer
Alphanumeric; 15 Characters; Optional
Specify the printer details from adjoining option list.
Enter the search criteria and click ‘OK’ button to generate the report.
This section contains the following topics:
Any information related to brokers in the system can be displayed by generating the reports in the reports in this section.
This report shows you the commission details for a broker, over a period, with summaries as well as fund-wise and transaction-wise groupings.
Also, this report shows you the value of the broker’s holdings in each fund, along with the CASA account balances.
The following details are displayed in the report:
In this section of the report, the Name, Code, Telephone and Facsimile Numbers, Mobile Number, Email Address and Postal Address of the concerned broker are displayed.
Also, the Last Paid On Date, which refers to the last commission payment date and the Next Payment On Date are displayed.
The VAT Registration Number is also displayed.
Here, the summary details of commissions that have accrued to this broker over the given time period are displayed. This includes the following information:
Here, the commission accrued will include the commission that has accrued from transactions for which the payment instruments have not been cleared, too. This portion of the commission is not paid out till the payment instruments are cleared.
The details of each commission payment are displayed here. Both Check as well as Transfer payments are displayed under the appropriate head.
For Check Payments, the following details are available for view:
For Transfer Payments, the following details are available for view:
The commission paid out will not include the commission that has accrued from transactions for which the payment instruments have not been cleared. This portion of the commission is not paid out till the payment instruments are cleared.
In this section, the details of commission in each fund, grouped according to transactions, are displayed. For each transaction that has resulted in a commission payment, the following details are displayed:
If the payment instrument for the transaction is not cleared, the commission as a result of the transaction is processed and accrued, but it is not paid out till the payment instrument is cleared.
In the final section of this report, the fund-wise balances held by each unit holder whose introducer broker is the broker for whom the report is being printed, are displayed. For each unit holder, the following details are displayed fund-wise:
The Grand Total of Holdings is the sum of all the total values of holdings for all unit holders across funds. This is also displayed in the report.
The ‘Broker Communique’ Report generation screen is as shown below. You can invoke the ‘Broker Communique’ screen by typing ‘UTR00107’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you must specify the following as mandatory sorting parameters for the generation of the report:
After making your specifications, click ‘Ok’ button.
This report displays all information regarding the Broker that you have entered in the broker's record, in the ‘Broker Maintenance’ screen. The information is logically grouped under the following heads:
In this portion of the report, the following details are displayed:
In this portion of the report, the following details are displayed:
In this portion of the report, the following details are displayed:
In this portion of the report, the following details are displayed:
In this portion of the report, all details that pertain to the income distribution set-up for this broker are displayed, as follows:
In this portion of the report, all details that pertain to the Reinvestment Options set up for this Broker are displayed, such as the Reinvestment Unit Holder ID, the Reinvestment Fund ID and the Split Percentage.
The Broker Details Report generation screen is as shown below. You can invoke the ‘Broker Details’ screen by typing ‘UTR00048’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you must specify the code of the broker whose details you want to view, in the Broker Code field. as mandatory sorting parameters for the generation of the report. After making your specifications, click ‘Ok’ button.
This report may also be termed as the Broker Hierarchy Report. You can use it to view the details and the framework of the reporting structure in a given Hierarchy Structure, for a given Parent Broker. The following details are displayed at each Reporting Hierarchy Level:
The Broker Hierarchy Report generation screen is as shown below. You can invoke the ‘Broker Hierarchy’ screen by typing ‘UTR00046’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you must specify the following as sorting parameters for the generation of the report:
Note
None of these details are mandatory.
After making your specifications, click ‘Ok’ button. The report details are displayed.
You can use this report to view the details of commission payment and commission reinvestment processing for a broker.
The information that is displayed is grouped under the following heads:
In this section of the report, the Name, Code, Telephone Number and Postal Address of the concerned broker are displayed.
Here, the details of commissions that have accrued to this broker over the given time period are displayed. This includes the following information:
Here, the commission accrued will include the commission that has accrued from transactions for which the payment instruments have not been cleared, too. This portion of the commission is not paid out till the payment instruments are cleared.
The details of each commission payment are displayed here. Both Check as well as Transfer payments are displayed under the appropriate head.
For Check Payments, the following details are available for view:
For Transfer Payments, the following details are available for view:
The commission paid out will not include the commission that has accrued from transactions for which the payment instruments have not been cleared. This portion of the commission is not paid out till the payment instruments are cleared.
The details of the reinvestment options that are set up for this broker are displayed here. These details include the Payment Date corresponding to the commission which is being reinvested in part or full, the Reinvestment Unit Holder ID, Reinvestment Fund ID and the Reinvestment Amount.
The details of the journal of commission payment for this broker are displayed here. This includes transaction number corresponding to the journal entry, Adjustment of payments of commissions, Payables and Receivables for the broker resulting from the transaction and the Remarks, if any.
The Broker Commission Payment Report generation screen is as shown below. You can invoke the ‘Commission Payment’ screen by typing ‘UTR00083’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you must specify the following as mandatory sorting parameters for the generation of the report:
After making your specifications, click ‘Ok’ button. The report details are displayed.
This section contains the following topics:
The Oracle FLEXCUBE Investor Servicing (FC-IS) system provides the facility of printing confirmation reports for all allocated transactions that have been confirmed on a given business day.
The transaction type confirmation report generation screen is as shown below.
In this screen, you must specify the following as mandatory sorting parameters for the generation of the report:
You could also print or view it as required by the user, by making appropriate specifications in the remaining fields of the generation screen, as follows:
After making your specifications, click ‘Ok’ button. The report details are displayed.
The following details are printed in the report:
In the case of switch transaction, confirmation notes are printed for both the legs of the transaction. For transfer transactions, separate confirmation notes are printed for both the transferor and the transferee.
This section contains the following topics:
Some other types of reports are discussed here.
This report displays the errors logged by the allocation process between any two dates.
The FMG Allocation Error Report screen is as shown. You can invoke the ‘Allocation Errors’ screen by typing ‘UTR00066’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you must specify the following as mandatory sorting parameters for the generation of the report:
After making your specifications, click ‘Ok’ button. The report details are displayed.
This report can be used to obtain a list of all the authorized loads that have been set up in the system and the loads that are dependent on the same. There are no parameters for the report. It will list the following details, grouped by the information item, Parent Load.
The Derived Load Report generation screen is as shown below. You can invoke the ‘Derived Load Details’ screen by typing ‘UTR00063’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you must specify the following as mandatory sorting parameters for the generation of the report:
After making your specifications, click ‘Ok’ button. The report details are displayed.
This report displays all the entities present in the system - all the AMC, Registrars and Trustees.
It is printed on request, and the details are ordered according to Entity Type and Entity ID. All the static data that is available for the entities is displayed, such as the entity type, name, address, contact person, authorized signatory, phone number, fax number, etc.
The ‘Entity Report generation’ screen is as shown below. You can invoke the ‘Entity Details’ screen by typing ‘UTR00062’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Enter the following details:
Enter the printing options and Click ‘Ok’ button to print.
This report displays details of overridden exchange rates for a fund on a given date. The details are displayed grouped by each Agent Code.
The following details are displayed:
The ‘Exchange Rate Override Report generation’ screen is as shown below. You can invoke the ‘Exchange Rate Overrides’ screen by typing ‘UTR00065’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you must specify the following as mandatory sorting parameters for the generation of the report:
After making your specifications, click ‘Ok’ button. The report details are displayed.
This report will contain all the data with respect to the Fund Price maintenance. It will contain details of the Real NAV per unit, Declared NAV, Total assets, Outstanding Units, Total Foreign Investors Outstanding Units, Total number of Unit Holders. It also has details of the base prices of the all the transactions that are operational with the fund as of that particular date.
The ‘Fund Price Report generation’ screen is as shown below. You can invoke the ‘Fund Price Details’ screen by typing ‘UTR00040’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you must specify the following as mandatory sorting parameters for the generation of the report:
After making your specifications, click ‘Ok’ button. The report details are displayed.
To obtain a summary of income distribution payments made for a fund, you can use this report.
The ‘Income Distribution Summary Report generation’ screen is as shown below. You can invoke the ‘Income Distribution’ screen by typing ‘UTR00115’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you must specify the following as mandatory sorting parameters for the generation of the report:
After making your specifications, click ‘Ok’ button. The report details are displayed.
The Income Advice Report generation screen is as shown below. You can invoke the ‘Income Advice Detail’ screen by typing ‘UTR00110’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you must specify the following as mandatory sorting parameters for the generation of the report:
You can also specify any of the following to fine tune your search:
After making your specifications, click ‘Ok’ button. The report details are displayed.
This report displays details of Letter of Intent indemnifications by unit holders that have nor been fulfilled in the LOI Period.
The ‘LOI Non Fulfillment Report generation’ screen is as shown below. You can invoke the ‘LOI Non Fulfillment’ screen by typing ‘UTR00104’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify any of the following as sorting parameters for the generation of the report:
After making your specifications, click ‘Ok’ button. A screen with print options is displayed. Enter the printing options and Click ‘Ok’ button to print.
This report presents a list of all transactions that have overridden loads, and have been entered from the branch where it is being generated. The details of each override such as the original percentage/amount, override percentage/amount and the load calculation method are displayed.
The report may be generated based on the Transaction From Date and To Date.
Transaction Number
Display Only
In this field, the transaction numbers of the transactions for which the load is applicable are displayed.
Transaction Date
Display Only
The dates of the concerned transactions are displayed here.
Unit Holder Number
Display Only
The ID of the unit holder who has made the transaction is displayed here.
Unit Holder Name
Display Only
The name of the unit holder who has made the transaction is displayed here.
Fund ID
Display Only
The Fund ID of the transaction, if any, is displayed here.
Broker Code
Display Only
The Code of the Broker that is involved in the transaction, if any, is displayed here.
Load ID
Display Only
The IDs of the loads that are applicable to the given transaction is displayed here.
Transaction Mode
Display Only
This shows whether the transaction is based on Units or Transaction Amount
Value Applied
Display Only
The transaction amount, upon which the load has been computed, is displayed here.
Original Load Percentage
Display Only
If the load is computed as a percentage, the original percentage that had been applicable before the override is displayed here.
Override Load Percentage
Display Only
If the load is computed as a percentage, the percentage became applicable after the override is displayed here.
Original Load Amount
Display Only
If the load is computed as an amount, the new amount that had been applicable before the override is displayed here.
Override Load Amount
Display Only
If the load is computed as an amount, the new amount that became applicable after the override is displayed here.
Date Allotted
Display Only
If the transaction has been allotted, the date on which the allotment took place is displayed here.
Units Allotted
Display Only
If the transaction has been allotted, the number of units that were allotted at the time of allotment is displayed here.
Maker ID
Display Only
The ID of the user who actually entered the override is displayed here.
Checker ID
Display Only
The ID of the user who actually authorized the override is displayed here.
Agent Code
Display Only
The Agent Code of the Agency from where the override was performed and entered into the system is displayed here.
Branch Code
Display Only
The Branch Code of the Agency from where the override was performed and entered into the system is displayed here.
Override Module
Display Only
The Module (FUNDMANAGER/AGENCY BRANCH) where the override was actually done is displayed here.
The Load Override Report generation screen is as shown below. You can invoke the ‘Load Override Detail’ screen by typing ‘UTR00094’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you must specify the the dates that enclose the period during which you want to view the details of load overrides that have been performed, in the From Date and To Date fields as sorting parameter for the generation of the report.
After making your specifications, click ‘Ok’ button. A screen with print options is displayed. Enter the printing options and Click ‘Ok’ button to print.
This report displays details of the trailing commissions paid to brokers, across all funds, for a given period.
The following details are displayed:
The Trailing Commission Details Report generation screen is as shown below. You can invoke the ‘Trailing Commission’ screen by typing ‘UTR00152’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you must specify the following as mandatory sorting parameters for the generation of the report:
You can also choose the ID of the fund for which you want to view the details of trailing commission accruals, in the Fund ID field.
After making your specifications, click ‘Ok’ button. The report details are displayed.
This report displays all the transactions of any selected type received for a given date for which units have been allotted, between any two dates. It must typically be printed by the AMC at the end of the day after the unit price is allotted.
The details are ordered according to agent / branch / transaction numbers. The report is printed fund-wise.
Sub totals of total units subscribed, amount subscribed, total fee and consideration for each branch is also calculated and printed for the same.
Grand totals of total units subscribed, amount subscribed, total fee and consideration across all branches for the agent are also calculated and printed for the transactions.
For each transaction type, the following details are displayed:
Unit Holder ID
The IDs of the unit holders who have entered into transactions of the selected type for the day.
Unit Holder Name
The Full Name (Title, First Name, Last Name and Middle Name) of the unit holders who have entered into transactions of the selected type for the day.
Agent Code
The code of the Agent where transactions of the selected type were entered into the system.
Branch Code
The code of the Agency Branch where transactions of the selected type were entered into the system.
Broker
The code of the broker involved in the transaction.
Sub Broker
The code of the sub-broker involved in the transaction.
Amount or Units
Enter the mode of the transaction.
Transaction Value
Enter the value of the transaction, in amount, units or percentage of holdings, as applicable to the transaction mode and the transaction type.
Net Units Allotted
Enter the actual number of units that have been allotted for the transaction.
Total VAT %
The rate of VAT charged on the fee for the transaction.
Total Fee
Enter the sum of all the fees applicable for the transaction.
Total Incentive
Enter the sum of all the Incentives applicable for the transaction.
Gross Fee
Enter the total fee applicable for the transaction. It is the sum of the total fees and the total VAT % that is applicable for the transaction.
Net Consideration
Enter the net consideration for the transaction. It is the total amount applied (Transaction Amount) minus the gross fee.
Total Amount
Displays the total amount value of transactions for the transaction type made for the day.
Remarks
Enter the Remarks for the transaction.
The ‘Transaction Summary Report generation’ screen is as shown below. You can invoke the ‘Transaction Summary’ screen by typing ‘UTR00001’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
This report displays all the transactions of any selected type received for a given date for which units have been allotted, between any two dates. It must typically be printed by the AMC at the end of the day after the unit price is allotted.
The details are ordered according to agent / branch / transaction numbers. The report is printed fund-wise.
Sub totals of total units subscribed, amount subscribed, total fee and consideration for each branch is also calculated and printed for the same.
Grand totals of total units subscribed, amount subscribed, total fee and consideration across all branches for the agent are also calculated and printed for the transactions.
In this screen, you must specify the following as mandatory sorting parameters for the generation of the report:
You can also obtain the details specific to a particular transaction type, or a fund, or both, by selecting the transaction type in the Transaction Type field, and / or the ID of the fund in the Fund ID field.
After making your specifications, click ‘Ok’ button. A screen with print options is displayed. Enter the printing options and Click ‘Ok’ button to print.
This section contains the following topics:
You can use this section of the Reports to query the database for any details regarding the following information:
You can view any details related to any unit holder account or CIF customer account at any point of time using the Consolidated Inquiry query. The number of unit holders that you are able to access depends upon the agency branches you are mapped to and the groups of unit holders that you are restricted to.
Each time you query a UH in this screen, the system displays all details pertaining to the UH only if you are mapped to the following:
If you are mapped to all the groups, then you can view the information of all the unit holders with-in the mapped agency branches.
The details regarding the account that you can view include the following:
After you have retrieved the details of the account so that it is displayed in the main Client Enquiry screen, click the Investor Fund Balances button to view the holdings balance of the investor in each of the funds of the AMC.
You can also invoke ’Investor Fund Balance Summary’ screen by typing ‘UTDFNBAL’ in the field at the top right corner of the Application tool bar and click the adjoining arrow. The screen is displayed below:
In addition to viewing the fund details of a unit holder, you can perform the following operations through the links in this screen:
You can also view financier and fund-wise blocked units and total number of units blocked in the ‘Total Block Units’ screen. You can invoke this screen by clicking the ‘Total Blocked Units’ button in the ’Investor Fund Balance Summary’ screen.
During block transaction, if the financer name is not maintained, then all the records will be categorized and consolidated under financer as ‘others’.
Note
You will be able to open the subscription /redemption/switch/SI screens from the Client Enquiry Fund Balances screen provided you have the SMS rights to open and transact in those screens.
After you have retrieved the details of the account so that it is displayed in the main Client Enquiry screen, fine tune your query as follows:
You can view all the details regarding the fund prices for any fund on a given business date, using this query. The View Fund Price screen is as shown below. You can also invoke ’Investor Fund Balance Summary’ screen by typing ‘UTDFPRIC’ in the field at the top right corner of the Application tool bar and click the adjoining arrow. The screen is displayed below:
Select the fund for which you want to view the fund prices, in the Select Fund From List field. Also specify the date for which you want to view details of the prevalent price as on that date, in the Effective Date field. Click the View button to trigger the query.
The details of the fund price prevalent for the selected fund on the specified date are displayed in the Fund Setup Details section and the Fund Price Transaction Details section.
In the Fund Setup Details section, the fund price record that would have been entered for the selected fund in the Fund Price screen in the Fund Manager component on the specified date is displayed. In the Fund Price Transaction Details section, the details for each transaction type are displayed.
You can view all the details regarding the authorized fund rules defined for any fund that are effective on the application date, using this query.
You can invoke ‘Fund Rule’ screen by typing ‘UTDFNDRL’ in the field at the top right corner of the Application tool bar and click the adjoining arrow. The screen is displayed below:
The View Fund Rule screen is opened.
Select the fund for which you want to view the fund rules, in the Select Fund From List field. Click the View button to trigger the query.
The details of all the fund rules that are effective for the selected fund on the specified date are displayed in the screen.
Click on any of the links to see the details for any of the fund rules for the fund.
You can view details regarding any scheduler activities, using this query. This includes details of jobs that are scheduled for execution as on the application date. You can invoke the ‘View Jobs Scheduled’ screen by typing ‘UTDJBVIW’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Select the fund for which you want to view the fund rules, in the Select Fund From List field. Also specify the date range for which you want to view details of the scheduler activity, in the All Runs between Date Range Between fields. Click ‘Ok’ button to trigger the query.
The details of all the scheduled jobs as on the application date are displayed in the screen.
Click the Show Future Runs button to see the details for any future scheduled executions of the jobs.
This section contains the following topics:
These reports display details of standing instructions maintained for investors.
You can use this report to view details about amendments to standing instructions maintained for investors that were affected between any two dates.Section 3.6.1, "SI Reports Details"
The SI Amendment Report generation screen is as shown below. You can invoke the ‘SI Amendment Details’ screen by typing ‘UTR00078’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you must specify the dates that enclose the period during which the amendments were made any standing instructions maintained for any investor, in the From Date and To Date fields as the sorting parameter for the generation of the report.
Click ‘Ok’ button after making your specifications. A screen with print options is displayed. Enter the printing options and click ‘Ok’ button to print.
You can use this report to view details about escalations to standing instruction amounts for investors.
The SI Escalation Report generation screen is as shown below. You can invoke the ‘SI Escalation Detail’ screen by typing ‘UTR00073’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Click ‘Ok’ button to generate the report. A screen with print options is displayed. Enter the printing options and Click ‘Ok’ button to print.
This report will print the reminders for any standing instructions for the given fund. It is generated based on the reminder action period. This is a word interface document with standard template. It will contain information telling that SI has been generated and needs to be processed.
The SI Reminder Report generation screen is as shown below. You can invoke the ‘SI Reminder Details’ screen by typing ‘UTR00079’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you must specify the language in which the report must appear, in the Report Language field for the generation of the report:
After making your specifications, click ‘Ok’ button . A screen with print options is displayed. Enter the printing options and Click ‘Ok’ button to print.
This report will print all the standing instructions for the given fund as of that date. It will only print the details of those standing instructions that are effective as of that date. Details of elapsed standing instructions will not be printed.
This report is typically printed as a monthly or quarterly report.
Details of the transactions that have been generated for the standing instructions are also printed. The data is ordered according to the standing instructions ID.
Along with the transaction details, any applicable fees, details of check numbers and dates for post dated checks, provided this option is available. Escalation details and the unit holder contact address details are also displayed.
The SI Report generation screen is as shown below. You can invoke the ‘SI Details’ screen by typing ‘UTR00067’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can view any standing instructions maintained in any fund for any unit holder, by specifying the required fund in the Fund ID field and the ID of the unit holder in the Unit Holder ID field.
After making your specifications, click ‘Ok’ button. The report details are displayed.
This section contains the following topics:
The Transaction reports displays information about transactions of any type received from investors on any given business day.
You can invoke ‘IPO Confirmation’ screen by typing ‘UTR00103’ in the field at the top right corner of the Application tool bar and click the adjoining arrow. The screen is displayed below:
The ‘transaction type confirmation report generation’ screen is as shown below.
In this screen, you must specify the following as mandatory sorting parameters for the generation of the report:
You can also specify a unit holder to retrieve transactions received only for the unit holder on the business day.
After making your specifications, click ‘Ok’ button. A screen with print options is displayed. Enter the printing options and Click ‘Ok’ button to print.
The Transaction Enquiry report displays all the transactions details made by all the unit holders maintained in the system on a desired search criteria.
You can invoke the ‘Transaction Enquiry Report’ screen by typing ‘UTR00228’ in the field at the top right corner of the Application tool bar and click the adjoining arrow. The screen is displayed below:
Enter the search criteria and click ‘Ok’ button to generate the report.
Based on the selected criteria, the following details are displayed in the report:
Unit Holder ID
Enter the ID of the unit holder for whom the transaction report is being generated.
From Maker Date, To Maker Date
Enter the date range to generate a report displaying all the transactions created by all the unit holders maintained in the system.
From Transaction Date, To Transaction Date
Enter the date range to generate a report displaying all the transaction details made by all the unit holders maintained in the system.
From Allocation Date, To Allocation Date
Enter the date range to generate a report displaying all the allotted transactions made by all the unit holders in the system.
AMC
Select the AMC to generate a report displaying all the transactions made by all the unit holders in the selected AMC.
Distributor
Select the distributor to generate a report displaying all the transactions made by all the unit holders for a selected distributor.
Fund ID
Select the fund ID to generate a report displaying all the transactions made by all the unit holders for a selected fund ID.
Transaction Type
Select the type of transaction for which the transaction enquiry report is being generated.
Currency
Select the currency for which the transaction enquiry report is being generated.
This report will print all the IPO transactions (both authorized and unauthorized transactions) received on the current business day at the Agency Branch.
Typically, the Agency Branch prints this report at the end of the day.
Click the IPO – By Fund option to group the transactions fund-wise.
Totals and sub totals will be shown at the following levels:
Click the IPO – By Payment option to group the transactions according to the mode of payment as well as fund-wise.
Totals and sub totals will be shown at the following levels:
This report will print all the subscription transactions (both authorized and unauthorized transactions) received on the current business day at the Agency Branch.
Typically, the Agency Branch prints this report at the end of the day.
Click the Purchases – By Fund option to group the transactions fund-wise.
Totals and sub totals will be shown at the following levels:
Click the Purchases – By Payment option to group the transactions according to the mode of payment as well as fund-wise.
Totals and sub totals will be shown at the following levels:
This report will print all the redemption transactions (both authorized and unauthorized transactions) received on the current business day at the Agency Branch.
Typically, the Agency Branch prints this report at the end of the day.
Click the Sales – By Fund option to group the transactions fund-wise.
Totals and sub totals will be shown at the following levels:
Click the Sales – By Payment option to group the transactions according to the mode of payment as well as fund-wise.
Totals and sub totals will be shown at the following levels:
This report will print all the switch transactions (both authorized and unauthorized transactions) received on the current business day at the Agency Branch.
Typically, the Agency Branch prints this report at the end of the day.
Totals and sub totals will be shown at the following levels:
This report will print all the transfer transactions (both authorized and unauthorized transactions) received on the current business day at the Agency Branch.
Typically, the Agency Branch prints this report at the end of the day.
Totals and sub totals will be shown at the following levels:
This report will print all the block transactions (both authorized and unauthorized transactions) received on the current business day at the Agency Branch.
Typically, the Agency Branch prints this report at the end of the day.
Totals and sub totals will be shown at the following levels:
This report will print all the unblock transactions (both authorized and unauthorized transactions) received on the current business day at the Agency Branch.
Typically, the Agency Branch prints this report at the end of the day.
Totals and sub totals will be shown at the following levels:
This report will print all the split transactions (both authorized and unauthorized transactions) received on the current business day at the Agency Branch. Typically, the Agency Branch prints this report at the end of the day.
Totals and sub totals will be shown at the following levels:
This report will print all the consolidation transactions (both authorized and unauthorized transactions) received on the current business day at the Agency Branch.
Typically, the Agency Branch prints this report at the end of the day.
Totals and sub totals will be shown at the following levels:
This report will print all the transfer transactions (both authorized and unauthorized transactions) received on the current business day at the Agency Branch.
Typically, the Agency Branch prints this report at the end of the day.
Totals and sub totals will be shown at the following levels:
This section contains the following topics:
These reports display information regarding unit holder / CIF accounts.
Use this report to list the acknowledgement reports generated for new unit holder accounts.
The Unit Holder Acknowledgement Report generation screen is as shown below. You can invoke the ‘Acknowledgement’ screen by typing ‘UTR00095’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can generate a report specific to a unit holder account, or the authorization status of the accounts, or to any unit holder account opened on a certain date, by specifying:
After making your specifications, click ‘Ok’ button. A screen with print options is displayed. Enter the printing options and Click ‘Ok’ button to print.
This report may be generated to view previous dividend payments for a unit holder in a fund. The payment details are presented, along with the reinvestment details and EPU component breakups. The following information is presented:
The Unit Holder Dividend Details Report generation screen is as shown below. You can invoke the ‘Dividend Details’ screen by typing ‘UTR00070’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you must specify the following as mandatory sorting parameters for the generation of the report:
You can also obtain this report specific to a unit holder by specifying the ID of the unit holder account in the Unit Holder ID field.
After making your specifications, click ‘Ok’ button. A screen with print options is displayed. Enter the printing options and Click ‘Ok’ button to print.
This report will print the summary of the list of unit holders whose balances have become zero for the given fund along with the date on which the balances touched zero.
Unit Holder ID
12 Character Maximum, Alphanumeric, Display
This is the ID of the unit holder whose balance has become zero.
Unit Holder Name
12 Character Maximum, Alphanumeric, Display
This field displays the Name of the unit holder whose balance has become zero.
Date
Date, Display
This is the Date as of which the unit holder balance became zero.
The Unit Holder Zero Balance Report generation screen is as shown below. You can invoke the ‘Zero Balance Details’ screen by typing ‘UTR00044’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you must specify the following as mandatory sorting parameters for the generation of the report:
After making your specifications, click ‘Ok’ button. A screen with print options is displayed. Enter the printing options and Click ‘Ok’ button to print.
This section contains the following topics:
For the given fund, the Account Statement of all the Unit Holders is printed. By availing of the Holdings Statement option, the Holdings Statement can be printed along with the Account Statement. It is printed as per the Account Statement Period. Account statements can either be printed as of the latest market value or as of the market value on the end date of the account statement period.
You must specify the Fund ID, unit holder ID range, date range and report language as mandatory information to generate the report. Also, indicate whether the market value of the investor’s holdings is ‘Latest’ or as of the report’s ‘To date’. You can invoke the ‘Acc. Statement’ screen by typing ‘UTR00137’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
AMC Name
40 Character Maximum, Alphanumeric, Display
The Name of the Asset Management Company to which the Fund belongs is displayed.
AMC Address
255 Character Maximum, Alphanumeric, Display
The Address of the Asset Management Company, to which the Fund belongs, is displayed.
Unit Holder ID
12 Character Maximum, Alphanumeric, Display
The ID of the Unit Holder, for whom the Account Statement is to be printed, is displayed.
Unit Holder Name
100 Character Maximum, Alphanumeric, Display
The Name of the Unit Holder, for whom the Account Statement is to be printed, is displayed.
Unit Holder Address
255 Character Maximum, Alphanumeric, Display
The Address of the Unit Holder, for whom the Account Statement is to be printed, is displayed.
Fund ID
Alphanumeric, Display
The ID of the Fund, for which the Account Statement is to be printed, is displayed.
Fund Name
Alphanumeric, Display
The Full Name of the Fund, for which the Account Statement is to be printed, is displayed.
Transaction Date
Display
Displays the date on which the transaction took place.
Transaction Type
25 Character Maximum, Alphanumeric, Display
The type of transaction that has affected the Unit Holder balance is displayed.
Units Transacted
Numeric, Display
The Number of Units transacted for the given transaction is displayed.
Transaction Number
Display
This displays the transaction number.
Price
Alphanumeric, Display
Displays the price at which the transaction was affected.
Unit Balance
Numeric, Display
The balance Number of Units at the end of the given transaction is displayed.
This report will print the details of redemption transaction for which payment is held back due to the unit holder being FICA non-compliant. The report also displays the Auto Investment date i.e. the date on which the redemption will be automatically invested back in the fund. You can invoke the ‘Auto Invest Reminder’ screen by typing ‘UTR00212’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You must specify the Fund ID, the unit holder, report language as mandatory information, and click ‘Ok’ button to generate the report. A screen with print options is displayed. Enter the printing options and Click ‘Ok’ button to print.
Fund ID
6 Character Maximum, Alphanumeric, Display
This field displays the Fund ID and the Name of the fund for which the report is to be printed.
Unit Holder
12 Character Maximum, Alphanumeric, Display
Display Only
The ID of the unit holder who has made the transaction is displayed here.
Transaction Number
Display Only
In this field, the transaction numbers of the transactions for which the unit holder is FICA non-compliant are displayed.
Transaction Date
Display Only
The dates of the concerned transactions are displayed here.
Allocation Date
Display Only
If the transaction has been allotted, the date on which the allotment took place is displayed here.
Investment Date
Display Only
This field displays the date on which the amount must be reinvested into the fund if the investor continues to be FICA non-compliant.
Reminder Date
Display Only
This field displays the date on which the reminder must be sent out to the FICA non-compliant investor.
This report will print the details of Fund Holdings of the Unit holder. The mailing label of the selected Unit holders can also be printed. You can invoke the ‘Unitholder Register’ screen by typing ‘UTR00127’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can use this screen to:
You can specify the Fund ID, Domicile of the unit holder and report language as mandatory information and the top number of records with sort parameters, to generate the report.
You can specify the date, as on which the details must be displayed in the report. You can opt for details as of:
The Report has Totals / subtotals for Number of Unit holders, Total of Holdings, Percentage of Holdings.
Fund ID
6 Character Maximum, Alphanumeric, Display
This field displays the Fund ID and the Name of the fund for which the Unit holder holding details are to be printed.
Fund Name
20 Character Maximum, Alphanumeric, Display
Enter the Fund ID and the Name of the fund for which the Unit holder holding details are to be printed.
Date
Date, Display
This displays the Date on which the Report is printed.
Unit Holder ID
12 Character Maximum, Alphanumeric, Display
This displays the ID of the Unit holder for whom the Fund Holdings are being printed.
Unit Holder Name
85 Character Maximum, Alphanumeric, Display
This displays the Full Name (Title + First Name + Last Name) of the Unit holder for whom the Fund Holding details are being printed.
Type of Investor
1 Character Maximum, Alphanumeric, Display
This displays the type of the Unit holder, whether Individual or Corporate, for whom the Fund Holding details are being printed.
Corresponding Address
1 Character Maximum, Alphanumeric, Display
This displays the Address of the Unit holder for whom the Fund Holding details are is being printed. This could be the permanent or the secondary address of the Unit holder as per the Unit holder’s instructions as to where his correspondence is to be made.
Telephone Number
1 Character Maximum, Alphanumeric, Display
This displays the Telephone Number of the Unit holder for whom the Fund Holding details are being printed.
Country of Residence
3 Character Maximum, Alphanumeric, Display
This displays the Country of residence of the Unit holder for whom the Fund Holdings are being printed.
Agent Code
3 Character Maximum, Alphanumeric, Display
This displays the Agent Code, where the corresponding Unit Holder account was opened.
Total Holdings
Numeric, Display
This shows the Unit Balance of the unit holder on the date when the report was printed.
Percentage of Holdings
Numeric, Display
This shows the percentage of holdings of the unit holder. This is a derived field based on the Total Holdings of the unit holder.
This report will print details of the Unit Holder Holdings in terms of distribution by Nationality or distribution by holdings.
This report will have two parts:
You can invoke the ‘Holdings Details’ screen by typing ‘UTR00124’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
The Report takes the Fund ID as the input. It has Totals / Sub-totals for the Number of Unit Holders, Number of Units and Percentage of Units.
Fund ID
6 Character Maximum, Alphanumeric, Display
This is the Fund ID of the fund for which the unit holder holdings summary report is to be printed.’
Fund Name
20 Character Maximum, Alphanumeric, Display
This displays the Name of the fund for which the Unit Holder holdings Summary Report is to be printed.
Distribution by Nationality
Type
1 Character Maximum, Alphanumeric, Display
This indicates the category of the unit holder (Local or Foreigner).
Number
Numeric, Display
This shows the number of the unit holder that falls in this category.
Units
Numeric, Display
This displays Number of Units that fall under this category type.
Percentage of Units
Numeric, Display
This shows the percentage based on Units.
Distribution by Investor type
Type
1 Character Maximum, Alphanumeric, Display
This indicates the category of the unit holder (Corporate or Individual)
Number
Numeric, Display
This is the number of the unit holders who fall into this category type.
Units
Numeric, Display
This is the Number of Units that fall under this category type.
Percentage of Units
Numeric, Display
This displays the percentage based on Units.
Distribution by Holdings
Type
1 Character Maximum, Alphanumeric, Display
This indicates the category of the unit holder. Type is based on the unit holder’s holdings based on units.
Number
Numeric, Display
This is the number of the unit holders who fall into this category type.
Units
Numeric, Display
This is the Number of Units that fall under this category type.
Percentage of Units
Numeric, Display
This is the percentage based on Units.
Distribution by Investor type
Type
1 Character Maximum, Alphanumeric, Display
This indicates the category of the unit holder (Corporate or Individual).
Number
Numeric, Display
This is the number of unit holders who fall into this category type.
Units
Numeric, Display
This is the Number of Units that fall under this category type.
Percentage of Units
Numeric, Display
This is the percentage based on Units.
Based on the Unit Holder Dividend Payment information, the withholdings tax certificate / form can be printed for those unit holders who have requested for tax to be deducted at source.
This report will print the number of units, the dividend rate per unit, the total dividend, minus the income tax net payable and dividend reference number for every unit holder. This is printed for each Dividend Payment Period and is ordered by the unit holder.
You can invoke the ‘Withholding Tax’ screen by typing ‘UTR00134’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You must specify the ID of the fund, dividend payment number and report language as mandatory information to generate the report. You can also specify the Investor Category and the Investor Status.
Fund ID
6 Character Maximum, Alphanumeric, Display
This is the ID of the fund for which the Unit Holder Withholdings tax screen is printed.
Fund Name
20 Character Maximum, Alphanumeric, Display
This is the Name of the fund for which the Unit Holder Withholdings tax form is printed.
Date
Date, Display
This is the date of issuance of the Withholdings Tax form.
Unit Holder ID
12 Character Maximum, Alphanumeric, Display
This is the ID of the unit holder for whom the Tax form is being printed.
Unit Holder Name
12 Character Maximum, Alphanumeric, Display
This is the Name of the unit holder for whom the Tax form is being printed.
Address
255 Character Maximum, Alphanumeric, Display
This is the Address for correspondence with the unit holder, for whom the Fund Holdings details are being printed. This could be the Permanent address or the secondary address of the unit holder depending upon the unit holder’s instructions.
Zip Code
6 Character Maximum, Alphanumeric, Display
This is the Zip Code of the unit holder’s address.
Unit Holder Tax ID
12 Character Maximum, Alphanumeric, Display
This is the Tax ID of the unit holder for whom the Tax form is being printed.
Units
Numeric, Display
This is the Unit Balance for the fund on the Book Closing Date
Pay per Unit
Numeric, Display
This is the Rate of Dividend per Unit
Total
Numeric, Display
This is the Unit Balance multiplied by the Rate of Dividend per Unit
Tax
20 Character Maximum, Alphanumeric, Display
This is the Withholdings Tax percentage multiplied by Total.
Net
20 Character Maximum, Alphanumeric, Display
This is the Total minus the Withholdings Tax
Reference Number
20 Character Maximum, Alphanumeric, Display
This is the Dividend reference Number
Other information like the name of the issue, the designation, the division and the contact number are printed at the end of the report.
This section contains the following topics:
This report will print the list of unit holders who have requested for reinvestment of their dividend earnings.
This report will print the list of all the unit holders who have requested for reinvestment for a given fund. This Report is printed ad-hoc or before dividend payment and is ordered by unit holder ID.
You can invoke the ‘ReInvestment Details’ screen by typing ‘UTR00128’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You must specify the date on which the reinvestment transaction was authorized. Click ‘Ok’ button to generate the report. A screen with print options is displayed. Enter the printing options and Click ‘Ok’ button to print.
Unit Holder ID
12 Character Maximum, Alphanumeric, Display
This is the ID of the unit holder who has requested for reinvestment.
Unit Holder Name
85 Character Maximum, Alphanumeric, Display
This is the Name of the unit holder who has requested for reinvestment.
Fund ID
12 Character Maximum, Alphanumeric, Display
The Fund ID in which the unit holder wants to reinvest.
This section contains the following topics:
You can use this screen to query about certificates issued in respect of allocated transactions.
Select the fund, Certificate Status and Allocation Date for whom the Certificate details are to be viewed or printed using the Find option. This screen shows the Certificate details for the specified criteria.
Fund ID
6 Character Maximum, Alphanumeric, Display
The ID of the fund whose Certificate Details are to be viewed or printed, is displayed.
Certificate Status
1 Character Maximum, Alphanumeric, Display
The Status of the Certificate is displayed.
Transaction Number
12 Character Maximum, Alphanumeric, Display
The Transaction Number of the Certificate, whose details are to be viewed or printed, is displayed.
Unit Holder ID
12 Character Maximum, Alphanumeric, Display
The ID of the unit holder, whose Certificate details are to be viewed or printed, is displayed.
Certificate Number
Numeric, Display
The Number of the Certificate, whose details are to be viewed or printed, is displayed.
Units
Numeric, Display
The Number of certified units of the Certificate, whose details are to be viewed or printed, is displayed.
Envelope Number
15 Character Maximum, Alphanumeric, Display
The Number of Envelope generated by the Franking Machine for the Certificate, whose details are to be viewed or printed, is displayed.
New Envelope Number
15 Character Maximum, Alphanumeric, Display
The New Number of Envelope generated by the Franking Machine for the Certificate, whose details are to be viewed or printed, is displayed.
This section contains the following topics:
The certificates are printed once the allocation of units is made for the unit holder. These are certificates that are being printed for the first time. This report will print certificates for the given range and fund.
You can invoke the ‘New Certificate’ screen by typing ‘UTR00129’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You must specify the Fund ID, the certificate number range, and the date range within which the transaction was authorized, to generate the report. You can also specify the unit holder ID as a parameter for the generation of the certificates.
Click ‘Ok’ button to generate the report. A screen with print options is displayed. Enter the printing options and Click ‘Ok’ button to print.
Fund
12 Character Maximum, Alphanumeric, Optional
Select the Fund Name for which the new certificates are to be printed, from the list provided.
Unit Holder ID
12 Character Maximum, Alphanumeric, Optional
Enter the ID of the unit holder for whom the Certificate is being printed.
From Certificate Number
Numeric, Optional
Enter the beginning of the range of new certificates to be printed.
To Certificate Number
Numeric, Optional
Enter the end of the range of new certificates to be printed.
From Allocation Date
Date, Optional
Enter the start date for the Allocation.
To Allocation Date
Date, Optional
Enter the end date for the Allocation.
User Input
Alphanumeric, Mandatory
Enter any characteristic or remark relating to the certificate.
If no options are chosen for either of the above, then, on clicking ‘Ok’ button the system automatically prints all the certificates.
The certificates are printed once the allocation of units is made for the unit holder. These are certificates are printed after the first print. This report will print certificates for the given range and fund.
You can invoke the ‘Dup. Certificate’ screen by typing ‘UTR00130’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Fund
12 Character Maximum, Alphanumeric, Mandatory
Select the Fund Name for which the duplicate certificates are to be printed, from the list provided.
Unit Holder ID
12 Character Maximum, Alphanumeric, Optional
Enter the ID of the unit holder for whom the duplicate certificate is being printed.
From Certificate Number
Numeric, Mandatory
Enter the beginning of the range of duplicate certificates to be printed.
To Certificate Number
Numeric, Mandatory
Enter the end of the range of duplicate certificates to be printed.
From Allocation Date
Date, Mandatory
Enter the start date for the Allocation.
To Allocation Date
Date, Mandatory
Enter the end date for the Allocation.
User Input
Alphanumeric, Optional
Enter any characteristic or remark relating to the duplicate certificate.
The certificates are printed once the allocation of units is made for the unit holder. These are certificates that are reprinted. This report will print certificates for the given range and fund.
You can invoke the ‘Re-Print Certificate’ screen by typing ‘UTR00131’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
This section contains the following topics:
This report will print the Unit Balance of the Unit holders whose Balances fall below a specified limit entered in terms of Units / Amount. If the Calculation Mode is in terms of Amount, the number of units for the entered Amount as per the latest Fund Price is calculated. This Report is printed at a Fund Level.
You can invoke the ‘Threshold Balance’ screen by typing ‘UTR00126’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Enter the search criteria and click ‘Ok’ button to generate the report.
You can invoke the ‘Threshold Unit Bal’ screen by typing ‘UTR00132’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Enter the search criteria and click ‘Ok’ button to generate the report.
Calculation Mode
1 Character Maximum, Alphanumeric, Mandatory
Select the Calculation Mode (Units / Amount) of the Unit holder.
Value
Numeric, Mandatory
Enter the Threshold value based on which the Report is generated.
Number of Units
Numeric, Display
This is the Number of Units held by the unit holder in the given fund, on the day of book closing.
Total Dividend
Numeric, Display
This is the Total Dividend that is applicable to the unit holder for the given fund, based on the Units held.
Dividend Date
Date, Display
This is the Date of Dividend Payment.
Net Paid
Numeric, Display
This is the Net amount paid to the unit holder after tax.
Tax Withheld
Numeric, Display
This is the Amount of Withholdings tax deducted from the unit holder dividend.
Authorized Signatory
20 Character Maximum, Alphanumeric, Display
This is the name of the person who is the Authorized signatory for Withholdings Tax.
Date
Date, Display
This is the date of reporting, usually the date when the report is being generated.
This section contains the following topics:
This report will print the details of all Transfers affected by the Registrar. The Registrar will print this report. You can invoke the ‘Transfer Reg Details’ screen by typing ‘UTR00121’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Click ‘Ok’ button to generate the report.
Unit Holder ID
12 Character Maximum, Alphanumeric, Display
The ID of the Unit holder that has transferred the units is displayed here.
Transaction Date
Date, Display
Enter the date on which the transaction occurred is shown here.
Transfer Deed Number
12 Character Maximum, Alphanumeric, Display
This is the Reference number or deed reference number of the Transaction.
Transaction Number
12 Character Maximum, Alphanumeric, Display
This is the Transaction Number generated by the system for this transaction.
Transfer Number
12 Character Maximum, Alphanumeric, Display
This is the Transfer Number provided by the Registrar.
Transfer Date
Date, Display
This is the date of the Transfer provided by the Registrar.
Units Transferred
Numeric, Display
This is the Number of Units transferred.
This section contains the following topics:
This report will be printed for redemption transactions confirmed allocated within the specified period for a given fund and unitholder. Only those redemption transactions whose settlement amount is lesser than or equal to 2000 reckoned in the fund base currency will be considered.
The Employee Tax 3(a) Report screen allows you to enter search criteria for the generation of an Employee Tax Report. You can invoke the ‘Employee Tax Details’ screen by typing ‘UTR00216’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, the following are the parameters for the generation of the report:
The following details are printed in the report:
This report will be printed for redemption transactions confirmed allocated within the specified period for a given fund and unitholder. Only those redemption transactions whose settlement amount is greater than 2000 reckoned in the fund base currency will be considered.
The Employee Tax IRP5 Report screen allows you to enter search criteria for the generation of an Employee Tax Report.
You can invoke the ‘Employee Tax IRP5’ screen by typing ‘UTR00217’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you must specify the following as mandatory sorting parameters for the generation of the report:
The following details are printed in the report:
This report will be printed for switch transactions confirmed allocated within the specified period for a given fund and unitholder. This report is applicable on death/retirement of a member.
The Tax Deduction Directive A&D Report screen allows you to enter search criteria for the generation of a request for tax deduction directive. You can invoke the ‘Tax Ded. Directive’ screen by typing ‘UTR00213’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you must specify the following as mandatory sorting parameters for the generation of the report:
The following details are printed in the report:
This report will be printed for switch transactions confirmed allocated within the specified period for a given fund and unitholder. This report is applicable on withdrawal of funds from preservation pension/provident fund.
The Tax Deduction Directive B Report screen allows you to enter search criteria for the generation of a request for tax deduction directive B. You can invoke the ‘Tax Ded. Directive B’ screen by typing ‘UTR00214’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you must specify the following as mandatory sorting parameters for the generation of the report:
The following details are printed in the report:
This report will be printed for switch transactions confirmed allocated within the specified period for a given fund and unitholder. This report is applicable retirement annuity funds.
The ‘Tax Deduction Directive Report’ screen allows you to enter search criteria for the generation of a request for tax deduction directive. You can invoke the ‘Tax Ded. Directive’ screen by typing ‘UTR00215’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you must specify the following as mandatory sorting parameters for the generation of the report:
The following details are printed in the report:
This section contains the following topics:
Oracle FLEXCUBE provides you with the option of investment simulator for both; pension and non pension funds.
For a given period, you can simulate the NAV for various combination of fund IDs and investment amount. Based on the application date (i.e. the date of subscription), redemption date, fund ID and the investment amount, the profit based on the NAV as per the days of subscription and redemption will be calculated by the investment simulator along with the gross amount and displayed.
Note
The investment simulator does not consider any loads or taxes set up in the system.
You can invoke ‘Investment Simulator – Non Pension Funds’ screen by typing ‘UTDHINAV’ in the field at the top right corner of the Application tool bar and click the adjoining arrow. The screen is displayed below:
For a given period, you can simulate the NAV for various combination of fund IDs and investment amount. Based on the application date (i.e. the date of subscription), redemption date, fund ID and the investment amount, the profit based on the NAV as per the days of subscription and redemption will be calculated by the investment simulator along with the gross amount and displayed.
From Date
Specify the date from which you wish to simulate the NAV for various combination of fund IDs and investment amount.
To Date
Specify the date till which you wish to simulate the NAV for various combination of fund IDs and investment amount.
Click on the 'Simulate' button to simulate the investment. The following details are displayed:
Fund ID
6 Characters Maximum, Alphanumeric; Mandatory
Select the ID of the funds which are Historic NAV Based as captured in the General Operating Rules screen.
Note
Only the funds for which the option ‘Historic NAV Based’ has been selected for the field ‘Investment Simulation Method’ in the General Operating Rules screen will be listed in the option list provided.
You can not simulate the investment option for the same fund more than once and thus the Fund ID should not be repeated in the panel.
Fund ISIN
12 Characters Maximum; Alphanumeric; Mandatory
Select the ISIN Code of the selected fund.
Investment Amount
Numeric, Mandatory
Specify the amount that you wish to invest. The value here should be greater than zero.
From date NAV
Display
Depending on the selected fund and the From Period, the NAV Value is displayed here.
To date NAV
Display
Depending on the selected fund and the To Period, the NAV is displayed here.
Gross Profit
Display
The Gross profit is displayed here and is calculated as follows:
(To Date NAV – From Date NAV) * (Investment Amount / From Date NAV)
Gross Balance
Display
The Gross balance is displayed here and is calculated as follows:
(Investment Amount / From Date NAV) * To Date NAV.
You can invoke ‘Investment Simulator –Pension Funds’ screen by typing ‘UTDPENFD’ in the field at the top right corner of the Application tool bar and click the adjoining arrow. The screen is displayed below:
FCIS also allows you to simulate the tax saving in a pension fund. It demonstrates the value of tax liability of the customer in case no investments are made and compares it with a scenario, where a specified investment is made by the customer.
Note
The investment simulator does not consider any loads or taxes set up in the system.
The following are the fields in this screen.:
Annual Gross Income
Numeric; Mandatory
Specify the gross annual income of the investor.
Pension fund contribution in the year
Numeric; Mandatory
Indicate the pension fund contribution that the investor has made or wishes to make during the year.
INSS paid in the year
Numeric; Optional
Indicate INSS paid in the year. This field is optional. In case the INSS paid during the year is not specified the same will be calculated based on the Load ID for INSS.
INSS load ID, IR Calculation Basis and IR. Aliquot load are also parameterized in system parameters under 'INVSIMULATOR '. If there is any changes in the load, than the load maintenance should be changed and not the system parameters.
Click on the 'Simulate' button to simulate the investment. Click on the 'Clear' button if you wish to clear the panel of the choices that have been made.
On simulation the following details are displayed.
INSS paid in the year
Display
The INSS paid as specified above with or without the pension fund is displayed here.
Deduction amount
Display
The deduction amount is displayed here.
IR Calculation Basis
Display
The minimum of the two values one of which is arrived at by adding the values of INSS and the Pension fund contribution in the year and the other by calculating the Limit for deduction by applying Percentage Limit for IR Contribution on the annual gross income, is deducted from the gross annual income to get the IR Calculation Basis, which is displayed here.
I.R. Aliquot
Display
The IR percentage is calculated based on the Load Id for IR and displayed here.
Installment to Deduct
Display
The Installment to deduct amount is calculated based on the Load Id for IR and displayed here.
IR Due
Display
The IR percentage is applied to the IR calculation basis and subtracted from the Installment to Deduct. This result gives the IR amount due from the investor which is displayed here.
This section contains the following topics:
You can view the multiple transactions errors occurred and their status using ‘Multi Transaction Error Log Report’ screen. You can invoke this screen by typing ‘UTR00218’ in the field at the top right corner of the Application tool bar and click the adjoining arrow. The screen is displayed below:
You can specify the following details:
Unit Holder
Optional
Specify the unit holder ID for whom you want to generate the report.
CIF Number
Optional
Specify the customer information number of the unit holder.
Wrapper Transaction Number
Optional
Specify the wrapper transaction number of the multi transaction for which you want to generate report.
From Date
Date; Optional
Enter the date from when you want to generate the report.
To Date
Date; Optional
Enter the date till when you want to generate the report.
You can view the tax credit report to view all unit holder and dividend details for which tax credit /reversal has been successful/unsuccessful. You can invoke this screen by typing ‘UTRTAXCR‘ in the field at the top right corner of the Application tool bar and click the adjoining arrow. The screen is displayed below:
You can specify the following details:
From Date
Date; Optional
Enter the date from when you want to generate the report.
To Date
Date; Optional
Enter the date till when you want to generate the report.
Tax Credit Mode
Optional
Specify the tax credit mode from the adjoining drop-down list. Following are the options available:
Fund ID
Alphanumeric; 6 Characters; Optional
Specify the fund ID. This adjoining option list displays all valid fund ID maintained in the system. You can choose the appropriate one.
Record Status
Optional
Select the status of the record from the adjoining drop-down list. Following are the options available: