How to Generate Balance Sheets and Profit & Loss Reports in Tally
Tally (both Tally Prime and Tally ERP 9) makes it easy to generate financial statements like the Balance Sheet and Profit & Loss Account within a few seconds โ as long as your ledgers, groups, and vouchers are entered correctly.
These reports help businesses track financial position, profitability, GST details, and overall accounting health.
๐ Before You Generate Reports โ Make Sure These Are Done
- โ All vouchers (Sales, Purchases, Payments, Receipts, Contra, Journal) are entered
- โ Ledger groups are correctly mapped
- โ Opening balances are correct
- โ Inventory and GST settings are enabled (if applicable)
If anything is wrong, the reports will show incorrect, blank, or unbalanced values.
๐งพ How to View the Profit & Loss Report in Tally
Step 1: Open your company file โ Select the company.
Step 2: Open Profit & Loss Report:
Alt + G โ Profit & Loss A/c
OR
Gateway of Tally โ Reports โ Profit & Loss
Alt + G โ Profit & Loss A/c
OR
Gateway of Tally โ Reports โ Profit & Loss
Step 3: Adjust the period:
Press F2 (Date)
Set: 01-04-2024 to 31-03-2025
Press F2 (Date)
Set: 01-04-2024 to 31-03-2025
Step 4: Review the structure:
| Section | Includes |
|---|---|
| Direct Income & Expenses | Purchases, raw materials, cost of production |
| Indirect Income & Expenses | Rent, interest, salary, commission |
| Net Profit / Loss | Final summary after expenses |
โ If numbers appear in the wrong section โ ledger grouping needs correction.
๐ How to Generate the Balance Sheet in Tally
Step 1: Open Balance Sheet:
Alt + G โ Balance Sheet OR
Gateway of Tally โ Reports โ Balance Sheet
Alt + G โ Balance Sheet OR
Gateway of Tally โ Reports โ Balance Sheet
Step 2: Adjust Date Range:
Press F2 and update reporting period.
Press F2 and update reporting period.
Step 3: Review key sections:
| Side | Contains |
|---|---|
| Assets | Cash, bank, receivables, stock, fixed assets, loans given |
| Liabilities | Capital, loans, outstanding creditors, GST payable, reserves |
โ If balance sheet is not tallying โ check stock values, opening balances, groupings, or missing journal entries.
Step 4: Enable Stock View (if inventory is used):
Press F12 โ Show Inventory Values: YES
Press F12 โ Show Inventory Values: YES
๐งฎ Exporting the Reports
You can export for GST filing, audit, or management reporting.
Press โ Ctrl + E โ Export
Available formats: PDF, Excel, CSV, or Printed report.
๐ก Common Mistakes That Affect Reports
| Mistake | Result |
|---|---|
| Wrong ledger grouping | Profit/Loss values appear in wrong section |
| Missing opening balances | Trial balance difference |
| Incorrect GST setup | Tax values missing |
| No stock tracking enabled | Closing stock shows zero |
| Unrecorded vouchers | Profit or Balance mismatch |
Tip: If a report looks wrong โ donโt panic. Usually itโs just grouping or date settings, not data loss.