Our business is to provide solutions for your business

Portfolio Management System version 1.0 Features Document

 

Introduction

Winsoft 's Portfolio Management System ( WinPort ) is designed keeping in mind the functionalities required by the Front Office and Mid Office operations personnel. The system helps the fund manager & back office operations staff to maintain, rebalance & track the portfolios client wise & product wise. The system has following PMS business categories ¯

  • Equity Based PMS
  • Capital Preservation Based PMS

The system currently interfaces with Deutsche Bank & ICICI Bank 's Fund Accounting & Custody System.

Features

Features of WinPort are broadly divided in the following five modules:

  1. User & Access control Management Module
    • Access Control is integrated with Windows 2000 NTFS Access Control. Independent Access Control is also provided in case integration with windows in not required.
    • If Access Control is integrated with Windows then application does not require multiple login, user is detected from the windows login.
    • User Creation
    • Roles Creation
    • Assignment of menu rights to roles
  2. Administration Module

    Client Management

    • New Client Creation
    • Client Signup Legal Document Management
    • Client Initial Capital Management (Cash/Instruments)
    • Client Cash Flow Management
    • Client Management Fee Capturing
    • Defining Non Traded Securities at client level (Considered during allocation)

    Product Management

    • Product Creation
    • Model Portfolio Definition & Management

    Security Master

    • Equity Security Creation/Modification Management
    • Provision to mark a security as non-tradable
    • Provision to mark a security as restricted for Non-Resident Indians.

    Sector Master

    • Mapping of Exchange & ISIN to Fund Accounting & Custody Codes
    • Derivatives (Options/Futures) Creation/Modification Management
    • Mutual Fund Scheme Creation/Modification Management

    Other Masters & Features

    • City Master
    • State Master
    • Region Master
    • Country Master
    • Mode Of Holding (Operating Mode of account, Single, Joint etc.)
    • Bank Account Type
    • Tax Status Master
    • Distributor Master (Agents through which the business is done)
    • Broker Master (List of brokers through which trades are done)
    • Document Master (List of legal documents required for client)
    • Nifty Benchmark Period Master
    • Application Parameters (user for setting default values at system level for e.g. Export File Path for allocation, Allocation Tolerance Limit, Performance Report Deviation etc.)

    Reports

    • Client Holding Report
    • Client Cash Report
    • Client Cash Transaction Report
    • Audit Trail Report
    • Profit & Loss Report
    • Balance Sheet Report
    • Model Portfolio Product/Scheme Wise Report (Equity PMS & Advisory)

    Interfaces

    Deutsche Bank Fund Accounting/Custody Interface
    • Market Price (Day End Closing Prices)
    • Security Master (Deutsch Bank Code, BSE Code, NSE Code & ISIN Number)
    • Order Transactions (Previous Day Transactions)
    • Capital Transactions (Previous Day Capital Cash Flow Transactions)
    • Holding/Portfolio Balances (As on Date Holding)
    • Balance Sheet
    • Profit & Loss
    • Benchmark Indices (BSE & NSE)

    Above mentioned files are uploaded in the system on daily basis. The interface imports all the files on selection of one file & have an option of overwriting the existing data. The system provides rollback of the upload done.

    ICICI Bank Fund Accounting/Custody Interface

    • Security Master (ICICI Bank Code, BSE Code, NSE Code & ISIN Number)
    • Order Transactions (Previous Day Transactions)
    • Capital Transactions (Previous Day Capital Cash Flow Transactions)
    • Holding/Portfolio Balances (As on Date Holding)
    • Balance Sheet Profit & Loss

    Above mentioned files are uploaded in the system on daily basis. The interface imports all the files on selection one file & have option of overwriting the existing data. The system also tracks the duplicate upload of data.

    Nifty Stock Weight Upload

    This interface updates the Nifty Stock Weight age in index. This is used for calculating the clients portfolio performance against the exchange performance.

  3. PMS Equity Front Office/Mid Office Module

    Process Flow Features

    Day Begin Activity (Back Office Operation)
    • Upload Fund Account/Custodial files (holding, transactions, balance sheets). Upload Security and market feed files.
    • Update/Add client master
    • Order generation for clients not aligned to the benchmark.

    Benchmark Selection For The Day (Fund Manager Operation)

    • Define/Update product benchmark required for the day.
    • Selection of Model Portfolio against which the current client portfolio is benchmarked to arrive at rebalanced portfolio
    • Any client's portfolio can also be selected as the model portfolio to be benchmarked.
    • Orders are generated based on cash available with the client.
    • The allocation is done on the basis of the orders generated.

    Client Mandates (Back Office Operation)

    The following requests from the client are recorded. Orders are generated to align the benchmark taking these requests into consideration.

    • Cash hold.
    • Preferred security
    • Hold Security
    • Bad security.
      • New version to have
    • Preferred Sector.
    • Bad Sector.
    • Only Buy.
    • Only Sell.

    Corpus Movement (Buy/Sell Generation) (Back Office Operation)

    The application records receipts and withdrawals from/by clients. Orders are generated to align the client to the benchmark

    • Generate buy & sell orders on each receipt/withdrawal.
    • Allows for security redemption/transfer to DP.
    • Generation of letters to Fund Accountant.
    • Generation of acknowledgement letters to client.
    • Different views are provided to view the client wise & product wise Buy/Sell list.
    • Generate Excel report of buy sell to send to broker.
    • Multiple Buy/Sell generation is allowed before the close of buy/sell
    • Close buy sell process

    Order Book Creation (Dealer Operation)

    • Select buy & sell transactions for trading and create broker-wise orders for all the products. The selection is allowed client-wise for new clients.
    • Option is given to modify the generated buy & sell orders at the discretion of Fund Manager.

    Broker Wise Trade Updates (Dealer Operation)

    • Upload/enter deals executed by the broker.
    • Upload Contract Notes received from the broker. Supports the FT's STP format.
    • Matching the contract notes with the deals.
    • Close Order Book process.
    • Generate a excel report for trades done for the day.

    Allocation (Auto allocation, as per buy/sell, across clients, specific clients and manual) (Back Office Operation)

    • Allocate traded transactions to clients after closing Order Book
    • Generate allocation report
    • Close Allocation
    • Allocation is done on the basis of orders generated.
    • Automatic skip of clients, security & saleable quantity during allocation.
    • Available Cash Balance is considered during allocation.

    Day End Activity (Back Office Operation)

    Closing allocation is day end activity. If any mistake has happened in process, rollback the day process to Order Book or Buy/Sell and do the processing again till closing of allocation. Generates excel files for capital transactions and allocation to be uploaded by the Fund Accountant.

    XIRR Calculation

    Capital Gain/Loss Calculation

    Reports

    • Asset Under Management Product Wise Report
    • Asset Under Management Client Wise Report
    • Daily Allocation Client Wise Report
  4. Capital Preservation PMS Module

    Capital Preservation Based PMS Module aims to provide capital preservation for the client based on his level of risk taking. The product function is as follows:

    A client invests X amount in the product. Based on the client's risk taking ability, a part of the money received is invested in a fixed income bearing security and the balance amount is used for systematic investment in options. Based on different opportunities available in market for options investments different schemes are created (for e.g. Index Based Option Investment, Sector Based Option Investments & Script Based Option Investments.)

    Process Flow Features

    • Day Begin Activity
    • Upload of Fund Accountant & Custodial interface files (holding, transactions and balance sheet files)
    • Defining Option series
    • Investment in Fixed income instruments
    • Generate buy sell for options trades for option component for the client.
    • Redemption
    • Create Order book and Update trades
    • Allocation of trades
    • Allocation is based on orders generated.

    Reports

    • Asset Under Management Product Wise, Client Wise Report
    • Buy/Sell List Report
    • Order/Trade Book Report
    • Allocation Report
  5. Fee Module
    • Fee rules creation for clients
    • Fee rules creation for distributors
    • Assigning fee rules to client and distributors
    • Calculating fees
    • Upfront, Trail & Profit Sharing based rule creation is allowed
    • Client Wise Management Fees Report
    • Distributor Wise Management Fees Report
  6. SEBI/MIS Reports
    • Following concepts are used throughout the system to help the audit of PMS by regulatory authorities:
    • Maker/Checker
    • Audit Trail
    • Rollback
    • Logs
    • User & Date Time Stamping
  7. Web Interface

     

    The clients can login to the web site and access the following information.

     

    Capital - Capital Statement

    - Capital transactions

    Portfolio - Portfolio Statement

    - Portfolio Transactions

    Performance - Performance Analysis

    Financial - Income Statement

    - Balance Sheet

    Hardware Requirement:
    • IBM Compatible Server P4
    • 1.5 GB RAM
    • 160 GB Hard Disk
    Software Requirement
    • Windows 200x Server operating system
    • IIS Web Server configured with SMTP gateway to send mails
    • Oracle 8i onwards
    • Crystal
  8. Customisation in process for Indian Market.
    • Incorporate derivatives for the purpose of hedging/trading based on percentage of value of underlying securities or portfolio.
    • MTM margin calculation at Day Begin and reduction of the same from cash available.
  9. Customisation in process for PAMS.
    • Customisation of desktop application to handle Korea Market specifics.
    • Sharing of common masters like Distributor, Advisor and Distributor's relationship managers across markets.
    • Extraction of data from local databases to a common database for web site.
    • Common login for client across markets.
    • Display of data in client selected currency.
    • Distributor and Relationship manager login to view client data.
    • Advisor login to view product data.
    • Graphical representation of data for client.
    • Website demo.
    • Chat & Web cast.