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

In Tally.ERP 9, CENVAT Credit on purchases from Manufacturer can be availed -

  1. While recording the purchase transaction (in the same invoice)

  2. If the Invoice received has correct duty calculation

  3. If the Invoice received has duty calculation errors: It is possible that in the invoice received there may be some calculation errors (when invoice prepared manually) or Duty Round Off. As per excise rule, receiving party can not make changes in the suppliers invoice. Even if it is a mistake in the excise calculations, buyer is supposed to enter the invoice as it is  without making any correction. In this scenario you have to alter the duty amount while recording the transaction.

In Tally.ERP 9, from Release 3.0 you can alter the Duty amount while availing the CENVAT Credit on purchases from manufacturer. For More details on altering the duty value in Excise Purchase voucher with Nature of Purchase as Manufacturer Refer - Availing CENVAT Credit on Purchases from Manufacturer (Duty Value Alteration)

  1. Later by recording a separate Debit Note: In this case first purchase invoice will be recorded without availing credit and later a separate Debit Note will be recorded to avail the CENVAT credit

Here we are illustrating the scenario for the first use case without altering the duty value. For the second use case refer Partial CENVAT Credit on Purchases

Following is the procedure to avail CENVAT Credit on purchases.

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.

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

  4. In Supplier Invoice No. field enter the Invoice No. as LM/243.

  5. In Party’s A/c Name field select the supplier i.e. Lanco Manufacturers from the List of Ledger Accounts (Use Alt+C to create the party ledger).

  6. In Nature of Purchase field the option Manufacturer is displayed automatically

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

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

  9. In Name of Item field select the Stock Item i.e. Pet Bottles – 1 Ltr.

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

  11. In Rate field enter the rate as Rs. 1.

  12. Amount will be displayed automatically.

  13. Select Bottle Caps as second item and specify Quantity as 3,00,000  and Rate as Rs. 0.25.

  14. Select Water Container – 20 Ltr as third item and specify Quantity as 10,000 and Rate as Rs.5.

  15. Select Low Density Polyethylene as fourth item and specify Quantity as 25,000 and Rate as Rs.0.25.


  1. Select Duty Ledger i.e. Basic Excise Duty (CENVAT) (use Alt + C to create the ledger). Duty ledger creation appears as shown.


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

  1. Amount for Basic Excise Duty (CENVAT) will be displayed automatically.

  2. Select duty ledger Education Cess (CENVAT) (use Alt +C to create the ledger).

Refer Creating Education Cess Ledger for more information

  1. Select duty ledger Secondary Education Cess (CENVAT) (use Alt + C to create the ledger).

Refer Creating Secondary and Higher Education (SHE) Cess Ledger for more information

Note: select Type of Duty/Tax as CENVAT for all the Duty ledgers created to avail Cenvat Credit. These duty ledgers are used only during accounting purchases.

  1. Select Input VAT @ 4% as the Vat duty ledger. Amount will be displayed automatically.

  2. 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 is displayed as shown.



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

  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.

When the CENVAT Credit is availed the Duty Ledgers selected will display the ledger balance and duty amount will not be apportioned to the Stock Item Rate.

To check the duty ledger balance

Go to Gateway of Tally > Display > Account Books > Ledgers > select Basic Excise Duty (CENVAT).


 To view the non- apportionment of duty amount to stock item Rate:

Go to Gateway of Tally > Display > Inventory Books > Stock Item > Pet Bottles – 1 Ltr > Stock item Monthly Summary > Stock Vouchers

In F12: Configure

  • Ensure that the option Show Rates is set to Yes.


Observe, in Stock Vouchers report stock item rate is displayed as Rs.1 which is the actual purchase rate. In this case the duty amount is not apportioned to the Stock item.

CENVAT Credit availed in the purchase voucher will be displayed in the Credit Availed report.

To view Credit Availed report, Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Manufacturer > CENVAT Registers > Credit Availed





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