Capital Gains Calculations simplified with MProfit


If you are looking for the most accurate and easy way to calculate your capital gains, you have come to the right place. If you invest in stocks, traded bonds or equity/debt mutual funds, you likely need to calculate capital gains for your intra-day, short-term and long-term investments. MProfit helps make this calculation process effortless for you.

You simply need to import a digital contract note received from your broker or mutual fund statement into MProfit and our software will take care of the rest! MProfit follows the First-In-First-Out (FIFO) method for calculating capital gains and also adjusts capital gains calculations based on corporate actions such as mergers, de-mergers, splits and bonus in accordance with income tax rules. After automatically performing all your capital gains calculations, MProfit also prepares reports in various formats to help you understand your capital gains.

With the simplicity and accuracy offered by MProfit, it is no surprise that MProfit is the preferred choice for everyone in the Indian investing community including Investors, Financial Advisors, Family Offices and Chartered Accountants.

Examples of the capital gains reports provided by MProfit include:
1. Summary reports (with period-wise computation for advance tax calculation)
2. Detailed transaction-wise reports
3. Debt mutual funds reports with and without indexation

MProfit further helps you understand your capital gains right before you sell your stock or mutual fund units by providing the following information:
1. Computation of unrealized capital gains
2. Holding reports (displays the number of days of your holdings from the purchase dates)

Below are several posts that explain in detail how MProfit handles capital gains calculations. Click the links below to know more:

Capital Gain Calculations for Shares (Stocks)
Capital Gain Calculations for Mutual Funds (MF)
A video tutorial on Capital Gains Reports

Also, if you don’t find your broker’s name in our list, do let us know at and we’ll make sure we add import support for your broker’s digital contract notes.

Download a free version by clicking the link 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.

Manage Your Commodity & Currency Trading with MProfit Pro

MProfit Pro makes it extremely easy to manage all your commodities and currency trades. You can import all commodities and currency digital contract notes or back-office files received from your brokers. MProfit gives you profit/loss statement as well as auto-generate accounting JVs and ledgers in integrated accounting module in MProfit.
Below is the list of sample of brokers for commodities and currency trades, we support for direct import in MProfit. If you don’t find your broker in the list, do get in touch with us at with sample of your digital contract notes and we will include the broker in our list

This is not the complete list, we have many more brokers in our list.
MCX and NSE Currency Brokers:

Aditya Birla Money
Alankit Imaginations
Anand Rathi
Angel Broking
Bezel Commodities
Bonanza Commodity
CD Equisearch
Citigroup Global Markets
Eureka Commodity
Fairwealth Commodity
Geofin Comtrade
Globe Capital Markets
JM Financial
Karvy Stock Broking
Master Commodity
Motilal Oswal
Nirmal Bang
Reliance Securities
SMC Comtrade
Sushil Global Commodities
Ventura Securities

New update for MProfit

new_94_boxToday, we released an update to v9.4 of MProfit. The version is still 9.4 but the build number is 1013.042:

New Features and Reports

  • Family-wise global transaction report
  • Option to print or save capital gain calculations of all families under one report
  • New closing balance detailed report with ISIN number for better analysis using Excel
  • Option for sorting ledgers name-wise in ‘Ledger Printing’ report.
  • Added Ref number next to asset name in macros created for repetitive PMS entries during import
  • Improvement in reconciliation during bank import

Minor Bug Fixes

  • Fixed issue of updating master database which affected some users
  • Fixed bug in reconciliation of PMS entries and transactions from bank statement duringimport
  • Fixed capital gains calculation error in certain scenrios for the leap year
  • Fixed bug in XIRR for FDs with zero interest
  • Fixed display issue in stock register report for short sell transactions
  • Fixed bug in summary capital gain report for Debt with indexation
  • Fixed incorrect display of total for specific period in Group Income report in PMS

Click to the see the full version history of MProfit.

10 Lucky Winners from the Finbridge Expo

