Quick Setup - Excise for Manufacturer

To create excise establishment /factory press Alt+C or select the option C: Creating Excise Establishment /Factory and press Enter to view Excise Establishment /Factory Setup sub-form.

1.  Registration Type: By default Manufacturer will be displayed as the Registration Type.

2. Address, Telephone No and PIN Code: Address, Telephone No. and PIN Code details are captured from the company creation screen. If required, it can be altered.

3. Excise Details: Under this section provide Excise Details of the unit. Excise Details will be specific to the Registration Type selected.

Note: Registration Type selected will be displayed below the heading – Excise Details to identify the unit as a manufacturer or a dealer.

• Unit Mailing Name: The Mailing Name entered in the company creation will be displayed as the Unit Mailing Name. If required, it can be altered.

Note: Name entered in the Unit Mailing Name will be used in all Excise Reports.

• Excise Registration (ECC) No.: It is a 15-Digit alphanumeric PAN based registration number mentioned in the Registration Certificate. The first part would be the 10-character (alphanumeric) Permanent Account Number [PAN] issued by the Income Tax Authorities to whom the registration number is allotted (includes a legal person).

The second part comprises a fixed 2-character alpha-code indicating the category of the  Registrant (XD – For Dealers / XM – For Manufacturers). The third part is a 3-character numeric.

Enter 15 digits Excise Registration Number (ECC) of the Company/Unit, e.g. AAPCA2149RXM001

• Date of Registration: Enter the date of Excise registration, e.g. 10-4-2000

• Type of Manufacturer: select the appropriate Manufacturer Type from the list of Types of Manufacturer, e.g. Regular

• Large Tax Payer Unit (LTU) Code: Enter the LTU code, if your company/unit is a large tax payer and has opted for assessment in Large Tax Payer Unit. Skip the Large Tax Payer Unit (LTU) Code field.

Note: Large Tax Payers are those assessees who pay large amount of Tax. They are the eligible taxpayer for the purposes of being served by the LTU. For e.g.: Rs.5,00,00,000

Large Tax Unit is self-contained tax office under the Department of Revenue acting as a single window clearance point for all matters relating to Central Excise, Income Tax/ Corporate Tax and Service Tax. Eligible Tax Payers who opt for assessment in LTU shall be able to file their excise return, direct taxes returns and service tax return at such LTUs and for all practical purposes will be assessed to all these taxes there under. These units are being equipped with modern facilities and trained manpower to assist the tax payers in all matters relating direct and indirect tax/ duty payments, filing of documents and returns, claim of rebates/ refunds, settlement of disputes etc.

Large Tax Unit location Code for Bangalore is L–10000

More information on LTU is available on – http://www.cbec.gov.in/cae1-english.htm

• Excise Book Name (as per Rule 11):  Enter the Excise Book Name which is allowed by the Commissioner of Central Excise for the company/unit.

• Select the option New Number from the List of Excise Books, to view Serial Number Alteration (Secondary) screen.

• Name: Enter the excise invoice book name allowed by the Commissioner of Central Excise for the company/unit, e.g. ABC/Rule11/Book1/09-10

ABC - Denotes Company Name.

Rule 11: Denotes that invoice book is maintained as per Rule 11 of Central Excise Rules, 2002

Book1: Stands for Book Number, which is allowed for the current financial year

          09-10: Denotes the financial year.

• Method of Numbering: By default Automatic (Manual Override) is displayed as the method of numbering.

Note: Automatic (Manual Override) method of numbering assures the Rule 11 requirement of maintaining invoices serially numbered and sequence of numbering.

• Prevent Duplicates: By default this field will be set to Yes.

• Starting Number: Enter the Starting Voucher Number which is allowed by the Commissioner of Central Excise. E.g. 1001

• Width of Numerical part: Mention the width of the numerical part.

• Prefill with Zero: when this option is set to No the digits before the invoice number will be blank. If this field is set to Yes the invoice number will be prefilled with Zeros based on the width of numerical part e.g. 00001(where the width of numerical part is set to 5).

