Manual - MProfit
Contents
1. Map the following Mutual Fund HDFC Equity Fund Growth Folio 111111 For PORTFOLIO Ashish Mehta To HDFC Equity Fund Growth Option Folio 111111 es Click lt Skip gt to skip mapping this item Mutual Fund Skip all further requests for mapping Posa lt a MProfit User Manual Back to Index Page 25 Step 5 Once the mutual fund names are mapped you will be shown a review screen where you can edit and approve the transactions Once you have reviewed all the data you can select Import and all the transactions will be added into the portfolio s Transaction Folio Number Shef Mehta Reliance Growth Fund Growth Pla 222222 02 07 09 336 2638 Ashish Mehta HDFC Equity Fund Growth Option 111111 17 07 09 13 89 Ashish Mehta HDFC Equity Fund Growth Option 111111 20 07 09 14 32 Shef Mehta Reliance Growth Fund Grovth Pla 222222 20 07 09 n 344 4786 Shef Mehta HDFC Equity Fund Growth Optio 222222 21 07 09 14 24 Ashish Mehta HDFC Equity Fund Grovth Option 111111 22 07 09 14 01 Ashish Mehta HDFC Equity Fund Growth Option 111111 23 07 09 Ashish Mehta HDFC Equity Fund Growth Option 111111 24 07 09 Shef Mehta Reliance Growth Fund Growth Pla 222222 28 07 09 MProfit User Manual Back to Index Page 26 Predefined Excel sheets Using the templates provided you c2. MPRO FIT Desktop Portfolio Management S oftware mprofit in Bonds vergi SS ppr ere pot office amp God gg 7 Leen vert Table of Contents Overview Getting Started ACTIVATE LICENS Wa 5 lie AT 5 Getting Started Balloon Notification ENEE 5 Asset Classes 6 Asset Classes Stocks Shares ssssssssssssecccccessesessssssnsceeseceeccsesccensnsssseeeeeeceecceseesensnsssnaneeeececceeeeecens 6 Asset Classes Mutual Funds MEFS sssssssssessescesecccceecccceccccesccscesseeeesseessssessesssesessesecesescesssesesseeeees 6 For Systematic Investment Plans SIPS ccsssssssccccceccccceeeesesssssseceeccececcceeeeeessnssseceeeeececcceeeeeeneeees 7 Asset Classes Unit Linked Insurance Products ULIPS iii eee 7 Asset Classes Insurance Policies Without Unit Linked Dans 8 Asset Classes Private EQUITY ui i Eaa EEE E Eea nera 8 Asset Classes Fixed Deposits FD annali 8 en EE 9 Asset Classes DEPOSILS LOAN Sia Aire 9 Asset Classes PPF EPPaissssssasescccceteccesdateasseancscecceducciesveathosnsacuaseeccoen PeR 9 Asset Classes e E 9 ACCIAI FEES ai 9 Lee UE 10 Asset Classes JEWELIOLY asninn en E O Eeer 10 Asset Classes PA ariana 10 ASSEt ClaSSES EE 10 Asset Classes Ee ET 10 Liabilities Loans 10 Reports 11 Reports Analytical AE E 11 Reports Analytical Portfolio SUMMAary iii rie eee rien eine 11
3. etc e The other features are quire similar to other asset types Asset Classes Jewellery e To keep track of your jewellery you can enter transactions in this asset class e It is important to include jewellery in your asset list as it will give a true report of your net worth e The other features are quire similar to other asset types Asset Classes Properties e To keep track of your property real estate you can enter transactions in this asset class e tis important to include property in your asset list as it will give a true report of your net worth e The other features are quire similar to other asset types Asset Classes Art e To keep track of your art collection you can enter transactions in this asset class e It is important to include art in your asset list as it will give a true report of your net worth e The other features are quire similar to other asset types Asset Classes Miscellaneous e This category of asset is helpful if you would like to create any asset which is not part of the above listed categories e Examples for this categories are Kisan Vikas Patra NSC certificates Investment in foreign countries Amount allocated for commodities account amount allocated for Derivatives trading etc e You need to provide the following details like interest rate Maturity Date Lock in Date Cumulative or Pay out option and Frequency of Compounding like Yearly Half Yearly Quarterly or Monthly e Maturity Value will be ca
4. 221 and select Import from file In MProfit to switch from one directory to another directory eGo to Settings Select Change Portfolio Data Location Select say C MProfitData AshishMehtaFamily MProfit User Manual Back to Index Page 24 CAMS WBR2 Follow the same steps for KARVY 221 but instead select your CAMS WBR 2 file you received CAMS Personal Step 1 Select Import CAMS Personal file Step 2 Select Import from file and select the CAMS file you received Step 3 Map to a Portfolio Select the portfolio where you want the transaction to be added Mappings for Data Import s Map the following Portfolio User ID Client ID PAN Sy lt a KS SHAH To Mr Shah New Click lt Skip gt to skip mapping this item Portfolio User ID Client ID PAN Skip all further requests for mapping Quit Import Press lt F1 gt for help o Skip Step 4 Map the scheme names in MProfit Select the portfolio where you want the transaction to be added Since you are doing this for the first time you will have to select New to find the fund name If you have a mutual fund like HDFC Equity Fund Growth for multiple portfolios you will need to map it to each folio number and you might have A or 5 entries for HDFC Equity Fund Instead of scrolling through the entire list you can use Crtl F to search for specific words in the scheme name to find it Mappings for Data Import lt
5. you can choose to expand all the transactions where there are multiple buys against sale Choose Show Details and entire report will be expanded with details Reports Accounts These reports are useful for your accounting entries as well as for reconciliation with your books of accounts Reports Accounts Income e Reports give a summary or detailed view of income generated from your assets e For stocks it would include dividend payout For mutual funds it would include dividend pay out and dividend reinvestment For property it would include rent received The report also includes all the interest income from your fixed income investment such as Bank FDs Bonds PPFs Post Office etc Reports Accounts Accounting JVs e Useful for entering journal entries for accounting purposes It lists the journal voucher entries based on stocks and MF buy and sale transactions e With stocks details like debit credit of intra day profit loss short term or long term capital gains STT transaction charges and broker s ledger account are listed based on the contract note details e With Mutual Funds details like debit credit of short term or long term capital gains and bank s account are listed based on the buy or sale transaction Reports Accounts Closing Balances e This report displays the closing balances of Stocks and Mutual Funds as per your books of accounts for the selected period e You can track the balance quantity as well as amo
6. Ifyou want to take incremental backup you need to rename the file each time you take backup such as MProfitBackupo1Deco8 MProfitBackup31Maro9 etc There are two options available for Backup a Backup without password With this option your entire portfolio data willbe backed up without password b Backup and Encrypt with password You will need to give the password for this option Please do remember the password as you will not be able to restore the data without password Menu Tools Restore Data e Your backed up data can be restored with the appropriate option e Your restore option selection is dependent on how you have backed up your data e Ifyou have used the backup option with password you need to provide the correct password to restore the data You need to restore the data in an empty directory MProfit User Manual Back to Index Page 29 Menu Settings You can change Default Period location of the data directory of your portfolios and password for Owner and User Menu Settings Change Default Period When you start the application for the first time the default period is till current financial year e You can add records of previous years as well current year e Once you have completed the entries of the previous year it is recommended that you change the period to current financial year so that all the reports by default will be displayed or printed for the current financial year Menu Settings Change
7. Portfolio Data Location e At the time of installation your data files by default are stored in My Documents mPrData Portfolios if you have not chosen to change the path of the directory e You can change the location of your portfolio data directory any time by selecting this option Menu Settings Change Password MProfit provides two types of access to the application the Owner and User e Owner has all the rights for this application where it can see current prices as well as the current values of all the portfolios e The User has limited rights whereas current prices and current values are not displayed in the summary screen e The passwords for both the types the Owner and the User can be changed by selecting this option Menu Settings Proxy Settings If you are using MProfit behind a company firewall then you might have to make changes to allow MProfit through the company proxy server You will need to obtain 4 pieces of data from your network administrator e Proxy Server Address and Port Number e Username and Password Menu Help General help section Menu Help General Help lt F1 gt This help file you are viewing Menu Help Check for Updates We are constantly listening to customer feedback and improving MProfit based on your feedback e You will receive the message when the new software version or update is available e Ifyou click Yes to install it the new software update version will be downloaded an
8. Sejal Shah Family which has two portfolios Sejal Shah and Vaishali Shah Select a client on the left hand side Name in External File and then map to the same client on the right hand side Name in MProfit System Do this for allthe portfolios in this directory and make sure to tick Do not ask for Portfolio Mapping while importing When you are done select Ok MProfit User Manual Back to Index Page 23 Step 8 Select Import from file You will now be asked to map the individual mutual fund names to the individual portfolio names in MProfit Since you are doing this for the first time you will have to select New to find the fund name If you have a mutual fund like HDFC Equity Fund Growth for multiple portfolios you will need to map it to each folio number and you might have 4 or 5 entries for HDFC Equity Fund Instead of scrolling through the entire list you can use Crtl F to search for specific words in the scheme name to find it Map the following Mutual Fund HDFC Equity Fund Growth HDFC Equity Fund Growth Option Folio 666666 Click lt Skip gt to skip mapping this item Mutual Fund Skip all further requests for mapping Step 9 Once the mutual fund names are mapped you will be shown a review screen where you can edit and approve the transactions Once you have reviewed all the data you can select Import and all the transactions will be added into the Sejal Sha
9. a group in minutes Step 1 To create two portfolios Select Open Portfolio and then select New e Enter your details and then select Save e Repeat the above steps to create a second portfolio Step 2 Add a transaction e Select a portfolio Double click on icon of the asset you want to add from panel on the left if you want to add a stock transaction double click on the Stocks icon e Enter your contract note details e Then select Save Step 3 To create a group Select Open Group then select New e Enter anew name and select the two new portfolios you created in Step 1 e Click Save and then click Close Step 4 Open up your two new portfolios and the group view you created Select Open Portfolio then select the first new account e Again select Open Portfolio and then select the 2nd new account Select Open Group and select the group you created For more help visit us online at Quick Start Guide PDF Our 10 minute quick start guide YouTube Tutorials Online Forums MProfit User Manual Back to Index Page 4 Activate License When you install MProfit it will work as a 30 day trial version After the trial period your trial license will expire and will work with limited functionality To activate the license for fully functional use please go to http www mprofit in buy and purchase an MProfit yearly license You will receive the Activation Key
10. an existing broker in MProfit you can select New and create it Then select Ok Map the following Broker Kotak Securities Ltd To Kot Securities Click lt Skip gt to skip mapping this item Broker E Skip all further requests for mapping Press lt F1 gt for help MProfit User Manual Back to Index Page 18 Step 3 Map to a Portfolio Select the portfolio where you want the transaction to be added Map the following Portfolio User ID Client ID PAN Wega Ki Ree SHAH To Mr Shah e Click lt Skip gt to skip mapping this item Portfolio User ID Client ID PAN Skip all further requests for mapping Step 4 Map the scrips This will ensure that the correct scrip name is added to your portfolio For each scrip this will be occur Click lt Skip gt to skip mapping this item Company Skip all further requests for mapping Step 5 Review window This allows you to make any changes to the data before it is imported into your portfolio When you are ready to import the data select Import R 5716997 Reliance Natural Resources 25 03 10 United Bank of India 25 03 10 United Bank of India 25 03 10 MProfit User Manual Back to Index Page 19 CAMS KARVY If you are an independent financial advisor and receive your clients mutual fund transactions via a CAMS KARVY file then you will be able to import that data
11. and Long Term Capital Gain for stocks equity mutual funds and debt mutual funds Reports Capital Gain Transaction wise e This gives the transaction wise details of Intra day Profit Loss Short Term Capital Gain and Long Term Capital Gain for stocks equity mutual funds and debt mutual funds e It gives date wise capital gain details of stocks and MFs which were sold or redeemed e The detailed view of specific transaction can be expanded by clicking on the transaction where there are multiple buys against one sale quantity e In customization form you can choose to expand all the transactions where there are multiple buys against sale transactions Choose Show Details and entire report will be expanded with details Reports Capital Gain Summary amp Categorised into LT ST amp Speculative e Here you will get separate summary report for Intra day Short Term 8 Long Term Capital Gain e The report can also be customised to get any one of category like Intraday Short Term or Long Term Reports Capital Gain Transaction wise amp Categorised into LT ST amp Speculative e Here you will get separate transaction wise report for Intra day Short Term amp Long Term Capital Gain e It gives date wise capital gain details of stocks and MFs which were sold or redeemed e The detailed view of specific transaction can be expanded by clicking on the transaction where there are multiple buys against one sale quantity e In customization form
12. by email To activate the license go to the Help Menu and select Activate License In the Activation Key box enter the Activation Key sent to you and click Activation License The software will be activated with full functionality for the length of the license Summary Screen The default view of MProfit is the Summary Screen e You can see different tabs on the left hand side of the panel for Assets Liabilities and Reports e The Asset tab is used to go to the summery screen where you can enter Buy Sell transactions for various assets e The Liabilities tab is used to go to the screen where you see the list of your creditors and your liabilities e The Reports tab will take you to the Reports page where the different categories of reports are listed e Today s gain and Overall gain will be calculated in case of stocks and mutual funds based on the closing prices In Interest bearing assets like FDs PPF Deposits Loans Post Office today s gain and overall gain s display the accumulated accrued interest e You can customise the views on the summary screen The assets can be sorted based on the current value or the names e You can hide zero quantity assets to get the clean view of the summary screen The settings for the views will be saved for each portfolio and will be retained when you start the application next time e The Quick Reports button gives you quick access to several reports portfolio summary trading P L sum
13. calculated based on the reducing balance method In case interest payout is entered than the final current value and maturity value in case of cumulative deposit loan will be adjusted based on this interest payout amount Asset Classes Post Office These categories are very similar to Bank Fixed Deposits You need to first create the asset by click New button next to the title field You need to provide the following details like interest rate Maturity Date Lock in Date Cumulative or Pay out option and Frequency of Compounding like Yearly Half Yearly Quarterly or Monthly Maturity Value will be calculated based on these details Summary screen shows the accumulated accrued interest in today s gain as well as overall gain The current value and maturity value are calculated based on the reducing balance method In case interest payout is entered than the final current value and maturity value in case of cumulative deposit loan will be adjusted based on this interest payout amount Asset Classes Gold Create the title as you please like Standard Gold 18K Gold or if you want to name the title with the name of the vendor you purchased e g Gold TB Jewellers etc The other features are quire similar to other asset types MProfit User Manual Back to Index Page 9 Asset Classes Silver e Create the title as you please like Silver or if you want to name the title with the name of the vendor you purchased e g Silver TB Jewellers
14. e From the toolbar select Edit Master and select Edit Group Portfolio then select Edit e You can change the name of the Group and also select which portfolios to include in the Group Menu Edit Master This section will help you understand the various options available to create modify or delete various records like Portfolios Groups Assets and other accounts Menu Edit Master Edit Portfolio The portfolio can be added edited or deleted from here e To delete any portfolio you must first delete all the transactions from that portfolio Menu Edit Master Edit Group Portfolio e Modify the composition of Group portfolio by adding or deleting one or more portfolios to the existing Group e Create the new Group portfolio by clubbing the various portfolios to the new group Menu Edit Master Create New Asset e You can create any asset name by selecting the appropriate Asset category e Newly listed stocks and MFs are added updated automatically Menu Edit Master Edit Delete Asset e You can modify or delete the existing asset except Stock name e If there are any transactions associated with particular asset the asset can not be deleted e You first have to delete all the transactions associated with the respective asset in order to delete it Menu Edit Master Other Accounts e The details of other accounts such as Brokers Agents Banks Insurance Companies and Sellers can be edited or deleted by selecting this option
15. from simple to comprehensive you can select which reports to create depending on your needs The reports are divided into 5 categories Analytical Covers asset allocation absolute and annualised returns e Transactions Covers all transactions related to purchase sale bonus and dividend reinvestments e Capital Gain Covers transaction relating to capital gains e Accounts Covers accounting entries as well as for reconciliation with your books of accounts e Miscellaneous Covers brokerage charges STT as well as transaction charges e You can customise most of the reports to give you specific desired results such as sorting name or date wise filter for specific asset or broker agent e Allreports are provided with a default title which you can customise the e You can add a second title of your choice in the report e Group reports provide the consolidated reports of all the members of the respective group e You can change the period to get the reports other than the default period Reports Analytical Analytical Reports such as Portfolio Summary Trading Profit Loss Asset Allocation Annualised Returns Realised and Unrealised reports are covered in this category Reports Analytical Portfolio Summary e A detailed report to view the net worth with the detailed portfolio summary which includes total balance quantity amount invested current price overall gain in Rupees and percentage and current value e You can custo
16. is visible in MProfit Step 2 Goto Import and select Value Research Online from Mutual Funds and Others section Step 3 Select Import from website and login to your Value Research Online account Step 4 Click on My Portfolio Step 5 Select the portfolio for which you want to import transactions Step 6 Click Transactions History Step 7 Click Import button at the bottom right corner to import the transactions Note Bonus and rights transactions will be imported however other corporate action transactions like split merger demerger will not be imported You will need to add these transactions manually MProfit User Manual Back to Index Page 28 Menu Tools Price updates refresh summary screen backup and restore are some of the options that fall under this menu Menu Tools Update Prices Now Price updates are updated when you start MProfit and it will keep updating the price of the newly added stocks and MFs e You can update the prices anytime by selecting this option Menu Tools Refresh Summary Screen e Summary screen are updated dynamically whenever the new assets are added The prices of all the assets are also updated at predefined intervals e You can refresh the summary screen anytime by choosing this option Menu Tools Backup Data e MProfit provides a very comprehensive backup solutions to meet the requirements of our users e Backup files will be overwritten each time you take backup e
17. need to enter a new activation key that can be obtained by emailing MProfit Support at support mprofit in e Once we receive the email we will send you instructions on how to enter the new activation key Menu Help About The About screen shows the current version number and build of the software Other Features Many features are available by right clicking the mouse on certain areas of the screen e Income e Tax Calculator e Last Transactions e Set Current Prices there are various ways to set current prices for different assets e Show Previous Name Back up feature Weekly Monthly MProfit User Manual Back to Index Page 31 v5 3 02102011 System Requirements e Windows XP Vista or 7 An internet connection MProfit Software Pvt Ltd 108 B Mittal Tower 10th Floor B Wing Nariman Point Mumbai 400 021 022 4002 4149 022 2202 4398 sales mprofit in http www mprofit in Desktop Portfolio Management Software mprofit in MProfit Software Pvt Ltd 2011
18. to lt Ashish Mehta gt Shefali Mehta Mapped to lt Shef Mehta gt Sejal Shah Unmapped Remove Mapping Vaishali Shah Unmapped Do not ask for Portfolio NI Mapping while lt II r Select the Name and Portfolio to map and click lt Map gt to add mapping ox Step 3 Select Import from file You will now be asked to map the individual mutual fund names to the individual portfolio names in MProfit Since you are doing this for the first time you will have to select New to find the fund name If you have a mutual fund like HDFC Equity Fund Growth for multiple portfolios you will need to map it to each folio number and you might have A or 5 entries for HDFC Equity Fund Instead of scrolling through the entire list you can use Crtl F to search for specific words in the scheme name to find it Mappings for Data Import Map the following Mutual Fund HDFC Equity Fund Growth Folio 111111 For PORTFOLIO Ashish Mehta pe To HDFC Equity Fund Growth Option Folio 111111 m es Click lt Skip gt to skip mapping this item Mutual Fund E Skip all further requests for mapping Quit Importing Pess lt a SSES MProfit User Manual Back to Index Page 22 Step 4 Once the mutual fund names are mapped you will be shown a review screen where you can edit and approve the transactions Once you have reviewed all the data you can select Import and all the transactions will be added into the Mehta F
19. Equity category First you need to create the name of the asset type by clicking the New button Asset Classes Fixed Deposits FDs New FD can be created by choosing Investment and creating new title for the FD The titles like State Bank of India 5 Years Deposit or HDFC Bank 1 Year Deposit are ideal when you create multiple deposits The same title can be used for different deposits at different times with different FD reference numbers Interest income and withdrawal entries can be added in the respective FDs by choosing the same from the drop down list You need to provide the following details like interest rate Maturity Date Lock in Date Cumulative or Pay out option and Frequency of Compounding like Yearly Half Yearly Quarterly or Monthly Maturity Value will be calculated based on these details Summary screen shows the accumulated accrued interest in today s gain as well as overall gain In case of partial withdrawal the withdrawal amount should be entered in the withdrawal form as two components principal amount and interest pay out on this partial withdrawal as per the statement of the bank to calculate the accurate maturity value and current value MProfit User Manual Back to Index Page 8 Asset Classes Bonds First you need to create the name of the asset type by clicking the New button You have the option to calculate the current value based on accrued interest If the current price of the valu
20. MProfit User Manual Back to Index Page 16 Menu Edit Master Manage ULIP Funds e You can add edit and delete any funds associated with any particular ULIP plans Menu Import MProfit can import data from 5 types of data sources a Brokerage digital contract notes b CAMS KARVY mutual fund files c Predefined Excel formats for stocks and mutual funds d Online portals e Backoffice files This manual will cover how to import from the various file types into MProfit From the main menu select Import which will bring up the Import window D Open Portfolio Ea Open Group amp Edit Master DN Import SE Tools ii Settings g Help Mr Shah Mrs Shah TestGroup G CAMS WBR2 Deposits Loans PPF EPF Ea Pos ofice Gold SW Silver Angel Broking CAMS WBI CAMS Personal ICICidirect com Trade Book India Infoline IIFL Modify Mappings for Selected Template 9 52 487 50 5 830 00 3 69 410 00 81 000 00 53 850 00 46 715 00 1 79 317 50 1 19 015 00 34 605 00 47 755 00 14 990 00 44 10 394 11 37 60 923 30 4 45 203 00 Prices fetch started Re Calc Signal sent Re Calculate All Current Prices retrieved 12 12 34 232 Please note that the BSE Prices and MF NAVs are closing values as on 03 12 10 MPROFIT MProfit User Manual Back to Index Page 17 Digital Contract Notes Most brokers send HTML c
21. Reports Analytical Trading Profit LoSS iii 11 Reports Analytical Asset Allocation zizi E 11 Reports Analytical Annualised Returns XIRR cccccssssssececssssseccesssssseeeecssssseecessseeeeesssesseeeesessnes 11 Reports Analytical Realised and Unrealised Gain LOSS iii 13 Reports Analytical Realised Gain LOSS iii 13 Reports Trans EE 13 Reports Transactions Contract Notes 13 Reports Transactions Mutual Fund Transaction Details 13 Reports Transactions Other Transaction Details 13 Reports Capital il E EAEEREN E EA ERR EKEEEEENEEEEN 13 Reports Capital Gaim SUM MALY sscssceveversvsssececcesasasevevdevevesescaae ctasgauvevevevessssteceacesusnanvetervesvessasteosaaan 14 Reports Capital Gain TramSaction WiSe ia 14 Reports Capital Gain Summary amp Categorised into LT ST amp Speculative 14 Reports Capital Gain Transaction wise 8 Categorised into LT ST amp Speculative 14 Reports aa 14 Reports Accounts INCOME neo Ee 14 Reports Accounts Accounting Ne 14 MProfit User Manual Back to Index Page 1 Reports Accounts Closing BalancCes ceeeseecceeccccecccccecccceeceeeaceessssssssesseescsseeececceceeceeeseceeeeeeeees 14 Reports MiscellaneoUs amunar air a 15 Reports Miscellaneous Brokerage Details for Stocks AAA 15 Reports Miscellaneous STT Details rnrn ENTREE E A EE 15 Reports Miscellaneous Transacti
22. We currently support 2 file types for advisors CAMS WBR2 and Karvy 221 If you are a retail investor we support the CAMS file format for individuals and Karvy Online With MProfit there is no limit to the number of portfolios you can create and maintain You can manage 1 100 or 1000 clients with the software It is recommended that you create individual portfolio directories for each family You should create a master directory C MProfitData then start creating the client family sub directories as follows C MProfitData AshishMehtaFamily C MProfitData SejalShahFamily C MProfitData RamPatelFamily To switch from one directory to another directory Go to Settings Select Change Portfolio Data Location Select say C MProfitData AshishMehtaFamily The application will be restarted with the portfolios of the Ashish Mehta family The advantage of this directory structure is that you can easily backup the individual directory and give the data to your client who might be using MProfit as well KARVY 221 Before importing the data from the KARVY 221 file you must do several steps that only occur the first time you run the import feature After the initial steps are complete then it becomes just a series of clicks to import all the data into MProfit on a regular basis As stated before it s recommended that you create individual portfolio directories for each family You should create a master directory C MProfitData then s
23. amily portfolios Folio Number Reliance Growth Fund Growth Pla 222222 02 07 09 336 2638 1 000 00 Ashish Mehta HDFC Equity Fund Growth Option 111111 17 07 09 13 89 300 00 Ashish Mehta HDFC Equity Fund Growth Option 111111 20 07 09 14 32 300 00 Shef Mehta Reliance Growth Fund Growth Pla 222222 20 07 09 344 4786 1 000 00 Shef Mehta HDFC Equity Fund Growth Optio 222222 21 07 09 14 24 300 00 Ashish Mehta HDFC Equity Fund Growth Option 111111 22 07 09 14 01 300 00 Ashish Mehta HDFC Equity Fund Growth Option 111111 23 07 09 14 46 300 00 Ashish Mehta HDFC Equity Fund Growth Option 111111 24 07 09 14 64 300 00 SSN S 8S 8 8 S Shef Mehta Reliance Growth Fund Growth Pla 222222 28 07 09 356 6247 300 00 You have successfully added transaction to the Mehta Family directory The next time you import the data for the Mehta Family you will only have to map new mutual fund names Step 5 Now let s change to the Sejal Shah family in MProfit eGo to Settings eSelect Change Portfolio Data Location eSelect say C MProfitData SejalShahFamily The application will be restarted with the Sejal Shah family Step 6 Goto Import and select KARVY 221 from the Mutual Funds and Others section Step 7 Select Add Mappings for Portfolios We will now map the portfolios for the
24. an import your stock and mutual fund transactions into MProfit Stock Transactions Step 1 We provide a template for stocks download the file from http www mprofit in import mprofit_stock xls all lowercase Step 2 Open the Excel file and follow the instructions at the top of the Excel sheet It will tell you what transactions are supported and where the data should go We currently support 4 transaction types that you can enter into the Trans Type column BUY SELL BONUS and DIV_PAYOUT Step 3 Save the Excel file as Excel 97 2003 Workbook Step 4 Goto Import and select MProfit Stock Transactions from Brokers Contract Notes section Select Import from file and select the file you just saved Mutual Fund Transactions Step 1 We provide a template for mutual funds download the file from http www mprofit in import mprofit_mf xls all lowercase Step 2 Open the Excel file and follow the instructions at the top of the Excel sheet It will tell you what transactions are supported and where the data should go We currently support 4 transaction types that you can enter into the Trans Type column BUY SELL DIV_REINV and DIV_PAYOUT Step 3 Save the Excel file as Excel 97 2003 Workbook Step 4 Goto Import and select MProfit Mutual Fund Transactions from Mutual Funds and Others section Select Import from file and select the file you just saved MProfit U
25. ct Note Inumber 2 Review the transactions and select Reliance Money si Value Research Online Modify Mappings for Selected Template Add Mappings for Portfolios Step 2 Select Add Mappings for Portfolios Once the file is done processing you will see ALL your clients on the left hand side from the file and on the right hand side you will see the individual portfolios in MProfit for that particular client In this example we see the Mehta Family has two portfolios Ashish Mehta and Shefali Mehta e Add Portfolio Mappings Name in Extemal File Name in MProfit System i Ashish Mehta Names in File Status Shef Mehta Mr Ashish Mehta Unmapped Shefali Mehta Unmapped Sejal Shah Unmapped Remove Mapping Vaishali Shah Unmapped Do not ask for Portfolio RZ Mapping while m r Select the Name and Portfolio to map and click lt Map gt to add mapping MProfit User Manual Back to Index Page 21 Select a client on the left hand side Name in External File and then map to the same client on the right hand side Name in MProfit System Do this for all the portfolios in this directory and make sure to tick Do not ask for Portfolio Mapping while importing When you are done select Ok r Add Portfolio Mappings el Name in Extemal File Name in MProfit System Ashish Mehta Names in File Status Shef Mehta Mr Ashish Mehta Mapped
26. d installed on your PC The time for downloading the update depends on your internet connection speed MProfit User Manual Back to Index Page 30 e Make sure that your firewall settings of your PC does not block the MProfit application Database updates like addition of newly listed stocks mutual funds or name change of a company are provided online and automatically updated in the MProfit database file on your PC e When these database updates are available U symbol will be displayed at the bottom of the screen e The updates can be accepted by clicking on the U symbol The application will be restarted to accept the new updates e You can click Check for Updates under Help menu any time to check the availability of database updates Menu Help Activate License e When you install MProfit it will work as a 30 day trial version After the trial period your trial license will expire and will work with limited functionality To activate the license for fully functional use please go to http www mprofit in buy and purchase an MProfit yearly license You will receive the Activation Key by email e To activate the license go to the Help Menu and select Activate License In the Activation Key box enter the Activation Key sent to you and click Activation License The software will be activated with full functionality for the length of the license Menu Help License Management e Ifyou upgrade or format your computer you will
27. e is set manually the current value will ignore the gain based on interest but it will calculate the gain based on current price Asset Classes Deposits Loans These categories are very similar to Bank Fixed Deposits You need to first create the asset by click New button next to the title field You need to provide the following details like interest rate Maturity Date Lock in Date Cumulative or Pay out option and Frequency of Compounding like Yearly Half Yearly Quarterly or Monthly Maturity Value will be calculated based on these details Summary screen shows the accumulated accrued interest in today s gain as well as overall gain The current value and maturity value are calculated based on the reducing balance method In case interest payout is entered than the final current value and maturity value in case of cumulative deposit loan will be adjusted based on this interest payout amount Asset Classes PPF EPF These categories are very similar to Bank Fixed Deposits You need to first create the asset by click New button next to the title field You need to provide the following details like interest rate Maturity Date Lock in Date Cumulative or Pay out option and Frequency of Compounding like Yearly Half Yearly Quarterly or Monthly Maturity Value will be calculated based on these details Summary screen shows the accumulated accrued interest in today s gain as well as overall gain The current value and maturity value are
28. ect the transaction type as Payable or Receivable so that only Payable or Receivable records are displayed in the report Reports Transactions Mutual Fund Transaction Details e Transaction related to subscription redemption dividend reinvestment and bonus are obtained through this report e You can customise to select report based on date wise transactions or MF scheme wise transactions e In customization form you can select MF Type as Equity Debt or ALL to display the records of the respective MF type e You can also filter the report based on transaction type such as Buy Sell or Dividend Reinvestment Reports Transactions Other Transaction Details e Transactions are listed with details such as income withdrawal investment opening and closing balance e Three reports available for ULIP Insurance and Other Assets Reports Capital Gain e Capital gain reports are prepared based on First In First Out FIFO method e Incase of stocks STT and transaction charges are not added to the purchase or sale amount however the brokerage is added to the purchase amount and it is deducted from the sale amount e Capital Gain calculations are automatically adjusted based on corporate actions such merger demerger split and bonus as per income tax rules amp regulations MProfit User Manual Back to Index Page 13 Reports Capital Gain Summary This gives the summary report of Intra day Profit Loss only for stocks Short Term Capital Gain
29. eme This is important as you would see separate reports for EQ MF and Debt MF as capital gain tax calculations are different for Equity MF and Debt MF You can maintain the records of folio number lock in date and agent name for each mutual fund scheme Any MF transaction can be edited by double clicking the particular transaction from the MF transaction list from summery screen You can use the right click on the particular transaction to edit the same To delete the particular transaction you need to open that MF transaction and click on the Delete Record button You can use the right click on the particular transaction to delete the same Once the record is deleted it can not be retrieved back The details regarding Folio Number Agent Name and Lock in Period can be seen in balloon notification while moving the cursor over the mutual fund name For Systematic Investment Plans SIPs You can record all your SIP transactions in MProfit SIP is a regular buy transaction Subscription of MF scheme at a regular interval with the same fixed amount Right click on the MF icon on the left hand side of the summary screen or Right click on the Buy Sell button on the right hand side of the summary screen Select Generate SIP Entries You can select this from Activity Menu as well You will see the MF SIP form You need to select the MF name SIP starting date SIP ending date frequency of SIP transactions like monthly quarterly etc and the a
30. ettings Proxy Settings ssssssssssssssssesssecceescceecceceecccsesseeeaseeesssessssssssseseseseeesseeesceseeeeeses 30 Menu Help 30 Menu Help General 30 Menu Help Check for UDHA SE iia AUA EA 30 Menu Help Activate LICENSE Aaa 31 Menu Help License Manageme nt ssssseeesssecceecccceccccceccaceceecaascesssssssssseesesseeceeececceseeececeeeeeseaes 31 MProfit User Manual Back to Index Page 2 Menus HID ABOUTS AA 31 Other Features 31 MProfit User Manual Back to Index Page 3 Overview MProfit is an easy to use personal desktop Portfolio Management Software for Indian retail investors and Non Resident Indians NRIs It allows you to take control of your investments such as stocks MFs ULIPs insurance policies property gold and many other asset classes And does it securely since all your personal data is saved locally on your computer e Manage an unlimited number of individual and groups portfolios e Manage all your assets like stocks MFs FDs ULIPs PPF property gold and more e Import data from contract notes CAMS KARVY Excel and online portals e Online auto updates for stock prices mutual fund and ETF NAVs e Many reports for annualised returns capital gains asset allocation and others e Allyour financial data is saved locally on your computer Getting Started When you start MProfit for the first time you will see a blank screen You can easily create a couple portfolios and
31. ght click on the particular transaction to edit the same e To delete the particular transaction you need to open that CN transaction and click on the Delete Record button You can sue the right click on the particular transaction to delete the same Once the record is deleted it can not be retrieved back Asset Classes Mutual Funds MFs e The Buy subscription Dividend Reinvestment or Sell redemption transaction of the mutual fund can be entered by double clicking the MF icon on the left side of the asset list or by clicking on the Buy Sell button on the right side of the summary screen e When you are entering the MF scheme for the first time you are required to select the scheme from the pull down list of all the available MF schemes by clicking New button This is the one time process e Selection of the right name of MF scheme needs to be done very carefully as there are many scheme names which appear identical e Check with your MF statement to identify the correct scheme which you hold Once you select the scheme this will be added to your asset list and this MF scheme will be visible for all your portfolios MProfit User Manual Back to Index Page 6 You do not need to select this again from the whole list of MF schemes You can give the name of your choice of the MF scheme or retain the full name as displayed When you select the MF Scheme you need to specify the type whether it is Equity Scheme or Debt Sch
32. h Family portfolios Select Portfolio Name Transaction Folio Number Date Quantity Price dl v shah Reliance Growth Fund Growth Pla 888888 02 07 09 2 974 336 2638 1 000 00 IS V Shah Reliance Grovth Fund Grovth Pla 888888 02 07 09 2 974 336 2638 1 000 00 V Shah Reliance Growth Fund Growth Pla 888888 10 07 09 3 183 314 1224 1 000 00 Sejal Shah HDFC Equity Fund Growth Option 666666 17 07 09 21 598 13 89 300 00 Sejal Shah HDFC Equity Fund Growth Option 666666 20 07 09 20 95 14 32 300 00 V Shah Reliance Growth Fund Grovth Pla 888888 20 07 09 2 903 344 4786 1 000 00 V Shah Reliance Growth Fund Growth Pla 888888 20 07 09 2 903 344 4786 1 000 00 S 9 S S S S Sejal Shah HDFC Equity Fund Growth Option 666666 22 07 09 21 413 14 01 300 00 Sejal Shah HDFC Equity Fund Growth Option 666666 23 07 09 20 747 14 46 300 00 Sejal Shah HDFC Equity Fund Growth Option 666666 24 07 09 20 492 14 64 300 00 V Shah Reliance Growth Fund Growth Pla 888888 28 07 09 LI 356 6247 300 00 S S S S V Shah Reliance Growth Fund Growth Pla 888888 28 07 09 14 0331 2 500 00 Step 10 Repeat the above steps 5 9 for each client family you advise Step 11 When you receive a new Karvy 221 file you simply goto each client directory and select Karvy
33. ker Name also be added from the Summery Screen Menu by clicking Edit Master and selecting Other Accounts gt Brokers Agents e In CN the list containing the companies names will be dropped down as you start typing the name of the company To find the particular company based on part of the company name or previous name or BSE code press Ctrl F in the company field e Allthe listed stocks of Bombay Stock Exchange are included in the list e The newly listed BSE stocks will be updated online e Unlisted or Private Limited companies shares can be entered under Private Equity section e CN form is similar to the contract notes issued by your broker however each stock broker has their own format for contract notes You are familiar with most of the fields in CN but when it comes to charges it varies from broker to broker You should input the brokerage details and charges appropriately if you intend to view the specific reports related to brokerage STT or transaction charges It is recommended that you start following the practice of adding these charges separately This will help you to get the accurate reports for your capital gain taxation as well as for you to understand how much your broker is charging you under various heads such as Brokerage STT and Transaction charges e Any CN transaction can be edited by double clicking the particular transaction from the CN transactions list from summery screen You can use the ri
34. lculated based on these details Summary screen shows the accumulated accrued interest in today s gain as well as overall gain e The current value and maturity value are calculated based on the reducing balance method e In case interest payout is entered than the final current value and maturity value in case of cumulative deposit loan will be adjusted based on this interest payout amount Liabilities Loans This category will track all your liabilities e Click on the Liabilities button on the left hand side of the summery screen e Your total net worth will be calculated by adding current values of all your assets minus the current values of your all liabilities e You can track of various liabilities by creating appropriate titles e You need to provide the following details like interest rate Maturity Date Cumulative or Pay out option and Frequency of Compounding like Yearly Half Yearly Quarterly or Monthly e Maturity Value will be calculated based on these details e Summary screen shows the accumulated interest payable in today s gain as well as overall gain e The current value and maturity value are calculated based on the reducing balance method e Incase interest is paid out during the tenure of the loan than the the final current value and maturity value will be adjusted based on this interest pay out amount MProfit User Manual Back to Index Page 10 Reports Many reports can be generated by MProfit which range
35. mary and income summary e To go the default view of the summary screen of any portfolio you need to refresh the summary screen from the Tools Menu All the settings related to the summary screen will be set to its default level If you refresh the summary screen of any group the settings for the group as well as all associated portfolios will be set to default level e You can directly print the summary screen by clicking on the Print View button Getting Started Balloon Notification In order to give the instant information to investors MProfit provides various balloon notification about the important details related to the particular assets by moving the mouse over specific areas of the screen By moving the mouse over the Curr Value for an asset type you will get the annualised returns XIRR for that particular asset class e When viewing Mutual Funds details like Agent Name Folio Number Maturity Date Lock in Period Maturity Values will be displayed in balloon notification when the mouse is moved over the asset name e When viewing Insurance and ULIPs details like Policy Number Next Premium Due Maturity Date Lock in Period and Agent Name will be displayed in balloon notification when the mouse is moved over the asset name e When viewing Bonds FDs and Deposits Loans details like Reference Number Maturity Date Lock in Period and Agent Name will be displayed in balloon notification when the mouse is moved over the asset name e I
36. mise the report to view the summary of any asset category The Group Portfolio Summary report includes the consolidated view of all the members of the group e The Portfolio Summary report can also be directly printed from the summary screen by clicking Print View button Reports Analytical Trading Profit Loss e Trading summary and detailed reports useful for investors who track their profit loss on their trading activities in stocks based on average purchase price e The calculations would be different than those generated by capital gain reports which are based on First In First Out FIFO basis Reports Analytical Asset Allocation e Auseful report to understand how well your individual and or group portfolio is diversified e You can select All Assets and check the asset allocation across each category e To see your asset allocation in one particular category you can select stocks MF etc to view how concentrated you are in a particular stock or MF scheme Reports Analytical Annualised Returns XIRR Areport that calculates the true rate of return for an investment using XIRR e XIRR and IRR similiar however IRR calculates the internal rate of return for a series of periodic cash flows e XIRR calculates the internal rate of return IRR for a series of cash flows for example investments and withdrawals in MProfit that is not necessarily periodic MProfit User Manual Back to Index Page 11 Our online forum has more inf
37. mount for SIP Click on Generate button to generate all the entries for the selected period The dates will be selected automatically The dates will be adjusted for Saturdays and Sundays as SIP transactions do not happen on weekends You can change the dates if you desire Now you need to only fill out the units as per your MF statement for all the respective dates The amount for each transaction will remain the same To edit or delete any transaction can be done in the same way as any mutual fund transaction It needs to be edited or deleted individually Asset Classes Unit Linked Insurance Products ULIPs Double click on the ULIP icon on the left side of the summary screen If you are creating the new policy select New Policy and click New button Similarly Create New Company and New Plan Once your new policy is created fill out all the details of your ULIP policy This is one time process You can keep track of the events like Next Premium Due Lock in Period and Maturity Date by setting the appropriate alerts Once you have filled up the details you can choose to fill additional details like Fund Allocation The funds details will be helpful to keep track of your chosen funds and to calculate the policy value You can ignore the fund details and directly put the policy value as mentioned in your ULIP statement as current value This value will be reflected in the summary screen Once the policy is created you can add transactio
38. n the case of Groups the balloon notification provides instant information about the holding details of each group member when the mouse is moved over the name of the asset MProfit User Manual Back to Index Pages Asset Classes Purchase Buy and Sale Sell transactions can be easily entered for any asset by any of the following ways e Double click on the icon of the asset in the left side panel e Right click on the asset icon e Click on the Buy Sell or Invest Withdraw button on the right side of the asset class name Select the asset name then select Activity Menu on the Summary Screen Any Buy or Sell transaction can be edited or deleted by double clicking the particular asset name you can also right click on a particular asset name to edit or delete the transaction Asset Classes Stocks Shares e The purchase and sale transactions of stocks are entered by entering transaction details in Contract Note CN form CN can be opened by double clicking the Stock icon or by using the right click on the left side of the asset list or by clicking the Buy Sell button next to Stocks on the right side of the summary screen e CN form is similar to contract notes issued by your stock broker e The Brokers List contains the list of Brokers or Agents which has to be created for the first time e Click on the New Button to create the new Broker Agent name Broker Agent List can be used across all the portfolios Bro
39. ns like Premium and Withdrawal by choosing the respective selection Any ULIP transaction can be edited by double clicking the particular transaction from the ULIP transactions list from the summery screen You can use the right click on the particular transaction to edit the same To delete the particular transaction you need to open that ULIP transaction and click on the Delete Record button You can use the right click on the particular transaction to delete the same Once the record is deleted it can not be retrieved back The details regarding Policy Number Next Premium Due Lock in Date and Maturity Date can be seen in balloon notification while moving the cursor over the ULIP plan on summary screen MProfit User Manual Back to Index Page 7 The current value of the ULIP policy policy can be set by three options a To use the method of Total Premium Total Withdrawal b Use Fund Values like Number of Units NAVs of funds to calculate the current value c Set the policy value manually as per the statement of the ULIP policy Asset Classes Insurance Policies Without Unit Linked Plans It is very similar to ULIP plans except this will only keep track of your insurance plans which are not unit linked plans The plans like Whole Life Money back policies fall under this category Double click on the INS icon on the left side of the summery screen If you are creating the new policy select New Policy and click New butt
40. o From the toolbar select Open Portfolio and click on the New button to create a new portfolio e Enter the portfolio details Portfolio Name short name Investor Full Name Address City Pin code Country and PAN To open an existing Portfolio From the toolbar select Open Portfolio and select the Portfolio Name to open To edit Portfolio details From the toolbar select Edit Master and select Edit Portfolio then select Edit You can edit the Portfolio Name short name Investor Full Name Address City Pin code Country and PAN number e The Portfolio must be closed before making any detail changes MProfit User Manual Back to Index Page15 Menu Open Group A Group can be created to consolidate the portfolios of family members or groups of people Details regarding portfolio holdings of each group member can be seen in balloon notification while moving the cursor over the asset name in the summary screen You can create multiple groups within a family for example e A Group with Parents A Group with Parents and Children e A Group with Parents and Children and Grandparents To create a new Group From the toolbar select Open Group and click on the New button to create a new group Select the portfolios by checking the box of each portfolio to be included in this new group To open an existing Group From the toolbar select Open Group and select the Group Name to open To edit Group details
41. on Charges Details 15 Reports Miscellaneous Due Daa ii 15 Reports Miscellaneous ULIP INS SUMMAry ui 15 Menu Open Portfolio 15 Menu Open Group 16 Menu Edit Master 16 Menu Edit Master Edit Borttolto d n N EE 16 Menu Edit Master Edit Group Borttolto ENNEN 16 Menu Edit Master Create New ASSe t sensssensssenseseeseeersseresserssseeseseesreeeseeresseessseessseesseersseresseessseess 16 Menu Edit Master Edit Delete Asset 16 Menu Edit Master Other Accounts 16 Menu Edit Master Manage ULIP FundS 2 0 0 eeecceececceccccceccccecececeeeeesscsssessssseeeseeccesccececcceeeceeeeeeeeeeneees 17 Menu Import 17 Digital Contract NOtES AAA AE a RR 18 CAMS RARVY EE 20 KARVY EE 20 CAMS WBR 2 enee eebe EE tee 25 CAMS RersOnia EE 25 Predefined Excel SNEEtS suuiin verace frana eater ae cirie iii ceci 27 Steck Transaction aa 27 MUtU al FUNG WEE ccs secede ctevavands ccewavau da vadceGvawewdecevnesen ani 27 Online Porta EE 28 NJ Fundz Online Transactlons 28 NJ Fundz Online Dividend HIO ya i 28 Valeria Ai alia 28 Menu Tools YD Menus Tools Update Prices NOW esst aaa 29 Menu Tools Refresh Summary SEE waa 29 Menu Tools BackUp Datd acari aaa 29 Men Tools Restore Datazione near RATE ANI RNA RISE rire 29 Menu Settings 30 Menu Settings Change Default Period 30 Menu Settings Change Portfolio Data Location iii 30 Menu Settings Change Password zikaanza aa 30 Menu S
42. on and create new Insurance company plan etc Once your new policy is created fill out all the details of your insurance policy This is one time process You can keep track of the events like Next Premium Due Lock in Period and Maturity Date by setting the appropriate alert alarm Once the policy is created you can add transactions like Premium and Withdrawal by choosing the respective selection Any Insurance Policy transaction can be edited by double clicking the particular transaction from the respective insurance policy transaction list from summery screen You can use the right click on the particular transaction to edit the same To delete the particular transaction you need to open that policy transaction and click on the Delete Record button You can use the right click on the particular transaction to delete the same Once the record is deleted it can not be retrieved back The details regarding Policy Number Next Premium Due Lock in Date and Maturity Date can be seen in balloon notification while moving the cursor over the ULIP plan on summary screen The current value of the insurance policy can be set by two options one is to use the method of Total Premium Total Withdrawal Or Set the policy value manually which may includes the bonuses as well as guaranteed addition by insurance company Asset Classes Private Equity You can keep track of shares of private limited companies and unlisted companies under the Private
43. ontract notes to their customers MProfit provides the facility to import these files for many brokers We are continually adding new brokers to the list and if you would like your broker included please contact us at support mprofit in TM MProfit Import ver 3 0 Usable Templates Brokers Contract Notes and other Angel Broking Stock Templates Anagram Capital ICICldirect com Trade Book India Infoline NFL Karvy 201 Mutual Funds Excel and other Templates Motilal Oswal CAMS WBR2 MProfit Mutual Fund Transactions MProfit Stock Transactions Prabhudas Lilladher Excel Contract Note Reliance Money Value Research Online Import from file Modify Mappings for Selected Template Import from website Close From the main Import window you will see all the brokers we currently support from the first drop down list Brokers Contract Notes and other Stock Templates We support cash segment transactions for BSE and NSE The first time you import digital contract notes it will ask you to map your broker portfolio and scrips Once the mappings are complete MProfit will only ask if there is a change from the information it currently has Step 1 Select the Broker and Exchange then select Import from file Then select the contract note you have received from your broker Step 2 Map to a Broker You can map the transaction to a particular broker and keep track of broker costs If you don t have
44. ormation on XIRR MProfit User Manual Back to Index Page 12 Reports Analytical Realised and Unrealised Gain Loss e This gives you the total of your booked profit Realized as well as notional profit Unrealized on your balance quantity based on the current market price as on today e An example would be your holdings in Infosys it would show how much profit loss was made on your sold shares during the period and how much profit loss with your remaining shares Reports Analytical Realised Gain Loss e This report gives you the profit loss for the stocks and MF for the particular period e This is your booked profit loss after you sold your stocks and MF from your portfolio e This is actually the total of your Intra day short term and long term gain for the particular period Using Change Period functionality you can get Realised Gain Loss for the chosen period Reports Transactions Transaction reports give you the details of all transactions related to purchase sale and dividend reinvestment Reports Transactions Contract Notes e Contract Notes Summary and Detailed Contract Notes reports are available Stock wise buy and sell transaction reports are displayed e Date wise and broker wise contracts notes can be displayed e Sale Purchase Summary during the period can be displayed e The report is refreshed with the new values if you have changed the values in the contract note e In customization form you can sel
45. ser Manual Back to Index Page 27 Online Portals You can import your transactions that are currently online via several online portals This allows you to keep a backup of your financial on your computer and also aggregate all your financial data NJ Fundz Online Transactions Step 1 Goto Import and select NJ Fundz Online Transactions from Mutual Funds and Others section Step 2 Select Import from website and login to your NJ Fundz account Step 3 Select Mutual Funds gt Transaction Report Step 4 Select the period and click Report and your mutual fund transactions will appear Step 5 Click Import button at the bottom right corner to import the transactions NJ Fundz Online Dividend History Step 1 Goto Import and select NJ Fundz Online Dividend History from Mutual Funds and Others section Step 2 Select Import from website and login to your NJ Fundz account Step 3 Mutual Funds Other Reports gt Dividend History Step 4 Under Dividend Option only select Dividend Payout Dividend Re investment information is already included in the Transaction Report The other options can be selected as required Step 5 Click Report and your mutual fund transactions will appear Step 6 Click Import button at the bottom right corner to import the transactions Value Research Online Step 1 Before starting to import verify the summary screen of the portfolio you want to add transactions to
46. tart creating the client family sub directories as follows C MProfitData AshishMehtaFamily C MProfitData SejalShahFamily C MProfitData RamPatelFamily In MProfit switch from one directory to another directory and create the individual clients eGo to Settings eSelect Change Portfolio Data Location eSelect say C MProfitData AshishMehtaFamily The application will be restarted with the Ashish Mehta family now you can create the individual client portfolios Repeat the above steps to create all the individual portfolios in each family directory Now you are ready to start the import process for the KARVY 221 file MProfit User Manual Back to Index Page 20 Step 1 Goto Import and select KARVY 221 from the Mutual Funds Excel and other Templates section Usable Templates Template Information Angel Broking file you receive from Karvy should be saved Stock Templates CAMS WBR2 Excel 97 2003 format 1 1 eS E CAMS Personal Anagram Capital X ICICidirect com Trade Book Before you begin the import process map all your India Infoline IIF Mutual Funds Excel and other e Add Mappings Templates the Karvy file Aa deepal GAS ERa Add gt MProft Mutual Fund Transactions Now you can begin to import the data MProfit Stock Transactions 1 Select Import from file The first time it will ask Networth Stock Broking to map the transactions to each portfolio and folio Prabhudas Lilladher Excel Contra
47. unt on a particular date MProfit User Manual Back to Index Page 14 Reports Miscellaneous Some useful reports like brokerage charges STT as well as transaction charges details can be obtained with these reports Reports Miscellaneous Brokerage Details for Stocks e You can compare brokerage charged by your different stock brokers e Broker wise as well as contract note wise brokerage charges can be obtained Reports Miscellaneous STT Details These reports will give you the Securities Transaction Tax STT details broker wise or contract note wise Reports Miscellaneous Transaction Charges Details This report will give you other transaction charges details broker wise as well as contract note wise Reports Miscellaneous Due Dates e Lists the due dates for various events reminders like premium due maturity date and lock in period complete e Due dates for next six months can be selected via the customization option e Inthe group portfolio the report lists the due dates for all the group family members in one consolidated report Reports Miscellaneous ULIP INS Summary This is a group portfolio report only which provides comprehensive information such as policy nominee sum assured premium withdrawal maturity date and current policy value Menu Open Portfolio A Portfolio can be created for a member of the family All transaction related to that member reside in that portfolio To create a new Portfoli
Download Pdf Manuals
Related Search