Tag: tally master creation

  • How to Create Company and Ledger in Tally Prime: Complete Step-by-Step Guide

    Tally Prime is one of the most trusted accounting and GST compliance software used by millions of businesses. Whether you are a beginner in accounting or a professional managing multiple clients, knowing how to create a Company and Ledgers in Tally Prime is essential. Without proper company setup and ledger creation, no business transactions can be recorded accurately.

    In this detailed guide, you will learn what a company in Tally means, how to create one, how to configure its features, how to create essential ledgers, and how to organize your chart of accounts effectively. This article is written in a simple and practical manner with tables, tips, and examples for better understanding.


    What Is a Company in Tally Prime?

    A Company in Tally Prime represents the business entity whose books of accounts you want to maintain. It contains essential information such as:

    • Company Name
    • Financial Year
    • Books Beginning Date
    • Address and Contact Details
    • GST Information
    • Currency Details
    • Security Controls
    • Financial and Accounting Preferences

    Tally Prime allows unlimited companies to be created and maintained in a single system. They can be opened, shut, altered, backed up, and restored anytime.


    How to Create a Company in Tally Prime

    You can create a company in Tally Prime through the Create Company menu.

    Step-by-Step Process

    Step 1: Open Tally Prime

    Start Tally Prime from your desktop.
    Once it opens, you will see the Gateway of Tally screen.

    Step 2: Go to Create Company

    You will see the following options:

    • Create Company
    • Select Company
    • Shut Company

    Choose Create Company.

    Step 3: Enter Company Details

    Fill in the details as required.

    FieldDescription
    DirectoryWhere your company data will be stored
    NameOfficial name of your business
    Mailing NameName to print on invoices
    AddressCompany address
    CountryLocation of business
    StateState for GST applicability
    PincodePostal code
    Phone/EmailContact information
    Financial Year BeginStart of financial year, e.g., 01-04-2024
    Books Begin FromStart date of accounts
    CurrencyAuto-filled based on country

    Step 4: Enable GST and Other Features

    After entering basic details, enable additional features as needed:

    • Enable GST
    • Maintain Accounts with Inventory
    • Enable Security Control
    • Enable TDS/TCS
    • Enable Payroll

    Each business requires different modules depending on operations.

    Step 5: Save the Company

    Press Ctrl + A to save the company.
    Now your Tally company is successfully created.


    Additional Company Configurations

    Once created, you can configure additional settings through:
    Gateway of Tally > F11 (Features)

    Some commonly used configurations are:

    FeaturePurpose
    Accounting FeaturesEnable credit limits, bill-wise details, cost centers
    Inventory FeaturesEnable batches, expiry dates, godowns
    Statutory FeaturesEnable GST, TDS, TCS, PF, ESI
    Invoice FeaturesEnable item-wise tax, discount, e-way bill options

    These settings help customize Tally Prime based on your business needs.


    What Is a Ledger in Tally Prime?

    A Ledger is an accounting head under which financial transactions are recorded.
    Tally uses a group and ledger system based on the accounting hierarchy.

    Examples of commonly used ledgers:

    • Cash
    • Bank Accounts
    • Sundry Debtors
    • Sundry Creditors
    • Purchase
    • Sales
    • Duties & Taxes
    • Capital Account
    • Fixed Assets
    • Expenses (Direct & Indirect)

    A company must have at least two ledgers to start:

    • Cash
    • Profit & Loss A/c (Created automatically)

    All other ledgers must be created manually.


    How to Create a Ledger in Tally Prime

    Step-by-Step Process for Creating a Ledger

    Step 1: Go to Ledger Creation Screen

    Gateway of Tally > Create > Ledger
    OR
    Press Alt + C while entering a voucher.

    Step 2: Enter Ledger Details

    Fill in the required details.

    FieldDescription
    NameLedger name (e.g., ABC Traders)
    GroupCorrect group classification such as Sundry Debtors
    Opening BalanceOpening value if any
    GST DetailsFor GST registered ledgers
    Mailing DetailsFor customers and suppliers

    Step 3: Group Selection

    Selecting the right group is very important because it affects:

    • Financial statements
    • Trial balance
    • Profit and loss
    • Balance sheet classification

    Example:
    Sale ledger should be under Sales Accounts,
    Supplier ledger under Sundry Creditors,
    Customer ledger under Sundry Debtors,
    Expenses under Indirect Expenses.

    Step 4: Save Ledger

    Press Ctrl + A to save.


    Types of Ledgers You Should Create in Every New Company

    Below is a practical list of common ledgers used in most businesses:

    1. Capital and Owner-Related Ledgers

    • Capital Account
    • Drawings

    2. Banking Ledgers

    • Bank Account Name
    • Bank OD/CC Accounts

    3. Sales and Purchase Ledgers

    • Sales GST 5 percent
    • Sales GST 12 percent
    • Sales GST 18 percent
    • Purchase GST 5 percent
    • Purchase GST 12 percent
    • Purchase GST 18 percent

    4. Tax Ledgers

    • CGST
    • SGST
    • IGST
    • TDS Payable
    • TCS Payable

    5. Customer and Supplier Ledgers

    Each customer and supplier has its individual ledger.

    6. Expense Ledgers

    • Rent
    • Salary
    • Office Expenses
    • Electricity Expenses
    • Telephone Charges
    • Stationery

    7. Asset and Liability Ledgers

    • Furniture
    • Computers
    • Building
    • Loan Accounts
    • Outstanding Expenses

    Example Table: Ledger and Its Group

    Ledger NameGroup
    ABC TradersSundry Debtors
    Rent ExpenseIndirect Expenses
    CGST PayableDuties & Taxes
    SBI Bank A/cBank Accounts

    Important Tips for Creating Accurate Ledgers in Tally Prime

    Here are must-follow guidelines to avoid errors:

    1. Use Proper Naming Conventions

    Examples:

    • Don’t use abbreviations without clarity.
    • Use customer/supplier names exactly as per invoices.

    2. Select Correct Group Always

    Grouping mistakes can cause wrong balance sheet or P&L results.

    3. Maintain Opening Balances Carefully

    Incorrect opening balances can reflect wrong totals throughout the year.

    4. Enable Bill-Wise Details

    Useful for tracking customer invoices, outstanding payments, and supplier credits.

    5. Add GST Details for Taxable Ledgers

    For customers and suppliers:

    • GSTIN
    • Registration type
    • State
    • Tax applicability

    For product-based ledgers:

    • GST rate
    • HSN/SAC code

    6. Use Mailing Details for Parties

    This helps generate invoices, statements, and reports accurately.

    7. Regularly Review the Chart of Accounts

    Tally Prime allows viewing all ledgers through:
    Gateway of Tally > Chart of Accounts

    This helps identify:

    • Duplicate ledgers
    • Wrong groups
    • Incomplete details

    Example: Creating a Customer Ledger

    To create a ledger for a customer named Sharma Traders:

    • Name: Sharma Traders
    • Group: Sundry Debtors
    • Maintain balances: Yes
    • Enable bill-wise details: Yes
    • Opening balance: Enter outstanding receivable
    • GSTIN: If available
    • State: Required for intra-state or inter-state supply

    This ensures proper tracking of sales, receipts, and outstanding balances.


    Example: Creating a Sales Ledger with GST

    For GST-based sales at 18 percent:

    • Name: Sales 18 Percent
    • Group: Sales Accounts
    • Type of supply: Goods or Services
    • GST Rate: 18 percent
    • HSN/SAC: Enter if known

    This ledger will automatically calculate GST in invoices.


    Conclusion

    Creating a Company and Ledger in Tally Prime is the foundation of maintaining accurate and compliant accounts. With proper setup, correct grouping, and well-structured ledgers, your accounting process becomes smooth and error-free. This guide explained company creation, ledger creation, essential fields, GST setups, grouping, and best practices in a simple and comprehensive format. Whether you are running a small business or managing large-scale operations, mastering these basics will significantly improve your accounting efficiency.


    Disclaimer

    This article is intended for educational purposes. Tally Prime features may vary depending on updates and configurations. Users should apply settings based on their business requirements.


  • 100 Ledger Examples in Tally with Correct Groups – Complete Guide for Beginners

    Here is a list of 100 practical ledger examples commonly used in Tally (ERP 9 / Prime), along with the correct group classification under which each ledger should be created. This is extremely useful for learners, accountants, and professionals managing accounts setup in Tally.


    📘 Ledger Creation Examples in Tally with Group Classification

    S.NoLedger NameGroup in Tally
    1CashCash-in-Hand
    2Axis BankBank Accounts
    3SBI Current AccountBank Accounts
    4Petty CashCash-in-Hand
    5Ram Traders (Debtor)Sundry Debtors
    6Shyam Suppliers (Creditor)Sundry Creditors
    7Sales – DomesticSales Account
    8Sales – ExportSales Account
    9Purchase – Raw MaterialPurchase Account
    10Purchase – Capital GoodsPurchase Account
    11Rent ReceivedIndirect Incomes
    12Rent PaidIndirect Expenses
    13Electricity ChargesIndirect Expenses
    14Salary ExpensesIndirect Expenses
    15Telephone ExpensesIndirect Expenses
    16Commission IncomeIndirect Incomes
    17Commission PaidIndirect Expenses
    18GST PayableDuties & Taxes
    19GST Input CGSTDuties & Taxes
    20GST Input SGSTDuties & Taxes
    21GST Input IGSTDuties & Taxes
    22GST Output CGSTDuties & Taxes
    23GST Output SGSTDuties & Taxes
    24GST Output IGSTDuties & Taxes
    25Provident Fund PayableCurrent Liabilities
    26TDS PayableDuties & Taxes
    27TDS ReceivableLoans & Advances (Assets)
    28Provident Fund Employer ContributionIndirect Expenses
    29Travelling ExpensesIndirect Expenses
    30Legal FeesIndirect Expenses
    31Professional ChargesIndirect Expenses
    32Audit FeesIndirect Expenses
    33Printing & StationeryIndirect Expenses
    34Advertising ExpensesIndirect Expenses
    35Marketing ExpensesIndirect Expenses
    36Interest on LoanIndirect Expenses
    37Interest ReceivedIndirect Incomes
    38DepreciationIndirect Expenses
    39Loan from DirectorSecured Loans
    40Loan from HDFC BankSecured Loans
    41Unsecured Loan from FriendUnsecured Loans
    42Fixed DepositBank Accounts / Investments
    43Share CapitalCapital Account
    44DrawingsCapital Account
    45Investments in SharesInvestments
    46Advance to SupplierLoans & Advances (Assets)
    47Advance from CustomerCurrent Liabilities
    48Outstanding RentCurrent Liabilities
    49Prepaid InsuranceCurrent Assets
    50Insurance PremiumIndirect Expenses

    ✅ Continued — More Ledger Examples

    S.NoLedger NameGroup in Tally
    51Accrued InterestCurrent Assets
    52Sundry IncomeIndirect Incomes
    53Repair & MaintenanceIndirect Expenses
    54AMC ChargesIndirect Expenses
    55Car Fuel ExpensesIndirect Expenses
    56Vehicle MaintenanceIndirect Expenses
    57Office EquipmentFixed Assets
    58Furniture & FixturesFixed Assets
    59ComputersFixed Assets
    60Land & BuildingFixed Assets
    61MachineryFixed Assets
    62ITC ReversalDuties & Taxes
    63RCM PayableDuties & Taxes
    64Freight InwardDirect Expenses
    65Freight OutwardIndirect Expenses
    66Customs DutyDirect Expenses / Duties & Taxes
    67Packing MaterialDirect Expenses
    68Production WagesDirect Expenses
    69Administrative ExpensesIndirect Expenses
    70DonationIndirect Expenses
    71PenaltyIndirect Expenses
    72Bank ChargesIndirect Expenses
    73Bank Interest PaidIndirect Expenses
    74Bad DebtsIndirect Expenses
    75Provision for Bad DebtsProvisions
    76Director’s RemunerationIndirect Expenses
    77Security Deposit PaidLoans & Advances (Assets)
    78Security Deposit ReceivedCurrent Liabilities
    79Office Rent DepositLoans & Advances (Assets)
    80Telephone Bill PayableCurrent Liabilities
    81Office AdvanceLoans & Advances (Assets)
    82ESI PayableCurrent Liabilities
    83Income Tax PayableDuties & Taxes
    84Income Tax AdvanceLoans & Advances (Assets)
    85Dividend PayableCurrent Liabilities
    86Dividend ReceivedIndirect Incomes
    87Partner’s Capital A/cCapital Account
    88Partner’s Drawings A/cCapital Account
    89Partner’s Current A/cCapital Account
    90Salary PayableCurrent Liabilities
    91Outstanding ExpensesCurrent Liabilities
    92Accrued IncomeCurrent Assets
    93Advance TaxLoans & Advances (Assets)
    94Bonus PaidIndirect Expenses
    95GratuityIndirect Expenses
    96House Rent Allowance (HRA)Indirect Expenses
    97Medical ReimbursementIndirect Expenses
    98Loan to EmployeeLoans & Advances (Assets)
    99Vehicle Loan PayableSecured Loans
    100Temporary ImprestLoans & Advances (Assets)

    ✅ Notes:

    • Always ensure to enable GST in Tally for auto-ledger creation of Input/Output tax ledgers.
    • Classify advance ledgers correctly depending on whether they are receivable (Assets) or payable (Liabilities).
    • For accurate reporting, avoid using Miscellaneous Expenses unless absolutely required.

    Download 100 Examples of Ledger in Excel and XML

    📥 How to Import This into Tally Prime / ERP 9:

    ✅ Option 1: Manual Copy-Paste into Tally via Excel

    1. Open the Excel file.
    2. Manually create ledgers in Tally using this list as a reference.
    3. Use “Multiple Ledgers” creation to save time.

    ✅ Option 2: Import via XML (Advanced Users)

    1. Open Tally (ERP 9 or Prime)
    2. From Gateway of Tally, press Alt + O (Import)
    3. Choose Masters
    4. In “Import File Name”, enter the path to the downloaded XML file
      • Example: C:\Users\YourName\Downloads\Tally_100_Ledger_Import.xml
    5. Press Enter to start import

    ✔️ All 100 ledgers will be created in your selected company.


    🧾 How to Create Ledger in Tally (ERP 9 & Prime)

    ✅ Step 1: Open Tally

    • Open Tally ERP 9 or Tally Prime
    • Select or create your Company where ledgers need to be added

    ✅ Step 2: Gateway of Tally > Accounts Info > Ledgers

    For Tally ERP 9:

    1. Gateway of Tally → Accounts Info
    2. Select Ledgers
    3. Choose Create (under Single Ledger for one-by-one creation)

    For Tally Prime:

    1. Press Alt + G and search Create Ledger
    2. Or go to Gateway of Tally → Create → Ledger

    ✅ Step 3: Fill Ledger Details

    You’ll now see the Ledger Creation Screen. Fill the following fields:

    FieldWhat to Fill
    NameName of the ledger (e.g., “Axis Bank”)
    Alias(Optional) Short name or reference
    UnderSelect the Group (e.g., “Bank Accounts”)
    Inventory ValuesSelect Yes if applicable (for stock ledgers only)
    GST ApplicableYes / No based on ledger use (for taxable ledgers)
    Opening BalanceIf applicable, enter amount with Dr/Cr selection

    Use arrow keys to move between fields and press Enter to confirm.


    🔁 Step 4: Repeat for Each Ledger

    • Repeat the same steps for all the 100 ledgers.
    • For batch creation, use “Multiple Ledgers” option:
      • In ERP 9: Gateway of Tally → Accounts Info → Ledgers → Multiple Ledgers → Create
      • In Prime: Go to Create → Ledgers (Multiple) or search from Go To (Alt + G)

    💡 Example: Creating a Ledger for “Axis Bank”

    FieldEntry
    NameAxis Bank
    UnderBank Accounts
    Opening Balance₹50,000 Dr (if available)
    GST ApplicableNo

    Press Enter until Tally saves the entry.


    🛠️ Tips for Accurate Ledger Entry

    • Cash Ledger: Only one is allowed per company. Default is “Cash”.
    • Sundry Debtors/Creditors: Used for customer and vendor ledgers.
    • GST Ledgers: Enable GST and set proper tax rates under “Statutory Details”.
    • Fixed Assets: Use for machines, furniture, etc., to calculate depreciation.
    • Direct vs Indirect Expenses:
      • Direct = used in production (e.g., Freight Inward)
      • Indirect = post-production/admin expenses (e.g., Salary, Rent)

    📌 Shortcut Keys You’ll Use

    FunctionKey
    Create LedgerAlt + C
    Multiple LedgersAlt + H
    Save EntryCtrl + A
    Search (Tally Prime)Alt + G
    Company SelectionAlt + F3