• Restart Numbering: In this field enter the Starting Number as 1001 and ensure under Particulars the Type of Period is Yearly

This section user can set the dates to restart the voucher number by defining the types of period (Daily, Monthly, Never, weekly or Yearly).

• Prefix Details: Here enter the information to be prefixed with voucher number

• Applicable From: The date displayed in this field indicates the date from when the prefix should be displayed along with the voucher number.

• Particulars: Enter the information to be prefixed to the voucher number E.g. ABC/

• Suffix Details: Here enter the information to be suffixed with voucher number

• Applicable From: The date displayed in this field indicates the date from when the suffix should be displayed along with the voucher number.

• Particulars: Enter the information to be suffixed to the voucher number E.g. /08-09

In Tally.ERP 9 user can create more than one Excise Book Name for the same company or Unit. But, as per Rule 11 of Central Excise Rules, 2001 only one invoice book shall be in use at a time. A unit can maintain more than one invoice book if it is allowed by the Deputy/Assistant Commissioner of Central Excise.

To create more serial numbers, user can follow the above said procedure by selecting the option New Number or he can create serial numbers from the option Additional Excise Bill Book provided under Advanced Setup  or he can create additional Excise Bill book from Gateway of Tally > Accounts Info. > Serial Number

4. Other Details: In this section enter Range, Division and Commissionerate details

5. Range: Enter the code Name and Address of the range under which your company is registered.

6. Code: Enter Range Code as 090308

7. Name: Enter Range Name as Electronic City

8. Address: Enter the Range Address

9. Division: Enter the code Name and Address of the division under which your company is registered.

10. Code: Enter Division Code as 0903

11. Name: Enter Division Name as Division III

12. Address: Enter the Division Address

13. Commissionerate: Enter the code Name and Address of the Commissionerate under which your company is registered.

14. Code: Enter Commissionerate Code as 09

15. Name: Enter Commissionerate Name as Bangalore I

16. Address: Enter the Commissionerate Address

5.  Press Enter to accept and save Excise Registration Details.

Note: You can also create Excise establishment/factory by enable Excise feature in  F11: Features screen. To Enable excise Go to Gateway of Tally > F11: Features > Statutory & Taxation

To know more on enabling excise from F11: Features refer the topic - Enabling Excise in Tally.ERP 9

Each and every goods manufactured or produced have to be classified for finding out the rate of duty applicable. Accordingly, Central Excise Tariff Act 1985 classifies all the goods under 91 chapters and specific code is assigned to each item. This code is called Tariff Classification code, which consists of 8 digits. First 4 digits represent Chapter and heading and next 2 digit represents sub-heading and the last 2 digit represents sub-sub heading.

To create Tariff Classifications press Alt+T or select the option T: Tariff Classifications (HSN) and press Enter to view Tariff Classifications (HSN) Setup screen.

In Tariff Classifications (HSN) Setup screen

1. Enter the name of the Tariff Classification e.g. Plastic Bottles in the Name of Tariff field.

2. In Used For field - Excise will be displayed automatically.

3. Enter the Tariff Classification Code e.g. 39233010 in HSN Code field

Note: The Harmonized Commodity Description and Coding System (HS) of tariff nomenclature popularly known as Harmonised System of Nomenclature (HSN), is an internationally standardized system of names and numbers for classifying traded products developed and maintained by the World Customs Organization.

Note: From Multi Tariffs Classification Alteration screen you can create multiple Tariff classifications.

4. Press Enter to save.

Note: You can also create Tariff Classification from Gateway of Tally > Inventory Info. > Tariff/VAT Commodity

To know more on creating Tariff Classification from Tariff/VAT Commodity refer the topic - Creating Tariff Classification.

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

7. 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 under Central 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

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

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

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

• Specify the Rate of Duty as 10%

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

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

• Specify the Rate of Duty as 2%

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

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

