Financial statement latest format for 2021-2022

Dear Sir/Madam,

can anyone share latest financial statement format in Excel to work?

regards,
Asha
Replies (1)

In India, the preparation of financial statements for companies is strictly governed by Schedule III of the Companies Act, 2013. This ensures uniformity, transparency, and comparability across all companies.

Components of Financial Statements

As per Section 2(40) of the Companies Act, 2013, a complete set of financial statements includes:

  • Balance Sheet: Represents the company’s financial position at the end of the financial year.

  • Statement of Profit and Loss: Reflects the financial performance (revenue and expenses) over the financial year.

  • Cash Flow Statement: Shows the movement of cash (mandatory for most companies, but exempt for One Person Companies, Small Companies, and Dormant Companies).

  • Statement of Changes in Equity: If applicable.

  • Explanatory Notes: Any notes annexed to or forming part of the documents above.

Key Requirements

  • Schedule III Compliance: Every company must follow the vertical format prescribed in Schedule III of the Companies Act, 2013.

  • Accounting Standards: Statements must comply with the Accounting Standards (AS) or Indian Accounting Standards (Ind AS) as notified under Section 133 of the Act.

  • True and Fair View: The statements must provide a "true and fair view" of the company's state of affairs.

  • Signing Authority: Financial statements must be signed by the required directors, the CEO, CFO, and Company Secretary (where applicable) before being presented to the auditors.

Accessing Excel Formats

While there is no single "official" government-provided Excel template, the standard structures are well-documented. You can find reliable, professional templates by searching for "Schedule III Balance Sheet format Excel" or "Schedule III Statement of Profit and Loss Excel" through reputable financial or professional platforms like ICAI (Institute of Chartered Accountants of India) or professional tax/accounting portals. Many accounting software providers also offer pre-configured templates that comply with these legal requirements.


Summary: Financial statements in India must adhere to Schedule III of the Companies Act, 2013. They consist of a Balance Sheet, P&L Statement, Cash Flow Statement (with specific exemptions), Statement of Changes in Equity, and relevant notes. You can obtain standardized Excel formats through professional accounting resources or standard accounting software, ensuring they comply with the mandatory vertical disclosure format.

Are you looking for a specific template for a particular type of entity, such as a small company or a non-profit organization?

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
19 September 2026
CA/Semi-CA/BCom

Pravin Sarvaiya

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 28 September 2026
Junior Accountant

J S P M & Associates LLP

Pune

B.Com

View Details
Company
ARTICLESHIP 18 September 2026
Industrial Trainee

Twenty Point Nine Five Ventures Private Limited

Noida

CA Inter

View Details
Company
Featured 21 September 2026
Consultant - Reporting

Finrep Advisors LLP

Mumbai

CA

View Details
Company
15 September 2026
Client-site CA associate

Aditya Muley and Co

Mumbai

CA

View Details
Company
06 October 2026
Assistant Manager - Audit and Compliance

Ravi K Jain & Co

Noida

Others

View Details
Company
17 September 2026
Chartered Accountant

Dass Gupta & Associates

Gurgaon

CA

View Details
Company
26 September 2026
Chartered Accountant

pushpganga ventures

Pune

CA

View Details