Manage Sovereign Gold Bonds with MProfit

What are sovereign gold bonds?
As part of the gold monetisation scheme launched by Prime Minister Narendra Modi in November 2015, sovereign gold bonds are issued by the Reserve Bank of India (RBI) on behalf of the government. They are a replacement for physical gold and are available in paper or demat form.

Which sovereign gold bonds are supported in MProfit?
In line with our commitment to continually improve MProfit and introduce new features, MProfit has added support for the sovereign gold bond asset class under the ‘Traded Bonds’ category. MProfit users can now track the performance of these bonds on a daily basis, review overall gains as well as annualised return (XIRR) for this category. Here is a list of the sovereign gold bond series that have been added in MProfit:

Sovereign Gold Bond 2.75% Nov 2023 Tr- I (ISIN: IN0020150085)
Sovereign Gold Bond 2.75% Feb 2024 Tr-II (ISIN: IN0020150101)
Sovereign Gold Bond 2.75% Mar 2024 Tr-III (ISIN: IN0020150119)
Sovereign Gold Bond 2.75% Aug 2024 Tr-IV (ISIN: IN0020160027)
Sovereign Gold Bond 2.75% Sep 2024 Tr-V (ISIN: IN0020160043)
Sovereign Gold Bond 2.50% Nov 2024 Tr-VI (ISIN: IN0020160076)
Sovereign Gold Bond 2.50% Mar 2025 Tr-VII (ISIN: IN0020160126)
Sovereign Gold Bond 2.50% MAY 2025 Sr-I 2017-18 (ISIN: IN0020170018)

How are capital gains calculated for sovereign gold bonds?
If sovereign gold bonds are sold in the secondary market before maturity after three or more years since purchase, capital gains on these transactions will be taxed at 20% with indexation. However, if they are sold within three years of purchase, the capital gains would be subject to the marginal tax rate. Our team is working to provide separate capital gains reports with and without indexation for this category, and these new reports should be available in the next public software update.

MProfit is ready with GST

The landscape of doing business in India has significantly changed in the last one year following two major events, demonetisation and the launch of the Goods & Services Tax (GST). Both measures are expected to have a lasting positive impact on the Indian economy.

GST has come into effect on July 1, 2017 and is expected to simplify the complex indirect tax structure in India by subsuming over a dozen central and state taxes. A question on the minds of several MProfit users is how will MProfit adapt to the introduction of GST. We see two immediate changes:

1. Lower prices! – The tax tier for MProfit under GST has been changed and we are happy to announce that we have passed along the benefits to our users. You can see a price decline of around 4% across all versions of MProfit

2. Updates to import templates – Over the coming months, our technical team will work hard to swiftly modify all our import templates to incorporate expected changes to brokers’ contract notes.

a) All contract notes and bills will have new taxes such as IGST, CGST and SGST instead of Service Tax, Krishi Kalyan Cess and Swachh Bharat Cess

b) MProfit now has over 2,300 templates to import contract notes & files across disparate formats such as PDF, HTML, Excel, CSV, Text and DBF. We will modify templates upon request from our clients on a first-come first-serve basis. This will of course be done at no extra cost to our users!

c) As we undertake this massive task to ensure MProfit continues to deliver seamless import functionality for all our users in a promising post-GST era, we greatly appreciate the patience and co-operation of our users. You can rest assured that the MProfit tech team will be working overtime to ensure a quick transition

In addition to any changes to MProfit required by GST, we are also consistently committed to introducing new features to improve our core platform and address customer requests. We have recently released our new update v9.5 (build 1014.0272) which packs some new features and fixes minor issues. Below is a complete list of all new features and bug fixes.

New Features:
• Addition of Sovereign Gold Bonds to the traded bonds category along with current prices. If you have already added these gold bonds under the NCD category, click here to learn how to transfer them to the traded bonds category.
• Bulk Delete option to delete records of an entire family in one go
• Recalculate closing balances of all families with a single click
• Move MF records from one MF scheme to another within the same portfolio instantly
• Import STT values from mutual fund CAS statements, CAMS WBR2 and Karvy 221
• New option to transfer STT along with charges in contract notes to purchase & sale value

Bug Fixes:
• Fixed a minor bug in capital gains calculations when using bulk corporate actions for splits
• Fixed a minor bug in the incorrect allocation of contract note charges
• Fixed a display issue in the Balance Sheet report for ledger names with parentheses

MProfit Review from Nooresh Merani

One of our users, Nooresh Merani has written a very in-depth review of MProfit on his website.