• Specify the Rate of Duty  as 1%

• 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 appropriate Stock 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

To create Supplier/ Customer Ledgers press Alt+S or select the option S: Supplier /Customer Ledgers and press Enter to view Party Ledgers Setup screen.

Creating Supplier Ledger

In Party Ledgers Setup screen

1. In Name of Ledger field enter the name of the supplier e.g Swastik Water Suppliers.

2. Select Sundry Creditors as the group name in Under field.

3. Enable Set/Alter Excise Details to Yes to view Excise Details screen.

4. In the Excise Details screen,

7. Under Mailing Details enter party address

8. Under Excise Details enter party excise registration details

9. Enter the Excise Registration Number of the supplier.

• Enter the Date of Excise Registration in Date of Registration field.

• Enter the Range under which the supplier’s company is registered.

• Enter the Division under which the supplier’s company is registered.

• Enter the Commissionerate under which the premise of the Supplier’s company is registered.

• Select the Default Nature of Purchase from the Nature of Purchase list. The table lists the Type of Purchase, which can be changed during transactions.

Note: The Default Type of Purchase depends upon the status of the supplier, whether he is a Manufacturer / First Stage Dealer / Importer / Second Stage Dealer. The default Type of Purchase set for the Ledger can be altered/changed during transaction.

5. Press enter to save supplier's excise details.

Creating Customer Ledger

1. In Name of Ledger field enter the name of the customer e.g. Universal Distributors.

2. Select Sundry Debtors as the group name in Under field.

3. Enable Set/Alter Excise Details to Yes to view Excise Details screen.

4. In the Excise Details screen,

5. Under Mailing Details enter party address

6. Under Excise Details enter party excise registration details

5. Press enter to save customer's excise details.

6. Press Enter to save.

Note: You can also create Party Ledgers from Gateway of Tally > Accounts Info. > Ledgers

To know more on creating party ledgers from Ledgers menu refer topics -

1. Creating a Supplier Ledger

2. Creating a Customer Ledger

Excise Duty Ledgers are created to account the duty liability on the goods removed or to account the CENVAT Credit portion which is not availed during purchase of Inputs.

To create Excise Duty Ledger press Alt+D or select the option D: Excise Duty Ledgers and press Enter to view Excise Duty Ledgers Setup screen.

Basic Excise Duty Ledger

In Excise Duty Ledgers Setup  screen

1. Enter the Name of the excise duty ledger you wish to create, for e.g., Basic Excise Duty @ 10% in Name of Ledger field

2. Select Duties & Taxes as the group name in the Under field.

3. In Excise Duty Type field select Basic Excise Duty from the List of Excise Duty Ledger

4. In Duty Head field based on the duty type selected in Excise Duty Types field duty head will be displayed automatically. e.g. Basic Excise Duty.

5. In Excise Accounting Code field enter the accounting code of Basic Excise Duty- 00380003.

Note: 8 digit Accounting Code and amount tendered against each type of duty should be mentioned in G.A.R.-7 Challan.

5. In Rate of Duty field mention the applicable rate of duty - 10%

Education Cess Ledger

1. Enter the Name of the education cess ledger you wish to create, for e.g., Education Cess @ 2%.

2. Select Duties & Taxes as the group name in the Under field.

3. In Excise Duty Type field select Education Cess from the List of Excise Duty Ledger

4. In Duty Head field based on the duty type selected in Excise Duty Types field duty head will be displayed automatically. e.g. Education Cess.

5. In Excise Accounting Code field enter the accounting code of Basic Excise Duty- 00380111.

6. In Rate of Duty field mention the applicable rate of duty - 2%

Secondary Education Cess Ledger

1. Enter the Name of the excise duty ledger you wish to create, for e.g., Secondary Education Cess @ 1%.

2. Select Duties & Taxes as the group name in the Under field.

3. In Excise Duty Type field select Secondary & Higher Education Cess from the List of Excise Duty Ledger

