Schedule 6 Balance Sheet Format in Excel

To monitor a company’s financial growth, the schedule 6 format of the balance sheet is used. It consists of a company’s financial statements for the current year as well as previous years. Just any other balance sheets, a schedule 6 balance sheet also have an Equity and Liabilities section and Assets section. In this article, I will discuss the schedule 6 balance sheet format in Excel.


Download Schedule 6 Balance Sheet Template

You can download the Excel file from the following link. You can use the file as a schedule 6 balance sheet template.


What Is Schedule 6 Balance Sheet?

The schedule 6 balance sheet is a balance sheet format that describes a company’s financial state at a particular time. It helps to determine a company’s gross liabilities as well as assets at any schedule of a financial year. Thus, the schedule 6 balance sheet format helps track a company’s financial state at any time.

Template of Schedule 6 Balance Sheet Format in Excel


Schedule 6 Balance Sheet Format

I used 4 columns to create a schedule 6 balance sheet. The columns are,

  • Particulars

This column consists of various financial statements.

  • Note No

You can use this column to keep any short notes.

  • Amounts as at the end of current reporting period

Here, you will insert the current financial statements of your company.

  • Amounts as at the end of the previous reporting period

In the column, you will insert the previous financial statements of your company.

Columns of Schedule 6 Balance Sheet Format in Excel


1. Equity and Liabilities

The first primary section of a balance sheet is the Equity and Liabilities section. Under this section, the following categories remain.


1.1. Shareholder’s Funds

If your company collected any funds by launching IPOs, those amounts should be mentioned here. The sectors under Shareholder’s Funds are:

  • Share Capital
  • Reserves and Surplus
  • Money received against share warrants

The sections are self-descriptive, so a detailed explanation is not written, if you have any problem understanding the terms please leave a comment, will try to provide you with an answer.


1.2. Share Application Money Pending Allotment

Your company might receive application fees, but maybe the allotment has not been made yet. Those application fees fall under the Share application money pending allotment category.


1.3. Non-Current Liabilities

Here, you should include a company’s past money borrowing statements. It has the following sectors:

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


1.4. Current Liabilities

Here, a company’s present borrowings are recorded. It includes,

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

Read More: Net Worth Formula Balance Sheet in Excel (2 Suitable Examples)


2. Assets

The second essential part of a balance sheet is the Assets section. It consists of a company’s tangible and intangible assets, investments, etc. Now let’s dive deeper into this section.


2.1. Non-Current Assets

Here, a company’s non-recent assets are recorded. It consists of the following sectors:

  • Fixed assets
  1. Tangible assets
  2. Intangible assets
  3. Capital work-in-progress
  4. Intangible assets under development
  • Non-current investments
  • Deferred tax assets (Net)
  • Long-term loans and advances
  • Other non-current assets


2.2. Current Assets

Here, you will insert a company’s present assets statements. It consists of the following sectors:

  • Current investments
  • Inventories
  • Trade receivables
  • Cash and cash equivalents
  • Short-term loans and advances
  • Other current assets

Read More: Balance Sheet Format of a Company in Excel (Download Free Template)


Practice Section

You will get an Excel sheet like the following screenshot, at the end of the provided Excel file. You can practice all the topics in that blank dataset discussed in this article.

Schedule 6 Balance Sheet Format in Excel


Conclusion

To sum up, I have discussed the format of a schedule 6 balance sheet in Excel. Please don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap. And please visit our website Exceldemy to explore more.


Related Articles

Mrinmoy

Mrinmoy

Hi! I'm Mrinmoy Roy. I'm an Excel and VBA content developer. I write blogs relating to Microsoft Excel on Exceldemy.com. I've completed my graduation in Electronics and Communication Engineering from Khulna University of Engineering & Technology. I've expertise in Excel functions, formulas, Pivot Table, Power Query, Visual Basic, etc. I write blogs to lessen people's hassles while working on Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo