Creating an Excise Opening Stock

Top Previous Next

Tally allows you to maintain a record of Excise Opening Stock Balance of the Excise Stock Items

Note: Excise Opening Stock option under the Inventory Info menu will appear only if you create an Excise Purchase voucher type with Use for Dealer Excise option set to Yes.

To create an Excise Opening Stock:

Go to Gateway of Tally > Inventory Info > Excise Opening Stock

Ex_Open_Stock_Menu

Creating an Excise Opening Stock

You can track the Excise Opening Stock by entering the Stock Item Purchase details in the Excise Opening Stock.

Let’s consider an Example: A user buys 100 nos of Stock Item A from King & Sons and 50 nos of Stock Item A from MICO Manufacturing Limited.

The Opening Stock carried forward for the current year will be 35 nos of Stock A ( 25 nos. from king & Sons and 10 nos from MICO Manufacturing Limited). To record this Excise Opening Stock balance, you need to follow the below procedure:

Go to Gateway of Tally > Inventory Info > Excise Opening Stock

1.	Enter the purchase Invoice Number of the Stock Item in the field Supplier Invoice No.

2.	Select the Party’s A/c Name from the List of Ledger Accounts

3.	Enter the Party details in the Party Details sub form

Ex_op_Stock_supp_det

4.	Accept the above screen and select the Nature of Purchase from the list

Ex_op_Stock_Dealer_select

5.	Select the Purchase Ledger from the List of Ledger Accounts

6.	Select the Stock Item from the List of Excise Stock Items for the Item Allocations screen to appear

7.	Enter the Purchase Quantity in the field Quantity, i.e. quantity purchased from the supplier

8.	Enter the purchase Rate

Ex_Op_Stock_St_Item_Alloc

9.	Accept the above screen and the Excise Details screen to appear

Ex_Op_Stock_Excise_Det

10.	Enter the Supplier Invoice Number and Supplier Invoice Date

11.	Enter the PLA RG 23 Sl. No. if any

12.	Enter the Quantity on hand in the field Excise Opening Stock and accept the Excise Dealer sub form

Note: For accurate Duty calculations, all the fields in the above screen have to be accepted.

Ex_Op_Stock_Purchase

13.	Accept the above screen

Similarly, the Excise Details sub form for the Stock Item purchased from MICO Manufacturing Limited appears as shown

Ex_Op_Stock_Excise_Det -1

The Excise Opening Stock appears as shown

Ex_Op_Stock_Purchase1

Note: The Excise Opening Stock voucher is an optional voucher, which will not affect your Book of Accounts. They can be viewed under Exception Reports and Day Book.