Sample text in [brackets], replace with yours · Accounting & Small Business Spreadsheets
Balance Sheet Format (Excel & PDF)
A simple balance sheet for a small business or firm: assets, liabilities and capital for two years, with a check that it balances.
Opens in your browser. No Excel needed, no signup.
Free for personal and commercial use · No watermark · Updated November 2026
Guide
About this balance sheet template
A balance sheet shows what a business owns (assets), what it owes (liabilities) and what belongs to the owners (equity or capital) on one date. The two sides must always be equal: assets = liabilities + equity. This Excel format lists the usual heads for a small business, sole proprietor or partnership, totals each section, compares this year with last year, and shows "Balanced ✓" when the two sides agree, or the exact difference when they don't.
How to prepare a balance sheet
- 1
Click "Edit online", or download the Excel file.
- 2
Set the "As at" date, usually the last day of your financial year.
- 3
Enter closing balances for cash, bank, debtors, stock and fixed assets, with accumulated depreciation as a negative.
- 4
Enter creditors, loans and tax payable, then capital, opening retained earnings, this year's net profit and drawings.
- 5
Check the line at the bottom. If it shows a difference, look for a missing balance or a figure on the wrong side.
Tips for a balance sheet that balances
Start from the trial balance
Take every closing balance from your trial balance so nothing is missed.
Use the P&L figure
Net profit for the year comes from your profit and loss statement and links the two reports.
Current vs non-current
Anything due or usable within 12 months is current; everything else is non-current.
Drawings reduce capital
Money the owner takes out for personal use is shown as a deduction from equity, not as an expense.
Frequently Asked Questions
Tools that help
Excel to PDF
Convert Excel spreadsheets to PDF with all sheets preserved
PDF to Excel
Extract tables from PDF into editable Excel spreadsheets
Percentage Calculator
Calculate percentages, increase, decrease, and ratios
Currency Converter
Convert between 150+ world currencies with live rates















