How to create multiple ledger in tally erp 9
How to create multiple ledger in tally erp 9
If you are not familiar with ledgers and groups We have made some post for your reference.
- How to create edit & delete ledger
- Create Edit Delete Group
Disadvantages of using Multiple Group Ledger creation
There are some disadvantages over advantages of using this option in Tally ERP 9. It is true that you can create large number of ledgers at a single screen in minutes. But If you are an advance user ,And using advance features like Cost centers, Interest calculation.Multiple ledgers, Then you have to edit the ledgers again in single mode to activate such options.
Here is how Tally will set advance options for ledger created under multiple creation mode
- If you have activated cost centers, The cost center is set to Yes for revenue accounts ( Like Travelling expense, Discount received,Sales Account )& No For non revenue accounts.
- In the case field “Inventory Values affected ” Set to Yes for sales and purchase ledgers and for rest of ledgers set to No.
- In bank Ledger,The effective date of reconciliation will be the date of book beginning.
- Maintain balance Bill-by-bill set Yes automatically for ledgers created under sundry debtors & Sundry Creditors.
- Default Base currency will set for all ledgers if you have activated multi currency option
So an editing is required for make all advanced options as required.
How to create multiple ledger in tally erp9, under single group
Assume that your company has so many clients (sundry debtors) and we want to create ledgers for each debtor name from a single screen in tally. Below is an example of five clients whose group comes under Debtors North. Let’s create ledger for all five clients using a multiple ledger creation feature.
Sr. No Ledger Name Group Name Opening Balance
1 Vishal Trading Debtor North 2500 Dr
2 NAS traders Debtors North 3000 Dr
3 Victory Enterprises Debtors North 4000 Dr
4 Star Motors Debtors North 5000 Dr
5 Aqua Logistics Debtors North 6000 Dr
Go to Gateway of Tally>>Account info>>Ledgers>>CReate
Select create under Multiple Ledgers
You will have a screen like this
At top of the screen there is an option “Under Group”
Select the group name. Debtors north is the group in our example.
Press enter to move on to the next field called Name of the Ledger type the ledger name “Vishal Trading “ and press enter key.
The next filed “Under” Automatically filled with Debtors North.
Again Press Enter Key to type opening balance. in this example Rs 2500.00.
The next field is Dr/Cr, by default it is Debit (Dr) as sundry debtors possesses debit balance but this may change in very few cases when shows credit balance in debtors.
In the same manner mentioned above enter all debtors name and balance. The final screen will be as follows.
Now save the screen. Multiple ledger creation under a single group is completed.
Multiple ledger creation in tally, under different group.
Now we will learn how to create ledgers under multiple groups from a single screen. Consider the following ledgers which are in different group.
Sr. No Ledger Name Group Name Opening Balance
1 Vishal Trading Debtor North 2500 Dr
2 NAS traders Debtors South 3000 Dr
3 Victory Enterprises Debtors East 4000 Dr
4 Star Motors Debtors West 5000 Dr
5 Aqua Logistics Sundry Creditors 6000 Cr
Go to Gateway of Tally >>Account Info >>Ledgers >>CReate
Select create under Multiple Ledgers
You will have the same screen as previously received in multiple ledger creation under single group
Select “All Items "Under Group Field. This is the key point in this session.
Now type the ledger name in the Name of Ledger field
Then press enter, to move on to the field under .earlier while creating under a single group the field was inactive .Here the field is active and you can select the group name in which the ledger comes under. You can select group for each ledger account you are creating.
Enter all the ledgers and select their appropriate group, opening balance as in the below image
Now save the screen .Multiple ledger creation under single group and multiple groups is completed.
Post a Comment