Skip to the content.

Free Balance Sheet Template

For an owner getting ready for a loan, a lease or a meeting with the accountant, who needs assets, liabilities and equity on one page.

Open the template · Make a copy · Google Sheet, free, no sign-up

What is inside

Tab What it holds
Balance Sheet Totals and views built from Accounts and Balances, no typing needed.
Accounts Columns Account ID, Account name, Classification and Quick asset.
Balances Columns Account ID, Balance date, Balance (USD) and Notes.
Settings Your own dropdown lists (current asset), so the choices match how you work.

How to fill it in

  1. List your accounts on Accounts with their classification.
  2. Enter each account’s balance on a given date on Balances.
  3. Pick the date on Settings, then read Balance Sheet.
  4. Compare two dates to see how cash, debt and equity moved.

A tip from the field

Take balances from statements dated the same day, bank, loan and card, so the page lines up.

Starter files

Each tab with sample rows comes as a CSV file, handy for importing into another tool or starting fresh.

When you outgrow it

Smarfle’s accountant export gives your bookkeeper the sales, payments and card fees behind those balances. See how it works on smarfle.com.

All free templates