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!


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.