Financial statement latest format for 2021-2022

355 views 1 replies
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
ARTICLESHIP 16 July 2026
Article Assistant

Sahil Agarwal & Company

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 08 July 2026
Article internship

AJAY SINGH AND CO LLP

Thane

CA Final

View Details
Company
ARTICLESHIP 17 July 2026
Article Assistant and B.com pass

BANSAL YOGESH AND CO

Gautam Budh Nagar

B.Com

View Details
Company
14 July 2026
Senior Executive/ Manager

H S SHARMA AND CO

Pune

CA Final

View Details
Company
13 July 2026
AVP / VP - PCG Advisory

Workforce Connect

Mumbai

MBA

View Details
Company
ARTICLESHIP 24 June 2026
CA Article Trainee

Rahul Dang & Associates

Pune

CA Inter

View Details
Company
20 July 2026
Senior GST Executive

Chandak Agarwal & Co

Mumbai

Graduate (Any)

View Details
Company
29 June 2026
ACCOUNTANT

SANDEEP AASHISH & CO

Araria

B.Com

View Details