Ledger and Group in Tally

Ledger in tally

A Ledger is the actual account head to which you identify a transaction and must be used in all Accounting Vouchers. Without a ledger we cannot record any transactions.

There are two pre-defined ledgers available in Tally. ERP 9, they are:

  1. Cash
  2. Profit and loss

How to create leader?

Gateway of tally —–> Create —–> Ledger

How to modify ledger?

Gateway of tally —–> Alter—–> Ledger —–> select ledger want to modify or delete And for delete press Alt +D

What is Group in tally?

Group are collection of ledgers of the same nature. Tally software automatically creates 28 groups that are used in the account chart. Out of 28 predefined groups in tally, primary groups are 15, and the sub-groups are 13. The different types of groups are as follows:

  1. Primary Group
  2. Sub Group

Primary Groups

This group is the main group. Primary groups are at the top of the hierarchy. Among 15 groups, 6 groups are profit and loss a/c items, and 9 groups are balance sheets items.

List of Primary Group in Tally

1.Branch/Division6. Current Assets11. Indirect Income
2. Capital Accounts7. Fixed Assets12. Misc. Expenses
3. Loans8. Investments13. Purchase Accounts
4. Suspense Account9. Sales Accounts14. Direct Income
5. Current Liabilities10. Indirect Expenses15. Direct Expenses

Sub Groups

This group is part of the primary group. It can be divided into 13 groups.

List of Sub Group in Tally

1. Sundry Creditors6. Secured Loans11. Bank Accounts
2. Stock in Hand7. Deposits12. Cash in Hand
3. Duties & Taxes8. Banks OD Accounts13. Loan & Advances (Assets)
4. Unsecured Loans9. Provisions
5. Reserves & Surplus10. Sundry Debtors

Create the following ledgers in Tally Prime by entering the correct State, GSTIN, and Opening Balance for each party.

Sundry Creditors – Ledger Creation & Opening Balance

Create the following Sundry Creditor ledgers in Tally Prime by entering the correct State, GSTIN, and Opening Balance for each party.

Ensure that the opening balances are entered on the Credit (Cr.) side.

Ledger NameStateGSTINOpening Balance
Larsen & Toubro LimitedMaharashtra27AAACL0140P1ZJ₹3,20,000 Cr
Asian Paints LimitedMaharashtra27AAACA3622K1ZV₹1,45,000 Cr
Hindustan Unilever LimitedMaharashtra27AAACH1004N1ZU₹2,35,000 Cr
Bajaj Auto LimitedMaharashtra27AADCB2923M2ZK₹2,10,000 Cr
Infosys LimitedKarnataka29AAACI4798L1ZU₹1,75,000 Cr
ITC LimitedWest Bengal19AAACI5950L1Z7₹1,95,000 Cr
Maruti Suzuki India LimitedHaryana06AAACM0829Q1Z8₹3,10,000 Cr
Dabur India LimitedUttar Pradesh09AAACD0474C1Z3₹1,20,000 Cr
Shree Cement LimitedRajasthan08AACCS8796G3ZP₹1,55,000 Cr
Reliance Industries LimitedMaharashtra27AAACR5055K1ZT*₹2,45,000 Cr

Sundry Debtors – Ledger Creation & Opening Balance

Create the following Sundry Debtor ledgers in Tally Prime by entering the correct State, GSTIN, and Opening Balance for each customer.

Ensure that the opening balances are entered on the Debit (Dr.) side.

Ledger NameStateGSTINOpening Balance
Tata Motors LimitedMaharashtra27AALCT0864B1ZE₹2,85,000 Dr
Titan Company LimitedMaharashtra27AAACT5131A1ZX₹1,65,000 Dr
Siemens LimitedMaharashtra27AAACS0764L1Z6₹2,40,000 Dr
Hindalco Industries LimitedGujarat24AAACH1201R1ZT₹1,95,000 Dr
Nestlé India LimitedHaryana06AAACN0757G1ZP₹1,45,000 Dr
Tata Consumer Products LimitedMaharashtra27AABCT0602K1ZL₹1,25,000 Dr
Cipla LimitedMaharashtra27AAACC1450B1ZE₹1,80,000 Dr
Sun Pharmaceutical Industries LimitedGujarat24AADCS3124K1ZJ₹2,15,000 Dr
Godrej Industries LimitedMaharashtra27AAACG2953R1Z3₹1,35,000 Dr
Eicher Motors LimitedHaryana06AAACE3882D2ZV₹1,70,000 Dr
Bharat Petroleum Corporation LimitedMaharashtra27AAACB2902M1ZT₹2,10,000 Dr
Indian Oil Corporation LimitedMaharashtra27AAACI1681G1ZP₹2,55,000 Dr

Bank Ledger Creation & Opening Balance

Create the following Bank Account ledgers in Tally Prime by entering the correct Bank Name, IFSC Code, Branch, Cheque Number Range, and Opening Balance for each bank account.

Ensure that the opening balances are entered on the Debit (Dr.) side.

Ledger NameAccount NumberIFSC CodeBranchCheque No. FromCheque No. ToOpening Balance
HDFC Bank50100012345678HDFC0001234Andheri East, Mumbai100001100200 ₹4,85,000 Dr
State Bank of India30210098765432SBIN0002345Dadar, Mumbai200001200250 ₹6,25,000 Dr
ICICI Bank451234567891ICIC0003456Vashi, Navi Mumbai300001300200 ₹3,75,000 Dr
Axis Bank91002076543210UTIB0004567Powai, Mumbai400001400250 ₹5,40,000 Dr
Kotak Mahindra Bank81123456789045KKBK0005678Thane West500001500200 ₹2,95,000 Dr
Bank of India61012345678934BKID0006789Borivali, Mumbai600001600250 ₹3,20,000 Dr
Canara Bank72123456789056CNRB0007890Kurla, Mumbai700001700200 ₹2,65,000 Dr
Punjab National Bank83012345678967PUNB0008901Malad, Mumbai800001800250 ₹4,10,000 Dr
Union Bank of India94012345678978UBIN0009012Ghatkopar, Mumbai900001900200 ₹3,55,000 Dr
Bank of Baroda15012345678989BARB0010123Borivali West, Mumbai110001110250 ₹2,80,000 Dr

Create the following GST ledger, Purchase and Sales ledger in there respective group as give below.

GST & Tax Ledgers

Important: In TallyPrime, GST ledgers are normally created under Duties & Taxes, with the appropriate GST type and tax details.

Ledger NamePurpose
Input CGSTCGST paid on purchases
Input SGSTSGST paid on purchases
Input IGSTIGST paid on purchases
Output CGSTCGST collected on sales
Output SGSTSGST collected on sales
Output IGSTIGST collected on sales

Purchase & Sales Ledgers

Ledger NameUnder GroupGST ApplicabilityPurpose
Purchase – LocalPurchase AccountsApplicableLocal purchases
Purchase – InterstatePurchase AccountsApplicableInterstate purchases
Purchase – ExemptPurchase AccountsExemptGST-exempt purchases
Purchase ReturnPurchase AccountsApplicableGoods returned to supplier
Sales – LocalSales AccountsApplicableLocal sales
Sales – InterstateSales AccountsApplicableInterstate sales
Sales – ExemptSales AccountsExemptGST-exempt sales
Sales ReturnSales AccountsApplicableGoods returned by customer