www.TallyERP9Help.Com

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

All Excise Registers available are explained in detail:

Excise Stock Register

Every Registered Dealer has to maintain Stock Register recording the daily receipt and issue of Excisable goods ready for inspection by the officers of the department.

Excise Stock Register is a commodity wise (Stock Item wise) report displaying the details of purchases (Receipts) and sales (Issues) of excisable goods in a given period. It also shows information on the sales transactions, which were sold under Excise Invoice and Commercial Invoice besides capturing details of the Supplier/ Manufacturer.

It clearly comments on the duty (CENVAT) amount passed, duty amount not passed and the balance of duty including Cess amount available during the specified period.

To view Excise Stock Register

Go to Gateway of Tally > Display > Statutory Report > Excise Reports > Dealer > Excise Registers > Excise Stock Register

  • Select the Name of Excise Unit as ABC Company from the List of  Excise Unit

  • In Name of Tariff field select Coils to select the stock item identified with the selected tariff classification

  • Select the Name of Item from the List of Excise Items to view the report. E.g., Hot Rolled Coils


[Img-198]

Note: On selecting Tariff Classification, Tally.ERP 9 displays only those stock items which are grouped under the Tariff Classifications which is selected.


[Img-199]

The above screen lists the Purchase details.

Receipt

  • Invoice No. /Date: The number given to the Invoice.

  • Invoice/Bill of Entry No. with Date: This column displays purchase invoice number (in case of domestic purchases) or Bill of Entry No. (in case of imports) along with date.

  • Name and Address of the Supplier: The field displays the Name and the Address of the Supplier.

  • Nature of Purchase: Lists the Nature of Purchase as specified during the Invoice Entry.

  • Quantity: Lists Quantity purchased.

  • Rate: The Rate at which the item is purchased.

  • Assessable value: The Total Assessable Value of the product.

  • Duty per Unit: The Total Duty amount divided by quantity is printed in this field.

  • Total Duty: The Total Duty for the Stock Item is displayed in this field. This field captures the total Duties paid.

  • Cess per Unit: Excise Cess per item is displayed.

  • Total Cess: Total Cess on the total Quantity of the Stock Item.

Issue

The Issue/Debit Note/Credit Note details in the Excise Stock Register are specified in the screen below.


[Img-200]

  • Duty Details

  • Duty Passed On/Duty not Passed on: This row displays the details of the Stock Items on which the duty is passed or not passed.

  • Balance Duty: The Balance available Duty Amount to be passed on is displayed in this field.

  • Issued Quantity: The Total Quantity of Items Sold/Returned is displayed in this field.

  • Total Duty: This Field displays the Total Duty utilized in whole or proportionate to the Quantity Issued/Returned.

  • Total Cess: The Total Cess Amount utilized is displayed in this field.

Detailed Excise Stock Register

Use Alt +F1: Detailed to get a detailed Report. The detailed Excise Stock Register appears as shown below.


[Img-201]

Vch Type/Invoice No./Date/: The Document type, Invoice number and date as specified in the Sales/Credit Note/Debit Note Invoice is displayed in this Column.

Name and Address of the Party: This column displays Name and Address of the Party and Duty Details such as the Duty Passed On, Duty not Passed On and the Balance Duty.

Printing Excise Stock Register

To print the Excise Stock Register

Use the Alt + P key or click on the Print option to print the Report. The printed Excise Stock Register appears as shown below.


[Img-202]

 

The preview of the Excise Stock Register in Detailed (Alt+F1) mode.


[Img-203]

Note: The Excise Stock Register can be printed in Neat Mode format only.

Excise Purchase Bill Register

Excise Purchase Bill Register is a Purchase bill-wise report displaying the details of purchases (Receipts) of excisable goods having stock pending for sale. It is Purchase invoice Date wise Report.

To view the Excise Purchase Bill Register

Go to Gateway of Tally > Display > Statutory Report > Excise Reports > Dealer > Excise Registers > Excise Purchase Bill Register

Select the Name of Excise unit as ABC Company


[Img-204]

The Excise Purchase Bill Register appears as shown


[Img-205]

To view all the Purchase Bills (with pending stock /zero balance) or only Purchase Bills with Zero Stock Balance or Pending Stock, the option Show Purchases of Excise stock for is now provided in F12: Configuration.

By selecting the appropriate option one can configure the Excise Purchase Bill Register.


[Img-206]

Select the Options -

  • All Bills: to view all the Purchase Bills (irrespective of Pending stock/zero balance)

  • Cleared Bills: to view only zero balance (no stock pending for sale) purchase bills.

  • Pending Bills: to view only purchase bills with stock pending for sale.

The Excise Purchase Bill Register consists of two sections Receipt and Issue.

Receipt