4. In Duty Head field based on the duty type selected in Excise Duty Types field duty head will be displayed automatically. e.g. Secondary Education Cess.

5. In Excise Accounting Code field enter the accounting code of Basic Excise Duty- 00380003.

6. In Rate of Duty field mention the applicable rate of duty - 1%

7. Press Enter to save.

Note: You can also create Excise Duty Ledgers from Gateway of Tally > Accounts Info. > Ledgers

To know more on creating excise duty ledgers from Ledgers menu refer topics -

1. Creating Basic Excise Duty Ledger

2. Creating Education Cess Ledger

3. Creating Secondary Education Cess Ledger

CENVAT Ledgers are created to avail and account the CENVAT Credit on the Raw Materials (Inputs) purchased.

To create CENVAT Ledger press Alt+N or select the option N: CENVAT Ledgers and press Enter to view CENVAT Ledgers Setup screen.

Basic Excise Duty - CENVAT

In CENVAT Ledgers Setup screen

1. Enter the Name of the CENVAT ledger you wish to create, for e.g., Basic Excise Duty - CENVAT in Name of Ledger field

2. Select Current Assets as the group name in Under field.

Note: Tally.ERP 9 allows the user to create CENVAT Ledgers under Current Assets or Duties & Taxes. If the user

* Wants Net Group balance to be displayed then create CENVAT Ledger under Duties and Taxes

Example: Tax Liability (Rs. 10000) – credit (Rs. 3000) = Net (Group) Duty Liability   

              (Rs. 7000)

* Wants separate balance of Tax Liability and Credit to be displayed create CENVAT Ledger under Current Assets

Example: Tax Liability = Rs. 10000

             Credit Account = Rs. 3000

3. In Excise Duty Type field select CENVAT Basic Excise Duty from the List of Excise Duty Ledger

4. In Duty Head field based on the duty type selected in Excise Duty Types field duty head will be displayed automatically. e.g. Basic Excise Duty.

5. Skip the Excise Accounting Code field. As the CENVAT Ledgers are not used to account duty payable it is not must to provide Excise Accounting Code. If required enter the accounting code.

6. In Rate of Duty field enter the duty rate as 10%

Education Cess - CENVAT

1. Enter the Name of the CENVAT ledger you wish to create, for e.g., Education Cess -  CENVAT.

2. Select Current Assets as the group name in Under field.

3. In Excise Duty Type field select CENVAT Education Cess from the List of Excise Duty Ledger

4. In Duty Head field based on the duty type selected in Excise Duty Types field duty head will be displayed automatically. e.g. Education Cess.

5. Skip the Excise Accounting Code field. As the CENVAT Ledgers are not used to account duty payable it is not must to provide Excise Accounting Code. If required enter the accounting code.

6. In Rate of Duty field enter the duty rate as 2%

Secondary Education Cess - CENVAT

1. Enter the Name of the CENVAT ledger you wish to create, for e.g., Secondary Education Cess - CENVAT.

2. Select Current Assets as the group name in Under field.

3. In Excise Duty Type field select CENVAT Secondary & Higher Education Cess from the List of Excise Duty Ledger

4. In Duty Head field based on the duty type selected in Excise Duty Types field duty head will be displayed automatically. e.g. Secondary Education Cess.

5. Skip the Excise Accounting Code field. As the CENVAT Ledgers are not used to account duty payable it is not must to provide Excise Accounting Code. If required enter the accounting code.

6. In Rate of Duty field enter the duty rate as 1%

7. Press Enter to save.

Note: You can also create CENVAT Ledgers from Gateway of Tally > Accounts Info. > Ledgers

To create Excise Purchase voucher type press F9 key or select the option F9 : Excise Purchase and press Enter to view Excise Purchase Voucher Type Setup screen.

Note: Here we are creating new voucher type by retaining the default voucher type available in Tally.ERP 9

In Excise Purchase Voucher Type Setup screen,

