How to enter Date-wise Opening Balances of Stocks into MProfit?

Modified on Tue, 26 Sep 2023 at 11:38 AM

To ensure accurate computation of capital gains and portfolio returns, it is crucial to import transaction-wise Opening Balances into MProfit. This import should include the Date, Quantity, and Price details of each transaction.

MProfit simplifies the process of updating your Opening Balances by providing a user-friendly Stock Opening Balances Excel template.


To get started, follow these steps to import your data using the MProfit Stock Opening Balances template:


1. Download the MProfit Stock Opening Balances template by clicking on the provided link. 

2. Once the download is complete, open the file and carefully read the instructions provided. 



Note: Remove and update your data from the 10th row onwards in the Excel Sheet, also it is recommended to make no changes in the header section in 9th row i.e., (Date, Portofloio Name...etc)




3. Enter the transaction details for all the stocks in your portfolio as per the instructions in the file.

4. In the MProfit application, locate and click on the Import button located at the top-right.


5. For a new user the interface will be as shown in the image below, click on to navigate to the Import window.  


Note: If you are an existing user, you'll directly receive a search window as shown in the image of Point 6.



6. In the Import window, search for the MProfit Stock Opening Balances on the search icon at the top. 


7. Click on MProfit Stock Opening Balances and then Add to Favourites.


8. Now that you have added MProfit Stock Opening Balances to your Favourites, you can now follow the step-by-step import guide.


Your stock opening balances will now be up-to-date!

After completing this one-time exercise of updating your opening balances, you can streamline the process further by setting up auto-import for your daily stock contract notes. 

This will automatically update your daily trades in your MProfit portfolios.


Learn more: How to set up Auto-Import in MProfit? 


Need help?

If you have followed the steps above but are unable to enter Date-wise Opening Balances of Stocks into MProfit, contact our support team and we will be happy to guide you with your MProfit setup.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article