Creating A Customer Ledger

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 7

Creating a Customer Ledger

To create the Sundry Debtor (Customer) Ledger, Go to Gateway of Tally > Accounts Info > Ledgers > Create 1. 2. 3. 4. 5. Enter the Name of the Customer in the Name field. E.g. Universal Distributors. Select the group Sundry Debtor in the under field. Set Maintain Balances Bill by Bill to Yes and enter the Default Credit Period if any. Set Inventory Values are affected to No. In Mailing Details and Tax Information sections enter the supplier contact details, Income Tax and the Sales Tax numbers. 6. Enable Set/Alter Excise Details to Yes to display the Excise Details sub screen.

7. In the Excise Details screen: 8. Enter the Excise Registration (ECC) No. of the customer e.g. AACCL0014CXD001. 9. Enter the Date of Excise Registration in Date of Registration field e.g. 20-Jul-2004.

10. Enter the Range under which the suppliers company is registered. E.g. Yeshwanthpur II. 11. Enter the Division under which the suppliers company is registered. E.g. Yeshwanthpur. 12. Enter the Commissionerate under which the premise of the Suppliers company is registered. E.g. Bangalore III. 13. In Default Nature of Purchase field select the option Not Applicable. 14. Select the Nature of Removal as Domestic from Types of Removal list.

Note: It is must to define the nature of removal for a customer. The Nature of Removal depends upon the removal, whether it is for Domestic/Exports/Exempt sales. The Type of Removal set for the ledger can be altered/changed during transaction. 8. Press Enter to Accept and save Note: The Excise Details sub-screen appears for ledgers created under Sundry Creditors and Sundry Debtors only.

Creating a Supplier Ledger

To Create the Sundry Creditor (Supplier) Ledger Go to Gateway of Tally > Accounts Info. > Ledgers > Create 1. 2. 3. 4. Enter the Name of the Supplier in the Name field. E.g. Swastik Water Suppliers. Select Sundry Creditors as the group name in the Under field. Set Maintain Balances Bill by Bill to Yes and enter the Default Credit Period if any. Set Inventory Values are affected to No.

5. In the Mailing Details and Tax Information section enter the supplier contact details, Income Tax and the Sales Tax numbers. 6. Enable Set/Alter Excise Details to Yes to display the Excise Details screen.

7. In the Excise Details screen: 8. Enter the Excise Registration Number of the supplier. E.g. AESDE3210NXM001 9. Enter the Date of Excise Registration in Date of Registration field. E.g. 15-May-1999 10. Enter the Range under which the suppliers company is registered. E.g. National Park 11. Enter the Division under which the suppliers company is registered. E.g. Bangalore II 12. Enter the Commissionerate under which the premise of the Suppliers company is registered. E.g. Bangalore I 13. Select the Default Nature of Purchase as Manufacturer from Nature of Purchase

8. Press Enter to accept and save. Note: The Excise Details sub-screen appears for ledgers created under Sundry Creditors and Sundry Debtors only.

Creating a Sales Ledger

To create a Sales Ledger, Go to Gateway of Tally > Accounts Info. > Ledgers > Create 1. Enter the Name of the sales ledger you wish to create, for e.g., Sales @ 12.5%. 2. Select Sales Accounts as the group name in the Under field. 3. Set Inventory values are affected to Yes. 4. In Type of Ledger field select Not Applicable Note:The sales on which discounts are allowed can be accounted in the books of accounts in 2 ways

1. Account Sales and Discount Separately 2. Account the Net Sales after deducting discount

Some of the Sates in India are following the system of accounting Net sales after discounts. To meet this requirement and to show the Net Group Balance (Sales - Discount) the Type of Ledger option has been provided in ledgers grouped under Sales Accounts.

If a sales ledger to be used as a Discount Ledger, in Type of Ledger field select the option Discount. 5. Set the option Used in VAT Returns to Yes to display the default VAT/Tax Class sub screen.

6. Select the required VAT/Tax Class, for e.g., Sales @ 12.5%

7. Press Enter to Accept and save.

Note: It is recommended to create separate Sales ledgers with appropriate VAT classification for different rates of VAT. However, Tally.ERP 9 provides you the flexibility to use a common sales ledger for different rates, by selecting VAT classification as Not Applicable and allows selection of required classification from the list of VAT/Tax Class while recording a transaction.

Creating a Purchase Ledger

To create a Purchase Ledger, Go to Gateway of Tally > Accounts Info. > Ledgers > Create 1. Enter the Name of the purchase ledger you wish to create, for e.g., Purchase of Raw Materials. 2. Select Purchase Accounts as the group name in the Under field. 3. Set Inventory values are affected to Yes. 4. In Type of Ledger field select Not Applicable Note:The purchase on which discounts are allowed can be accounted in the books of accounts in 2 ways

1. Account Purchase and Discount Separately 2. Account the Net Purchase after deducting discount

Some of the Sates in India are following the system of accounting Net Purchases after discounts. To meet this requirement and to show the Net Group Balance (Purchases - Discount) the Type of Ledger option has been provided in ledgers grouped under Purchases Accounts.

If a purchase ledger to be used as a Discount Ledger, in Type of Ledger field select the option Discount.

5. Set the option Used in VAT Returns to Yes to display the default VAT/Tax Class sub

screen.

You might also like