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.
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.
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.