2020-01-20 11:16:33 Accounting & Bookkeeping English Use our guide to learn the importance of balance sheets for small businesses. Learn how to format your balance sheet through examples and... https://quickbooks.intuit.com/ca/resources/ca_qrc/uploads/2020/01/Balance-Sheet-2_featured.jpg https://quickbooks.intuit.com/ca/resources/finance-accounting/balance-sheets-with-template/ A Guide to Balance Sheets with Template

A Guide to Balance Sheets with Template

9 min read

Use our guide to learn the importance of balance sheets for small businesses. Learn how to format your balance sheet through examples and a downloadable template.

A balance sheet, along with an income statement and cash flow statement, is an integral part of your financial reporting. It will give insight into what your company owns and what it owes.

No matter the size of your business, keeping financial reports is an important aspect of managing your company. Use the data found in your balance sheet to make more informed decisions. In fact, research has shown this can lead to an increase in marketing productivity by 15% to 20%.

Plus, when your balance sheets are paired with your accounting software it allows you to have a complete picture of the health of your company.

What is a Balance Sheet?

Balance sheets are one of the primary financial statements used to measure a company’s financial position. It summarizes the company’s assets, liabilities, and owners’ equity at a specific date, and it is used to calculate the net worth of the business.

Understanding your company’s balance sheet is vital to ensuring it has a strong financial position.

Typically, when assets are greater than liabilities, this represents a strong financial position. But when liabilities are greater than assets, this can represent a weak financial position and a company with lower value.

Having an accurate balance sheet can help you and your managers assess the company’s strengths and weaknesses and develop appropriate strategies moving forward. Balance sheets can help you identify trends and are commonly used when dealing with potential lenders, such as banks, investors, and vendors.

There are two other financial statements that are connected to the balance sheet:

  • An income statement reports revenue, expenses and net income for a specific period of time. The net income balance in the income statement increases an owner’s equity in the balance sheet.
  • A cash flow statement lists the cash inflows and outflows for a month or year, and the ending cash balance is the same dollar amount reported in the balance sheet. If you create a June cash flow statement, for example, the June 30th cash balance in the cash flow statement equals the cash balance in the June 30th balance sheet.

Get a complete picture of your business finances, and in real-time, with QuickBooks financial reports.

Putting together your first balance sheet can seem a little overwhelming. But with the help of a template, you’ll not only have it done quickly but accurately. This balance sheet template can be downloaded and used for any type of business!

Before you fill it in here is a breakdown of the different sections in a balance sheet:

Assets

Assets include all items of cash and property held by your company. Usually, assets on the balance sheet are divided into two categories: current assets and non-current assets.

Examples of assets include:

  • Cash, such as money in petty cash, deposits in checking and savings accounts, and any short-term investments that can readily be converted into cash.
  • Marketable securities, including stocks, bonds, and other securities held for investment that are readily tradable.
  • Accounts receivable (A/R) owed to your company by a customer or client that is expected to be paid within a year.
  • Inventory, including raw materials, works in progress, and finished goods produced or acquired for sale to customers in the normal course of business. Businesses may have an obsolescence reserve that reduces the inventory asset on the balance sheet.
  • Pre-paid expenses, such as amounts for insurance coverage or other expenses that you expect to use or apply within one year.

Non-current assets include:

  • Property, such as equipment and machinery, buildings and land, and furniture and fixtures.
  • Intangible property, including copyrights, patents, and trademarks, as well as goodwill.

Liabilities

Liabilities are debts or other obligations of the company that could have a negative effect on its net worth. There are two basic categories of liabilities: current liabilities and long-term (fixed) liabilities.

Current liabilities, which are liabilities reasonably expected to come due within a year, include:

  • Accounts payable (AP) owed to suppliers and vendors for goods or services bought by the company.
  • Accrued expenses incurred by your business without any invoice, such as wages, employee benefits (e.g. medical insurance, retirement plan contributions), and federal and provincial taxes
  • Short-term borrowing, which includes company credit card bills and lines of credit.
  • Unearned revenue from a product or service that has yet to be delivered or performed.

Long-term (fixed) liabilities include:

  • Mortgages taken out to buy or build the company’s facilities (e.g. buildings, factories, etc.)
  • Other loans for company vehicles, equipment purchases, and loans from shareholders.
  • Bonds issued by the company to raise capital (this type of liability is unusual for a small business)

Owners’ Equity

This portion of the balance sheet represents the value of your owner’s interest in the company.  Subtracting the liabilities from the assets gives you the value of your equity.

Owners’ equity breaks down into three basic categories:

  • Capital that owners initially put into the business
  • Additional paid-in capital that owners add to the business after the initial funding
  • Retained revenue, or the earnings of the business that are kept in the company rather than being distributed to the individual owners

If you have positive equity, your assets exceed your liabilities. If your equity is negative, there are more liabilities than assets, and the company could be in trouble.

