• Practice
  • About 24 min
  • 5 practice questions

Tally practical: opening balances, closing stock and reports

Carry a business from opening balance sheet to final accounts in Tally.ERP 9: create ledgers with opening balances, enter vouchers, record closing stock, alter or delete entries, and display the trial balance, final accounts, ratio analysis and day book.

If something looks wrong, please tell us.

By the end of this lesson you can

  • Enter opening balances when creating ledgers and alter the Cash ledger for its opening balance.
  • Record closing stock when 'Maintain accounts only' is on, and alter or delete a voucher.
  • Display the trial balance, profit and loss account, balance sheet, ratio analysis and day book, and check them against a manual working.

Tally is useful only if its reports are right, and an accountant must be able to tell when they are not. In this lesson you take a made-up business from its opening balance sheet to its final accounts the way the book's second practical problem does, and you also work the answer by hand so you can check what Tally shows.

Steps the book follows

  1. Create the company (Company Info > Create Company) and set Maintain accounts only: Yes under F11 Accounting Features.
  2. Create ledgers with opening balances: Gateway of Tally > Masters > Accounts Info > Ledgers > Single Ledger > Create; give Name, Under and Opening balance. The Cash ledger already exists, so record its opening balance by altering it (Single Ledger > Alter).
  3. Create ledgers for the year's transactions (wages, rent, purchases, sales, new parties, depreciation) under their groups.
  4. Enter the transactions through Gateway of Tally > Transactions > Accounting Vouchers, using the right voucher for each.
  5. Record closing stock: because accounts are not integrated with inventory, stock is entered by hand. Alter the stock ledger: Single Ledger > Alter > Stock > Closing balance > Date (enter the opening date, as the book directs) > Amount > Accept Yes.
  6. View the reports (table below).
Viewing reports
ReportPath in Tally.ERP 9 (as in the book)
Trial BalanceGateway of Tally > Reports > Display > Trial Balance > Alt + F1 (detailed)
Profit & Loss A/cGateway of Tally > Reports > Profit & Loss A/c > Alt + F1, or F10: A/c Reports > Profit & Loss A/c
Balance SheetGateway of Tally > Reports > Balance Sheet > Alt + F1, or F10: A/c Reports > Balance Sheet
Ratio AnalysisGateway of Tally > Reports > Ratio Analysis, or F10: A/c Reports > Ratio Analysis
Day BookGateway of Tally > Reports > Display > Day Book > Alt + F1, or F10: A/c Reports > Day Book

To alter or delete a voucher: Gateway of Tally > Reports > Display > Day Book > choose the voucher > make the change (or delete it) > Accept Yes. Since Tally posts each voucher everywhere at once, correcting it in one place corrects every report.

From opening balance sheet to final accounts in Tally

  1. Company and features Maintain accounts only = Yes
  2. Ledgers with opening balances Alter Cash for its opening balance
  3. Vouchers for the year Receipt, payment, contra, purchase, sales, journal
  4. Closing stock Alter the stock ledger
  5. Reports Trial balance, P&L, balance sheet, ratios, day book

Worked example: Malar Stores (made-up figures)

Opening balance sheet on 1 April: Capital ₹1,50,000; Sundry creditor Kannan ₹20,000 (total ₹1,70,000). Machinery ₹60,000; Furniture ₹15,000; Stock ₹25,000; Sundry debtor Selvi ₹30,000; Cash in hand ₹10,000; Cash at bank ₹30,000 (total ₹1,70,000). Transactions during the year: (a) wages paid in cash ₹3,000; (b) rent paid by cheque ₹6,000; (c) cash purchases ₹8,000; (d) goods bought on credit from Meena ₹20,000; (e) goods sold on credit to Arul ₹45,000; (f) cash sales ₹15,000; (g) cheque received from Selvi ₹20,000; (h) cheque paid to Kannan ₹12,000; (i) cash deposited into bank ₹5,000; (j) depreciate machinery at 10%; (k) closing stock ₹18,000.

Step 2: ledgers with opening balances
LedgerUnderOpening balance ₹
Malar's Capital A/cCapital Account1,50,000 (Cr)
Kannan A/cSundry Creditors20,000 (Cr)
Machinery A/cFixed Assets60,000 (Dr)
Furniture A/cFixed Assets15,000 (Dr)
StockStock-in-Hand25,000 (Dr)
Selvi A/cSundry Debtors30,000 (Dr)
Cash (predefined: alter it)Cash-in-Hand10,000 (Dr)
Bank A/cBank Accounts30,000 (Dr)

Step 3 ledgers: Wages (Direct Expenses), Rent (Indirect Expenses), Purchases (Purchase Accounts), Sales (Sales Accounts), Meena (Sundry Creditors), Arul (Sundry Debtors), Depreciation (Indirect Expenses). Step 4 vouchers: (a), (b), (h) Payment; (c), (d) Purchase; (e), (f) Sales; (g) Receipt; (i) Contra; (j) Journal, Depreciation A/c Dr ₹6,000 To Machinery A/c ₹6,000 (10% of 60,000). Step 5: closing stock ₹18,000 by altering the stock ledger.

