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
16 October 2026
CA article trainee

Zerdi & Co. Chartered Accountants

Pune

CA Inter

View Details
Company
10 October 2026
Accounts Associate Level 1

Abic and Mani Chartered Accountants

Kottayam

B.Com

View Details
Company
Featured ARTICLESHIP 06 October 2026
Semi Qualified

AJAY SINGH AND CO LLP

Thane

CA Final

View Details
Company
ARTICLESHIP 29 October 2026
Article Assistant (CA Inter / CMA Inter) - Thrissur

Varma Raja & Associates

Thrissur

CA Inter

View Details
Company
19 October 2026
Accountant

Jari Saree Center

New Delhi

Others

View Details
Company
12 October 2026
Chartered Accountant - Internal Audit

HKC | Chartered Accountants & Business Advisors

Ludhiana

CA

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
08 October 2026
Accounts and Tax Associate

POOJA R TELI & CO

Pune

CA Inter

View Details