Finance template
Balance sheet
Compare assets, liabilities and equity at two year ends with changes and key ratios. A check line confirms that the sheet balances.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
1 sheet
- Balance sheet
81 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 170 filled cells in all.
Built in
- Conditional formatting
- Frozen headers
- 3 conditional format rules
A look at the Balance sheet sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Balance sheet | |||||||
| 2 | As of December 31. Enter both years in the yellow cells. | |||||||
| 3 | ||||||||
| 4 | TOTAL ASSETS | TOTAL LIABILITIES | EQUITY | CURRENT RATIO | STATUS | |||
| 5 | $743,550 | $329,900 | $413,650 | 2.8x | Balanced | |||
| 6 | ||||||||
| 7 | ||||||||
| 8 | Dec 31, 2025 | Dec 31, 2026 | Change | Change % | ||||
| 9 | Current assets | |||||||
| 10 | Cash and equivalents | $ 142,300 | $ 186,900 | $ 44,600 | 31.3% | |||
| 11 | Accounts receivable | $ 98,400 | $ 112,750 | $ 14,350 | 14.6% | |||
| 12 | Inventory | $ 76,200 | $ 81,400 | $ 5,200 | 6.8% | |||
- balance sheet
- accounting
- ratios
- assets
More finance templates
FinancePersonal monthly budgetPlan income and spending for the month and see what is left at a glance. Compare planned and actual amounts by category with a chart.
FinanceInvoice trackerTrack every invoice you send, what has been paid and what is overdue today. An aging summary groups open balances by how late they are.
FinanceBreak-even analysisFind how many units you need to sell to cover fixed costs, and what it takes to hit a profit goal. A chart shows revenue crossing total cost.
FinanceCap tableModel ownership through seed and Series A rounds with share prices worked out from each pre-money valuation. See fully diluted ownership and a simple payout at an exit value.
Start your balance sheet now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.