QS Excise for Dealers

Quick Setup for Excise for Dealer in Tally.ERP 9 helps you to configure statutory setup required to maintain the financial records of Excise Dealers.

Go to Gateway of Tally > Quick Setup > Excise for Dealer. Quick Setup screen for Excise for Dealer will be displayed as shown

From this screen you can make required basic configurations like- creating excise dealer establishment, masters, voucher types to account statutory transactions. It also allows making advance configurations wherever applicable.

Configuration details will be displayed below the setup options once the configuration is done other wise application will display the status as Not Configured for Company Setup and 0 of 0 Configured for other setups (Masters/Voucher Types setup etc.).

Procedure to Quick Setup for Excise for Dealer

1. Company Setup

Company Setup guides you to create excise unit by providing relevant excise registration details . For more details on creating excise establishment click, C : Creating Excise Establishment / Factory

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.

Registration Type: By default Dealer will be displayed as the Registration Type.
Address, Telephone No., PIN Code: Address, Telephone No. and PIN Code details are captured from the company creation screen. If required, it can be altered
Excise Details: Under this section provide Excise Details of the Dealer. 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 code. E.g. AAPLS5647MXD001

Date of Registration: Enter the date of Excise registration, e.g. 1-4-1999
Excise Book Name (as per Rule 11): Enter the Excise Book Name. This will help in maintaining the sequence of Excise invoices raised by the dealer.
Select the option New Number from the List of Excise Books, to view Serial Number Alteration (Secondary) screen.
In the Serial Number Alteration screen, enter the details as shown:

Creating Excise Book will help the Excise Dealer to maintain the sequence of excise Sales invoices raised. Example: If the Excise Dealer raises , 3 Excise Invoices and 4 & 5th are commercial invoice. When the 6th Invoice raised is Excise Invoice the invoice number will be 4 instead of 6.

Note: Dealers who want the earlier method of invoice numbering can continue without creating the Excise Book.

Other Details: Enter Code, Name and Address of Range, Division and Commissionerate under which your company is registered.

Press Enter to accept the details of Entering Company Excise for Dealer 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

Note: To move from one setup to another setup use Arrow (up and down) Keys.

2. Master Setup

Master Setup guides you to create masters like Tariff Classification, Stock Item and Supplier and Customer ledgers by enabling relevant excise options in the masters. For more details on master creation Click on the below links.

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

Enter the name of the Tariff Classification e.g. Coils in the Name of Tariff field.
In Used For field - Excise will be displayed automatically.
Enter the Tariff Classification Code e.g. 72271000 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.

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 Item press Alt+I or select the option I: Stock Item and press Enter to view Stock Items Setup screen.

In Stock Items Setup screen

Enter the name of the Stock Item e.g. Hot Rolled Coil in the Name of Item field.
Select the Group Name e.g. Primary in the Under field.
In Tariff Classification field select the applicable tariff classification e.g. Coils from the List of Tariff Classifications

Select the unit of measurement of stock item e.g. Kg in Units field (Use Alt +C to create Unit of Measurement).
In Opening Stock field specify opening stock of the stock item
In Rate field specify the rate of the opening stock, if any. Amount will be calculated and displayed automatically.
Enable the option Set/Alter Excise Details to Yes to view Excise Details screen.

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: By default the unit of Measurement selected under Units will be considered as UOM for all the reports.
Set/Alter Duty Details: Set this field to Yes to view the Excise Duty Details screen.

In Excise Duty Details screen
In Type of Duty filed select Basic Excise Duty 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%
Method of Calculation – Assessable Value will be defaulted automatically based on the Type of Duty selected.
In Type of Duty filed select Education Cess 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%
Method of Calculation – On Duty Value will be defaulted automatically based on the Type of Duty selected.
In Type of Duty filed select Secondary Education Cess 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%
Method of Calculation – On Duty Value will be defaulted automatically based on the Type of Duty selected

Press enter to save the Excise Duty details.

Note: You can create multiple stock items from Multi Stock Item Alteration screen.

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 topic - Creating a Stock Item

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

In Name of Ledger field enter the name of the supplier e.g Sterling Steel Industries.
Select Sundry Creditors as the group name in Under field.
Enable Set/Alter Excise Details to Yes to view Excise Details screen.

In the Excise Details screen,
Under Mailing Details enter party address
Under Excise Details enter party excise registration details
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.

Press enter to save supplier's excise details.

Creating Customer Ledger

