Excise on Opening stock in Tally 9 Release 1.1

Tally 9 is enabled with Excise for Dealers. However, there is one caveat.

There seems to be no straightforward option to enter the excise purchase details of opening stock.

Here is the workaround:

1. On 1st April, pass a Purchase invoice in Tally showing the full purchase as per the original bill. While entering Supplier's Bill No. and Date, enter the correct Date which can be back-dated.

2. Consolidate all the sales which you have made out of the items purchased, and pass a single Sales invoice on 1st April with Party Name as Cash.

3. The side-effect of 1 and 2 above will be that Sundry Creditors will increase and Cash will also increase. To counter that, pass a normal Debit note for the Sundry Creditor and Credit Note for Cash (dont use Invoice Mode, i.e. dont give Stock Item details).

4. Now when viewing the Purchase and Sales Register, the entries created in 1 and 2 above will need to be hidden using Alt-R.

Of course, this is a stop-gap solution until Tally comes up with a proper solution in a future release.

If you have any better approach, feel free to post here.

About this Blog

Dear Reader,

This blog is an attempt to share my knowledge of Tally with you, and also present some case studies where we have successfully implemented Tally to meet complex accounting requirements.

Let me introduce myself. I am a freelancer in Bangalore, India specializing in Tally implementation and customization.

Other than Tally, I also undertake software development projects in Visual Basic, .NET and Excel programming.

Among others, I have ready products for Weigh Bridge Management, Courier Billing System, Photo Studio Billing System.

I will try to keep this blog updated about my Tally exploits and make it a forum for meaningful Tally interaction.

Yours sincerely,
Rajesh Khater.
rajesh_khater@yahoo.com