Free template · Excel · Bookkeeping and reports
Free balance sheet template for Excel
A two-column balance sheet: what the business owns, what it owes and the owners' equity on two dates side by side, with the change, a balance check and three quick ratios.
Balance sheet template
Excel workbook (.xlsx) · 8 KB · 2 sheets
| Account | Dec 31, 2026 | Dec 31, 2025 | Change |
|---|---|---|---|
| Total current assets | 36,000.00 | 27,900.00 | 8,100.00 |
| Total fixed assets | 9,300.00 | 8,900.00 | 400.00 |
| TOTAL ASSETS | 45,300.00 | 36,800.00 | 8,500.00 |
| TOTAL LIABILITIES | 15,150.00 | 17,500.00 | (2,350.00) |
| TOTAL EQUITY | 30,150.00 | 19,300.00 | 10,850.00 |
| TOTAL LIABILITIES AND EQUITY | 45,300.00 | 36,800.00 | 8,500.00 |
| Check | Balanced | Balanced |
What it is
A balance sheet is a snapshot of the business on one date. Assets (what it owns) always equal liabilities (what it owes) plus equity (the owners' stake).
Comparing two dates shows how the business changed: more cash, less debt, more owed by customers. This template also checks that it balances and works out the ratios lenders look at first.
Who it's for
- Owners preparing for a loan or lease application
- Year-end reviews with a partner or accountant
- Businesses keeping books in a spreadsheet for now
What's in the file
| Sheet | What it holds |
|---|---|
| Balance sheet | Current, fixed and other assets; current and long-term liabilities; equity; totals; a Balanced check for each date; and working capital, current ratio and debt to equity. |
| Instructions | Where each number comes from. |
How to use it
- Enter your company name and the two dates, such as this year end and last year end.
- Clear the sample numbers.
- Enter each balance on the date: bank balances from reconciled statements, receivables from unpaid invoices, payables from unpaid bills, loans from lender statements.
- Enter accumulated depreciation and owner's draws as negatives.
- Take net income for the year from your profit and loss.
- Check the Balanced row. If it says Off by, something is missing or entered twice.
Pale yellow cells are for your entries; white cells calculate. Nothing is locked, so you can rename lines, add rows inside a section, or change the layout. Each file has an Instructions sheet with these steps.
Download balance sheet template (.xlsx)
Questions
Why must a balance sheet balance?
Everything the business owns was paid for either with borrowed money (liabilities) or the owners' money and kept profits (equity). So assets always equal liabilities plus equity. If they don't, a number is wrong.
What's a good current ratio?
It depends on the industry, but above 1 means current assets cover the bills due within a year. Many lenders like to see 1.2 or more. A very high ratio can mean idle cash or slow-moving inventory.
Where does net income go?
Into equity. This year's net income from the profit and loss appears in equity until year end, when it moves into retained earnings.
Related
- Fixed assets and depreciation basics
- How to record a business loan
- Year-end closing checklist
- Profit and loss template
- All free templates
General information, not tax, legal or accounting advice. Check with your accountant before relying on a template for a tax return.
AcboBooks
When the spreadsheet stops being enough
In double-entry software the balance sheet can't fail to balance, because every transaction updates both sides. AcboBooks produces it for any date from your books.
More free templates
Get started
Outgrown the spreadsheet?
AcboBooks is desktop accounting for US and Canadian small businesses. Bought once, with your company file on your own PC.
No card. No account. Nothing to cancel.