MProfit now supports long-term capital gains calculations as per Grandfathering provision

The 2018 Indian Budget introduced a long-term capital gains tax of 10% on stocks and equity mutual funds exceeding Rs. 1 lakh. However, all gains until 31-Jan-2018 are grandfathered. This means that you will have to pay tax ONLY on the gain from the base of highest price on 31-Jan-2018.

Grandfathering calculations get complex when there are one or more corporate actions in your long-term holdings. The recent major update of MProfit has simplified the calculation of capital gains as per the Grandfathering clause for all transactions (including multiple corporate actions such as bonus, split, merger and demerger). MProfit automatically calculates the long-term capital gains and provides reports in different formats including Summary and Detailed views with all details such as Purchase Price (PP), FMV and Cost of Acquisition (CA) accurately calculated and displayed for each transaction.

MProfit has, over the years, perfected the calculation of capital gains and made it extremely simple for users to use this information while filing their tax returns.

Salient features of MProfit specific to the calculation of capital gains include:
– Calculation of capital gains based on First-In-First-Out basis (FIFO) and as per Grandfathering clause
– Intra-day, short-term and long-term capital gains calculations for stocks
– Short-term and long-term capital gains calculations for equity & debt mutual funds as well as for traded bonds
– Long-term capital gains calculations for debt mutual funds with or without indexation
– Adjustment of capital gains calculations as per income tax rules for corporate actions such as bonus, split, merger and demerger
– Feature to allocate contract note charges to purchase amount and sale amount for stock transactions to reduce the tax liability
– Summary and detailed formats available for capital gains reports
– Transaction-wise capital gains report with all details such as Original Purchase Price (PP), FMV (highest price as on 31-Jan-18) and Cost of – Acquisition (CA) as per grandfathering rules
– Unrealised capital gains reports that help users manage “actual” capital gains
– Holdings reports that track the number of holding days of stocks and mutual funds since the purchase date

Below is a list of useful posts to help you know more about how MProfit manages capital gains calculations:

Forum post:
Summary and Detailed Capital Gains Reports as per Grandfathering rules

Blog Posts:
Capital Gains Calculations simplified with MProfit
Capital Gain Calculations for Shares (Stocks)
Capital Gain Calculations for Mutual Funds (MF)
A video tutorial on Capital Gains Reports

Grandfathering – New Capital Gains Tax Simplified

India’s 2018 Budget delivered by Finance Minister, Mr. Arun Jaitley proposed a long-term capital gains tax of 10% on stocks and equity mutual funds exceeding Rs. 1 lakh without allowing any benefit of indexation. However, as per the Budget, all gains until 31st January, 2018 will be grandfathered. According to Wikipedia, a grandfather clause is a provision by which an old rule continues to apply to a certain existing situation while a new rule would apply to all future instances. This implies that you will not be taxed on any gains that you have already accumulated up until 31st January, 2018.

More recently, on 4th February, 2018, the Central Board of Direct Taxes (CBDT) issued a list of 24 frequently asked questions (FAQs) regarding taxation of long-term capital gains proposed in the Finance Bill, 2018. This list of FAQs further makes it clear that the new long term capital gains tax will be applicable only for sales on or after 1st April, 2018. The long-term capital gains tax exemption will continue for any sale between 1st February and 31st March, 2018 as per current taxation policies. To summarize, there is no change in the long term capital gains tax exemption for the financial year 2017-18.

MProfit has consistently been the preferred choice of solution amongst chartered accountants and investors for the computation of short-term and long-term capital gains. As the new long term capital gains tax change is not applicable for the current financial year FY2017-18, investors should continue using the existing version of MProfit to compute capital gains for the financial year FY 2017-18.


The scenarios below detail how long term capital gains will be calculated for sales on or after 1st April, 2018. In each of these scenarios, a certain asset is purchased on 1st January 2017 and sold on 1st April 2018. The Long Term Capital Gain calculation for this asset is now computed by determining what the Cost of Acquisition is for the asset, by comparing the values for Purchase Price (PP), Fair Market Value on 31st January 2018 (FMV)  and Sale Price (SP):

ScenarioScenario DescriptionPurchase Price as on 01-Jan-2017 (PP)Fair Market Value as on 31-Jan-2018 (FMV)Sale Price as on 01-Apr-2018 (SP)Cost Price for Capital Gains CalculationLong Term Capital Gain
1PP < FMV < SP10020025020050
2PP < SP < FMV1002001501500
3FMV < PP < SP1005015010050
4SP < PP < FMV10020050100-50
5SP < FMV < PP1005025100-75
6FMV < SP < PP1005075100-25
7Bonus: PP = 0, FMV < SP
8Bonus: PP = 0, SP < FMV

If you would like to learn more about how MProfit simplifies capital gains for various assets, click here.

Click here to download the FAQ list published by CBDT.

MProfit supports import of CAMS consolidated account statement for all mutual fund schemes

Computer Age Management Services (CAMS) and Karvy are two leading Registrars who provide services to investors on behalf of mutual fund houses. Many mutual fund investors are not aware that CAMS provide consolidated account statement (CAS) for their entire family’s mutual fund transactions across all schemes including the ones managed by CAMS, Karvy and Franklin Templeton.

One statement contains the mutual fund transactions for entire family across all the mutual fund schemes. Investor needs to link the same email address to their all family folio numbers with CAMS, Karvy and Franklin, if not done while investing for the first time. The CAS statement can be requested for any period of all your mutual funds, including holding of many years.

MProfit has made it extremely easy to upload all mutual fund transactions for entire family from this statement. All kind of transactions, such as subscription, redemption, SIP, STP, Switch-In/Out, SWP, Dividend Reinvestment, Dividend Pay-out are imported from this statement in MProfit. Investors can review various reports related to mutual funds in MProfit such as capital gains (with & without indexation), annualised returns (XIRR), asset allocation and many other reports.

