Select Your Language :

ALT+I : Raw Materials (Input), Finished Goods, Capital Goods and Other Stock Items

(Quick Setup for Excise for Manufacturer in Tally.ERP 9)

To create Stock Items (Raw material/ Finished goods/ Capital Goods/ Others) press Alt+I or select the option I: Raw Materials (Input), Finished Goods, Capital Goods and Other Stock Items and press Enter to view Stock Items Setup screen.

Creating Raw Material (Input)

In Stock Items Setup  screen

1.    Enter the name of the Stock Item e.g. Pet Bottles - 1Ltr in the Name of Item field.

2.    Select the Group Name e.g. Primary in the Under field.

3.    In Tariff Classification field select the applicable tariff classification e.g. Plastic Bottles from the List of Tariff Classifications


4.    Select the unit of measurement e.g. U (Numbers) of the stock item in the Units field (Use Alt +C to create Unit of Measurement).

5.    In Opening Stock field specify opening stock of the stock item

6.            In Rate field specify the rate of the opening stock, if any. Amount will be calculated and displayed automatically.

7.    Enable the option Set/Alter Excise Details to Yes to view Excise Details screen.

6.    In Excise Details Screen

·         Excise Unit Name: By default Tally.ERP 9 displays ABC Company as Excise Unit Name.

Note:  In Tally.ERP 9 excise units (Dealer/manufacturer) created  are identified as godowns. When the option Maintain Multiple Godowns/Excise Units is not enabled in F11: Features > Inventory Features (F2) by default Tally.ERP 9 identifies the excise unit name with the Default Godown named - Main Location

·         Reporting UOM: Select Kg as Reporting UOM. All the reports will display the Stock item details based on the reporting UOM selected. (Use Alt +C to create Unit of Measurement)

Note: As Per Central Excise Act, in all the reports relating to stock items are required to be indicated with the relevant Unit of Quantity as specified underCentral Excise Tariff Act. The Applicable Unit of Quantity for Bottles is ‘Kg (Kilograms)’, so it is must to select Kg (Kilograms) as the Reporting UOM.

·         In Conversion Factor field Set as 1 Kg = 100 U

Note: Tally.ERP 9 prompts the user to select the Conversion Factor only when the unit of Measurement selected in Units field and Reporting UOM is different.

·         Set/Alter Duty Details: Set this field to Yes to view the Duty Details screen


·         In the Duty Details screen

o    In Valuation Type select Ad Valorem from List of Valuation Type.

o    Select the Basic Excise Duty in the Type of Duty filed from the List of  Excise Duty Classifications

o    In Applicable From field mention the Date from when the specified Rate of Duty is applicable

o    Specify the Rate of Duty as 10%

o    Select the Education Cess as the second duty  in the Type of Duty filed from the List of  Excise Duty classifications

o    In Applicable From field mention the Date from when the specified Rate of Duty is applicable

o    Specify the Rate of Duty as 2%

o    Select the Secondary and Education Cess as the third duty in the Type of Duty filed from the List of Excise Duty classifications.

o    In Applicable From field mention the Date from when the specified Rate of Duty is applicable

o    Specify the Rate of Duty  as 1%


o    Accept to save Duty Details screen.

·         In Excise Details screen, under Stock Item Type field select as Principal Input from the List of Item Types.


Note: You can create multiple stock items from Multi Stock Item Alteration screen. While creating Finished goods or Capital Goods etc. select the appropriateStock Item Type.


8.            Press Enter to save.

Note: You can also create Stock Item from Gateway of Tally > Inventory Info. > Stock Items

          To know more on creating items from Stock Items menu refer the topics -

1. Stock Item Raw Materials

2. Stock Item Finished Goods (Advalorem)

3. Stock Item Finished Goods (Quantum)

4. Stock Item Finished Goods (MRP)

5. CENVAT Credit on Capital Goods


Tally.ERP 9 Reference Manual
Tally.ERP 9 Reference Manual LIBRARY
Installation of Tally.ERP9
Site Licensing of Tally.ERP9
Shortcut Keys in Tally.ERP9
Maintaining Company Data
Creating Masters
5a. Accounts Information [Creating Masters]
5b. Inventory Information [Creating Masters]
Voucher Entry
Reports in Tally.ERP9
Excise for Dealer
Excise for Manufacturer
Reports [ Excise for Manufacturer]
Excise for Importer
Service Tax in Tally.ERP9
Tax Collected at Source (TCS) in Tally.ERP9
Tax Deducted at Source (TDS) in Tally.ERP9
Value Added Tax (VAT) in Tally.ERP9
Central Sales Tax (CST) in Tally.ERP9
28. GST using Tally.ERP9
Tally.ERP 9 Help LIBRARY
Short Cut Keys Command in Tally.ERP9
Reorder Levels & Reorder Quantity
Price Lists in Tally.ERP 9
Point of Sale (POS) in Tally.ERP 9
Job Costing in Tally.ERP 9
Interest Calculations in Tally.ERP 9
Features (F11) of Tally.ERP 9
Configuratioin (F12) of Tally.ERP 9
Data Migration in Tally.ERP 9
Cost Categories and Cost Centers
Budgets in Tally.ERP 9
Advanced Inventory Features
Advanced Accounting Features
Self-Running Tutorial with Audio
F.A.Q. Knowledgebase in Tally.ERP 9
Sample Reports @ Tally.ERP 9
Tips on Tally.ERP 9
Disclaimer. :
Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP 9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners.
The visitors may click here to visit the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications