Problems in VAT and Excise in Tally.ERP 9

An update on the below post. : this is an old post you are requested to ignore this post and download the latest version of tally.erp 9 release 1.60 to avoid problems in vat and excise in Tally.Erp 9

Latest updates resolved the issue related to  VAT, EXCISE in Tally.ERP 9 and made the life simplified.

Today, I will post problems relating to vat and excise.

In, India, there is no unique system for issuing a sales bill.There are so many different practices prevailing in Industry, trade or business and Tally ERP failed to understand this basic point resulted in incorrect calculation of VAT, Excise and reporting of the same

Tally ERP 9 work okay if the billing is simple e.g. (for entering a purchase bill)

Cost of ItemRs.100.00 INR

+Basic Excise Duty 8.00INR


+S.H.E.0.80 INR

+Vat 4%4.32 INR

+Add. Vat 1%1.08 INR


Total bill amount 113.64 INR

IF a bill is such a simple, then there is no problem in calculation. However as I indicated there are multi ways a supplier raise a bill.

Let’s see the same example

+Cost of ItemRs. 100.00 INR

+Excise Duty



+PackingRs. 20.00( or any other expenses)


+Add. Vat


Now, interesting thing is that once you enter the amount of such kind of expenses (packing or any other then the figure of excise duty will automatically changed! In tally ERP however the vat will show a correct figure but the total bill amount not!

And if a supplier charge such an expense on the amount of item + excise + vat then both the duty will get changed accordingly and you will not be able to post a bill in a correct way. Even if you are an advanced user and somehow able to post the entry then VAT reports, calculation (atleast for Gujarat State) will not show a true picture. This Time, I have to prepare vat reports manually for the month of March 2009 until that I was just taking print out directly from the tally 9 without any manual work.

Further more, if you have installed and migrated to tally erp 9 and using the excise module, then don’t try to view a voucher by pressing enter continuously. There are chances that vat, excise duty will be disappear or the figures of vat, excise will be changed and so the bill amount will also be changed.

I hope that Tally will make correction to such big mistake at the earliest. I suggest that it may be possible if Tally allow its users to change the assessable value while entering a purchase/sales voucher which is at presently not possible. If tally users are able to change assessable value both for excise and vat, then this problem might be solve. However it has again to modify its vat reports






Latest Comments
  1. sree November 29, 2010
  2. Mr Avilash Ray June 7, 2011
  3. Sadiq July 25, 2011
    • kamlesh patel December 29, 2012
  4. Jitendra December 10, 2011
    • Mahendra December 10, 2011
  5. netra kotharkar February 25, 2014

Leave a Reply

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

Optimization WordPress Plugins & Solutions by W3 EDGE