Announcement

Collapse
No announcement yet.

How do I import a Vijya Software excel file in MProfit ?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How do I import a Vijya Software excel file in MProfit ?

    Click image for larger version  Name:	logofinal123.png Views:	1 Size:	9.0 KB ID:	420

    If you are using Vijya Software you can import your clients information via the "Record Detail" excel format.

    1. Start the Vijya Software located on your computer.

    2. Click on the star icon which will open the "Mutual Fund Portfolio Report" window.





    3. Select a client and make sure the "1 Portfolio Valuation Report" is selected. Select the other settings as shown below:





    4. Select Report in the bottom right hand corner

    5. Once the report appears, click on the Envelope icon.

    6. Under Format select "Excel 7.0 (XLS)" and select OK

    7. Save the file to your computer.

    8. Open the file in Excel and save it again as 'Excel 97-2003 Workbook Format'.

    9. Import into MProfit using the "Vijya Software - Record Detail (v1)" template.


    Click image for larger version  Name:	vijya123.PNG Views:	1 Size:	14.3 KB ID:	387


    10. Here is the image of the Sample Back-office file from Vijya Software.


    Click image for larger version

Name:	final sample.png
Views:	58
Size:	15.8 KB
ID:	770
    Last edited by Shweta Rathod; 22-10-18, 02:37 PM.
Working...
X