1. Enter the name of the Voucher type in Name Field e.g. Excise - Purchases

2. In Type of Voucher field application displays the voucher type as Purchase

3. Select the appropriate Method of Voucher Numbering e.g. Automatic

4. Set Use for Excise to Yes to enter Excise Purchase to capture Assessable Value and Excise Duty breakup.

5. In Default Excise Unit field select ABC Company from the List of Excise Units

6. Skip Name of Class field.

7. Press enter to save.

Note: You can also create Excise Voucher types from Gateway of Tally > Accounts Info. > Voucher Types

To know more on creating voucher Types refer topic - Creating Excise Voucher Types

To create Sales voucher type press F8 key or select the option F8 : Rule 11 Invoice (Excise Sales Invoice) and press Enter to view Rule 11 Invoice (Excise Sales Invoice)  Voucher Type Setup screen.

Note: Here we are creating new voucher type by retaining the default voucher type available in Tally.ERP 9

In Rule 11 Invoice (Excise Sales Invoice)  Voucher Type Setup screen,

1. Enter the name of the Voucher type in Name Field e.g. Excise - Sales

2. In Type of Voucher field application displays the voucher type as Sales

3. Select the appropriate Method of Voucher Numbering e.g. Automatic

4. Set Use for Excise to Yes to enter Excise Purchase to capture Assessable Value and Excise Duty breakup.

5. In Default Excise Unit field select ABC Company from the List of Excise Units

6. Skip Name of Class field.

7. Press enter to save.

Note: You can also create Excise Voucher types from Gateway of Tally > Accounts Info. > Voucher Types

To know more on creating voucher Types refer topic - Creating Excise Voucher Types

In cases where you are not availing CENVAT credit on Inputs purchased while accounting purchases, same can be availed later. In Tally. ERP 9 CENVAT Availing entry can be recorded through a Debit Note (with Voucher Class).

To avail CENVAT credit you can alter Default Debit Note by creating CENVAT Availing Voucher Class or can create separate voucher type with Class under Debit note. It is suggested to alter the default Debit note by defining the CENVAT Availing Voucher Class.

To create voucher class in Debit Note to account CENVAT Credit Availing press Alt+A or select A: CENVAT Credit Availing to view CENVAT Credit Availing Voucher Type Setup screen

In CENVAT Credit Availing Voucher Type Setup screen, Tally.ERP 9 displays default Debit Note voucher along with the Excise Debit Note voucher if any.

1. Select Debit Note Voucher Type. Retain the default settings in Name of Voucher Type,  Method of Voucher Numbering

2. Set the option Use for Excise to NO

3. In Name of Class field mention the class name as - CENVAT Availing

4. Press Enter to view Voucher Type Class screen

5. In Voucher Type Class screen

6. Set the option Use Class for Excise /CENVAT Adjustment to Yes

6. Press Enter to save voucher Type Class screen

7. Press enter to save.

Note: You can also create voucher class for Debit Note from Gateway of Tally > Accounts Info. > Voucher Types > Alter > Debit Note

To know more on creating Voucher Class for Debit Note refer the topic - CENVAT Credit on Purchases from Excise Dealers

Under Central Excise Act Excise duty is payable monthly or quarterly depending on the Type of manufacturer. If you’re a Regular Manufacturer, Excise Duty is payable Monthly and if you are SSI Excise Duty is payable Monthly. Hence the CENVAT Credit Adjustment entry is recorded at the end of Every month or Quarter depending on the type of Manufacturer.

For the payment of Excise Duty, CENVAT Credit available to a Unit will be adjusted towards the Duty Payable to arrive at the Net Duty Payable to the Government.

In Tally.ERP 9 to record the adjustment entry is recorded in Journal Voucher with a CENVAT Adjustment Voucher Class by Crediting - CENVAT Ledgers and Debiting - Excise Duty Ledgers to nullify their balances and the net balance in the Excise Duty ledgers will be paid to the Government.

