Supplier and customer ledgers for excise can be created in Tally.ERP 9 under Sundry Creditor and Sundry Debtor groups, respectively.
To create a supplier ledger
1. Go to Gateway of Tally > Accounts Info. > Ledgers > Create .
2. Enter the Name of the supplier ledger.
3. Select Sundry Creditors from the List of Groups .
4. Set Maintain balances bill-by-bill to Yes .
5. Enter the Default credit period , if any.
6. Set Check for credit days during voucher entry to Yes , if required.
7. Enter the Mailing Details .
8. Select the Country to which the supplier belongs. The application will infer the nature of removal based on the country selected.
o If the country selected is India , the nature of removal is Domestic by default.
9. Select the State , if applicable.
o On selecting a country other than India, the cursor skips the fields State .
Note: Ladakh is listed in the State field in Release 6.5.5 and later versions.
10. Enter the bank details if required.
11. Enter the PAN.
12. Enable the option Set/Alter Excise Details to enter the excise details.
o Select the Default Nature of Purchase .
o Select the Nature of Removal , as required.
o Enter ECC No. ECC number is PAN based, and has 15 digits. The format of ECC no. is ABCDE1234HXM001 .
o Enter the IEC code .
o Enter the Range, Division, and Commisionerate .
o Press Enter .
13. Enable the option Set/Alter VAT Details , if required.
14. Press Enter and enter the opening balance, if any.
15. Press Enter .
The completed supplier ledger appears as shown below:
16. Press Enter to save.
To create a customer ledger
1. Go to Gateway of Tally > Accounts Info. > Ledgers > Create.
2. Enter the Name of the customer ledger.
3. Select Sundry Debtors from the List of Groups .
4. Set Maintain balances bill-by-bill to Yes .
5. Enter the Default Credit Period , if any.
6. Set Check for credit days during voucher entry to Yes , if required.
7. Enter the Mailing Details .
8. Select the Country to which the supplier belongs. The application will infer the nature of removal based on the country selected.
o If the country selected is India , the nature of removal is Domestic by default.
9. Select the State , if applicable.
o On selecting a country other than India, the cursor skips the fields State .
Note: Ladakh is listed in the State field in Release 6.5.5 and later versions.
10. Enter the PIN Code , if applicable.
o On selecting a country other than India, the cursor skips the fields Pin Code .
11. Enter the bank details if required.
12. Enter the PAN.
13. Enable the option Set/Alter Excise Details to enter the excise details.
o Select the Default Nature of Purchase .
o Select the Nature of Removal , as required.
o Enter ECC No. ECC number is PAN based, and has 15 digits. The format of ECC no. is ABCDE1234HXM001 .
o Enter the IEC code .
o Enter the Range, Division, and Commisionerate .
o Press Enter .
14. Enable the option Set/Alter VAT Details , if required.
15. Press Enter and enter the opening balance, if any.
16. Press Enter .
The completed customer ledger appears as shown below:
17. Press Enter to save.