This section details the Purchase details.

  • Invoice/ Bill of Entry No with Date: This column displays Purchase Invoice number (incase of domestic Purchase) / Bill of Entry number (in case of Imports) and Date.

  • Particulars: This column displays the Stock Item purchased with Tariff Number.

  • Name and Address of the Supplier: This column displays the Name and the Address of the Supplier.

  • Nature of Purchase: This column lists the Nature of Purchase as specified during the Invoice Entry.

  • Quantity: This column displays the Quantity purchased.

  • Rate: This Column displays the Rate at which the item is purchased.

  • Assessable Value: The Total Assessable Value of the item appears in this column.

  • Total Duty: The Total Duty for the Stock item is displayed in this column.

  • Total Cess: The Total Cess Amount calculated on the purchased quantity is displayed in this column.

Issue

This section displays the Sales/Credit Note/Debit Note details.


[Img-207]

Duty Details: This Column displays the details of Duty Passed On, Duty Not Passed On and Balance Duty on the Quantity sold.

Issued Quantity: The Total Quantity of Items Sold/Returned is displayed in this column.

Total Duty: This column displays the Total Duty Utilized in whole or proportionate to the quantity Issued/Returned.

Total Cess: The Total Cess Amount utilized on the Stock items Issued/Returned

Note: Use ALT+F1 to view the Excise Purchase Bill Register in Detailed mode.

Printing Excise Purchase Bill Register

The preview of the Excise Purchase Bill Register appears as shown when the register is configured to view All Bills


[Img-208]

Excise Stock CENVAT Register

Excise Stock CENVAT Register displays the CENVAT details of Goods Purchased. Using this report Excise Dealer can ascertain the pending quantity and CENVAT duty per unit which he can pass on to the subsequent buyers.

To view Excise Stock CENVAT Register,

Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Excise Registers > Excise Stock CENVAT Register


[Img-209]

Excise Stock CENVAT Register can be viewed for All Items or One Item.

Excise Stock CENVAT Register - All Items

To view Excise Stock CENVAT Register for All Items

Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Excise Stock CENVAT Register > All Items

In Select Excise Unit screen

  • In Name of Excise Unit field select the Excise unit from the List of Excise Units

The Excise Stock CENVAT Register appears as shown:


[Img-210]


[Img-211]

Excise Stock CENVAT Register  - One Item

To view Excise Stock CENVAT Register for All Items

Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Excise Stock CENVAT Register > One Item

In Select Excise Unit screen

  • In Name of Tariff field select the Tariff Classification from the List of Tariff Classifications.

  • In Name of Item field select the stock item.

The Excise Stock CENVAT Register appears as shown:


[Img-212]

F12: Configure

To configure Excise Stock CENVAT Register - All Items\ One Item report press F12 key or click on F12: Configure button

The Configuration screen appears as shown:


[Img-213]

  • Show Purchases of Excise Stock for: Select the required type of Purchase bills - All Bills, Cleared bills & Pending Bills. According to the option selected, the Excise Stock CENVAT Register will capture the Excise Purchase Bills with the respective details.

  • Show Supplier Name and Address: Set this option to Yes to view Name & Address of the Supplier. By default this option is set to No.

  • Show Nature of Purchase: Set this option to Yes to view the Nature of Purchase, like Manufacturer, First Stage Dealer etc.

  • Show Rate and Assessable Value: Set this option to Yes to view Rate & Assessable Value of the Excise Stock.

  • Show Excise Duty Amount: Set this option to Yes to view the Total excise duty paid on the excise stock. By default the report will display ‘Duty per Unit'.

Customs Clearance Register

Customs Clearance Register is a import bill-wise report displaying the details of imports of Excisable goods having stock pending for Clearance. It is Purchase invoice Date-wise Report.

This report captures the information of goods Imported, Cleared from customs warehouse and stock Pending for clearance.

To view Customs Clearance Register

Go to Gateway of Tally > Display > Statutory Reports > Excise Reports > Dealer > Excise Registers > Customs Clearance Register

You can view Customs Clearance Register for All Items or One Item, as required.


[Img-214]

 

All Items - Customs Clearance Register

To view Customs Clearance Register for all items select All Items and press enter to view Select Excise Unit screen

In Select Excise Unit screen

  • Select ABC Company in Name of Excise Unit field


[Img-215]

The Customs Clearance Register appears as shown


[Img-216]

One Item - Customs Clearance Register

To view Customs Clearance Register for one items select One Items and press enter to view Select Excise Unit screen

In Select Excise Unit screen

  • Select ABC Company in Name of Excise Unit field

  • In Name of Tariff field select the tariff classification of the stock item for which the report to be viewed. Select Coils

  • In Name of Item field select Cold Rolled Coils


[Img-217]

The Customs Clearance Register appears as shown


[Img-218]

 
 
 
 
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