Bookkeeping Template for Excel (Free Excel)
A free bookkeeping ledger for small businesses. Log every transaction and see a running balance and totals by category.
Download the free Excel template (.xlsx)
Free. No email or sign-up needed. One Excel file, 3 sheets.
What is inside the bookkeeping template
| Sheet | What it does |
|---|---|
| Ledger | 300 transaction rows with date, description, category, account, income and expense and a running balance from your opening balance. |
| Summary | Income, expense and net by category, a check that every transaction is categorised, closing balance and a chart. |
| Read me | Short instructions. |
Yellow cells are for your own numbers and text. Green cells calculate by themselves, so do not type over them. Sample data is included so you can see how it works, then replace it with your own.
How to use it
- Download the file and open it in Excel 2010 or later. It also opens in Google Sheets and LibreOffice.
- Replace the sample data in the yellow cells with your own.
- Read the totals and results that update automatically.
- Save a copy for each month, project or client, or print it from File > Print.
The template is free to use and edit. If you want a version built around your own process, with your branding, extra sheets or automation, tell us what you need.
Free pricing tips for your business
Get short, practical tips on pricing jobs and using our free calculators. No spam, unsubscribe any time.
Frequently asked questions
Can I do bookkeeping in Excel?
For a very small business, yes. Log each transaction and categorise it.
What categories should I use?
Sales, rent, software, marketing, supplies, travel, wages and other, or match your tax return.
How do I know the summary is complete?
The check cell shows OK when every transaction is in a listed category.
Is this accounting advice?
No. It is a simple record keeping template. See an accountant for tax filing.
Need a custom spreadsheet built for your business?
Talk to usMore free tools: All free Excel templates · Income and expense template · Profit and loss template · Balance sheet template