Schedule 6 Balance Sheet Format in Excel

In this article, we will discuss the structure of a Schedule 6 balance sheet format in Excel. A free downloadable template is provided below.

What Is a Schedule 6 Balance Sheet?

A Schedule 6 balance sheet is a balance sheet format that describes a company’s financial state at a particular time. It consists of a company’s financial statements for the current year as well as previous years. Just like any other balance sheet, a Schedule 6 balance sheet includes an Equity and Liabilities section and an Assets section. Thus, the Schedule 6 balance sheet format helps track a company’s financial state at any time.

Schedule 6 Balance Sheet Format

We’ll use the following 4 columns to create our Schedule 6 balance sheet:

Particulars

Consists of various financial statements.

Note No

Stores any applicable short notes.

Amounts as of the end of the current reporting period

Stores the current financial statements.

Amounts as of the end of the previous reporting period

Stores the previous financial statements.

Section 1 – Equity and Liabilities

In this section of our Schedule 6 Balance Sheet, the following categories should appear:

1.1 – Shareholder’s Funds

If the company collected any funds by launching IPOs, those amounts should be included here. The sub-sections under Shareholder’s Funds are:

Share Capital
Reserves and Surplus
Money received against share warrants

The sections are self-explanatory, so a detailed explanation is not provided here.

1.2 – Share Application Money Pending Allotment

The company might receive application fees, but perhaps the allotment has not been made yet. Such application fees fall under the Share Application Money Pending Allotment category.

1.3 – Non-Current Liabilities

Include the company’s past borrowing statements here. The sub-sections are:

Long-term borrowings
Deferred tax liabilities (Net)
Other Long term liabilities
Long term provisions

1.4 – Current Liabilities

Here, the company’s present borrowings are recorded. Sub-sections include:

Short-term borrowings
Trade payables
Other current liabilities
Short-term provisions

Section 2 – Assets

The second essential part of a balance sheet is the Assets section, which consists of the company’s tangible and intangible assets, investments, etc. This section includes the following components: