www.TallyERP9Help.Com
Select Your Language :

23.     Quick Setup for Excise for Dealer in Tally.ERP 9

Did you know that in Tally.ERP 9, you can implement all statutory modules and Tally.NET service from just a single screen?

Implementing company statutory modules in Tally.ERP 9 involves setting up of statutory masters by entering the required details, creation of  needed voucher types  and  going  through advance setup if required. Similarly, setting up Tally.NET also requires creation of users with different security levels and defining  various  authorization  rights  based  on  business  requirements.  Let  us  take  an  example. The standard steps required to implement statutory module for ‘Excise for Dealer’ is shown in the image below:

Quick Setup for Excise for Dealer in Tally.ERP 9
[208]

Remembering the sequence of creation of all these ledgers and voucher types is not a simple task. But, Quick Setup provides a one stop solution that allows users to complete all these requirements in a sequential manner from a single screen. It helps users save time, prevent errors and makes implementing statutory modules in Tally.ERP 9 a stress-free experience.

Currently, Quick Setup feature in Tally.ERP 9 is available for 7 different modules and in this article let’s implement ‘Quick Setup for Excise for Dealer’. To start:

To configure statutory setup for Excise for Dealer

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

Quick Setup for Excise for Dealer in Tally.ERP 9
[209]

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

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.


[209-A]

  • 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:


[209-B]

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.


[209-C]

  • 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.

T : Tariff Classifications (HSN)

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. Coils in the Name of Tariff field.

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

3.    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

Quick Setup for Excise for Dealer in Tally.ERP 9
[210]

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

I : Stock Item

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

1.    Enter the name of the Stock Item e.g. Hot Rolled Coil 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. Coils from the List of Tariff Classifications

Quick Setup for Excise for Dealer in Tally.ERP 9
[211]

4.            Select the unit of measurement of stock item e.g. Kg in 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 ompany 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.

Quick Setup for Excise for Dealer in Tally.ERP 9
[212]

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

Quick Setup for Excise for Dealer in Tally.ERP 9

[213]

·         Press enter to save the Excise Duty details.

Quick Setup for Excise for Dealer in Tally.ERP 9
[214]

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

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

S : Supplier / Customer Ledgers

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 Sterling Steel Industries.

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

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

Quick Setup for Excise for Dealer in Tally.ERP 9
[215]

4.            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.

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

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

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

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

o    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.

Quick Setup for Excise for Dealer in Tally.ERP 9
[216]

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. Decora Equipments.

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,

·         Under Mailing Details enter party address

·         Under Excise Details enter party excise registration details

Quick Setup for Excise for Dealer in Tally.ERP 9
[217]

·         Press enter to save customer's excise details.

Quick Setup for Excise for Dealer in Tally.ERP 9
[218]

5.            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.

F9 : Excise Purchase

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

Quick Setup for Excise for Dealer in Tally.ERP 9
[219]

6.    Skip Name of Class field.

Quick Setup for Excise for Dealer in Tally.ERP 9
[220]

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

 F8 : Rule 11 Invoice (Excise Sales Invoice)

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.

Quick Setup for Excise for Dealer in Tally.ERP 9
[221]

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

Ctrl+ F9 : Purchase Return (Debit Note)

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,

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

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

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.

Quick Setup for Excise for Dealer in Tally.ERP 9

[222]

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

 Ctrl+ F8 : Sales Return (Credit Note)

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,

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

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

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.

Quick Setup for Excise for Dealer in Tally.ERP 9
[223]

7.    Press enter to save.

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

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.

X : Creating Additional Excise Establishment / Factory

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

1.    In Name field enter the additional Excise Factory name e.g. Southern Dealers

2.    In Under field select Primary

3.   In Excise Registration Type field select Dealer

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

5.   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

o    Excise Registration No. - AEDFR4584DXD001

o    Date Of Registration - 10-May-2004

Quick Setup for Excise for Dealer in Tally.ERP 9
[224]

·         Press Enter to save Excise Details.

Quick Setup for Excise for Dealer in Tally.ERP 9
[225]

·         Press Enter to Save.

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

U : Updating Excise Duty for Multiple Stock Items

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

Quick Setup for Excise for Dealer in Tally.ERP 9
[226]

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

o    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.

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

o    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

Quick Setup for Excise for Dealer in Tally.ERP 9
[227]

o    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

Quick Setup for Excise for Dealer in Tally.ERP 9
[228]

·         Press Enter to view Excise Duty Details screen

Quick Setup for Excise for Dealer in Tally.ERP 9
[229]

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

o    Press Enter to view Proceed to Set Excise Duty screen

Quick Setup for Excise for Dealer in Tally.ERP 9
[230]

o    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.

 
Add
 
 
 

Tally.ERP 9 Reference Manual
www.tallyerp9help.com
Tally.ERP 9 Reference Manual LIBRARY
1.
Installation of Tally.ERP9
2.
Site Licensing of Tally.ERP9
3.
Shortcut Keys in Tally.ERP9
4.
Maintaining Company Data
5.
Creating Masters
5a. Accounts Information [Creating Masters]
5b. Inventory Information [Creating Masters]
6.
Voucher Entry
7.
Reports in Tally.ERP9
8.
Excise for Dealer
9.
Excise for Manufacturer
10.
Reports [ Excise for Manufacturer]
11.
Excise for Importer
12.
Service Tax in Tally.ERP9
13.
Tax Collected at Source (TCS) in Tally.ERP9
14.
Tax Deducted at Source (TDS) in Tally.ERP9
15.
Value Added Tax (VAT) in Tally.ERP9
16.
Central Sales Tax (CST) in Tally.ERP9
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
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
 
Our Portal : www.TallyERP9Book.Com www.IncomeTaxManagement.Com www.Tally9Book.com www.TallyERP9Help.Com
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