Skip to content
Small Business Balance Sheet cover: a sample sheet with total assets, total liabilities and owner's equity and a bar chart, beside the Dashboard tab

Small Business Balance Sheet

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

This balance sheet suits a small business owner, bookkeeper or lender reviewing a company's position on a set date. The Accounts tab takes each account with its type (current asset, fixed asset, current liability, long-term liability or equity), its amount and a short note. Depreciation is entered as a negative figure under fixed assets, so the totals reflect its value.

Headline figures on the Dashboard are total assets, total liabilities, owner's equity and the current ratio. A difference figure should read 0, which confirms the sheet balances. A bar chart compares the balances by type. Sample figures are for a company with cash, receivables, equipment, a vehicle, a loan and retained profit.

Useful for

  • Showing a lender the business position on a date
  • Checking that the books balance at year end
  • Comparing the current ratio over several quarters

What's included

  • 3 tabs: Dashboard, Accounts, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Accounts: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Accounts tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What does it mean if the difference is not zero?

It means an account is missing, entered twice, or in the wrong type. Recheck each row, then look at the retained earnings figure, which is the most common place for a mismatch. Your bookkeeping records should explain every number before you rely on the sheet.

Is a balance sheet the same as a profit statement?

No. A balance sheet shows the position on one date. A profit statement covers a period, such as a month or a year. Retained earnings links the two, because profit that is kept in the business is added to equity.

How frequently does the balance sheet need new figures?

Most owners update it monthly or quarterly, and at year end for tax and lender purposes. File a dated copy at each update so earlier periods stay on hand for comparison.

  • #profit-and-loss
  • #balance-sheet
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More profit and loss templates

See all 12

Also in Finance

All finance templates
Get this template

Preparing your template…