Skip to content
Tutorials Center
My learning

Topics

Lesson 30 of 38 ยท Reports and Banking

Trial Balance, Profit and Loss and Balance Sheet in Tally Prime

Read the trial balance, profit and loss account, balance sheet, cash flow and ratio analysis in Tally Prime, drill down to vouchers and check that the books tally.

All the vouchers you enter feed a small set of financial statements. Tally Prime builds them live: there is no "closing the books" step to see a balance sheet. If the entries are right, the reports are right, and every figure can be drilled down to the vouchers behind it.

Tally is not runnable here, so the menus are described, and Python stand-ins show how the statements are derived from ledger balances. All figures in the examples are invented.

Where the reports are

On the Gateway of Tally the Reports column lists Balance Sheet, Profit & Loss A/c, Stock Summary, Ratio Analysis and Display More Reports, which includes Trial Balance, Day Book, Cash/Fund Flow, Statements of Accounts and more. Press Enter on a line to drill down: Balance Sheet group > ledger > ledger vouchers > the voucher itself. Alt+F2 changes the period and F2 the date in many screens; use Esc to go back.

Trial balance

The trial balance lists every ledger with its debit or credit closing balance. Its single rule: total debits equal total credits. If they do not, the books are broken, which Tally prevents because each voucher must balance.

Ledger Debit Credit
Capital 100,000
Bank 80,000
Stock (opening) 20,000
Sales 150,000
Purchases 90,000
Rent 12,000
Salaries 40,000
Sundry creditors 25,000
Sundry debtors 33,000
Total 275,000 275,000
Python Stand-in: check that a trial balance tallies

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Profit and loss account

The P&L has income (sales, direct and indirect income) on one side and expenses (purchases adjusted for stock, direct and indirect expenses) on the other. In Tally it is grouped: Sales Accounts, Direct Incomes, Purchase Accounts, Direct Expenses, Indirect Incomes/Expenses. The important sub-result is gross profit: sales minus cost of goods sold, where

cost of goods sold = opening stock + purchases + direct expenses - closing stock

and then net profit = gross profit + indirect income - indirect expenses.

Closing stock comes from the inventory (see stock valuation). If closing stock is wrong, gross profit is wrong by the same amount.

Python Stand-in: compute gross and net profit

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Balance sheet

The balance sheet shows liabilities (capital, reserves, loans, current liabilities such as creditors and duties) against assets (fixed assets, investments, current assets such as stock, debtors, cash and bank). The net profit from the P&L is added to capital, so the two sides tally. The difference, if any, is shown as Difference in Opening Balances and must be fixed by correcting the opening entries.

The accounting equation is Assets = Liabilities + Capital (with capital including this period's profit).

Cash flow, fund flow and ratios

  • Cash Flow (Display More Reports): inflows and outflows classified into operating, investing and financing activities by group.
  • Fund Flow: changes in working capital and long-term funds.
  • Ratio Analysis (Gateway of Tally): a summary with working capital, current ratio, quick ratio, debt/equity, gross and net profit %, inventory turnover and receivable turnover. Drill down on a ratio to see the figures behind it.
Python Stand-in: three common ratios

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Using the reports well

  • Drill down from any figure; the Day Book at the bottom shows who entered what.
  • Use Alt+F5 or the report's Detailed switch to expand groups (the key can differ by release), and Alt+F2 to change the period.
  • Compare periods: in the Balance Sheet or P&L choose to add a column for a previous period or another company.
  • Export (Alt+E) to Excel, PDF or HTML, or print (Alt+P).
  • Set Configure (F12) options: show percentages, group-wise details, closing balance columns.

Checks before you trust the numbers

  1. The trial balance tallies and has no suspense balance.
  2. Closing stock is correct and negative stock is cleared.
  3. Bank ledger balances agree with bank statements (next but one lesson).
  4. Receivables and payables match the outstanding reports (previous lesson group).
  5. GST ledgers agree with returns filed.

Common mistakes

  1. Posting an expense to the wrong group (for example a capital purchase as an expense), which changes profit and the balance sheet.
  2. Leaving "Difference in opening balances" unexplained.
  3. Reading the P&L before posting depreciation, accruals and closing stock.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. What must be true of every trial balance?

    Double entry guarantees equal debit and credit totals.
  2. 2. Opening stock 20,000, purchases 90,000, closing stock 35,000. Cost of goods sold is:

    20,000 + 90,000 - 35,000 = 75,000.
  3. 3. Where does net profit appear in the balance sheet?

    Profit increases the owner's capital, which keeps the balance sheet balanced.
  4. 4. Which report gives current ratio and working capital in one place?

    Ratio Analysis summarizes working capital, ratios and turnover.

Summary

  • Tally builds the trial balance, P&L and balance sheet live from vouchers.
  • A trial balance always has equal debit and credit totals.
  • COGS = opening stock + purchases + direct expenses - closing stock.
  • Drill down from any figure to the vouchers; export or print as needed.
  • Verify stock, bank, outstanding and GST ledgers before relying on the statements.

Next: Day book, registers and outstanding reports