Lesson โ€“ Balance Sheet in Tally Prime
100%

๐Ÿ“Š Balance Sheet in Tally Prime

The Balance Sheet is a financial statement that shows the financial position of a business on a specific date. It displays the business's Assets, Liabilities and Capital and helps determine the financial health of an organization.

Lesson Objective Learn how to view the Balance Sheet, understand Assets and Liabilities, analyze financial position and use the report for decision-making.
1. What is a Balance Sheet?

A Balance Sheet is a statement that shows what a business owns (Assets) and what it owes (Liabilities) on a particular date.

Component Description
Assets Resources owned by the business.
Liabilities Amounts payable by the business.
Capital Owner's investment and retained earnings.
Financial Position Shows business strength at a particular date.
Accounting Equation Assets = Liabilities + Capital
2. Importance of Balance Sheet
  • Shows financial position of the business.
  • Helps evaluate business stability.
  • Measures liquidity and solvency.
  • Supports investment decisions.
  • Required for bank loans.
  • Useful during auditing.
  • Helps management planning.
  • Required for statutory reporting.
A strong Balance Sheet indicates a financially healthy business.
3. Information Available in Balance Sheet
Section Description
Capital Account Owner's capital and reserves.
Current Liabilities Creditors and short-term obligations.
Loans Secured and unsecured loans.
Fixed Assets Building, Machinery, Furniture etc.
Current Assets Cash, Bank, Debtors, Inventory.
Investments Long-term investments.
The Balance Sheet provides a complete overview of business resources and obligations.
4. How to Open Balance Sheet in Tally Prime
Steps
  1. Open Tally Prime.
  2. Go to Display More Reports.
  3. Select Balance Sheet.
  4. Select the required financial period.
  5. Review Assets and Liabilities.
  6. Press Enter on any group for detailed analysis.
Balance Sheets can be compared across financial years to analyze business growth.
5. Major Components of Balance Sheet
Assets Liabilities
Cash in Hand Capital Account
Bank Balance Secured Loan
Sundry Debtors Unsecured Loan
Inventory Sundry Creditors
Furniture Outstanding Expenses
Machinery Duties & Taxes
Building Provisions
Investments Reserves & Surplus
Total Assets should always be equal to Total Liabilities plus Capital.
6. Balance Sheet Filters & Search Options

Tally Prime provides several filtering options that help users analyze the Balance Sheet more effectively and locate specific financial information.

Filter Purpose
Period View Balance Sheet for any accounting period.
Group Wise View Assets and Liabilities separately.
Ledger Wise Open detailed ledger balances.
Comparative View Compare current year with previous year.
Search Locate a particular ledger or group quickly.
Filters make Balance Sheet analysis faster and help identify important financial information quickly.
7. Viewing, Printing & Exporting Balance Sheet

The Balance Sheet can be viewed on-screen, printed or exported for auditing, taxation and management reporting.

Steps
  1. Open Balance Sheet.
  2. Select the desired financial period.
  3. Press Enter to view group or ledger details.
  4. Press Alt + P to print the report.
  5. Select Export to save as PDF, Excel or XML.
Action Shortcut
Open Group/Ledger Enter
Print Report Alt + P
Export Report Export Option
Exporting the Balance Sheet to Excel is useful for financial analysis and presentation.
8. Assets, Liabilities & Capital Analysis

The Balance Sheet helps management understand how business assets are financed through capital and liabilities.

Component Purpose
Current Assets Measure short-term financial strength.
Fixed Assets Evaluate long-term investments.
Current Liabilities Measure short-term obligations.
Long-term Liabilities Review long-term borrowing.
Capital Measure owner's investment.
Example
Particular Amount
Total Assets โ‚น50,00,000
Total Liabilities โ‚น18,00,000
Capital โ‚น32,00,000
The accounting equation should always remain balanced: Assets = Liabilities + Capital
9. Financial Ratio Analysis

Balance Sheet information is used to calculate important financial ratios that help evaluate the financial health of a business.

Ratio Purpose
Current Ratio Measure short-term liquidity.
Quick Ratio Evaluate immediate payment capacity.
Debt-Equity Ratio Measure financial leverage.
Working Capital Current Assets โˆ’ Current Liabilities.
Capital Employed Measure total long-term funds.
Verification Checklist
  • Verify all Assets.
  • Verify all Liabilities.
  • Review Capital Account.
  • Check Current Assets.
  • Check Current Liabilities.
  • Ensure Assets equal Liabilities + Capital.
