www.TallyERP9Help.Com

'Extract Reports' (Reports on Excise for Dealer) in Tally.ERP 9

Extract Reports available in Tally.ERP 9 are explained in detail:

Party Wise Duty Extract

Party Wise Duty Extract report displays party wise duty details of Purchases or Sales or Both (Purchases & Sales) till the Last Date of Entry in the Books of Accounts.

To view Party Wise Duty Extract report

Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Extract Reports > Party Wise Duty Extract

In the Select Ledger screen,

  • Name of Excise Unit: In this field select the Excise Unit. If you have more than one manufacturing unit select the appropriate Excise Unit from the List of Excise Units to view the party Wise Duty Extract of parties who carried out transaction with the Unit.

  • Name of Group: In this field select the Group to select the ledgers created under the Group selected.

  • Name of Ledger: In this field select the ledger from the List of ledgers e.g. Decora Equipment


[iMG-219]

Party Wise Duty Extract of Decora Equipments appears as shown


[iMG-220]

Detailed Party Wise Duty Extract

Use Alt +F1: Detailed to get a detailed Report. The detailed Party Wise Duty Extract appears as shown below.


[iMG-221]

Description of Fields and Columns in Party Wise Duty Extract report

  • Excise Unit Name: In this field the Excise Unit selected in the Select Excise Unit screen

  • Group: In this field the field selected will be displayed

  • Ledger: The party ledger selected in the Select Excise Unit screen will be displayed

  • Voucher No. with Date/ Supplier Invoice No. with Date: In this column by default the voucher Number and Date will be displayed. On viewing the report in detailed mode the supplier Number & Date will be displayed

  • Particulars: Sales ledger used in the invoice will be displayed

  • Voucher Type: This column displays the name of the voucher type used to record the excise transactions

  • Quantity: This column displays the Quantity of goods sold to customer or returned by the customer.

  • Assessable Value: This column displays the assessable value of the stock item sold on which the duty is passed on.

  • Excise Duty: This column displays the excise duty passed on

  • Education Cess: This column displays the Education cess passed on

  • Secondary Education Cess: This column displays the Secondary education cess passed on

  • Duty per Unit: This column displays the total duty per unit passed on the stock item

  • Total Duty: This column displays the Total duty (Excise Duty + Education Cess + Secondary Education Cess) passed on.

Configuring Party Wise Duty Extract report

Use F12 Key or click on F12: Configure button to configure the report


[Img-222]

  • Show Separate Special Excise Duty Column: Set this option to Yes to display the Special Excise Duty in separate column

  • Show CETSH No. Column: Set this option to Yes to display Central Excise Tariff Sub Heading Number of the stock item.

Note:HSN code (Tariff Number) will be displayed in Party Wise Duty Extract only when the option is enabled and the report is viewed in Detailed Mode.

  • Range of Transaction to Show: By default, report displays the Purchase or Sale transactions based on the Group of the Party Ledger selected in Select Ledger screen.

  • If Sundry Creditors is selected in Select Ledger screen, then by default Excise Purchase and Excise Debit Note vouchers recorded for the party (or all the parties) selected will be displayed.

  • If Sundry Debtors is selected in Select Ledger screen, then by default Excise Sales and Excise Credit Note Vouchers recorded for the party (or all the parties) selected will be displayed.

If the same party is used to record both the excise purchase or Sales then user can use the configuration option Range of Transactions to Show to view only Purchases or Sales or Both.

Excise Sales and Purchase Extract report

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


[Img-223]

The preview of Sales and Purchase Extract appears as shown.


[Img-224]

Press Pg Down


[Img-225]

  1. Name of the First Stage/Second Stage Dealer: The name of your company specified in the Company Creation screen is printed in this field.

  2. Excise Registration Number: The Excise Registration Number of your company, specified in the F11: Features screen is printed.

  3. Address: The address of your company specified in the Company Creation screen is printed in this field.

  4. Particulars of Invoice issued by First Stage / Second Stage Dealer: This section lists all the Sales Invoices with the following details

  5. Invoice Number with Date: The Date and the Invoice Number is printed in this field.

  6. Description of the Goods: This column list the Stock Items sold

  7. Central Excise Tariff Heading: The Tariff Number of the Stock Items is printed in this column.

  8. Quantity: The total number of Stock items sold is printed in this column.

  9. Amount of Duty: The total amount of Excise Duty passed on for the Stock Item is printed in this column.

  10. Amount of Ed Cess: The total amount of Education Cess passed on for the Stock Items is printed in this column.

  11. Amount of Sec Ed Cess: The total amount of Sec Education Cess passed on for the Stock Items is printed in this column.

  1. Particulars of the Documents based on which the credit is passed on: This section displays details such as

  2. Invoice / Bill of Entry Number with Date: The Purchase Invoice number and date is printed in this column.

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

  4. Name and Address of the Manufacturer / Importer: This column displays the Manufacturer / Importer details specified in the Purchase Entries.

  5. Description of the Goods: The description of the goods is printed in this column.

  6. Central Excise Tariff Heading: The Tariff  number of the Stock Items are printed in this column

  7. Quantity: The quantity of goods purchased is displayed in this column.

  8. Amount of Duty: The total duty paid on the Stock Items is printed in this column.

  9. Amount of Ed Cess: The total amount of Education Cess paid on for the Stock Items is printed in this column.

  10. Amount of Sec Ed Cess: The total amount of Sec Education Cess passed on for the Stock Items is displayed in this column.

 
 
 
 
Tally.ERP 9 Reference Manual LIBRARY
1.
Installation of Tally.ERP9
2.
Site Licensing of Tally.ERP9
3.
Shortcut Keys in Tally.ERP9
4.
Maintaining Company Data
5.
Creating Masters
5a. Accounts Information [Creating Masters]
5b. Inventory Information [Creating Masters]
6.
Voucher Entry
7.
Reports in Tally.ERP9
8.
Excise for Dealer
9.
Excise for Manufacturer
10.
Reports [ Excise for Manufacturer]
11.
Excise for Importer
12.
Service Tax in Tally.ERP9
13.
Tax Collected at Source (TCS) in Tally.ERP9
14.
Tax Deducted at Source (TDS) in Tally.ERP9
15.
Value Added Tax (VAT) in Tally.ERP9
16.
Central Sales Tax (CST) in Tally.ERP9
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
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