“This is one of the software I have been using for the last few years and have found it very simple and effective to use for tracking an equity portfolio. But i believe it has a lot of features for tracking all your assets.

MProfit is developed by a Mumbai based software company called MProfit Software. There is a free version as well as a paid version. The free version is for the India retail investor while the paid one is for accountants, CA’s, traders, financial advisors, HNI’s and companies. The paid version costs between 3657-14020 INR for a 1 year subscription. It is also available on android allowing you to see your financial details on the go. The features that are listed by MProfit are the following …” the full review is available on his site.

Manage your family office with MProfit

The Indian family office

A family office is an organisation that manages investments and trusts for one or many high net-worth families. Family offices are of two types: single family offices (SFOs) and multi-family offices (MFOs). While families of high net-worth individuals (HNIs) often use services provided by wealth managers and private bankers, they often utilise their own in-house teams to manage investments. India has many large family offices including Azim Premji’s PremjiInvest, N. R. Narayana Murthy’s Catamaran and the Ambani Family Office.

A large number of family-run businesses have similar investing needs as large family offices. However, they usually do not use only a single entity for wealth management, relying instead on multiple financial advisors, stock brokers and private bankers. This poses challenges to decision-makers in the family when trying to adhere to the following portfolio management best-practices:

  • Aggregation of all investment transactions from multiple disparate statements
  • Tracking of portfolio performance across financial advisors as well as at a consolidated level
  • Calculation of capital gains for stocks, bonds, equity mutual funds and debt mutual funds (with & without indexation)
  • Accounting, which is often done separately resulting in duplication of effort

MProfit’s integrated portfolio management and accounting solution for family offices

Having devoted considerable time and resources to understanding the investment management challenges faced by Indian families, MProfit has perfected an integrated solution that addresses each challenge. Ever since we launched MProfit, the Indian family office has been central to our software and we now have many marquee family offices and family-run businesses as clients.

MProfit’s primary value-add is our grouping feature that allows users to aggregate portfolios across various entities/individuals into a single group view. This is particularly important to Indian families as they prefer to track and review the performance of the entire family’s consolidated portfolio. Additionally, we offer the following key functionality that has helped make MProfit a stand-out solution for large family offices as well as other family-run businesses:

  • Import of all financial transactions from single or consolidated files
  • Import support from over 2,300 different sources across digital contract notes, mutual fund statements and bank statements in various formats
  • Import support for various disparate formats such as PDF, HTML, Excel, CSV, DBF and Text
  • Ability to create and manage multiple family (group) portfolios, with the option to group across various combinations of individual portfolios
  • Comparison of performance returns across various financial advisors
  • Consolidated view of family net-worth
  • Capital Gains Reports for stocks, bonds, equity mutual funds and debt mutual funds (with & without indexation) (Read more here)
  • Annualised Return (XIRR) for any specific asset or asset category, both at the individual and family level
  • Holding Reports displaying detailed holdings for individual family members or the entire group
  • Asset Allocation Reports for individuals or the entire family
  • Due Date Reports for the entire family that track insurance premium payments, maturity dates and lock-in periods

MProfit, a very reliable and user friendly solution – Sendhil Madhivathanan, PenguWIN Wealth Management Consulting

PenguWIN® Wealth Management Consulting and PenguWIN Investment Services are professionally managed firms headed by Sendhil Madhivathanan and Sathya Sendhil. They have been using MProfit Advisor to manage clients’ portfolios for the past three years.

Here is Sendhil’s review about MProfit:

“I have been using the 200 users Advisor Version of MProfit for close to 3 years now. I have an IT background working for Software multinationals and have implemented Enterprise systems including Oracle, PeopleSoft and JD Edwards. The first thing that impressed me about MProfit is the reliability factor. Even Enterprise systems throw errors and shut down forcibly. But this has never happened with MProfit and this speak volumes about its reliability.

The User Interface and Reports are very impressive and though it has some limitations in terms of data generated from advisor’s perspective, end users (our investors) love this Software and it is almost impossible for me to convince users to move to other platforms, including cloud based Architecture software. MProfit has an Android version too, that is used by many of PenguWINs investors and are very happy.

On the support front too, MProfit scores well and the support team has always been accessible. I have leveraged only a part of MProfit’s functionality and am slowly exploring the other features. End user help provided within the application is one area where MProfit can add more value. I have heard that MProfit is working on a cloud based architecture, which can remove the issue of a client footprint sitting on an investor’s laptop. I am extremely satisfied with MProfit and my sincere wishes to the MProfit Team”

Import your Bank Statements with MProfit

