How to Generate Balance Sheets and Profit & Loss Reports in Tally

How to Generate Balance Sheet & Profit & Loss in Tally

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
Step 3: Adjust the period:
Press F2 (Date)
Set: 01-04-2024 to 31-03-2025
Step 4: Review the structure:
SectionIncludes
Direct Income & ExpensesPurchases, raw materials, cost of production
Indirect Income & ExpensesRent, interest, salary, commission
Net Profit / LossFinal 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
Step 2: Adjust Date Range:
Press F2 and update reporting period.
Step 3: Review key sections:
SideContains
AssetsCash, bank, receivables, stock, fixed assets, loans given
LiabilitiesCapital, 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

๐Ÿงฎ 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

MistakeResult
Wrong ledger groupingProfit/Loss values appear in wrong section
Missing opening balancesTrial balance difference
Incorrect GST setupTax values missing
No stock tracking enabledClosing stock shows zero
Unrecorded vouchersProfit or Balance mismatch

Tip: If a report looks wrong โ€” donโ€™t panic. Usually itโ€™s just grouping or date settings, not data loss.

Leave a Reply

Your email address will not be published. Required fields are marked *