To create a Sales Invoice,
Go to Gateway of Tally > Accounting Vouchers > F8: Sales
Select Excise - Sales Voucher type from the list of Voucher Types.
Enter Ref. details as 981.
In Excise Unit field Tally.ERP 9 displays ABC Company, as selected during voucher type creation
Select the Party’s A/c Name from the List of ledgers e.g. Decora Equipments
The Buyer’s Details sub-form appears enter Despatch and Order details in corresponding fields and accept the screen to save.
Note: The Buyer's Details will appear automatically if specified during the ledger creation.
Select the Sales ledger from the list of ledger accounts.
Select the VAT/Tax Class from the list Vat/tax Class.
Note: By default the VAT/Tax Class selected in the Sales Ledger appears in the above field which can be changed.
Select the Stock Item from the list of excise stock items.
On selecting the item, the Supplier Details sub-screen for the item appears as shown below.
Select the appropriate purchase e.g. 457 from the List of Purchases table. This table lists all the purchases made for the Stock Item.
Note: The List of Purchases displays the list of purchases made for the selected item from different Suppliers (Manufacturer / First Stage Dealer / Second Stage Dealer). However, once the goods purchased from a Manufacturer is selected for Invoicing, only goods purchased from Manufacturer will be displayed and If goods purchased from a First Stage Dealer is selected, only purchases from First Stage Dealer will be displayed for selection.
Upon selecting a Purchase, the cursor skips to Quantity Utilised field. The value in this field can be altered.
If the Purchased quantity is 100 and the Utilised quantity is 25, it can be specified in the above field.
Note: If the utilized quantity is more than the purchased quantity the cursor remains in that field and Tally.ERP 9 warns you with a message.
On selecting the second entry, Tally.ERP 9 filters the List of Purchases to display the purchases made from the Supplier and the nature of purchase specified in the first entry.
Note: The Supplier Details sub-form can hold the details belonging to a Single Supplier and for one type of purchase only.
Upon accepting the Supplier Details, Quantity is automatically captured from the supplier details sub form, enter the Rate as Rs. 2800 to display the Amount.
Select the applicable Output VAT Ledger, and press Enter, VAT Rate and amount is defaulted automatically
Set Show Statutory Details to Yes to view Statutory Details screen. Press Alt+F1: Detailed to view the statutory details
In Bill-wise details screen select Type of Ref as New Ref and accept other details as defaulted.
Enter Narration, if required.
Press Enter to accept and save.
Printing Excise Sales Invoice
The Voucher Printing screen appears as shown since, Print after saving option is enabled in Excise - Sales Voucher Type, if not enabled press Alt+P from voucher alteration screen.
Press F12: Configure to view the Invoice Printing Configuration screen
In Invoice Printing Configuration screen, enable the configuration settings as shown below
Note: From Tally.ERP 9 you can also print multi page excise invoice when the invoice contains many items and stock item details cannot be captured in single page invoice. To print multi page Excise Invoice you have to enable the option Print Multi Page Excise Invoice to Yes in Invoice Printing Configuration screen
* Printing of Name and Designation of the Authorised Person in Rule 11 is mandatory for the proprietary concerns or a business owned by Hindu Undivided Family as per Central Excise Rules, 2002 in rule 11, after sub-rule (2).
Press Alt+I and accept Yes to view the print preview of Sales Excise Invoice. The preview of Excise Sales Invoice appears as shown below:
The Excise Sales Invoice includes the Sales details of the Stock item sold, like the Quantity, Rate and Amount.
The Excise Duty credit, passed on information will contain Assessable Value, Rate of Basic Excise Duty, BED Amount, Rate of Education Cess, Education Cess amount, Rate of Secondary Education Cess and Secondary Education Cess Amount is printed in this section.
Supplier and Manufacturer’s Excise Details are printed with Invoice No, Date of purchase and Excise Details of the stock item.
This invoice provides you with the Purchase and Sales details of the Excise Stock Items, along with the Excise Duty paid on the Products.
In the above screen, it is assumed that the Excise Stock Items are purchased from a Manufacturer. Hence, the Sales Excise Invoice is titled as First Stage Dealer, which indicates the stage of this Transaction.
The title of Excise Invoice printing will be as follows:
If the Stock Items are purchased from a Manufacturer/Importer, then the sales invoice for that item will print as First Stage Dealer.
If the Stock Items are purchased from a First Stage Dealer, then the sales invoice for that item will print as Second Stage Dealer.
If the Stock Items are purchased from a Second Stage Dealer, then the Sales Invoice for that item will print as Second Stage and Subsequent Dealer.
The Sales Excise Invoice prints the VAT/CST/Excise registration Number details, captured from Statutory & Taxation of F11: Features.
The details specified in the Excise Details sub form of the Statutory & Taxation of F11: Features is printed in the corresponding fields.
The Buyer details specified in the Party Details sub form is printed in this field. The details will also include the corresponding Excise and Tax registration details.
This section will print the Excise Stock Items sold. It displays the Quantity, Rate and the total Amount of the Stock Items sold.
Excise Duty credit passed on information will contain Description of goods, Assessable Value, Rate of Basic Excise Duty, Rate of Cess and Cess amount is printed in this section.
If the quantity of Stock Items sold is less than the purchased quantity, then the proportionate Assessable Value of item is captured along with the Rate of Duty of Item and Education Cess from the Purchase Invoice.
The Amount of Excise Duty and Amount of Cess is printed in words.
Note: Similarly, if there is more than one type of duty, then the breakup of the duties are printed.
This section prints the purchase details of the Stock Items.
The Supplier details like the Name and Address along with the Excise Registration details, of the Manufacturer/Importer, First Stage or the Second Stage Dealer is printed in this field.
It also prints the Purchase Invoice number and the Date of the Purchase invoice issued by the Supplier and the Manufacturer.
The Invoice will also print the Seller RG 23D number.
The Excise Duty Section displays the Description of Goods, Tariff Classification number of the Stock Item, Quantity of the Stock Item purchased, Assessable Value, Basic Excise Duty Amount, Education Cess Amount, Secondary Education Cess Amount, Total Duty Amount and Duty per Unit, which is captured from the corresponding Purchase Entry.
The VAT Declaration is printed if the VAT ledgers are allocated in the sales entry.
If the you are printing separate excise declaration other than VAT declaration such, excise declaration will be printed in Excise Declaration field
Printing Excise Invoice without Trader Supplier Information
In the Invoice Printing Configuration screen, set Print Trader Supplier Info to No.
The preview of Excise Sales Invoice appears as shown below:
Printing Excise Invoice as Commercial Invoice
Tally.ERP 9 allows you to generate Commercial Invoice directly from the Excise Invoice Voucher
In Invoice Printing Configuration
Type TAX INVOICE in Title of Document field
Set Print as Commercial Invoice to Yes
Set Print Trader Supplier Info to No
The preview of Excise Invoice as Commercial Invoice appears as shown below: