Add to Favourites

Creating Masters for Excise (Excise for Importer)

You can create the required accounting and inventory masters, to maintain transactions of excise for importer.

Excise Duty Ledger

You can create a duty ledger for excise for importers by grouping the ledger under Duties and Taxes.

To create a duty ledger

1. Gateway of Tally > Create > type or select Ledger > and press Enter.
   Alternatively, press Alt+G (Go To) > Create Master > Ledger > and press Enter.
2. Enter the Name of the duty ledger.
3. Select Duties and Taxes from the List of Groups in the field Under.
4. Select the Type of duty/tax. For local purchases, select CENVAT. For imports, select CVD.
5. Select the one of the following Duty Head from the List of Duty Heads. All duty masters created will be displayed in the List of Duty Heads.
   • The duty heads created.
   • Any if you want to use one duty ledger for multiple duty head types.
   • New to define your own duty head.
6. Enter the Percentage of Calculation if the duty ledger is created for a specific rate of duty. To use it as a common duty ledger, enter the percentage as zero or leave it blank.
7. Select the required Rounding Method.
8. Press Enter.
9. Press Enter to accept.

Recording Purchase and Sales Ledgers

Using TallyPrime, you can create purchase and sales ledgers, and use it to record the corresponding details for excise tax.

To create a purchase ledger

1. Gateway of Tally > Create > type or select Ledger > and press Enter.
   Alternatively, press Alt+G (Go To) > Create Master > Ledger > and press Enter.
2. Enter the Name of the purchase ledger.
3. Select Purchase Accounts as the group name.
4. Set the option Is Excise Applicable to Applicable.
5. Enable the option Set/alter excise details.
6. Select the Classification from the List of Excise Classifications.
7. Press Ctrl+A to save the purchase ledger.

You can also create a new classification by selecting Undefined as the Classification from the List of Excise Classifications. However, if you select an already created classification from the List of Excise Classifications, then you cannot enter any details in the fields below Classification. To know more about creating classifications, click here.

To create a sales ledger

1. Gateway of Tally > Create > type or select Ledger > and press Enter.
   Alternatively, press Alt+G (Go To) > Create Master > Ledger > and press Enter.
2. Enter the name of the sales ledger
3. Select Sales Accounts as the group name.
4. Set the appropriate VAT/Tax Class.
   
   The completed Ledger Creation screen appears as shown below:
   
5. Press Enter to accept.

Creating Supplier and Customer Ledgers

Supplier and customer ledgers for excise can be created in TallyPrime under Sundry Creditor and Sundry Debtor groups, respectively.

To create a supplier ledger

1. Gateway of Tally > Create > type or select Ledger > and press Enter.
   Alternatively, press Alt+G (Go To) > Create Master > Ledger > and press Enter.
2. Enter the Name of the supplier ledger.
3. Select Sundry Creditors from the List of Groups.
4. Set the options Maintain balances bill-by-bill, Default Credit Period, and Check for credit days during voucher entry as required.
5. Enter the Mailing Details.
6. Select the Country to which the supplier belongs. The application will infer the nature of removal based on the country selected.  
   If the country selected is India, the nature of removal is Domestic by default.
7. Select the State, if applicable. On selecting a country other than India, the cursor skips the fields State.
8. Enter the bank details if required.
9. Enter the PAN.
10. Enable the option Set/Alter Excise Details to enter the excise details.
    • Select the Default Nature of Purchase.
    • Select the Nature of Removal, as required.
    • Enter ECC No. The ECC number is PAN based, and has 15 digits. The format of ECC no. is ABCDE1234HXM001.
    • Enter the IEC code.
    • Enter the Range, Division, and Commisionerate.
    • Press Enter.
11.  Enable the option Set/Alter VAT Details, if required.
12. Press Enter and enter the opening balance, if any.
13. Press Enter. The completed supplier ledger appears as shown below:
    
14.  Press Enter to save.

To create a customer ledger

