Type search words and press enter
Seamless e-invoicing is now at your fingertips. Check out our self-help videos.
https://help.tallysolutions.com/docs/te9rel49/Excise_for_Manufacturers/Rule_11_Inv_Items_Diff_Valuation_Type_.htm

Rule 11 Invoice for Stock Items Falling Under Different Valuation Type

 

In Tally.ERP 9, the user can account different stock items falling under different valuation type in single sales voucher.

In the below illustration we are accounting the sale of AquaPure – 1 Ltr (MRP Based), AquaMini – 200 ml (Ad Quantum) and AquaKing – 20 Ltr (Ad Valorem) in single sales voucher

 

To create a Sales Voucher

Go to Gateway of Tally > Accounting Vouchers > F8: Sales

  1. In Voucher Type sub form select Excise – Sales as the voucher type

  2. Ensure that the Sales Voucher is in Item Invoice Mode

  3. Enter the Date as 13-4-2008

  4. Enter the Ref details as ABC/726

  5. In Excise Unit field Tally.ERP 9 displays ABC Company, as selected during voucher type creation

  6. Excise Book Name field displays the name of the excise invoice book (ABC/Rule11/Book1/08-09) created for the Excise Unit

  7. Serial No. field displays the Rule 11 invoice Number e.g. ABC/1002/08-09

  8. In Party A/c Name field select Universal Distributors from the List of Ledger Accounts

  9. In Party Details sub form

  10. Despatch/Order Details: Under these two sections enter the Despatch and Order Details

  11. Sl.No. in PLA /RG-23: In this field enter the Sl.No. in PLA /RG-23 register as 2

  12. Date & Time of Invoice: In this field enter the time Date of Invoice. Tally.ERP 9 by default displays the system time and date in this field which can be changed

  13. Date & Time of Removal: In this field enter the Time & Date of Removal of Goods. Tally.ERP 9 by default displays the system time and date in this field which can be changed

Note: As per Central Excise Invoice System, in all the sales invoice time and date of removal has to be printed.

  • Buyer Details: In this section Tally.ERP 9 by default displays the details provided during buyer ledger creation, which can be changed.

 

  1. In Nature of Removal field select the option Domestic from the list of Types of Removals.

  2. In Sales Ledger field select the ledger Sales @ 12.5% from the List of Ledger Accounts.

  3. VAT/Tax Class field automatically gets updated with the VAT/Tax class as selected in the sales ledger, which can be changed.

  4. In Name of Item field select the Stock Item i.e. AquaPure - 1Ltr.

  5. In Quantity field enter the quantity as 20000.

  6. In Rate field enter the rate as Rs. 20.

  7. Amount will be displayed automatically.

  8. In Name of Item field select the Stock Item i.e. AquaMini – 200 ml as the second Item.

  9. Enter 4000 as Quantity and Rs. 5 as Rate.

  10. In Name of Item field select the Stock Item i.e. AquaKing – 20 Ltr as the third Item.

  11. Enter 3000 as Quantity and Rs. 60 as Rate.

  12. Select Duty Ledger i.e. Basic Excise Duty @ 16%. Amount will be calculated and displayed automatically.

  13. Select Education Cess @ 2% and Secondary Education Cess @ 1% ledgers. Amount will be calculated and displayed automatically.

  14. Select Output VAT @ 12.5%. Amount will be calculated and displayed automatically.

  15. Set the option Show Statutory Details to Yes to view Statutory Details screen.

 

  1. In Statutory Details screen press Alt + F1: Detailed to view details of duty calculation. The Statutory Details screen is displayed as shown.

 

 

Note: In statutory details user can view Item/ ledger wise assessable value and Duty/Tax calculations.

 

For the stock item AquaPure - 1Lt, valuation Type selected is MRP Based, MRP is Rs.20/L and the Abatement allowed is 48%.  

  • Assessable Value: Sales Quantity * Rate = Total Amount – Abatement (Total Amount*48/100)

  • Rs. 2,08,000: 20,000*20 = 4,00,000 – 1,92,000 (4,00,000*48/100)

On the Assessable Value (2,08,000) BED is calculated @ 16%. Education Cess @ 2% and SHE Cess @ 1% is calculated on BED  

 

For the Stock Item AquaMini – 200ml, Valuation Type selected is Ad Quantum (duty is calculated on quantity)

  • BED is defined @ 2/L (on the Reporting UOM - Liter), Education Cess @ 0.04/L (2% of Rs. 2) and Secondary Education Cess @ 0.02/L (1% of Rs.2)

  • BED for AquaMini – 200ml is calculated on (4000*0.200ml) 800 liters (800*2 = 1600)

  • Education Cess for AquaMini – 200ml is calculated on 800 liters (800*0.04 = 32)

  • Secondary Education Cess is calculated for AquaMini – 200ml is calculated on 800 liters (800*0.02 = 16)

For the Stock Item AquaKing – 20 Ltr, Valuation Type selected is Ad Valorem

  • BED @ 16% is calculated on the Transaction Amount/Assessable Value of Rs. 1,80,000 (180000*16/100 = 28,800)

  • Education Cess @ 2% and Secondary Education Cess @ 1% is calculated on BED

  1. In Bill-wise Details screen select Type of Ref as New Ref, Name as ABC/726 and in other fields retain the default details.

  2. Enter the Narration, if required.

 

  1. Press Enter to accept and save.

 

Printed Excise Invoice

 

 

 

Mail this article