bank-importMProfit offers several features to help investors better manage their investments. In addition, MProfit also offers an integrated accounting module that auto-creates accounting vouchers and ledgers from investment transactions. This helps investors quickly and effortlessly complete preparation of an entire year’s accounts. MProfit’s accounting module has been very popular and we have been continually enhancing it based on user feedback.

Traditionally, users have always had to manually enter transactions from their bank statements into external accounting software. MProfit has eliminated this tedious process by auto-creating vouchers and ledgers as well as enabling the effortless import of statements from a vast majority of banks in India. Bank statements (monthly or yearly) in various formats such as PDF, Excel, CSV and text format can be imported into MProfit. Banks supported include HDFC, ICICI, IDBI, Kotak Mahindra, Karnataka Bank, State Bank of India, Citibank, Canara Bank, Andhra Bank and many more!

To check if your bank or broker is supported, please visit our import page. If your bank or broker is not listed, please call us at 022-40024149 or email us at and we’ll surely add them to our list.

MProfit now supports import from more than 2,200 formats across digital contract notes, mutual fund statements and bank statements. Check out MProfit today by downloading it here!


Manish Jain, Co-founder, MProfit as speaker at Fintegrate 2017 event

February Newsletter

MProfit wishes you a prosperous 2017!

2016 has been quite a year to remember not because of the US elections, but because of what else happened that day… the demonetization of the Rs. 500 and Rs. 1000 rupee notes. Within hours of the announcement Prime Minister made it impossible to use large notes. It was a very positive move for the financial markets as most of the money would come back into the banking system. The positive effects will be felt for many years to come.In addition, it was also an extremely productive year for MProfit. With a series of new features, reports and improvement in 2016 as well as unmatched customer support, we continue our path in 2017 to make MProfit, India’s leading portfolio management & accounting solution. Below is a quick summary of new features & reports implemented:

New Features

Reached the milestone of supporting import from 2000 formats (PDF, HTML, Excel, Text, DBF)
Import support for auto-mapping using ISIN numbers for many broker’s contract notes
Live prices (End of Day prices) of traded bonds on NSE and BSE in capital market segment
Import support for the new format of the Consolidated Account Statement from CAMS
Create Mark to Market profit/loss in F&O which can be reconciled with broker’s ledger

New Reports

Capital Gains of traded bonds
‘Bank & Broker’ report to see banks and Broker’s balances for one or all families
Contract notes summary and detailed report to view contract notes of all families
Asset Holding – Closing Balances
Family – wise global transaction report
Capital gain calculations of all families under one report
Closing Balance report for one family or all families under one report
New XIRR report with Quantity
Stocks & Mutual Fund transactions register

New Online Help Desk

At MProfit, we are constantly looking for ways to improve our support for customers.  The latest feature we have added is an online help desk (forums) which will allow you to search for any issues or problems you may be experiencing.  Of course, you can always email us at as well.

Our new online help desk is located at

Take a look and let us know what you think.

New v9.5 released

left-facing-boxLast week we released v9.5 of MProfit which packs many new features and fixed several older issues. Below is a complete list of all the new features, reports and enhancements.

New Features
– Create Mark to Market profit/loss in F&O which can be reconciled with broker’s ledger [Click to learn more]
– Settlement of all open expired contracts [Click to learn more]
– Import support for the new format of the Consolidated Account Statement from CAMS
– Import support for auto-mapping using ISIN numbers for many additional brokers’ contract notes

New Global Reports (Pro & Advisor Version)
– ‘Bank & Broker’ Report to see banks and Brokers’ balances for one or all families
– Transaction Reports, CN Summary and Detailed to view contract notes of all families and search any Contract note with contract no or Settl. No
– Closing Balance Report for one family or all families under one report
– Asset Holding – Closing Balances

Improved Reports
– Capital Gain Summary report – Added filter to see only intra-day, short term or long term gains
– Ledger Printing Report – Option to exclude stocks, MFs & traded bonds
– Closing Balance report, added two more columns, Curr. Price and Curr. Value
– Holding Report, added three more columns, Curr. Price, Curr. Value and Gain/Loss
– Display of current value of assets with Lock-in Period entry in due date report
– Trading Profit/Loss report of past date will show valuation of the respective date

Bug Fixes
– Fixed bug related to Capital gain for Transfer-In with IPO and Bonus
– Fixed error in Transaction report with Bonus and Split
– Fixed clubbing of buy transactions entered separately on same day in capital gain report for income tax report, now it shows individual entries
– Fixed error in report of Debt MF with Indexation if internet is not connected

Click to the see the full version history of MProfit.