Free demoJob-oriented courses at Debugshala, Old Palasia, Indore. Freshers, non-IT and year-gap welcome.Book a free demo +91-8982385539

TallyPrime Reports: Day Book, Trial Balance, P&L, Balance Sheet

Lesson 5 of 10 · 10 min · Updated 13 Nov 2026

Read TallyPrime reports with a worked month: Day Book, ledger, Trial Balance, Profit & Loss A/c and Balance Sheet, plus the keys to filter, detail and export.

Think of a cricket match scorecard. The ball-by-ball commentary records every delivery. The batting card sums up each batter's runs. The final result says who won, and the series table shows where each team stands.

Nobody writes the batting card separately; it comes from the ball-by-ball record. If the commentary is right, every summary is right.

TallyPrime reports work the same way. The vouchers are the ball-by-ball record. The Day Book replays them, ledgers sum them per account, the Trial Balance checks the totals, and the Profit & Loss A/c and Balance Sheet give the final result.

TallyPrime reports are statements calculated automatically from recorded vouchers, ranging from the Day Book of daily entries to the Trial Balance, Profit & Loss A/c and Balance Sheet.

You will read the July 2026 books of Narmada Traders, the made-up Indore wholesaler whose seven vouchers you entered in voucher entry.

How are TallyPrime reports organised?

Reports build on each other, from the most detailed to the most summarised. Learning them in this order makes each one easier to read.

TallyPrime reports hierarchy: vouchers feed the Day Book and ledgers, which feed the Trial Balance, which splits into the Profit and Loss account and Balance Sheet

Each report summarises the one below it. If a final figure looks wrong, drill down until you reach the voucher.

You open reports in three ways:

  1. From the Gateway of Tally. Day Book, Balance Sheet, Profit & Loss A/c and Stock Summary sit on the main screen. Everything else is under Display More Reports.
  2. With Alt+G (Go To). Type a few letters of the report name and press Enter. This works from any screen.
  3. By drilling down. In a summary report, select a line and press Enter to open the detail behind it, down to a single voucher.

A few keys that work in every report

TallyPrime uses the same buttons across reports, so learn them once.

Key What it does
F2 Change the date or period
Alt+F5 Switch between condensed and detailed views
F12 (Configure) Show or hide columns and options
Ctrl+B (Basis of Values) Change what values are included, such as stock valuation
Alt+N (Auto Column) Add columns, for example one per month or quarter
Alt+E / Alt+P / Alt+M Export, print or share the report
Esc Go back one level

How to read the Day Book in TallyPrime

The Day Book lists every voucher in date order. It is the first report to check at the end of each day, because it shows exactly what was entered.

  1. Go to Gateway of Tally > Day Book, or press Alt+G and type "Day Book".
  2. It opens on the current date shown on the Gateway. Press F2 and set the period 1-7-2026 to 31-7-2026.
  3. Press Alt+F5 for the detailed view, which shows both sides of each voucher.
  4. Press F4 to show only one voucher type, such as Sales. Press Ctrl+F to filter, for example by amount.
  5. Press F12 to show narrations, which helps when you review someone else's work.

For Narmada Traders, the July Day Book shows seven vouchers: two sales, one purchase, one payment, one receipt, one contra and one journal. If an entry is missing or on the wrong date, it shows up here first.

How to view a ledger account

To see every transaction in one account, open Ledger Vouchers: press Alt+G, type "Ledger Vouchers" and pick the ledger. The menu path is Display More Reports > Account Books > Ledger.

Sharma Kirana Store's July ledger reads:

Date Particulars Debit (₹) Credit (₹)
Opening Balance 18,500
1-7-2026 Sales 27,200
2-7-2026 Bank of Baroda A/c (receipt) 18,500
Closing Balance 27,200 Dr

Sharma still owes ₹27,200: the 1 July bill. Press F12 and turn on a running balance if you want the balance after each line.

How to read the Trial Balance in TallyPrime