1. Gateway of Tally > Create > type or select Ledger > and press Enter.
   Alternatively, press Alt+G (Go To) > Create Master > Ledger > and press Enter.
2. Enter the Name of the customer ledger.
3. Select Sundry Debtors from the List of Groups.
4. Set the options Maintain balances bill-by-bill, Default Credit Period, and Check for credit days during voucher entry as required.
5. Enter the Mailing Details.
6. Select the Country to which the supplier belongs. The application will infer the nature of removal based on the country selected.  
   If the country selected is India, the nature of removal is Domestic by default.
7. Select the State, if applicable. On selecting a country other than India, the cursor skips the fields State.
8. Enter the PIN Code, if applicable. On selecting a country other than India, the cursor skips the fields Pin Code.
9.  Enter the bank details if required.
10. Enter the PAN.
11. Enable the option Set/Alter Excise Details to enter the excise details.
    • Select the Default Nature of Purchase.
    • Select the Nature of Removal, as required.
    • Enter ECC No. The ECC number is PAN based, and has 15 digits. The format of ECC no. is ABCDE1234HXM001.
    • Enter the IEC code.
    • Enter the Range, Division, and Commisionerate.
    • Press Enter.
12. Enable the option Set/Alter VAT Details, if required.
13. Press Enter and enter the opening balance, if any.
14. Press Enter. The completed customer ledger appears as shown below:
    
15. Press Enter to save.

Creating Stock Item for Custom Duty

In TallyPrime, you can create stock items with the applicable excise details.

1. Gateway of Tally > Create > type or select Stock Item> and press Enter.
   Alternatively, press Alt+G (Go To) > Create Master > Stock Item > and press Enter.
2. Enter the Name of the stock item.
3. Select the stock group in the field Under.
4. Select the required Units.
5. Select Applicable in the field Is Excise Applicable.
6. Enable the option Set/alter excise details.
   • Enter Tariff name.
   • Enter HSN code.
   • Select the Reporting unit of measure.
   • The cursor skips the field Valuation type. To modify it, press F12 (Configure).
   • Enter the Rate of duty.
     
   • Press Enter to save.
7. Enter the Conversion Factor.
   To convert the unit of measure defined in the Units field to the Reporting UOM predefined in the selected Excise Classification.
8. Select Applicable in the field VAT Applicable?, if required.
9. Enable the option Set/alter VAT details?, if required.
10. Enter the Opening Balance, if required. The completed stock item creation screen appears as shown below:
11. Press Enter to accept.

Creating Excise Godown

You can create an excise godown by primarily enabling the appropriate option through

1. Gateway of Tally > Create > type or select Godown> and press Enter.
   Alternatively, press Alt+G (Go To) > Create Master > Godown> and press Enter.
2. Enter the Name of the godown.
3. Select Primary as the group name from the List of Godowns.
4. Select the company name as the Excise Tax Unit from the List of Excise Tax Units.
5. To provide address details, press F12 (Configure) and Enable the option Use address for Godowns.
6. Press Enter to save.

These details will be displayed in Form RG23D generated for the importer unit.

Creating Excise Classifications

Excise classification is the excise tariff master in which details of tariff, duty, notifications, and so on can be provided.

1. Gateway of Tally > Create > type or select Excise Classification > and press Enter.
   Alternatively, press Alt+G (Go To) > Create Master > Excise Classification > and press Enter.
2. Enter the Name of the excise classification.
3. Enter the HSN code.
4. Select the Reporting unit of measure. The Valuation type appears by default.
5. Enter the Rate of the tariff.
   
6. Press Enter to save.

Creating Excise Voucher Types

You can create excise voucher types, such as excise stock journals, excise purchase and sales voucher types for both dealer and importer units.

Excise Stock Journal

Excise stock journal voucher class is required for the purpose of transferring stock from dealer unit to importer unit.

1. Gateway of Tally > Alter > type or select Voucher Type> and press Enter.
   Alternatively, press Alt+G (Go To) > Alter Master > Voucher Type> and press Enter.
