Skip to content
BookkeepKit

Balance Sheet Template

List what the business owns, what it owes and the owner's stake on one date. The totals and the check that assets equal liabilities plus equity update as you type.

Details

Assets

Current assets

Total current assets$0.00

Fixed assets

Total fixed assets$0.00

Other assets

Total other assets$0.00
Total assets$0.00

Liabilities

Current liabilities

Total current liabilities$0.00

Long-term liabilities

Total long-term liabilities$0.00
Total liabilities$0.00

Equity

Equity

Total equity$0.00
Total equity$0.00

How it works

  1. 1

    Pick the date

    A balance sheet is a snapshot: usually the last day of a month, quarter or year.

  2. 2

    Fill in the accounts

    Assets, liabilities and equity, each split into the usual sections. Add or rename lines freely.

  3. 3

    Balance and download

    When assets equal liabilities plus equity, download Excel or a PDF with the totals ruled.

The accounting equation

Every balance sheet rests on one equation: assets = liabilities + equity. What the business owns was paid for either by someone it owes (liabilities) or by the owners (equity). If the two sides don't match, something is missing or entered twice, and the template shows the exact difference.

What goes where

  • Current assets: cash in every bank account, accounts receivable, inventory, prepaid expenses such as insurance paid in advance.
  • Fixed assets: equipment, furniture, vehicles and buildings at cost, less accumulated depreciation.
  • Other assets: security deposits, long-term investments, intangible assets.
  • Current liabilities: accounts payable, credit card balances, sales tax and payroll taxes collected but not yet paid, the current portion of loans.
  • Long-term liabilities: the rest of loan and mortgage balances.
  • Equity: owner's capital, owner's draws (negative), retained earnings from prior years, and net income for the current year.

A balance sheet that holds up

Reconcile every bank and credit card account to its statement for the balance sheet date first. A balance that doesn't match a statement is the most common reason a balance sheet looks right but isn't. The bank reconciliation tool does that comparison for you.

Frequently asked questions

Why doesn't my balance sheet balance?

The usual culprit is this year's profit: until the books are closed, net income for the year belongs in equity. Other causes are a missing loan or credit card balance, owner's draws left out of equity, or accumulated depreciation entered as a positive number.

How do I enter accumulated depreciation?

As a negative number in fixed assets, so it reduces the cost of the equipment. The template includes a line for it.

What's the difference between current and long-term?

Current assets turn into cash, and current liabilities come due, within a year. A loan's next twelve months of principal is current; the rest is long-term.

Where do the numbers come from?

Bank and card balances from the statements for the date, receivables and payables from your invoicing and bills, loan balances from the lender, and equity from the prior balance sheet plus this period's profit, contributions and draws.

Is my data saved?

In this browser only. Nothing is uploaded.

Guides