Click here for the detailed information to learn how to request CAS file and how to import it in MProfit.

Made in India – MProfit Review by Dr. Mahesh Docherla

As a physician, I have been dabbling in investments since 15 years but the problem has always been accounting and calculating tax estimates which my CA was reluctant to do. It was also tedious to take each contract note and entering every detail especially when using all the services of a institution like ICICIDIRECT. I had started using MPROFIT since its inception when it was free to use and have gained complete confidence in the software and I am now a paid subscriber.

My CA also understands the reports very easily. MPROFIT does not charge anything etc for modifications & updates in software when the laws are changed and importing contract notes are completed in seconds. Any query is solved within a few hours in the daytime and where I do query at night, I immediately get online assistance and correction within 24 hours without fail. The support team is prompt, knowledgeable and once they have contacted, they will put in the time necessary to solve the problem.

Such service at such low subscription is a rarity in India. You have all the aspects of an international standard services company in the form of customer services, regular updates, online rectification of problems, accountability and most of all patient and decent services. I recommend this software to each and every Indian and hope that everyone encourages MPROFIT which follows excellent business and work ethics. This is one “MADE IN INDIA” company which truly deserves our support and everyone should make use of the services provided by this company.

A resolution to receive a handsome financial reward

Happy New Year to everyone! Why not make a New Year’s resolution that will give you a handsome financial reward and is easy to achieve? Start using MProfit and effortlessly take care of portfolio management for your entire family or all your clients.

MProfit’s comprehensive list of features as well as its best-in-class support have made it the preferred choice of the entire investing community, including 1000s of investors, financial advisors, family offices and chartered accountants. It is consistently rated as one of the best software solutions on SoftwareSuggest, India’s popular software listing web portal.

MProfit is an easy to use software solution to manage Stocks, Mutual funds, Bonds, F&O, and all other assets. MProfit now supports import of more than 2,700+ different formats such as digital contract notes, mutual fund & bank statements.

2017 has certainly shown that dynamic changes at both a global and local level are frequent yet unexpected. As financial markets are influenced by all forms of macro & micro events, investors should be prepared for any heightened volatility in 2018 by actively monitoring their investments and taking prudent decisions based on changing circumstances.

MProfit is specifically geared towards helping investors/financial advisors achieve these goals with ease and efficiency by reducing their administrative manual work and providing useful reports including capital gains reports. Investors/financial advisors using MProfit can certainly spend more time on research related to their investments and make better investment decisions.

So, make the resolution to be smarter & more disciplined with your investments in 2018! Click here to download MProfit Investor for free today!

New Cost Inflation Index & Capital Gains Reports for Gold Bonds

As declared in the Budget 2017, Finance Minister Mr. Arun Jaitley has made changes to the cost inflation provision and accordingly, new cost inflation index (CII) numbers used for calculating capital gains with indexation have been notified by the Central Board of Direct Taxes (CBDT). The base year for the cost inflation index has been revised to 2001 from 1981. These changes are applicable starting financial year 2017-18 and onwards. MProfit’s new software update has incorporated these changes. MProfit has made it extremely simple for users to compute capital gains with indexation for any period. If any Debt MF or gold bonds are sold after 1st April 2017,the software will compute capital gains with the new base year and new CII index numbers. Computations for trades prior to 1st April will be done based on old CII numbers.

We recently introduced support for current prices of gold bonds in MProfit. The new update also provides capital gains reports for gold bonds. Normally all traded bonds on exchanges have long term capital gains for 1 year and beyond, except gold bonds, which follow the 3year & beyond long term capital gains calculations. Our latest update shows separate capital gains for gold bonds. We are also consistently committed to introducing new features to improve our core platform. We have recently released our new update v9.5 (build 1014.028) which packs new features, provides improved reports and fixes minor issues. Below is the complete list:

New Features:

  • New import support to handle GST details from contract notes (MProfit now supports more than 2,500 import templates)
  • New import support for yearly consolidated contract notes in one PDF file from various brokers
  • Contract note window – label changed to GST / S. Tax
  • Improved mapping mechanism during import to avoid losing mapping details

Improved Reports:

  • Capital gains reports now show separate capital gains for traded bonds (1 year, long term) and Gold Bonds (3 year, long term)
  • Support for new indexation table from 1stApril,2017 for Debt MF & Gold bonds in global and individual capital gains reports
  • Changed label ‘Serv. Tax’ to ‘GST / S. Tax’ in contract notes reports
  • Capital gains summary reports now show five periods for advanced tax planning: 01-Apr to 15-Jun, 16-Jun to 15-Sep, 16-Sep to 15-Dec, 16-Dec to 15-Mar and 16-Mar to 31-Mar

Minor Bug Fixes:

  • Fixed incorrect gain/loss in multiple buys and sells within the same contract note in stock register
  • Fixed incorrect balance quantity in case of merger after short sell in closing balance report
  • Fixed report crash issue if instrument name was missing in F&O Summary report


MProfit receives awards of “Budget Friendly” and “Customer’s Choice”

SoftwareSuggest, one of India’s leading business software discovery and recommendation platforms, has given MProfit the awards of “Budget Friendly” and “Customer’s Choice”.

We at MProfit are very proud of this achievement and would like to thank the entire MProfit team and all the stakeholders and especially our valued clients for helping us earn these awards.

MProfit has become the preferred choice for users across the entire investing community, be it Investors, Traders, Family Offices, Financial Advisors, Sub-brokers or Chartered Accountants. We have added many features and reports over the years and made MProfit a robust platform along with unmatched customer support to help you manage your investments and finances

We again thank all our clients for valuing MProfit as their preferred choice.

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.