www.TallyERP9Help.Com

Rule 11 Invoice for Stock Items Falling Under Different Valuation Type [Excise for Manufacturer] in Tally.ERP 9

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.

 
[Img-173]

  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.

 
[Img-174]

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

 
[Img-175]

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.

 
[Img-176]

  1. Press Enter to accept and save.

 

Printed Excise Invoice

 
[Img-177]

 
 
 
 
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