Checking Tally's reports by hand

  1. Cash = 10,000 − 3,000 (a) − 8,000 (c) + 15,000 (f) − 5,000 (i) = ₹9,000.
  2. Bank = 30,000 − 6,000 (b) + 20,000 (g) − 12,000 (h) + 5,000 (i) = ₹37,000.
  3. Debtors: Selvi 30,000 − 20,000 = ₹10,000; Arul ₹45,000. Creditors: Kannan 20,000 − 12,000 = ₹8,000; Meena ₹20,000.
  4. Ledger balances before closing stock: debits = cash 9,000 + bank 37,000 + Selvi 10,000 + Arul 45,000 + machinery 54,000 + furniture 15,000 + opening stock 25,000 + purchases 28,000 + wages 3,000 + rent 6,000 + depreciation 6,000 = ₹2,38,000; credits = capital 1,50,000 + Kannan 8,000 + Meena 20,000 + sales 60,000 = ₹2,38,000. They agree.
  5. Gross profit = (sales 60,000 + closing stock 18,000) − (opening stock 25,000 + purchases 28,000 + wages 3,000) = 78,000 − 56,000 = ₹22,000.
  6. Net profit = 22,000 − rent 6,000 − depreciation 6,000 = ₹10,000.
  7. Balance sheet: capital 1,50,000 + net profit 10,000 = 1,60,000; creditors 28,000; total ₹1,88,000. Assets: machinery 54,000 + furniture 15,000 + closing stock 18,000 + debtors 55,000 + cash 9,000 + bank 37,000 = ₹1,88,000.

If Tally's balance sheet does not show ₹1,88,000 on both sides, or its profit is not ₹10,000, look in the Day Book for a voucher of the wrong type, a ledger under the wrong group (for example wages under Indirect Expenses would leave net profit unchanged but raise gross profit to ₹25,000), or a missed closing stock entry. Remember that in education mode the book allows dates only on the 1st, 2nd and 31st.

A note on versions: the steps in this chapter are the ones the Tamil Nadu textbook gives for Tally.ERP 9. Software versions differ: newer releases of Tally use different screens, menu names and shortcut keys. If your school's computer shows a different screen, the accounting ideas stay the same; ask your teacher for the matching menu.

Key takeaways: enter opening balances while creating ledgers (alter Cash, which already exists); record closing stock by altering the stock ledger when accounts are not integrated with inventory; correct vouchers through the Day Book; and read the trial balance, profit and loss account, balance sheet, ratio analysis and day book from Reports or F10. Always check key totals by hand.

Check your understanding

  1. 1. Why is the Cash ledger altered, not created, to record its opening balance?

    1. Because cash has no opening balance
    2. Because Cash is a predefined ledger that already exists
    3. Because cash goes under Capital Account
    4. Because Tally does not allow cash transactions
    Show answer

    Answer: B. Cash is one of the two predefined ledgers, so its opening balance is entered by altering it (Single Ledger > Alter).

  2. 2. When 'Maintain accounts only' is Yes, closing stock is recorded by:

    1. a sales voucher
    2. a contra voucher
    3. altering the stock ledger and entering its closing balance
    4. creating a new company
    Show answer

    Answer: C. Since accounts and inventory are not integrated, the book records closing stock manually by altering the stock ledger's closing balance.

  3. 3. Which path displays the trial balance in the book?

    1. Gateway of Tally > Reports > Display > Trial Balance
    2. Gateway of Tally > Masters > Trial Balance
    3. F11 > Trial Balance
    4. Company Info > Trial Balance
    Show answer

    Answer: A. The book's path is Gateway of Tally > Reports > Display > Trial Balance, with Alt + F1 for the detailed view.

  4. 4. Opening stock ₹20,000; purchases ₹50,000; sales ₹70,000; closing stock ₹15,000; wages ₹5,000 (made up). Tally's trading section should show a gross profit of:

    1. ₹10,000
    2. ₹15,000
    3. ₹5,000
    4. ₹20,000
    Show answer

    Answer: A. Gross profit = (70,000 + 15,000) − (20,000 + 50,000 + 5,000) = 85,000 − 75,000 = ₹10,000.

  5. 5. A wrongly entered voucher is found. Where does the book go to alter or delete it?

    1. F11: Features
    2. Gateway of Tally > Reports > Display > Day Book
    3. Company Info > Alter Company
    4. Masters > Voucher Types > Display
    Show answer

    Answer: B. Vouchers are altered or deleted through the Day Book: choose the voucher, change or delete it and accept.

Privacy · Terms · Refunds · Delivery