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.