Capital Gains in Tally

Capital gains computation in Tally is one of the most debated issue on the web, especially when it comes to capital gains arising from trading of stocks and other similar financial instruments.

There are several add-ins which you can buy with the help of which you can easily compute capital gains in Tally.

But the problem is, they are costly and everyone cannot afford it.

Or you just don’t want to buy it. 😕

Let me directly come to the point.

Today you are going to learn in the following post, the computation of capital gains in case of stocks and other similar financial instruments.

In fact, you can apply the method to calculate capital gains arising from any type of asset.

Capital losses can also be calculated by this method.

Note: In this post you will learn passing entries as if stock market is your investment as per Income Tax Law. If stock market is your daily business, you should see this post on Stock Market Entries for business in Tally. 

What is Capital Gains

Capital gains is a concept of Indian Income Tax Act, 1961 and probably every other income tax law in the world.

It literally means gains arising from transacting in capital assets.

Now, you must be thinking, what is a capital asset?

Capital Asset means big things like investments, house, shop, mobiles (at least now a days), building, furniture and so on.

In simple words, usually a big thing which is of more value is a capital asset.

Capital gains only arise when you have an investment and not in case of trading of shares in the course of your business (that would be business income).

In this case capital gains arises from selling of shares because we are discussing capital gains on shares.

Therefore capital gains will be reflected in Balance Sheet and no effect will arise in the Profit and Loss account.

And that is the reason I’ve NOT integrated accounts and inventory.

Because inventory details will give you overall report with the help of which capital gains entries will be passed.

You can do that by pressing F11 from the Gateway of Tally.

Then select Accounting Features.

Go to General and set No in the first option i.e. Integrate Accounts and Inventory

integrate-accounts-and-inventory

As per Income Tax Act, 1961, there are two types of capital gains.

  1. Long term capital gain – Arises when you purchase and sell shares after 12 months.
  2. Short term capital gain – Arises when you purchase and sell shares within 12 months.

By now, I am sure that you have understood what are short and long term capital gains.

This will make easier for you to understand this tutorial.

Ledgers required for this Capital Gains in Tally

Other than that, I’ve already created certain ledgers like:

If you don’t know how to create ledgers in Tally, here is a complete explanation along with the video tutorial.

Create ledgers in Tally

  • Share Purchase under Stock Investment which is under Investments
  • Share Sale under Stock Investment which is under Investments
  • Stock Broker under Sundry Debtors
  • Share Brokerage under Capital Account
  • Long Term Capital Gain under Capital Account
  • Short Term Capital Gain under Capital Account
  • Reliance (scrip for giving example in the video) under Stock Investment which is under Investments

And, lastly I have used the Simple Tally Trick of opening two windows of Tally at a time for saving a big amount of time by not coming in and out just for passing entries.

Entries required for Capital Gains in Tally

As you have read earlier that capital gains arises on sale of a capital asset and in our case, we have shares as an investment.

As we are discussing about shares I have passed a certain entries for shares purchases and sales.

I will show you step by step what entries I have passed and how I calculate capital gains in Tally.

This is the share purchase entry which is pretty simple to understand.

In this example, I have purchased 15 shares of Reliance for ₹15,000 on 1st April, 2016 and paid stock brokerage.

capital-gains-share-purchase-entry-in-tally

Now, I have sold 8 shares of Reliance for ₹12,000 on 31st May, 2016 and paid the share brokerage of ₹120.

capital-gains-share-sale-entry-in-tally-1

Again, I have sold 2 shares of Reliance for ₹3,200 on 1st June, 2016 and paid the share brokerage of ₹32.

capital-gains-share-sale-entry-in-tally-2

One more time, I have sold 5 shares of Reliance on 31st May, 2017 and paid share brokerage of ₹85.

capital-gains-share-sale-entry-in-tally-3

Please note that this time, I have sold the shares in 2017 and NOT 2016.

This is because I wanted you show both short term and long term capital gains.

I have explained earlier that more 12 months period results in long term capital gain.

Although, both the entries are same but still for the purpose of clear explanation, I will explain it to you both of them step by step.

These were the entries required for calculating capital gains in Tally.

Now we will look at how to calculate the capital gains as per the Income Tax Act, 1961 in Tally.

Calculation of Capital Gains in Tally

Calculation of capital gains is easy in Tally because you just have select certain options and Tally will automatically calculate the gains.