The Trial Balance lists the closing balance of every ledger with debits on one side and credits on the other. If both totals match, every voucher was entered with equal debits and credits.

  1. Go to Gateway of Tally > Display More Reports > Trial Balance, or Alt+G and "Trial Balance".
  2. It opens as on the date of the last voucher. Change the period with F2 if needed.
  3. It shows groups by default. Press F5 to switch to a ledger-wise list, or Alt+F5 for the detailed view.
  4. Press F12 and turn on Show Opening Balance or Show Transactions to see the full movement.

Narmada Traders on 31 July 2026, ledger-wise. The opening stock is shown as one line, as it would appear in a hand-drawn trial balance:

Ledger Debit (₹) Credit (₹)
Ramesh Patel Capital 4,00,000
Malwa Dal Mill 1,02,000
Indore Roadways 2,000
Sales 33,000
Bank of Baroda A/c 2,51,500
Cash 10,800
Sharma Kirana Store 27,200
Opening Stock 1,73,500
Purchase 60,000
Shop Rent 12,000
Freight Inward 2,000
Total 5,37,000 5,37,000

Quick check

Which TallyPrime report lists every voucher entered for a chosen day or period?

How to read the Profit & Loss A/c

The Profit & Loss A/c compares income and expenses for a period. Ledgers under the six revenue groups (Sales, Purchase, Direct and Indirect Incomes and Expenses) appear here, along with opening and closing stock.

  1. Gateway of Tally > Profit & Loss A/c, or Alt+G.
  2. Press F2 to set the period: 1-7-2026 to 31-7-2026.
  3. Press Alt+F5 for detail. In F12, Show Vertical Profit & Loss switches to a top-to-bottom layout, and Show Percentages shows each line as a share of sales.

TallyPrime's default horizontal layout works out gross profit first (trading items) and then net profit.

Debit side ₹ Credit side ₹
Opening Stock 1,73,500 Sales Accounts 33,000
Purchase Accounts 60,000 Closing Stock 2,04,500
Direct Expenses (Freight Inward) 2,000
Gross Profit c/o 2,000
2,37,500 2,37,500
Indirect Expenses (Shop Rent) 12,000 Gross Profit b/f 2,000
Net Loss 10,000

Read it like this. The 10 bags sold had cost ₹29,000 (8 × ₹3,000 + 2 × ₹2,500) and sold for ₹33,000, a ₹4,000 margin.

Freight of ₹2,000 cut gross profit to ₹2,000, and ₹12,000 rent turned it into a ₹10,000 loss. One slow month of sales can't carry a full month's rent: that is the insight a P&L gives you.

Press Alt+N (Auto Column) and choose Quarterly or Monthly to compare periods side by side once you have more data.

TallyPrime trial balance to final accounts: revenue ledgers go to the Profit and Loss account, capital ledgers to the Balance Sheet, and net profit or loss links the two

Every Trial Balance line goes to exactly one statement. Net profit or loss is the bridge between them.

How to read the Balance Sheet in TallyPrime

The Balance Sheet shows what the business owns (assets) and owes (liabilities and capital) on one date. Both sides always total the same.

  1. Gateway of Tally > Balance Sheet, or Alt+G.
  2. Press F2 and set the date to 31-7-2026.
  3. Press Alt+F5 to expand groups into ledgers, and Ctrl+H to switch to the vertical view.
  4. F8 (Valuation) or Ctrl+B changes the stock valuation method used for closing stock.
Liabilities ₹ Assets ₹
Capital Account 4,00,000 Current Assets: Closing Stock 2,04,500
Current Liabilities: Sundry Creditors 1,04,000 Current Assets: Sundry Debtors 27,200
Current Assets: Bank 2,51,500
Current Assets: Cash 10,800
Profit & Loss A/c (loss) 10,000
Total 5,04,000 Total 5,04,000

By default, TallyPrime shows a loss on the assets side. If you prefer it deducted from capital, F12 has an option to show the loss under liabilities in the horizontal view.

