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 support@mprofit.in 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

cap_gains_taxes

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 support@mprofit.in 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

Capital Gain Calculations for Mutual Funds (MF)

MProfit generates separate capital gains reports for Equity MFs and Debt MFs because taxation rules vary for each type. You can also generate two separate reports with indexation and without indexation for Debt MFs (Liquid funds, Income funds, FMPs and Gold ETFs). We give a quick overview of how MProfit handles these calculations and how you can easily generate mutual funds capital gains reports using MProfit.

Getting started:

  • If you are an individual investor, all you need to do is import (upload to MProfit) the consolidated account statement sent by CAMS. This statement includes all types of transactions related to mutual fund schemes managed by CAMS, Karvy and Franklin for your entire family. Most mutual fund schemes are covered under this statement. Click here to learn how to request this file.
  • If you are a financial advisor, you need to import the CAMS WBR2, Karvy 221 and Franklin back-office files which contains mutual fund transactions for all your clients. Click here to learn how to request these files

Here are the MF capital gains calculation methodology that MProfit follows:

  • MProfit follows the First in First Out (FIFO) method for capital gain calculations
  • In the event of consolidation or splitting of units of mutual funds, MProfit automatically calculates capital gain reports based on the adjusted purchase prices. MProfit also takes care of Dividend Reinvestments when calculating capital gains as follows. Dividend Reinvestments are considered as new buy transactions for that particular scheme. When you sell (redeem) units, all new subscriptions (buys) and dividend reinvestment transactions are taken into account and short term and long term capital gains are calculated as per the FIFO rule
  • MProfit also accurately computes capital gains for Switch-In, Switch-Out, STP-In and STP-Out transactions as per income tax rules. STP-In/Switch-In are considered as “buy” transactions in one scheme and STP-Out/Switch-Out are considered as “sell” transactions in another scheme

Here is an example demonstrating how MProfit handles capital gains calculations for MFs:

Date Type

Units

NAV

Amount

Short Term Capital Gain

Long Term Capital Gain

10-Apr-15 Buy

1,000.00

10.00

10,000.00

   
25-Apr-15 Dividend-Reinvestment

100.00

11.00

1,100.00

   
15-Dec-15 Sell

1,050.00

15.00

15,750.00

5,200.00

 
02-May-16 Sell

50.00

20.00

1,000.00

 

4,50.00

Note: the dividend reinvestment of 100 units with a NAV of 11.00 on 25-Apr-15 is characterized as a new buy transaction.

Capital gain/loss calculation on 15-Dec-15:

  • Total redemption (sale) value = Units ´ NAV = 1,050 ´ 15 = 15,750
  • As per FIFO, 1,000 units bought on 10-Apr-15 and 50 units bought on 25-Apr-15 are sold on 15-Dec-08
  • Total cost = (1,000 ´ 10) + (50 ´ 11) = 10,550
  • Capital gain = 15,750 – 10,550 = 5,200
  • The redemption of all 1,050 units took place within 12 months of subscription (buy) so the 5,200 capital gain is characterised as short term

Capital gain/loss calculation on 02-May-16

  • Total redemption (sale) value = Units ´ NAV = 50 ´ 20 = 1,000
  • Total cost = 50 ´ 11 = 550
  • Capital gain = 1,000 – 550 = 450

The redemption of these 50 units took place after 12 months of subscription so the 450 capital gain is characterised as long term