Home›Templates›Accounting & Small Business Spreadsheets›Balance Sheet
Preview of the Balance Sheet template

Sample text in [brackets], replace with yours · Accounting & Small Business Spreadsheets

Free template

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.

✓ A4✓ Auto totals✓ Balance check✓ Excel & PDF

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. 1

    Click "Edit online", or download the Excel file.

  2. 2

    Set the "As at" date, usually the last day of your financial year.

  3. 3

    Enter closing balances for cash, bank, debtors, stock and fixed assets, with accumulated depreciation as a negative.

  4. 4

    Enter creditors, loans and tax payable, then capital, opening retained earnings, this year's net profit and drawings.

  5. 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

Yes. Download the Excel or PDF version, or edit it online for free, with no signup and no watermark.

Assets = Liabilities + Equity. The check line uses it to tell you whether your figures balance.

Yes. Use the capital, drawings and net profit lines for the owner's or partners' accounts.

No. Companies filing statutory accounts must follow their country's rules (such as Schedule III in India or IFRS). This is a simple management format.

Tools that help

📗

Excel to PDF

Convert Excel spreadsheets to PDF with all sheets preserved

Use Tool→
📊

PDF to Excel

Extract tables from PDF into editable Excel spreadsheets

Use Tool→
%

Percentage Calculator

Calculate percentages, increase, decrease, and ratios

Use Tool→
💱

Currency Converter

Convert between 150+ world currencies with live rates

Use Tool→

More accounting & small business spreadsheets

Expense Report template preview

Expense Report

Claim business expenses with category totals and advances.

ExcelPDF
Inventory / Stock Sheet template preview

Inventory / Stock Sheet

Stock in, stock out, closing stock and reorder alerts.

ExcelPDF
Monthly Business Budget template preview

Monthly Business Budget

Budget vs actual for income and expenses, with profit.

ExcelPDF
Cash Book template preview

Cash Book

Daily cash in and out with a running balance.

ExcelPDF
Price List template preview

Price List

Products and services by category, with discounts.

ExcelPDF
Daily Sales Report template preview

Daily Sales Report

Bills, payment methods and end-of-day cash check.

ExcelPDF
Salary Sheet (Payroll) template preview

Salary Sheet (Payroll)

Monthly payroll for all staff: gross, deductions, net pay.

ExcelPDF
Project Plan (Gantt Chart) template preview

Project Plan (Gantt Chart)

Tasks, owners, dates and a 12-week Gantt chart.

ExcelPDF
Income & Expense Tracker template preview

Income & Expense Tracker

Small business money in and out, running balance, profit by category.

ExcelPDF
Profit and Loss Statement template preview

Profit and Loss Statement

Income statement with gross, operating and net profit.

ExcelPDF
Trial Balance template preview

Trial Balance

Every ledger balance in debit and credit, with totals that must agree.

ExcelPDF
Trading Account template preview

Trading Account

Dr/Cr trading account that works out gross profit or gross loss.

ExcelPDF
Cost Sheet template preview

Cost Sheet

Prime cost to sales, with cost per unit at every level.

ExcelPDF
Cash Flow Statement template preview

Cash Flow Statement

Indirect-method cash flow: operating, investing and financing.

ExcelPDF
Bank Reconciliation Statement template preview

Bank Reconciliation Statement

Match the cash book to the bank statement, with an automatic check.

ExcelPDF
Ledger template preview

Ledger

Ledger account with running Dr/Cr balance, plus a T-format sheet.

ExcelPDF