www.TallyERP9Help.Com

Excise Registers [Excise for Importer] in Tally.ERP 9

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

  • Sales transactions recorded by raising,  Excise Invoice and Commercial Invoice, besides capturing details of the Supplier/ Manufacturer

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

  1. Go to Gateway of Tally>Display>Statutory Report>Excise Reports>Dealer/Importer>Excise Registers>Excise Stock Register

  2. Select the name of excise unit as ABC Company from the List of  Excise Units

  3. In the option Name of Tariff option, select the stock item identified with the tariff classification linked to it

  4. Select the name of the item from the list of excise items to view the report


[Img-59]

Note: On selecting the Name of Tariff, only those stock items grouped under the selected Tariff Classifications will be displayed.

Receipt

  • Invoice/Bill of Entry No. with Date: It displays the supplier invoice number and date entered in the excise purchase invoice

  • Name and Address of the Supplier: It displays the name and address of the supplier from whom stock items were purchased

  • Nature of Purchase: It displays the Nature of Purchase selected  in the invoice

  • Quantity: It displays the quantity of stock items purchased

  • Rate: It displays the rate at which the item was purchased

  • Assessable value: It displays the assessable value entered in the Assessable Value field of Excise Details screen of excise purchase invoice

  • Duty per Unit: It displays the Total Duty amount divided by quantity

  • Total Duty: It displays the total duty paid for the stock item

  • Cess per Unit: It displays the cess paid per item

  • Total Cess: It displays the total cess paid on the total quantity of stock item


[Img-60]

Issue

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

  • Select the Name of Excise Unit (Dealer Unit) as ABC Company from the List of  Excise Units

  • In Name of Tariff option, select the stock item identified with the tariff classification linked to it

  • Select the Name of Item from the List of Excise Items to view the report


[Img-61]

  • Duty Details

  • Duty Passed On/Duty not Passed on: This row displays the details of stock items on which duty is passed or not passed

  • Stock Transferred to Importer Unit: This row displays the no of units of stock item transferred to the Importer Unit.

  • Balance Duty: This row displays the balance amount of dutyto be passed on

  • Issued Quantity: It displays the total quantity of stock items sold/returned

  • Total Duty: It displays the total duty utilized in whole or proportionate to the quantity issued/returned

  • Total Cess: It displays the total cess amount utilized

Detailed Excise Stock Register

Press Alt +F1: Detailed to view the detailed report. The detailed Excise Stock Register appears as shown below:


[Img-62]

Vch Type/Invoice No./Date/: It displays the name of the voucher type, invoice number and date as specified in the excise Sales/Credit Note/Debit Note

Name and Address of the Party: It displays the 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, press Alt + P  or click the P: Print button.

The printed Excise Stock Register appears as shown below:


[Img-63]

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

To view the Excise Purchase Bill Register,

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

Select the name of the Excise Unit


[Img-64]

The excise purchase bill register appears as shown below:


[Img-65]

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 provided in F12: Configuration. The Excise Purchase Bill Register can be configured by selecting the required option.


[Img-66]

  • All Bills to view all the purchase bills (irrespective of pending stock/zero balance)

  • Cleared Bills to view only purchase bills against which there is no stock pending for sale

  • 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

  • Invoice/ Bill of Entry No with Date: It displays the supplier invoice number and date entered in the excise purchase invoice

  • Particulars: It displays the stock item purchased with HSN Code

  • Name and Address of the Supplier: displays the name and the address of the supplier from whom stock items were purchased

  • Nature of Purchase: It This column lists displays the Nature of Purchase selected in the invoice

  • Quantity: It displays the quantity of stock items purchased

  • Rate: It displays the rate at which the stock item was purchased

  • Assessable Value: It displays the assessable value entered in the Assessable Value field of Excise Details screen of excise purchase invoice

  • Total Duty: It displays the total duty paid for the stock item

  • Total Cess: It displays the total amount of cess calculated on the purchased quantity

Issue

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

Select the Name of Excise unit as ABC Company

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


[Img-67]

  • 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: This row displays the balance amount of duty  to be passed on

  • Stock Transferred to Importer Unit : This row displays the unit of stock item transferred to the Importer unit

  • Issued Quantity: It displays the total quantity of stock items sold/returned

  • Total Duty: It displays the total duty utilized in whole or proportionate to the quantity issued/returned

  • Total Cess: It displays the total cess amount utilized on the Stock items issued/returned

Note: Press Alt+F1 to view the Excise Purchase Bill Register in Detailed mode.

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


[Img-68]

 
 
 
 
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