As per the Indian Income Tax Act, 1961, either FIFO (First in First Out) method is used or WAM (Weighted Average Method) is used.

But, FIFO is used in 99% of cases therefore in this post I am going to talk about calculation of short term and long term capital gains in Tally.

Now that we have passed the entries for shares, we will look into the calculation of capital gains in Tally.

From Gateway of Tally, go to Stock Summary.

stock-summary-from-gateway-of-tally

The following screen you will see will be the the Stock Summary.

Here is the screen in the picture below.

stock-summary-screen-in-tally

As you can see there are no entries in the screen.

This is because Tally does not automatically show the entries for which there is no stock.

Note that we have purchased 15 shares of Reliance and we have sold 15 (8+2+5) shares and therefore we do not have any stock.

Now, we have to select certain options and so we will have all the details which are required for calculating capital gains in Tally.

Firstly you have to press F7, which is a shortcut for Showing Profit in Stock Summary. It will also show losses if there are any in negative here.

The Stock Summary screen after pressing F7 will look like in the picture below.

stock-summary-showing-profit-in-tally

You can now see that there are two columns, which are:

Outwards and Closing Balance

But still there is no information about the capital gains which we have by selling the shares.

This is because, Tally does not automatically show you the shares which are sold out and therefore we have select yet another option in Tally.

It is called Configuration. You can go to it by pressing F12.

And the following options will appear on screen.

stock-summary-confiuration-in-tally

In this menu, you have to set Yes for the option – Show all Items (incl. zero balance).

Because of this, Tally will show all the entries even when there is no stock i.e. zero balance.

Also, set Yes to all the options till Show all Items (incl. zero balance) as you will require them to have a good picture for the purpose of calculation of capital gains as well as the profits.

After configuring these settings you will see a screen with the calculations as shown in the picture below.

capital-gains-in-tally-inwards-and-outwards

Did you note that there is nothing in the Opening Balance and the Closing Balance column?

Because we have no opening balance of Reliance and we sold all the shares before the end of the period.

You can clearly see that there is Gross Profit of ₹8,700 which is 36.71% of the total investment.

But for the Income Tax purposes we will have to calculate the gains as per FIFO so we have to select FIFO in Tally.

For selecting FIFO in Tally, you have press ALT+C, while in Stock Summary.

ALT+C is the shortcut for New Column in Stock Summary.

In this option, you will have to select FIFO Perpetual and NOT FIFO.

Here is the picture for clear understanding of what you have to do.

selecting-fifo-perpetual-in-stock-summary-in-tally

FIFO Perpetual means FIFO throughout all the periods for which you will have accounting entries.

On the other hand FIFO alone means FIFO for a particular accounting period and therefore we always choose FIFO Perpetual especially for the income tax purposes.

Accounting period usually starts from 1st April and ends on 31st March of the next year.

Now we have the exact calculation which is required for calculating capital gains as per the Indian Income Tax law.

After selecting FIFO Perpetual, you will see the screen as shown in the picture below.

fifo-perpetual-in-stock-summary-in-tally

You can clearly in the red rectangle that the method is FIFO Perpetual.

The gains have not changed because we only have one share only 3 entries so it is very much simple.

But if you have more entries and more shares, the gains in both the methods will change and it would be usually a bit higher in FIFO Perpetual.

Now we will pass the entry for capital gains in Tally.

Short and Long Term Capital Gains in Tally

If you have read till now line by line, you are awesome because you want to learn something in a very detailed way.

We have seen how to see the capital gains in Tally.

Now we will see how to pass capital gains entry in Tally.

From the Stock Summary, when you see the gains in FIFO perpetual as shown in the picture above, press enter to see all the entries.

This will help us to determine whether a gain is a long term gain or a short term gain.

It will look like in the picture below.

Calculation of long term and short term capital gains in Tally

Did you note that one of sales of shares is in May, 2017, which means it is long term capital gain because more than 12 months have surpassed since the purchase of the shares.

Both the sales in May and June which are in the year 2016, will be short term capital gains because they are sold within 12 months of the purchase.

Now, will pass one entry for short term capital gains and one entry for long term capital gains.

Note – You can can also pass two entries for short term capital gains since there are two entries. I have done the same in the video.

Firstly, we will pass entry for short term capital gains.

It will be as shown in the picture below.

Short term capital gain entry in Tally

And, the entry for long term capital gains will be same as short term capital gains as shown in the picture below.

Long term capital gain entry in Tally

These were the capital gain entries in Tally.

