Creating an Excise Purchase Invoice (Excise for Dealer) in Tally.ERP 9

The Excise Voucher Types created should be used to record all the Excise transactions (purchases and sales).  

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

Note: Set Use Common Ledger A/c for Item Allocation to Yes in F12: Configure (Purchase Invoice Configuration)

  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 457 and Date as  1-4-2008

  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 will appear as shown


  1. Supplier’s Details will include the supplier and Manufacturer/Importer Details like, contact details, Sales Tax number and the Excise registration details. The details will appear automatically if they are provided during the Supplier Ledger Creation.

If the supplier of the goods is not the manufacturer, specify the details of the manufacturer of the goods in the Manufacturer / Importer details section

  1. Select the Nature of Purchase from the list of Nature of Purchase. This field defines the Supplier’s role in selling the product.

  2. Agent of Manufacturer (Consignment Agent) is selected when the supplier is an consignment agent of the manufacturer and the goods are directly sold from the manufacturer to the buyer. The buyer is a First Stage Dealer. In this case the excise invoice may be issued by the manufacturer or the agent.

  3. First Stage Dealer is selected when the goods are directly purchased from the First Stage Dealer. In this case the excise invoice is issued by the First Stage Dealer.

  4. From Agent of Manufacturer is selected when the supplier is an commission agent of the manufacturer. In this case agent of Manufacturer issues only commercial invoice and Rule 11 invoice is issued by the manufacturer.

  5. Importer is selected when the goods are directly self imported.  In this case the invoice is issued by the exporter.

  6. Manufacturer is selected when the goods are directly purchased from the manufacturer. In this case the excise invoice is issued by the manufacturer.

  7. Manufacturer Depot is selected when the goods are purchased from Manufacturer depot. In this case invoice is issued by the Manufacturer Depot.

  8. Purchase from Importer is selected when the goods are purchased from the importer. In this case the invoice is issued by the importer.

  9. Second Stage Dealer is selected when the goods are purchased from the Second Stage Dealer. In this case the invoice is issued by the Second Stage Dealer.


Note: By default the Nature of Purchase selected in the Party Ledger appears in the Nature of Purchase field which can be changed.

  1. Select the Purchase Ledger from the list of ledger accounts. E.g. Purchases @ 4%

  2. Select the VAT/Tax Class  from the list of VAT/Tax Class. E.g. Purchases @ 4%

Note: By default the VAT/Tax Class selected in the Purchase Ledger appears in the above field which can be changed.

  1. Select the Stock Item from the List of Excise Stock Items

Note: The List of Excise Stock Items displays only those stock items for which the Excise feature is enabled.

  1. Enter Quantity as 100

  2. Specify the Rate as Rs. 2329.60 (Total cost of the item)

  3. Amount of  Rs. 2,32,960 will be displayed automatically


  1. In the Excise Details screen,

  2. RG 23D Entry No.: This number represents the display of this particular transaction in the relevant page of RG 23 D Register.  Enter the RG 23 D entry number manually in the very first excise purchase voucher. The RG 23 D Entry no in the subsequent excise purchase vouchers are automatically incremented by 1 every time an item is selected in excise purchase invoice.


1. If an excise Purchase invoice is deleted/ cancelled/ marked as Optional, the RG 23 D Entry no used in it, will not be used in subsequent.

2. If an existing excise purchase transaction is duplicated, the RG 23 D Entry no will remain the same in both, the original and duplicate invoice and will not be incremental.

3. If an excise purchase invoice is inserted between two other excise purchase invoices, then the RG 23 D Entry no allotted for the stock items in the inserted invoice will be the latest in the sequence.


  1. Supplier Invoice No: by default displays the Invoice No. details provided in the supplier Invoice No. in the voucher entry screen. However, it is an editable field.

Note: The Supplier Invoice No. is mandatory and can be alphanumeric. If the Supplier Invoice No. is not entered in the Voucher creation screen, then the Supplier Invoice No. field by Default will appear as Not Applicable and the cursor remains in that field until a valid number is entered.

Note: The Supplier Invoice Date is mandatory. The date has to be same or lesser than the Voucher date. Ensure that the Supplier Invoice Date is same as theExcise Purchase Invoice date.

  • PLA/RG 23 Entry No.: In this field specify manufacturers PLA nubler. This Number represents the display of this particular transaction in the relevant page of PLA register of Manufacturer.

  • Enter the Assessable Value (it is the amount on which the Excise Duty is calculated by the manufacturer) on which the Excise Duty is calculated.

Note: The Basic Excise Duty and Cess amount is automatically calculated on the Assessable Value (computed based on the Quantity and Rate entered in the Voucher Creation screen). However, where separate Excise Duty & Cess ledgers are not created to record duty amounts, the additional cost in respect of Excise duty & cess amount is directly included in the purchase cost by apportioning it by Quantity or by Value (by altering the Purchase Value in the Rate Column). In such cases, the Assessable Value is required to be specified as Purchase Cost before Excise Duty and Cess Amount.

  • The Type of Duty and the Rate of Duty details are displayed automatically, as specified during Item Masters Creation.


  1. Select the applicable Input VAT ledger and press Enter, VAT Rate and amount is defaulted automatically

  2. Set Show Statutory Details to Yes to view Statutory Details screen

             Press Alt +F1: Detailed to view the statutory details


  1. In Bill-wise details screen select Type of Ref as New ref and retain all the other default details.

  2. Enter Narration, if required.


  1. Press Enter to accept and save.

Similarly, record purchase entry dated 2-4-2008 for the purchase of 50Kg of Hot rolled Coil @ of Rs.2000.

Similarly, you can create Purchase vouchers for other Nature of Purchase such as Purchase from Importer, First Stage Dealer etc.

Note: 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. This method is generally recommended for manufacturers intending to maintain CENVAT balance separately and claiming CENVAT Credit. Whereas, in case of Inclusive method, the Gross Amount before sales tax is back calculated as the Assessable Value is determined accordingly.


In the above Invoice, Inclusive method is adopted and 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 Cess are calculated in the Excise Details for sub screen based on the Stock Item pre-definition for the purpose of declaration in the Excise Invoice.

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