This past weekend (Feb 6-7) MProfit was an exhibitor at the Finbridge Expo in Navi Mumbai. Finbridge is a financial services and technologies expo, this was the 2nd year that the event was held. The expo was a great way for existing customer of MProfit to meet the team. In addition, it was a way for potential customers to get a demo of MProfit and interact with the entire team at MProfit. Below are some pictures from the event.

DSC02002 DSC02010 DSC02011 DSC02014 DSC02019 DSC02027

In addition, we had a lucky drawing for people that visited our booth, a chance to win a free 1 year license of MProfit Pro. The following are the 10 lucky winners:

  • Indresh Malik
  • Jay Ram
  • Karan Thakkar
  • Lokesh Shah
  • Manish Sidhpura
  • Nageshwarrao Patta
  • Prashant Mahadik
  • Ranjit Das
  • Sandeep Daas
  • Sanjay Sutaria

Latest Update Tracks Bond Prices

new_94_boxLast week we released the latest update to v9.4 (1013.0366) and we have added many new features. One of the biggest features is the ability to track bond prices.

Tax free bonds have emerged as highly popular investment option among investors due to the taxation benefit that they offer and better yields since last couple of years. The bonds are mostly issued by government-promoted entities hence, come with the highest level of credit rating and provide investors a sense of safety compared to other corporate bonds.

Support for traded bonds in MProfit was one of the most requested features from our clients. The current version supports live prices (end of the day prices) of traded bonds in capital market segment and also provides short term and long term capital gains reports for traded bonds.

New Features:
– Live prices (End of Day prices) of traded bonds on NSE and BSE in capital market segment (Historical prices of Bonds are not supported yet)
– Earlier “Bonds” category has been renamed as NCD/Debentures
– Transfer of assets from NCD/Debentures to Traded Bonds –
– Reassignment of asset to new bank with effective date –
– Settlement of expired options –
– Increased count to 25 from 16 portfolios in PMS & F&O together (for Pro and Advisor version)
– Increased count to 25 from 16 accounts in Account category (for Pro and Advisor version)
– Expired instruments (in F&O category) will appear with sign E in red colour on summary screen

New Reports:
– Capital Gains of  traded bonds
– New XIRR report with Quantity
– Stocks & Mutual Fund transactions register (for Pro and Advisor version)
– Holding Period (number of days for Stocks & Mutual funds) (for Pro and Advisor version)

For the complete list you can visit our version history section.

To get the update, in MProfit goto Help -> Check for Updates and follow the instructions.

Parents Health Insurance Buying Guide

mahavir-coverfoxFrom time to time at MProfit we come across some really guide articles that we feel will benefit our users. Below is an article from Mahavir Chopra of Coverfox talking about buying health insurance for parents. The eBook they provide is very useful and highly informative.

– – –

Culturally, India is a very unique country, especially how we operate as families and take care of each other. When we are young, our parents meticulously take care of all our needs for years together till they are absolutely convinced that we are financially independent.

The role reverses when our parents turn old and they willingly or unwillingly start depending on us.

As they turn old we see small health complaints cropping up, they start getting feeble. Worst-case scenarios start randomly crossing our minds– like a major surgery or hospitalization.

No wonder whenever the topic of Health Insurance for parents gets raised in a group of friends, a strong emotion erupts that results in dead pan silence or an animated conversation around the problems of getting the coverage, high premiums, or worse, being able to make claims around diseases the parents are already suffering from.

This dichotomy has always made me think hard. I knew deep down that health insurance was not as bad and is accessible to 80% of the parents, but almost 50% of us give up for one reason or the other.

I therefore decided to write a short eBook which is an attempt at resolving the doubts, questions and road blocks that exist in the minds of the average 30 year old Indian looking at covering his parents under a health insurance plan.

The book essentially covers:

  • Uncovering myths around Parents’ Health Insurance.
  • How to get health insurance for parents with medical conditions.
  • Comparison of leading Parents’ health insurance.
  • What do you if your Health Insurance is declined.

You can download the eBook here.