Now if you check the Stock Summary as well as the Balance Sheet both the values of the Reliance share will be the same.

In our case, the value of the share will be NIL because we sold all the shares.

Now you can watch the video tutorial.

It is pretty long because I’ve covered each and every detail, so be sure to watch it full for exact understanding.

Capital Gains in Tally

I am sure by now you must have understood how to pass capital gains entry in Tally.

It was a long process and a long post as well.

I didn’t do it intentionally. It was required to properly explain the concept.

If you have any type of confusion or any kind problem in computing capital gains via Tally, just comment below.

I’ll be glad to help you out! 🙂

Join TallySchool & Start learning Tally with GST for Free!





21 thoughts on “Capital Gains in Tally

    • Rishit Shah says:

      Hi Amar!
      Reliance ledger is under a group named primary (default in Tally for stock groups).

      Though you can make groups if you have stocks as well as mutual funds or if you think grouping is necessary for better accounting.

  1. Sai Sandeep says:

    Hello,
    I had a client dealing in stock market which we are doing accounts in tally as trading business for the past 2 years.My query is if we had a loss or profit which in general we call its as STCG or LTCG or STCL how can i account them in books.Kindly do the needful

    • Rishit Shah says:

      I have explained in the video tutorial how calculate capital gains.
      And if you do the opposite entry you can calculate capital losses. I suggest you watch the video one more time.

      Still if you have any questions, do tell me!

  2. Rajat Bothra says:

    this was really helpful… tried executing it, bt encountered a problem with an entry where a single sale transaction had both LTCG and STCG.. or where there were like 100 entries for a single stock nd i had to co-relate the sale txn with dat of the purchase.. manually it was next to impossible.. even if did it der wasnt any use of tally..

    • Rishit Shah says:

      Hi, Rajat!

      When there are both LTCG and STCG in one bill, you have to pass LTCG and STCG in one entry by bifurcating the stocks for STCG and LTCG.

      If there are 100 entries for single stock and correlation with Sales Tax, it is impossible.

      What you can do is at the time of entering the transactions itself, you could have entered proper sales tax, then it would have been easy for you.

  3. Dinesh Salian says:

    Dear Sir,
    I am a professional trader. I want to keep my books of accounting in tally. i understood your above explanation. but can u tell me how to enter my investments made two years back in tally.

  4. deeapk says:

    hi, sir
    how to calculate TDS, SERVICE TAX in tally i know that how to do entry in tally but not clear auto calculate in tally TDS & Service Tax

  5. Priya says:

    in privious vedio i.e share market entries in tally, u have taken share brokerage under Direct exp. and in this u have taken it under Capital A/c. so which one is correct?

  6. yogesh says:

    i created stock under inventory and passed entry in jounral for purchase and sales.. now when i try to pass entry for short term profit . stock name doesnt apper in ledger.. what should i do now?

    • Rishit Shah says:

      Hi, Yogesh!

      That means you have done the right entry.
      You have sold the entire stock and now there is nothing to show.

      Still, if you want to see it you can see it in the following way.

      Press F12 while is Stock Summary and set YES to Items including Zero Balance.
      You will now see the stock.

  7. HARSHIT says:

    HII.. YOUR EXPLANATION IS VERY USEFUL.
    HOWEVER MY QUES. IS
    AT THE TIME OF FILING I.T. RETURN MORE DETAILED DATA REQUIRED I.E. SALE DATE, SALE AMT,NO. OF SHARE,PUR.DT. , PUR. AMT., NO. OF SAHRE ……
    IN YOUR DESCRIBE MANNER WE CANNOT GET DETAILS LIKE PUR. DATE AND SALE DATE
    SO HOW CAN WE GET THE CHART MENTIONING THESE ALL DETAIL WHICH I HAVE DESCRIBED IN TALLY???

    THANKS FOR THIS GOOD EXPLAINATION

    • Rishit Shah says:

      Hi, Harshit!

      You can get in fact get details like purchase date and sales date. The date of the voucher will be the date of purchase or sale.
      Also, you can look at the Stock Summary which also mentions the date on which the share was bought and sold.

      • harshit says:

        I UNDERSTAND THAT BUT HOW CAN I GET THAT DATE IN EXPORTED CHART??…IF MY CA IS ASKING FOR SUCH CHART WHICH IS NECESSARY FOR FILING I.T. RETURN

Leave a Reply

Your email address will not be published. Required fields are marked *