In Name of Ledger field enter the name of the customer e.g. Decora Equipments.
Select Sundry Debtors as the group name in Under field.
Enable Set/Alter Excise Details to Yes to view Excise Details screen.
In the Excise Details screen,
Under Mailing Details enter party address
Under Excise Details enter party excise registration details

Press enter to save customer's excise details.

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

3. Voucher Types Setup

In Tally.ERP 9, all the Excise transactions needs to be recorded in Excise Voucher types. You can create or alter the existing default voucher types to meet the requirement.

Voucher Types Setup guides you to create excise voucher types required to record excise transactions. For more details on voucher type creation Click on the below links.

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,

Enter the name of the Voucher type in Name Field e.g. Excise - Purchases
In Type of Voucher field application displays the voucher type as Purchase
Select the appropriate Method of Voucher Numbering e.g. Automatic
Set Use for Excise to Yes to enter Excise Purchase to capture Assessable Value and Excise Duty breakup.
In Default Excise Unit field select ABC Company from the List of Excise Units

Skip Name of Class field.

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,

Enter the name of the Voucher type in Name Field e.g. Excise - Sales
In Type of Voucher field application displays the voucher type as Sales
Select the appropriate Method of Voucher Numbering e.g. Automatic
Set Use for Excise to Yes to enter Excise Purchase to capture Assessable Value and Excise Duty breakup.
In Default Excise Unit field select ABC Company from the List of Excise Units

Skip Name of Class field.

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 Debit Note voucher type press Ctrl+ F9 or select the option Ctrl+ F9 : Purchase Return (Debit Note) and press Enter to view Purchase Return (Debit Note) Voucher Type Setup screen.

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

In Purchase Return (Debit Note) Voucher Type Setup screen,

Enter the name of the Voucher type in Name Field e.g. Excise - Debit Note
In Type of Voucher field application displays the voucher type as Debit Note
Select the appropriate Method of Voucher Numbering e.g. Automatic
Set Use for Excise to Yes to enter Excise Purchase to capture Assessable Value and Excise Duty breakup.
In Default Excise Unit field select ABC Company from the List of Excise Units

Skip Name of Class field.

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 Credit Note voucher type press Ctrl+ F8 or select the option Ctrl+ F8 : Purchase Return (Debit Note) and press Enter to view Sales Return (Debit Note) Voucher Type Setup screen.

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

In Sales Return (Debit Note) Voucher Type Setup screen,

Enter the name of the Voucher type in Name Field e.g. Excise - Credit Note
In Type of Voucher field application displays the voucher type as Debit Note
Select the appropriate Method of Voucher Numbering e.g. Automatic
Set Use for Excise to Yes to enter Excise Purchase to capture Assessable Value and Excise Duty breakup.
In Default Excise Unit field select ABC Company from the List of Excise Units

Skip Name of Class field.

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

4. Advanced Setup

Advance Setup is an optional (not a must) setup. Advance set up is required, only when you have more than one excise unit and which needs to be created or if you want to copy the duty details of one stock items to multiple stock items.

Advanced Setup guides you to create additional excise establishments and to update excise duty of one stock item to multiple stock items at once. For more details on creating additional excise establishments and to update excise duty to multiple stock items Click on the below links.

Note: To view the advance setup options press Enter from Advanced Setup or press F5 key or click on F5: Show Adv config button in the buttons bar.

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 screen

In Additional Excise Establishment screen

In Name field enter the additional Excise Factory name e.g. Southern Dealers
In Under field select Primary
In Excise Registration Type field select Dealer
To enter the excise registration details set the option Set/Alter Excise Details to Yes
In Excise Details screen
In Address field enter the address of the excise factory
Enter PIN Code and Telephone No. of the Excise Factory
Enter the Excise Details like

Excise Registration No. - AEDFR4584DXD001
Date Of Registration - 10-May-2004

Press Enter to save Excise Details.

Press Enter to Save.

Note: Additional Excise Establishment 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 Hot Rolled Coil to other stock Items like Cold Rolled Coils, Iron Rod 6mm, Iron Rod 4mm 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. Hot Rolled Coil

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 Coils 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 Coils 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

5. Q : Quit

To quit from Excise for Dealer Quick Setup screen press Alt+Q or select Q: Quit and press enter.

Quick Setup - Excise for Dealer

Procedure to Quick Setup for Excise for Dealer

1. Company Setup

2. Master Setup

Creating Supplier Ledger

Creating Customer Ledger

3. Voucher Types Setup

4. Advanced Setup

5. Q : Quit