2. Select Stock Journal from List of Voucher Types.
3. Select Any as the Default Tax Unit.
4. Enter the Name of the Class.
5. Press Enter to display the Voucher Type Class screen.
6. Enable the option Use for transfer to Import Unit.
7. Press Ctrl+A to save the voucher type.

Excise Purchase Voucher Type

For a business unit initially registered as Dealer and then registered as Importer, separate voucher types have to be created to account for purchase of stock items for dealer unit and importer unit. If a company has more than one Excise Unit, create separate voucher types for each.

Excise Purchase Voucher Type – Dealer Unit

1. Gateway of Tally > Create> type or select Voucher Type> and press Enter.
   Alternatively, press Alt+G (Go To) > Create Master > Voucher Type> and press Enter.
2. Enter the name of voucher type.
3. In the Type of Voucher option select Purchase.
4. Enable the option Use for Excise.
5. Select the dealer unit as the Default Excise Unit.
6. Press Enter to accept.

Excise Purchase Voucher Type – Importer Unit

1. Gateway of Tally > Create> type or select Voucher Type> and press Enter.
   Alternatively, press Alt+G (Go To) > Create Master > Voucher Type> and press Enter.
2. Enter the name of voucher type.
3. In the Type of Voucher option select Purchase.
4. Enable the option Use for Excise.
5. Select the importer unit as the Default Excise Unit.
   
6. Press Enter to accept.

Excise Sales Voucher Type

The stock items imported to:

1. Dealer unit has to be cleared from dealer unit until the stock is transferred to importer unit
2. Importer unit has to be cleared from importer unit

Hence, separate excise sales voucher types have to be created to account for sales made by clearing goods from dealer unit and importer unit.

To create an excise sales voucher type for sale of goods from importer unit

1. Gateway of Tally > Create> type or select Voucher Type> and press Enter.
   Alternatively, press Alt+G (Go To) > Create Master > Voucher Type> and press Enter.
2. Enter the name of voucher type.
3. In the Type of Voucher option select Sales.
4. Enable the option Use for Excise.
5. Select the importer unit as the Default Excise Unit.
   
6. Enable the option Print voucher after saving.
7. Disable the option Use as tax invoice.
   
8. Press Enter to accept.

Excise Debit Note

The purchase returns have to be made against the unit where goods were stored using debit note voucher type predefined with the respective excise unit.

To create an excise debit note voucher type to account for purchase returns against importer unit

1. Gateway of Tally > Create > type or select Voucher Type > and press Enter.
   Alternatively, press Alt+G (Go To) > Create Master > Voucher Type> and press Enter.
2. Enter the name of voucher type.
3. In the Type of Voucher option select Debit Note.
4. Enable the option Use for Excise.
5. Select the importer unit as the Default Excise Unit.
   
6. Press Enter to accept

The company logo can be printed on the Excise Debit Note.

Excise Credit Note

The sales returns have to be made against the unit from which goods were cleared using credit note voucher type predefined with the respective excise unit.

To create an excise credit note voucher type to account for sales returns against importer unit

1. Gateway of Tally > Create> type or select Voucher Type> and press Enter.
   Alternatively, press Alt+G (Go To) > Create Master > Voucher Type> and press Enter.
2. Enter the name of voucher type.
3. In the Type of Voucher option select Credit Note.
4. Enable the option Use for Excise.
5. Select the importer unit as the Default Excise Unit.
   
6. Press Enter to accept.

Excise Receipt Note

Excise receipt note can be used while accounting for partial customs clearance of imported goods.

1. Gateway of Tally > Create> type or select Voucher Type> and press Enter.
   Alternatively, press Alt+G (Go To) > Create Master > Voucher Type> and press Enter.
2. Enter the name of voucher type.
3. In the Type of Voucher option select Receipt Note.
4. Enable the option Use for Excise.
5. Select the importer unit as the Default Excise Unit.
   
6. Press Enter to accept.