Quick check

Where does TallyPrime show a net loss in the horizontal Balance Sheet by default?

Export, print and share reports

Any report can leave TallyPrime in three ways: Alt+E exports it (to Excel, PDF and other formats), Alt+P prints it, and Alt+M shares it by e-mail or WhatsApp.

Owners who want to see figures on a phone can also turn on Enable Browser Access for Reports in F11 > Online Access, which lets authorised users view reports in a browser.

Many accountants export the Profit & Loss A/c and Sales Register to Excel and analyse them further. The Excel pivot tables tutorial shows how to slice sales by month and party. Reports become far more useful when GST data is added; that is covered in GST returns.

Common mistakes when reading reports

Wrong period. Most "missing" entries are just outside the period. Check the dates at the top and press F2.

Trusting a balanced Trial Balance. Balance only proves equal debits and credits. Review ledgers for wrong parties and duplicates.

Ignoring stock valuation. Closing stock drives gross profit. A wrong stock rate makes the P&L wrong even when every voucher is right.

Reading condensed views only. Group totals can hide an expense posted to the wrong ledger. Use Alt+F5 when something looks odd.

Key takeaways

  • All TallyPrime reports are calculated from vouchers; correct vouchers mean correct reports.
  • The Day Book checks daily entry, Ledger Vouchers show one account, and the Trial Balance checks that debits equal credits.
  • The Profit & Loss A/c gives gross and net profit for a period; the Balance Sheet gives the position on a date.
  • F2, Alt+F5, F12, Ctrl+B and Alt+N work across reports, and Alt+E exports to Excel.
  • Learn the keys that make this quick in TallyPrime shortcut keys, then start the GST section with GST basics.
Practise on Debugshala TestOnline compiler, coding questions, aptitude and reasoning MCQs. Free at test.debugshala.com ↗

FAQ

How do I open the Trial Balance in TallyPrime?

Go to Gateway of Tally > Display More Reports > Trial Balance, or press Alt+G, type "Trial Balance" and press Enter. It opens as on the last voucher date in group-wise form. Press F5 for a ledger-wise list and F2 to change the date.

What is the difference between the Trial Balance and the Balance Sheet?

The Trial Balance lists every ledger's balance, including incomes and expenses, to check that debits equal credits. The Balance Sheet is a final statement that shows only assets, liabilities and capital on a date, with the period's net profit or loss carried in as one figure.

Why is closing stock shown in the Profit & Loss A/c?

Closing stock is the cost of goods you bought but haven't sold yet. Adding it to the credit side removes that unsold cost from the period's expenses, so gross profit reflects only the goods actually sold. The same value then appears as a current asset in the Balance Sheet.

Can I export TallyPrime reports to Excel?

Yes. Open the report, press Alt+E (Export), choose the Excel format, and set the file location. Exporting is useful for comparing months, building charts or combining Tally data with other sources. Analysts often build a pivot table from an exported Sales Register.

What should I learn after Tally reports to move into analytics?

Learn Excel well first, then SQL and a BI tool such as Power BI, so you can analyse the data Tally produces. Debugshala, which also teaches TallyPrime at Old Palasia (ask about TallyPrime classes at Old Palasia), offers a data analytics course in Indore with a free demo class. For logic practice, use the reasoning tests on Debugshala Test.

From the team behind this site

Go further with the Data Analytics Course at Debugshala

These tutorials are written by Debugshala, a training and placement institute at Old Palasia, Indore. The classroom course adds live mentoring, real projects and interview preparation.

  • Offline classes at Old Palasia, Indore
  • Free demo class before you pay
  • Non-IT, fresher and year-gap friendly
  • Placement assistance

700+ students placed · 200+ hiring partners · 4.9★ Google rating

Inventory in TallyPrime: Stock Items, Units and GodownsTallyPrime Shortcut Keys: Full List Every Accountant Uses