Select Your Language :

Sale to Merchant Exporters [Excise for Manufacturer] in Tally.ERP 9

To account sale of goods to "Merchant Exporters", either of the following Natures of Removal can be used:

  • Export

  • Export/LUT

Example: On 3-4-2013, ABC Company received an order for 100 nos. of Jute Bags from Karthik Exports a merchant exporter. On 7-4-2013, ABC Company sold 80 nos of Jute Bags at Rs. 260 per nos, to Karthik Exports. A sales order and a sales invoice have to be recorded.


Step 1: Create the Party Ledger

Click here to learn how to create the ledger for Karthik Exports. For this party ledger, the Nature of Removal is set to Export.

Note: A Merchant Exporter need not get himself registered under ‘Central Excise’. And at the same time, he can procure the excisable goods from various manufacturers and ultimately export the goods. To avoid Excise Duty being charged by the manufacturer, the merchant exporter will normally execute a Bond with the concerned authority and obtain CT-1 certificate. Then he will place an order (purchase order) along with CT-1 certificate to the manufacturer. On receipt of the CT-1 Certificate, the manufacturer will clear the goods without charging Excise Duty.

Step 2: Record Sales Order

Go to Gateway of Tally > Order Vouchers  > F5: Excise Sales Order

  1. Enter the Date as 3-4-2013

  2. The Excise Unit field will be pre-filled with the Excise Unit selected while creating the Excise Sales Order voucher

  3. In Party A/c Name field select Karthik Exports from the List of Ledger Accounts

  4. In the Party Details screen,

  5. select  Nature of Removal as Export, and select CT-1 in the Certificate Type

Note: CT-1 will be issued by the merchant exporter to the manufacturer.

  • Enter CT-1 number and Date


  • Enter Buyer's Details and Despatch Details as required

  1. In the Voucher entry screen, enter the Order No.

  1. Select the required Sales Ledger

  2. Select the item being sold, that is, Jute Bags

  3. In the Stock Item Allocations screen, enter details of quantity (100 nos.) and rate (Rs. 260). The amount will be calculated automatically.

  4. Enable the option Show Statutory Details, if you want to view the duty details

The complete sales order entry is displayed as shown:


  1. Press Enter to save

Step 3: Record Excise Sales Invoice

Go to Gateway of Tally > Accounting Vouchers  > F8: Sales

  1. In Voucher Type sub form select Excise – Sales as the voucher type

  2. Ensure that the Sales Voucher is in Item Invoice Mode.

  3. Enter the Date as 7-4-2013

  4. Enter reference number, if any, in the Ref field

  5. The Excise Unit field will be pre-filled with the Excise Unit selected while creating the Excise Sales voucher

  6. Excise Book Name field displays the name of the excise invoice book created for the Excise Unit

  7. Serial No. field displays the Rule 11 invoice number

  8. In Party A/c Name field select Karthik Exports from the List of Ledger Accounts

  9. Enter the required details In Party Details sub-screen

  10. Set Nature of Removal to Export


  • Select Certificate Type as CT-1. Fill in other field under VAT/Excise Details as is necessary

  • Under Despatch Details, select the Tracking Number for the relevant Delivery Note, if any. Fill in other details as is necessary


  • Under Order Details, Select the relevant Order Number. The Certificate Number, if entered while raising the Sales Order, will be captured here. Fill the other details as required

Note: Incase the user has not recorded an Excise Sales Order, then while recording an Excise Sales entry, after selecting the Nature of Removal as Export and CT-1 as the Certificate Type, the option New Number needs to be selected for Order No(s), and a provision will be available for specifying CT-1 number and date. These details are captured on Rule 11 Invoice.

  • Accept the screen

  1. The option Nature of Removal in the Voucher Creation screen will be set to Export

  2. In Notification Number field enter the notification under which the goods are exported. If the Notification number is specified while creating the party ledger application will capture the details from party ledger

  3. In Sales Ledger field select the sales ledger Sales - Export  from the List of Ledger Accounts

  4. The VAT/Tax Class will automatically be set to Exports, if the same is configured in the Sales Ledger

  5. In Name of Item field select the Stock Item i.e. Jute Bags

  6. In the Quantity field enter the number of units being exported. That is, 80 nos.

  7. In Rate field enter the rate as Rs. 260. Amount will be calculated automatically

  8. Select the relevant Output VAT ledger, if required

  9. Enable Set/Alter ARE Details. Enter the details as required in the Form ARE Details sub-screen:


  1. Enable the option Show Statutory Details to view the duty details

  2. Press Enter to accept the screen and return to Voucher Creation screen

The completed entry appears as shown:


Printing Rule 11 Invoice

To print Rule 11 Invoice,

In the Voucher Printing screen, set Print ARE-1 to No.

The print preview will appear as shown:


Note: The ARE-1 number and CT-1 number and date of issue of the CT-1 will be captured in Rule 11 invoice.

Printing Form A.R.E. 1

From the Voucher Alteration screen, press Alt+P

The Voucher Printing screen appears:


  1. Set Print ARE-1 to Yes

  2. Enable the other options if required

  3. Fill in the place and date of generating ARE-1.

Note: (i) If the goods are dispatched under ‘Self Sealing and Certification’, then the same needs to be certified accordingly. Hence the need to enable the optionShow Self-sealing and Certification. Otherwise this option is set to No

       (ii) Incase if the manufacturer would like to mark the ARE-1 with the details as ‘Export under EPCG / Advance License’ scheme then the option Is Clearance under Export Promotion Scheme has to be set to Yes

Form A.R.E. 1 will be printed as shown:

Page 1


Page 2


Pending sales orders can be tracked using their CT-1 numbers, in the CT-1 Outstandings report. This report displays details of quantity pending to be delivered, party wise and CT-1 certificate wise.

Tally.ERP 9 Reference Manual LIBRARY
Installation of Tally.ERP9
Site Licensing of Tally.ERP9
Shortcut Keys in Tally.ERP9
Maintaining Company Data
Creating Masters
5a. Accounts Information [Creating Masters]
5b. Inventory Information [Creating Masters]
Voucher Entry
Reports in Tally.ERP9
Excise for Dealer
Excise for Manufacturer
Reports [ Excise for Manufacturer]
Excise for Importer
Service Tax in Tally.ERP9
Tax Collected at Source (TCS) in Tally.ERP9
Tax Deducted at Source (TDS) in Tally.ERP9
Value Added Tax (VAT) in Tally.ERP9
Central Sales Tax (CST) in Tally.ERP9
GST using Tally.ERP9
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