02-06-2023 TPN (Creating and Managing Ledger Accounts)
02-06-2023 TPN (Creating and Managing Ledger Accounts)
02-06-2023 TPN (Creating and Managing Ledger Accounts)
ACCOUNTS)
You can enter the opening balance as on The profit or loss from the previous year is
the books beginning day. carried forward as the opening balance of
the ledger. It is shown in the balance
sheet under liabilities.
This ledger can be altered and deleted. This ledger cannot be deleted but it can
be altered
● Create a Ledger
● Create a Ledger from Transactions or Reports
● Create a Ledger under Primary groups
● Create a Tax Ledger
Create a Ledger
Once the company is created, you can create ledgers to account for the expenses,
incomes, assets and liabilities of your business. In TallyPrime, you can create ledgers
one at a time or create ledgers in one go.
Step-1 Press Alt+G (Go To) > Create Master > type or select Ledger and press Enter.
Alternatively, Gateway of Tally > Create > type or select Ledger and press Enter.
Step-2 Name: Enter the name of the ledger account you want to create.
You cannot create two ledger accounts with the same name.
Step-3 Alias: Enter the alias of the ledger account, if required. You can access the
ledgers using the original name or the alias name.
Alias is the alternate name for the ledger accounts. You can create Alias at the time of
creation or also can modify the respective ledger later. While selecting the ledger, you
can choose the Alias name and the same ledger account gets selected.
Step-4 Under: Enter the group from the List of Groups under which the ledger is
created.
All the ledgers must be grouped correctly to record the transaction under the proper
heads. For example: If you are creating a ledger for Office Expenses, then you need to
create the ledger under the Indirect Expenses group.
Step-6 Note: To create a new group from this field, press Alt+C. You can alter a ledger
account to change its group classification at any time.
Fill in the other necessary details such as Mailing Details, Banking Details and Tax
Registration Details.
Step-7 Opening Balance: Enter the carry forward balance from the previous year as
the opening balance.
Opening Balance is applicable when the ledger is an asset or a liability, and also if it has
a closing balance in the account at the end of the period.
Single-ledger-creation
Step-8 As always, press Ctrl+A to save.
Below is the procedure for creating a ledger under the group created for expenses.
● In the Ledger Creation screen, in the field Under, select the group from the List of
Groups created already or create a group under Primary group.
Select Create from the List of Groups, to create a new Group.
● In the Group Creation (Secondary) screen, create the group under Primary and
select the Nature of Group as Expenses.
● Press Ctrl+A to save the Group Creation (Secondary) screen.
● Fill in the other necessary details and press Ctrl+A to save the ledger.
Similarly, you can create ledgers under groups created for Liabilities, Assets and
Income.
Creation of Tax Ledger
Tax Ledgers in TallyPrime should be created under the Duties & Taxes group which
contains all tax accounts like GST, VAT, CENVAT, Excise, Sales, and other trade taxes
and total liability.
1.In the Ledger Creation screen, specify Duties & Taxes group in the field Under.
2.Enter other details as below.
a.Type of Duty/Tax: Select based on statutory compliance applicable to your
Company. For Indian statutory, Others is displayed by default.
b. Percentage of Calculation: Select the rate of tax e.g. 5%, 10%, 12.5%, as
applicable.
Once you select Percentage of Calculation, the Method of Calculation field appears.
c.Method of Calculation: Select the tax calculation method from the Type of Duty list.
i.Additional Duty: If there is another tax ledger and you want to calculate tax on that
tax value then you need to select this option.
ii.On Total Sales: This method is used to calculate tax on the total item value in the
invoice.
iii.Surcharge on Tax: It is similar to Additional Duty, the difference is it is used for the
purpose of Income Tax.
iv.Tax based on Item Rate: This method is used to calculate tax based on the Item
rates specified on the items.
d.Rounding Method: Select the Rounding Method to round off the tax values.
For example:
For duty value 123.33 and rounding Limit is 1. In this case:
● Downward rounding shows as 123.
● Normal rounding shows as 123.
● Upward rounding shows as 124.
For Duty value 125.55 and rounding Limit is 1. In this case:
● Downward rounding shows as 125.
● Normal rounding shows as 126.
● Upward rounding shows as 126.
3.Fill in the other necessary details and press Ctrl+A to save the ledger.
Alter and Delete Ledgers
After you create the ledgers as per your requirement, you can alter the details of such
ledgers. You can even alter the group under which the ledger was created. Apart from
altering the ledger, you can also delete ledgers which are not required. You can alter or
delete ledgers one at a time or in one go. You can alter or delete the ledgers and other
masters from the Chart of Accounts as well. Using a Chart of Accounts, you can alter
multiple masters in one go and delete masters from a single screen.
In this section
● Alter the ledger
● Delete the ledger
● View Edit Log for ledgers
Alter the ledger
After you create the ledgers, you may want to update certain details. For
instance, you may update GSTIN/UIN or the Mailing Details, based on the
information you receive from your customer or vendor. In TallyPrime, you can
alter the details in the ledgers and use them as needed. You can alter the ledger
one at a time or you can also alter multiple ledgers from the Multi Alter screen in
the Chart of Accounts. However, you cannot alter all fields of ledgers through the
Multi Alter screen
Step-1 Press Alt+G (Go To) > Alter Master > type or select Ledger and press
Enter.
Alternatively, Gateway of Tally > Alter > type or select Ledger and press Enter.
The Ledger Alteration screen appears.
Step-2 Alter the details, as required, and save the ledger.
You can alter any information provided in the ledger master with the exception of
the closing balance under the group Stock-in-Hand.
If you want to enable Edit Log in TallyPrime, then refer to the Create a
Company section in the Setup Your Company topic.
You can view the altered or deleted ledgers from the Chart of Accounts,
refer to Validate Changes and Deletion of Masters.
Step-2 Press Ctrl+B (Basis of Value) to view the report with either Debit or Credit
Values, including post-dated vouchers or the opening balance.
You can also view Altered and Unaltered vouchers.
Step-1 In the Ledger Vouchers screen, press F12 (Configure) > set the option
Show Running Balance to Yes to see the running balances for the Ledger
Voucher report
Step-2 Press Enter to save the changes.
A sample Ledger Vouchers report with a running balance column appears as shown
below.
You can also access Ledger Vouchers reports by drilling down from different
statements, such as Group Summary and Monthly Summary.
You can see the Mailing details and the account details on the screen.
Step-1 Press Alt+G (Go To) > type or select Chart of Accounts > Ledger > and press
Enter.
Alternatively, Gateway of Tally > Chart of Accounts > Ledger > and press Enter.
Step-2 Press Alt+H (Multi-Masters) > select Multi Alter > and press Enter.
Step-3 Select All Items from the List of Groups. In the Multi Ledger Alteration screen,
you can view the Opening Balance of all the ledgers which are Balance Sheet Items.
From the Chart of Accounts, you can view the opening balances of each ledger in one
single screen.
Additionally, you can print, export or email the opening balances of all ledgers from Trial
Balance with the necessary configurations. To know more, Click here.