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
- List your accounts on Accounts with their classification.
- Enter each account’s balance on a given date on Balances.
- Pick the date on Settings, then read Balance Sheet.
- 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.
Related templates
- Free Profit and Loss Statement Template
- Free Small Business Budget Template
- Free Business Plan Template for Service Businesses
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.