Balance Sheet Formula

Those three components are connected by the balance sheet formula:

Assets = Liabilities + Owners’ Equity
Or
Owners’ Equity = Assets – Liabilities

The formula is used to create the financial statements, including the balance sheet and will give you an accurate snapshot of your company’s financial health.

How to Create a Balance Sheet

To create a balance sheet manually, use two columns for entries of the items discussed earlier. The left column is for listing your assets, with a total of assets at the end of the column. The right column is for listing liabilities, which you total and add to the owners’ equity. When the sum of liabilities and owners’ equity is totaled, the amount should be equal to the total amount of assets in the left column.

For example, say you run an ice cream shop. Your current assets might include $2,000 cash in the bank plus $500 in accounts receivable for an upcoming catering gig and $3,000 worth of inventory (ice cream, cones, spoons, and the like). Your fixed assets might include tables and chairs worth $500, and $7,000 in freezers, and $1,000 for your computers and point-of-sale equipment. The numbers on the asset side of your balance sheet look like this:

($2,000 + 500 + 3,000) + ($500 + 7,000 + 1,000) = $14,000

The right side of your balance sheet shows your liabilities. Your current liabilities might include $1,000 in accounts payable for more ice cream and supplies, $500 for sales tax, and $1,500 owed in salary and wages to your employees. Your long-term liabilities might include $4,000 outstanding for a business loan you took to start the company. The numbers on the liabilities side of your balance sheet look like this:
($1,000 + 500 + 1,500) + 4,000 = $7,000

When you subtract your liabilities from your assets ($14,000 – 7,000), the remainder ($7,000) is your owners’ equity.

FAQs

How do I make a balance sheet?

Balance sheets are typically created in spreadsheets. To create a balance sheet manually, start with two columns for entries – one for categories and subcategories and one to the left that will show total amounts. Categories include assets, liabilities, and owners’ equity. Plug-in the formula above and fill in the form with your company’s information.

We’ve made it super easy to start a balance sheet with our downloadable template!

How do I read a balance sheet?

A balance sheet consists of rows and columns that list a company’s assets, liabilities, and equities. One column will list the category of assets or liability, with a second column beside it with the total amount for each of those categories. Underneath the assets and liabilities is data about the owners’ equity, which also includes a column of categories and total amount.

The balance sheet is then balanced through the formula Assets = Liabilities + Owners’ Equity. Ideally, a company’s assets should be equal to its liabilities and equity.

What is included on a balance sheet?

There are three categories that are included on a balance sheet: assets, liabilities, and owners’ equity.

What is the difference between classified and unclassified balance sheets?

An unclassified balance sheet provides minimal information, only presenting totally balances for assets, liabilities, and owner’s equity. While classified balance sheets breakdown assets, liabilities, and owners’ equity into subcategories. Classified balance sheets tend to be more popular because they provide more detail to the financial statement reader.

What is a report form?

A report form refers to a balance sheet that presents a fiscal year in one column. It starts with assets and provides a total value of assets at the end of the section, followed by liabilities, equities, with the final section totalling up the combined value of liabilities and equity.

How is report form and account form balance sheets different?

The difference between a report form balance sheet and account form balance sheet is simply how it is presented.

An account form balance sheet is presented in a horizontal format with information in two columns beside each other, benefits include its readability when you’re presenting data over multiple periods and it allows for quick verification that the ledger is in balance.

The report form balance sheet is presented in a vertical variation and is essentially one column that spans the entire width of the page. The benefits of using a report form balance sheet include its ability to showcase the fiscal year in one report.

Download Your Balance Sheet Template Today

balance sheet template

Balance Sheet Template

Keep in mind that your balance sheet is an always changing document. You will need to fill out a number of them each year. It should be customized to include the specific asset and liability categories that apply to your company.

The example balance sheet will help guide you through the process. You can change the account titles and the amounts listed in the spreadsheet to fit your needs. You can also add rows, in order to add new accounts and balances. The total amounts will automatically populate, based on the embedded formulas.

You’re That Much Closer to a Healthy Business

Creating and keeping your balance sheet up to date will allow you to have a better handle on your company’s finances. Using the included template along with other financial reporting can help you manage debt, help you determine risks and returns, and it can be used to help you secure loans and other capital.

Download the template to start your journey to great business health.

Information may be abridged and therefore incomplete. This document/information does not constitute, and should not be considered a substitute for, legal or financial advice. Each financial situation is different, the advice provided is intended to be general. Please contact your financial or legal advisors for information specific to your situation.

Related Articles

QBOA Pro Tax & ProFile T1 forms and schedules

The following chart outlines the T1 forms and schedules that are currently…

Read more

QBOA Pro Tax & ProFile T2 forms and schedules

The following chart outlines the T2 forms and schedules that are currently…

Read more

Understanding a Trial Balance

As a business owner, you’re probably familiar with the trial balance statement…

Read more