Creating a Excise Purchase Voucher - Not Availing CENVAT Credit [Excise for Manufacturer] in Tally.ERP 9

To create a Purchase Voucher

In F12: Configure (Purchase Invoice Configuration)

  • Ensure the option Use Common Ledger A/c for Item Allocation is set to Yes

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

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

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

Note: In Tally.ERP 9 Excise Purchase Transactions needs to recorded in Invoice Mode Only.

  1. Enter the Date as 1-4-2008.

  2. In Supplier Invoice No. field enter the Invoice No. as SI/336.

  3. In Party’s A/c Name field select the supplier i.e. Swastik Water Suppliers from the List of Ledger Accounts.

  4. In Nature of Purchase field Manufacturer is displayed automatically.

  5. In Purchase Ledger field select the ledger Purchase of Raw materials from List of Ledger Accounts.

  6. VAT/Tax Class field select Not Applicable

Note: Ensure Allow Selection of VAT/Tax Class during entry is enabled in F12: Configure (Purchase Invoice Configuration)

  1. In Name of Item field select the Stock Item i.e. Natural Water.

  2. In Quantity field enter the quantity as 10,00,000.

  3. In Rate field enter the rate as Rs. 2.

  4. Amount will be displayed automatically.

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

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

Note: Input VAT Ledger is not selected as Natural water is exempted under VAT Act in Karnataka

  1. 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. Statutory Details screen appears as shown.



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

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


  1. Enter the Narration, if required


  1. Press Enter to save and accept.

Note: To avail Cenvat Credit, create the Current Assets by selecting duty/tax type as CENVAT in the Type of Duty/Tax field.


When the CENVAT Credit is not availed the Duty Legers selected won’t display the ledger balance and duty amount will be apportioned to the Stock Item cost.

Go to Gateway of Tally > Display > Account Books > Ledgers > select Basic Excise Duty @ 16%


 To view the duty apportionment to Stock Item

Go to Gateway of Tally > Display > Inventory Books > Stock Item > Natural Water > Stock Item Monthly Summary > Stock Vouchers

In F12: Configure

  • Ensure the option Show Rates is set to Yes


Purchase rate of natural Water is Rs.2 per Liter. Observe, in the above screen stock item rate is displayed as 2.33 which includes the excise duty amount.





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
Tally.ERP 9 Reference Manual LIBRARY
Installation of Tally.ERP9
Site Licensing of Tally.ERP9
Shortcut Keys in Tally.ERP9
Maintaining Company Data
Creating Masters
5a. Accounts Information [Creating Masters]
5b. Inventory Information [Creating Masters]
Voucher Entry
Reports in Tally.ERP9
Excise for Dealer
Excise for Manufacturer
Reports [ Excise for Manufacturer]
Excise for Importer
Service Tax in Tally.ERP9
Tax Collected at Source (TCS) in Tally.ERP9
Tax Deducted at Source (TDS) in Tally.ERP9
Value Added Tax (VAT) in Tally.ERP9
Central Sales Tax (CST) in Tally.ERP9
28. GST using Tally.ERP9
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

Trademarks :
Tally,Tally GST,TallyERP9 GST, 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. This Website is not associated with any product or vendor mentioned in this Website