www.TallyERP9Help.Com

Duty Charging on Excise Purchase/Sales (Excise for Dealer) in Tally.ERP 9

The Excise duty on purchases may be accounted in two ways i.e., Exclusive or Inclusive method.

Under Exclusive method, Excise Duty, Education Cess, Higher Education Cess & other duties of excise ledgers are created and itemised separately in the Purchase Invoice and as a result the excise amount paid is available separately in the respective ledgers.

Under Inclusive method the value of Excise Duty and other cess amount debited to Purchase Accounts i.e., apportioned to the Purchase Cost. The applicable Duties of Excise and Cessare calculated in the Excise Details sub screen based on rate of duty pre-defined in the stock item master.

In most of the cases Excise Dealers will follow Inclusive method. But there are dealers who will follow Exclusive method where separate duty ledgers are created to account the duty charged and while making sales same ledgers are selected to pass on the duty to the dealers.

In Tally.ERP 9 users can also record the excise purchases in Exclusive method.

Example: On 4-1-2011, ABC Company Purchased 1000 kgs of Hot Rolled Coils from Sterling Steel Industries @ 500per Kg

 

Duty paid on this purchase is

 

*Basic Excise Duty @ 10% - 50000

*Education Cess @ 2% - 1000

*Secondary Education Cess @ 1% - 500

Step 1: Create Basic Excise Duty Ledger

Go to Gateway of Tally > Accounts Info. > Ledgers > Create

  • In Name field enter duty ledger name E.g. Basic Excise Duty @ 10%

  • Group the duty ledger under Duties & Taxes

  • In Type of Duty/Tax field select Excise

  • In Excise Accounting Code field specify the accounting code of basic excise duty.

Note: Excise Accounting Code is not mandatory as this code is not printed in invoice or the excise reports.

  • In Duty Head field select Excise Duty

  • In Percentage of Calculation specify the rate of duty charged on the excise stock

  • In Method of Calculation select Type of Duty - On Total Sales


[Img-170]

  • Press Enter to save.

Step 2: Create Education Cess Ledger

  • In Name field enter duty ledger name E.g. Education Cess @ 2%

  • Group the duty ledger under Duties & Taxes

  • In Type of Duty/Tax field select Excise

  • In Excise Accounting Code field specify the accounting code of education ces.

Note: Excise Accounting Code is not mandatory as this code is not printed in invoice or the excise reports.

  • In Duty Head field select Cess on Duty

  • In Percentage of Calculation specify the rate of cess charged on the excise stock

  • In Method of Calculation select Type of Duty - Additional Duty

Note: From Rel 4.8 an option to provide Bank Details is provided in the Ledger Master.


[Img-171]

  • Press Enter to save.

Step 3: Create Secondary Education Cess Ledger

  • In Name field enter duty ledger name E.g. Secondary Education Cess @ 1%

  • Group the duty ledger under Duties & Taxes

  • In Type of Duty/Tax field select Excise

  • In Excise Accounting Code field specify the accounting code of education ces.

Note: Excise Accounting Code is not mandatory as this code is not printed in invoice or the excise reports.

  • In Duty Head field select Cess on Duty

  • In Percentage of Calculation specify the rate of cess charged on the excise stock

  • In Method of Calculation select Type of Duty - Surcharge on Tax


[Img-172]

  • Press Enter to save.

Step 4: Record the Transaction in Excise Purchase

Go to Gateway of Tally > Accounting Vouchers > F9: Purchase

  1. Select the Excise - Purchase as the Voucher Type from the list of types.

  2. Select Alt + I: Item Invoice if it is in Acct Invoice Mode

  3. Enter the Supplier Invoice No.  as SI\6035 and Date as  4-1-2011

  4. By Default Tally.ERP 9 displays the Excise Unit as ABC Company as defined during voucher type creation.

  5. Select the Party’s A/c Name from the list of Ledger Accounts e.g. Sterling Steel Industries

  6. The Supplier’s Details sub-form accept the default details

  7. In Purchase Ledger field select the purchase ledger. Based on the VAT/Tax Class selected in the purchase ledger VAT/Tax Class will be displayed automatically

  8. In Name of Item field select the stock item purchased. e.g. Hot Rolled Coil

  9. In Quantity field specify the quantity of item purchased e.g. 500 kg

  10. In Rate field specify the rate at which the excise stock is purchased. e.g. 1000

Note: In Rate field specify the actual purchase rate per unit excluding the Duty & VAT.

  1. Amount will be calculated & displayed automatically


[Img-173]

  1. Press Enter to view Excise Details screen.

  2. In Excise Details screen, specify the RG 23 D Entry No. where the reference of this purchase entry is available

  3. In Supplier Invoice Details section specify the Invoice Number, Invoice Date & PLA/RG 23D Entry No. of the supplier. In Assessable Value field specify the amount on which the duty is calculated (manufacturer assessable value). Specify Rs. 5,00,000


[Img-174]

Note: In all the Dealer Excise Reports, duty details of the excise goods purchased (sold) are captured from the Excise Details screen. Hence it is must to provide all the details in Excise Details even while recording Excise Purchase using Exclusive Method (by selecting Duty ledgers).

  1. Select Excise Duty Ledger - Basic Excise Duty @ 10% duty will be calculated & displayed automatically.

  2. Similarly select Education Cess & Secondary Education Cess ledger. Cess will be calculated & displayed

  3. Select Input VAT ledger to account the VAT paid on the purchases

The completed Excise Purchase Voucher is displayed as shown


[Img-175]

  1. Press Enter to accept.

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