Excise Sales and Purchase Extract report displays the details of purchase and sales transactions of all excisable goods (Excise Invoice as well as Commercial Invoice).
Go to Gateway of Tally > Display > Statutory Report > Excise Reports > Dealer > Sales and Purchase Extract
In the Sales and Purchase Extract printing screen,
Press Backspace and in Excise Unit field select ABC Company from the List of Trader Excise Unit
Specify the From date and To date
Specify Place and Date
The preview of Sales and Purchase Extract appears as shown.
Press Pg Down
Name of the First Stage/Second Stage Dealer: The name of your company specified in the Company Creation screen is printed in this field.
Excise Registration Number: The Excise Registration Number of your company, specified in the F11: Features screen is printed.
Address: The address of your company specified in the Company Creation screen is printed in this field.
Particulars of Invoice issued by First Stage / Second Stage Dealer: This section lists all the Sales Invoices with the following details
Invoice Number with Date: The Date and the Invoice Number is printed in this field.
Description of the Goods: This column list the Stock Items sold
Central Excise Tariff Heading: The Tariff Number of the Stock Items is printed in this column.
Quantity: The total number of Stock items sold is printed in this column.
Amount of Duty: The total amount of Excise Duty passed on for the Stock Item is printed in this column.
Amount of Ed Cess: The total amount of Education Cess passed on for the Stock Items is printed in this column.
Amount of Sec Ed Cess: The total amount of Sec Education Cess passed on for the Stock Items is printed in this column.
Particulars of the Documents based on which the credit is passed on: This section displays details such as
Invoice / Bill of Entry Number with Date: The Purchase Invoice number and date is printed in this column.
Name and Address of the First Stage /Second Stage Dealer: This column displays the First Stage /Second Stage Dealer details specified in the Purchase Entries.
Name and Address of the Manufacturer / Importer: This column displays the Manufacturer / Importer details specified in the Purchase Entries.
Description of the Goods: The description of the goods is printed in this column.
Central Excise Tariff Heading: The Tariff number of the Stock Items are printed in this column
Quantity: The quantity of goods purchased is displayed in this column.
Amount of Duty: The total duty paid on the Stock Items is printed in this column.
Amount of Ed Cess: The total amount of Education Cess paid on for the Stock Items is printed in this column.
Amount of Sec Ed Cess: The total amount of Sec Education Cess passed on for the Stock Items is displayed in this column.