Importing your F&O transactions from Sharekhan

TABLE OF CONTENTS

• Import your historical Sharekhan F&O transactions
  
  This is important for computing accurate Realised Profit/Loss. 
  
  
• Set up auto-import for your daily Sharekhan contract note
  
  This is will ensure your daily trades are auto-updated in MProfit

1. Import your historical Sharekhan F&O transactions

To get your historical f&o transactions in one file from Sharekhan, you can request the Trade Listing Back-office Excel file from Sharekhan. Once you receive this report, you can directly import this report to MProfit.

Below is a sample image of this report:

Please follow the steps below to import the same into MProfit:

1. Login to your MProfit account at https://cloud.mprofit.in
   
   
2. Once logged in, click Import (top-right) and search for the following template:
   
   Sharekhan - Trade Listing Backoffice File
   
   In the search results, click on the Sharekhan - Trade Listing Backoffice File (F&O) template for f&o, as displayed in the below screenshot

3. Review the template information. Next, click the Add to My Templates button and then  click Continue.  

4. Now that this template has been added, select the Sharekhan - Trade Listing Backoffice File (F&O) template under the My Templates section.  

You can now proceed to uploading & importing your file:

Step-wise MProfit import guide (start at step 5 in this guide) 

2. Set up auto-import for your daily Sharekhan Contract Notes

The Sharekhan daily email contract note contains your daily trades across BSE-EQ, NSE-EQ, BSE-FO NSE-FO and NSE-Currency.
 

Depending on whether you have already set up auto-forwarding for your Sharekhan daily contract note for Stocks, you can proceed as per the guidance below.

If you HAVE NOT set up auto-import for your daily Sharekhan contract note:

1. Please follow the steps in this guide.
   (Section 2: Set up auto-import for your daily Sharekhan contract note)
   
   
2. Next, proceed with the steps below.
   
   

If you HAVE already set up auto-import for your daily Sharekhan contract note:

Please follow the steps below:

1. Login to your MProfit account at https://cloud.mprofit.in.
   
   
2. Once logged in, click Import (top-right) and search for the following template:
   
   

Sharekhan - Daily CN

In the search results, click on the Sharekhan - Daily CN (F&O) template, as displayed in the below screenshot below:

3. Review the template information. Next, click the Add to My Templates button and then             click Continue.

4. Next, under My Templates, locate the Sharekhan - Daily CN (EQ) template and click the Template Information button.

Please note this is the EQ Contract Note template for Sharekhan. 

5. In the Template Information box, click the Link button. 

6. Add Sharekhan - Daily CN (F&O HTML) - Latest as the Linked Template. 

7. Finally, click Save, and now you are done.

MProfit will now start importing both Stocks and F&O transactions from your Sharekhan daily contract note file.

Disclaimer: Any company names and logos used in this document are the property of their respective owners and may be trademarks. MProfit Software Private Limited does not claim proprietary interest in the marks, names & property of others.