Financial ratio analysis helps management make informed business decisions.
10. Common Balance Sheet Mistakes
Common Mistake Correct Practice
Wrong Asset Classification Use the correct asset group.
Wrong Liability Classification Verify liability ledgers carefully.
Incorrect Opening Balances Review balances before the financial year begins.
Ignoring Adjustments Pass all adjustment entries.
Duplicate Ledger Entries Review vouchers before posting.
Difference in Balance Sheet Verify Trial Balance and ledger balances.
Incorrect Accounting Period Select the correct financial year.
No Data Backup Take regular backups before major corrections.
A carefully reviewed Balance Sheet provides reliable financial information for management, auditors and investors.
11. Real Business Case Studies

The Balance Sheet is used by every business to evaluate its financial position, assets, liabilities and owner's capital.

Business Assets Liabilities Purpose
Retail Store Cash, Inventory, Furniture Creditors Measure business worth.
School / College Building, Computers, Bank Balance Salary Payable Evaluate financial stability.
Hospital Medical Equipment, Cash Bank Loan Assess financial strength.
Manufacturing Company Plant, Machinery, Inventory Suppliers & Loans Analyze production assets.
IT Company Computers, Bank Balance Outstanding Expenses Monitor company growth.
NGO / Trust Cash, Investments Grant Obligations Maintain transparency.
A healthy Balance Sheet reflects strong financial management and long-term business stability.
12. Complete Balance Sheet Verification Checklist
Checklist Status
Accounting Period Verifiedโœ”
Assets Verifiedโœ”
Liabilities Verifiedโœ”
Capital Verifiedโœ”
Current Assets Reviewedโœ”
Current Liabilities Reviewedโœ”
Fixed Assets Verifiedโœ”
Outstanding Liabilities Checkedโœ”
Ledger Balances Matchedโœ”
Assets = Liabilities + Capitalโœ”
Report Printed / Exportedโœ”
Company Backup Takenโœ”
Always verify every asset and liability before finalizing the Balance Sheet.
13. Professional Financial Management Best Practices
  • Review the Balance Sheet every month.
  • Compare Balance Sheets of previous years.
  • Monitor Current Ratio regularly.
  • Reduce unnecessary liabilities.
  • Maintain sufficient working capital.
  • Verify fixed asset records periodically.
  • Reconcile bank balances regularly.
  • Maintain proper supporting documents.
  • Export reports for management and auditors.
  • Take regular backups of company data.
Regular Balance Sheet analysis improves financial planning and strengthens long-term business growth.
14. Practical Exercise & Interview Questions
Practical Exercise
  1. Create Asset and Liability Ledgers.
  2. Enter Capital Amount.
  3. Record Purchase of Furniture.
  4. Record Bank Loan.
  5. Open the Balance Sheet.
  6. Verify Assets and Liabilities.
  7. Print the Balance Sheet.
  8. Export the report to Excel.

20 Interview Questions
  1. What is a Balance Sheet?
  2. Why is a Balance Sheet prepared?
  3. How do you open the Balance Sheet in Tally Prime?
  4. What are Assets?
  5. What are Liabilities?
  6. What is Capital?
  7. State the Accounting Equation.
  8. What are Current Assets?
  9. What are Fixed Assets?
  10. What are Current Liabilities?
  11. What are Long-term Liabilities?
  12. How does the Balance Sheet help management?
  13. What is Working Capital?
  14. What is the Current Ratio?
  15. Can the Balance Sheet be exported?
  16. How do you analyze business financial position?
  17. What are common Balance Sheet mistakes?
  18. How does the Balance Sheet help investors?
  19. How does Tally Prime simplify Balance Sheet preparation?
  20. Why should the Balance Sheet be reviewed regularly?
15. Lesson Summary
  • Learned the purpose of the Balance Sheet.
  • Understood Assets, Liabilities and Capital.
  • Learned the Accounting Equation.
  • Analyzed financial position.
  • Reviewed important financial ratios.
  • Studied real business case studies.
  • Completed practical exercises.
  • Prepared for accounting interviews.
  • Learned professional financial management practices.
  • Built a strong understanding of Balance Sheet reporting.
Congratulations!
You can now confidently prepare, analyze and interpret the Balance Sheet in Tally Prime to evaluate the financial position and stability of any business.

๐Ÿง  Quick Quiz

Which accounting equation is used in the Balance Sheet?