Note: This Voucher Type can also be used to adjust the Advance Excise duty paid to the Government towards Excise Duty payable for the current month.

To create CENVAT Adjustment Class in Journal Voucher press F7 Key or select F7: Adjustment of CENVAT Credit / Advanced Adjustment and press enter to view CENVAT Credit /Advanced Adjustment Voucher Type Setup screen.

In CENVAT Credit /Advanced Adjustment Voucher Type Setup screen, Application displays default Journal Voucher

1. Select Journal Voucher Type. Retain the default settings in Name of Voucher Type,  Method of Voucher Numbering

2. In Name of Class field mention the class name as - CENVAT Credit Adjustment

3. Press Enter to view Voucher Type Class screen

4. In Voucher Type Class screen

5. Set the option Use Class for Excise /CENVAT Adjustments to Yes

5. Press Enter to save Voucher Type Class screen.

6. Press enter to save.

Note: You can also create voucher class for Journal from Gateway of Tally > Accounts Info. > Voucher Types > Alter > Journal Voucher

To know more on creating Voucher Class for Debit Note refer the topic - Creating a Journal Voucher - CENVAT Credit Adjustment

In Tally.ERP 9 you can record production (of finished goods) entry through Manufacturing Journal or Excise - Stock Journal.

• Manufacturing Voucher type – Used to record the production of Single Finished Goods

• Excise - Stock Journal – Used to record the production of Multiple Finished Goods

To create Manufacturing or Excise - Stock Journal press Alt +F7 or select F7 : Manufacturing /Stock Journal and press Enter to view Manufacturing / Stock Journal Voucher Type Setup screen

Manufacturing Journal Voucher Type

In Tally.ERP 9 user can create a Manufacturing Journal under Stock Journal or alter the exiting Stock Journal

Note: Here we are creating new voucher type by retaining the default voucher type available in Tally.ERP 9

In Manufacturing / Stock Journal Voucher Type Setup screen

1. Enter the name of the Voucher type in Name Field e.g. Manufacturing Journal

2. In Type of Voucher field application displays the voucher type as Stock Journal

3. Select the appropriate Method of Voucher Numbering e.g. Automatic

4. Set the option Use As Manf Jurl to Yes

Excise - Stock Journal Voucher Type

There are industries which use common raw materials to manufacture multiple finished goods. In this case Raw materials will be issued from godown to production floor for the manufacture of multiple finished goods (with or without by-products).

In Tally.ERP 9, multiple finished goods manufacture (with or without by-products) can be recorded using Excise-Stock Journal.

1. Enter the name of the Voucher type in Name Field e.g. Excise - Stock Journal

2. In Type of Voucher field application displays the voucher type as Stock Journal

3. Select the appropriate Method of Voucher Numbering e.g. Automatic

4. Set Use for Excise to Yes

5. In Default Excise Unit field select ABC Company from the List of Excise Units

6. Press Enter to save.

In Tally.ERP 9 you can create multiple excise establishments in single company.

To create additional excise establishment press Alt+X or select X: Creating Additional Excise Establishment/Factory and press Enter to view Additional Excise Establishment /Factory Setup screen

In Additional Excise Establishment /Factory Setup screen

1. In Name field enter the additional Excise Factory name e.g. National Manufacturers

2. In Under field select Primary

3. In Excise Registration Type field select Manufacturer

4. To enter the excise registration details set the option Set/Alter Excise Details to Yes

5. In Excise Details screen

6. In Address field enter the address of the excise factory

7. Enter PIN Code and Telephone No. of the Excise Factory

8. Enter the Excise Details like

• Excise Registration No. - ASSED4578SXM001

• Date Of Registration - 10-Jun-2001

• Type of Manufacturer - Regular

• Excise Book Name (as Per Rule 11)- NM/Book 1/09-10 and enter the details in Serial Number alteration (Secondary) screen as shown below

• Press Enter to save Serial Number alteration (Secondary) screen

