Balance Sheet Format in Excel

It Tells You When It Doesn't Balance

That sounds obvious. It is also the one thing every blank template downloaded from anywhere else cannot do.

At the bottom of the sheet, total equity and liabilities is subtracted from total assets and the result is reported as either Balanced or "Out by ₹X" — separately for each year, because Schedule III requires previous-period figures and those have to tie too.

An empty sheet stays blank rather than claiming to be balanced, which would be worse than saying nothing.

The Schedule III Order

The line order is prescribed by Schedule III to the Companies Act, 2013 and is what an auditor, a lender and the registrar all expect to see. Equity and liabilities come first:

• Shareholders' funds — share capital, reserves and surplus, money received against share warrants
• Share application money pending allotment
• Non-current liabilities — long-term borrowings, deferred tax liabilities (net), other long-term liabilities, long-term provisions
• Current liabilities — short-term borrowings, trade payables, other current liabilities, short-term provisions

Then assets:

• Non-current assets — property, plant and equipment; capital work-in-progress; intangible assets; intangible assets under development; non-current investments; deferred tax assets (net); long-term loans and advances; other non-current assets
• Current assets — current investments, inventories, trade receivables, cash and cash equivalents, short-term loans and advances, other current assets

The Requirements Most Often Missed

Requirement	Why it matters
Trade payables are split	Amounts due to micro and small enterprises must be shown separately from other trade payables. It exists because of the MSMED Act's payment timelines and interest on late payment, and it drives further disclosures. Both lines are on the face of this sheet.
Current vs non-current	Decided by the operating cycle, not simply twelve months. Where the cycle cannot be identified, twelve months is assumed.
Intangibles under development	Kept separate from intangible assets, the same way capital work-in-progress is separate from property, plant and equipment.
Previous year is not optional	Corresponding figures are required for every line — which is why the second column exists and why the balance check runs on it too.
Rounding is prescribed	Schedule III sets the rounding unit by turnover, and whichever you choose must be used consistently across the statements.

Division I or Division II?

This is Division I — for companies that are not applying Indian Accounting Standards. Companies applying Ind AS follow Division II, where the line items differ. Using the wrong division is not a formatting preference; it is the wrong statement.

What This Sheet Does Not Do

It does not compute your figures. It is a presentation format with a consistency check — it can tell you the two sides of your numbers disagree, not whether the numbers are right. It is not accounting advice.