How To Edit Balance Sheet Excel Template

The residuum sheet is a very of import financial argument that summarizes a company'south assets (what information technology owns) and liabilities (what it owes). A balance sheet is used to gain insight into the financial force of a company. You tin also see how the company resources are distributed and compare the information with like companies.

No balance sheet argument is complete (in my opinion) without an income argument to go along with information technology. Every bit a small business concern possessor, I find the income statement to be more useful in the general performance of the business, just the balance canvas is still a critical accounting tool that provides a key piece of data.

The balance sail informs visitor owners about the net worth of the company at a specific point in fourth dimension. This is done by subtracting the total liabilities from the total assets to calculate the owner'due south equity, besides known as shareholder's equity (for corporations) or just the net worth.

Rest Sheet

Sample Balance Sheet Template

Download

⤓ Excel

For: Excel 2007 or later & Excel for iPad/iPhone

⤓ Google Sheets

Other Versions

Template Details

License: Private Utilise (not for distribution or resale)

"No installation, no macros - but a simple spreadsheet" - by

Description

Download our free Rest Sheet template, designed for the modest-business owner. It includes common financial ratios and works well for a two-yr comparing. See below for more information on the dissimilar asset and liability categories.

Remainder Sheet Essentials

The Accounting Equation: Assets = Liabilities + Owner's Equity

Current Assets

The term current in a balance sheet generally means "short-term" which is usually ane twelvemonth or less. Common current avails includes cash (cash, coin, balances in checking and savings accounts), accounts receivable (amounts owed to your business past your customers commonly within 10-60 days), inventory (goods for sale), and prepaid expenses (e.g. insurance and rent).

Long-Term Assets

These assets include long-term investments, price of holding and equipment (e.grand. country, buildings, equipment, tools, furniture, computers, vehicles, etc.) offset by accumulated depreciation, intangible assets (e.g. patents, contracts, trademarks, copyrights, and goodwill), and other avails (like deferred income tax arising from the loss of value of property that cannot exist reported equally a tax deduction until the belongings is sold).

Current Liabilities

These include the obligations to exist paid within i twelvemonth, including accounts payable, brusque-term loans, income taxes payable, wages, unearned acquirement (e.1000. service contracts), and the current portion of long-term debt (e.g. mortgage payments payable within 12 months).

Long-Term Liabilities

These include long-term debt (e.g. notes, mortgages), capital lease obligations (due east.m. leases structured equally loans), and deferred income tax (e.thousand. the tax due on the increase in value of an investment security that isn't paid until the security is sold).

Possessor's Equity (or Stockholders' Equity for corporations)

This is basically the amount left over when you subtract Total Liabilities from Total Avails. In includes the owner's investment(s) and retained earnings (the portion of the profits reinvested in the business concern). For corporations, there are usually more categories (see the references beneath).

Balance Sheet References

Financial Accounting: Reporting and Analysis by M.A. Diamond, East. K. Slice, and J.D. Slice., 2000.
Balance Canvas, Fixed Assets, Intangible Assets, Deferred Tax, Shareholders' Equity at wikipedia.org

Disclaimer: This remainder sheet spreadsheet and the information on this page is for illustrative and educational purposes merely. We do non guarantee the results or the applicability to your fiscal situation. You should seek the communication of qualified professionals regarding financial decisions.