• Enter Other Details like Range, Division and Commissionerate details.

• Press Enter to save Excise Details

• Press Enter to save.

Note: Additional Excise Establishment/Factory can also be created from Gateway of Tally > Inventory info. > Godowns / Excise Units > Create

In case of companies which have many stock items and doesn't want to define Duty to each item separately when ever there is change in duty (because of budget or any other reason),  can use multi stock duty alteration option available in Tally.ERP 9 to copy the duty details of one stock item to multiple stock items.

Example: Update the excise duty details of Pet Bottles - 1Ltr to other stock Items like Pet Bottles - 2Ltr , Pet Bottles - 700ml etc.

To update excise duty details to multiple items press Alt+U or select the option U : Updating Excise Duty for Multiple Stock Items and press Enter to view Set Excise Duty Rates Setup screen.

In Set Excise Duty Rates Setup screen

• Copy From: In this field select the stock item from which the duties to be copied i.e. Pet Bottles - 1Ltr

• Destination Type: Here select the destination type to which you want to copy the duties. Tally.ERP 9 gives 3 Destination Types.

• Stock Groups: If this destination type is selected, the duty details will get copied to all the stock items created under the selected Stock Group.

• Stock Items: If this destination type is selected, the duty details will be copied to the Stock Item selected.

• Tariff Classifications: If this destination type is selected, the duty details will get copied to all the stock items which fall under the selected Tariff Classification.

Here, Tariff Classifications is selected as the Destination Type

• Copy To: In this filed depending on the destination type selected, identify the stock item/Stock Group /Tariff Classifications to copy the excise Duties

  Select Plastic Bottles from the List of Tariff Classifications

• Press Enter to view Excise Duty Details screen

Note: The above screen displays the details (Excise Unit Name, valuation Type,Units, etc.) which will copied to the stock items.

• Press Enter to view Proceed to Set Excise Duty screen

• Press Enter to set excise Duty.

Now the stock items created under Tariff Classification Plastic Bottles would have been updated with the excise duties. Details like -

• Stock Items to which the duty rates are updated

• Number of stock items grouped under stock group/tariff classification (displayed when the Stock Group /Tariff Classifications is selected in Copy to field)

• To how may Items update has been done.

will be displayed in the Calculator Pane.

Note: You can also update excise duty for multiple stock items from Gateway of Tally > Inventory Info. > Stock Items > Update Excise Duties

To know more on updating excise duty for multiple stock items refer the topic - Multi Stock Duty Alteration

In Tally.ERP 9 user can create more than one Excise Bill Book for the same company or Unit. But, as per Rule 11 of Central Excise Rules, 2001 only one invoice book shall be in use at a time. A unit can maintain more than one invoice book if it is allowed by the Deputy/Assistant Commissioner of Central Excise.

To create Additional Excise Bill Book press Alt+B or select B: Additional Excise Bill Book and press enter to view Additional Excise Bill Books Setup screen.

Additional Excise Bill Books Setup screen displays the excise bill book which was created during excise establishment creation.

To create Additional Excise Bill Book

1. In Name of Excise Book enter the additional excise invoice book name allowed by the Commissioner of Central Excise for the company/unit, e.g. ABC/Rule11/Book2/09-10

2. By default Automatic (Manual Override) is displayed as the Method of Numbering.

3. Set Prevent Duplicates field to Yes.

4. In Starting Number field enter the Starting Voucher Number which is allowed by the Commissioner of Central Excise. E.g. 101

5. In Width of Numerical part field mention the width of the numerical part if required.

6. Set the field Prefill with Zero to No

7. Set the field Advanced Configuration to Yes and press enter to view serial number setup screen

8. In Serial Number Setup screen enter the details of Restart Numbering, Prefix and Suffix.

1. 9. Press enter to save Serial Number setup

10. Press enter to save

Note: You can also create Additional Excise Bill Book from Gateway of Tally > Accounts Info. > Serial Number