This is a simple bookkeeping (accounts) excel spreadsheet template suitable for self-employed, sole traders and partnerships in United Kingdom and Northern Ireland.
The template is based on Cash basis method of book-keeping. It is created on the basis of UK government guides for Cash basis and keeping business records.
Template consist of 6 pages/tables: business details, sales, expenses, flat rate expenses, capital allowances and income statement.
6 steps to get through to your accounts for a year.
1. Step – fill in your business details,
2. Step – fill in your sales/income,
3. Step – fill in your expenses,
4. Step – fill in your flat rate expenses, if you want to use this method (for vehicle, working from home, living at your business premises),
5. Step – fill in your capital allowances for a business car, if you haven’t used flat rate expenses for particular car,
6. Step – sign your income statement (Profit and Loss Account), it is prefilled with details you completed in previous tables.
Excel file have many formulas which help you with calculation and many pre-filled cells.
Template is available for MS Excel 2007 Onward (size: 57 KB) and it was lastly updated in June 2025.
Helpful links:
UK Cash Basis information.
Guide how to do simple bookkeeping and how to use this template.
Simple Bookkeeping Template for businesses in Ireland.
Complex Bookkeeping Template for experienced accountants and practices.




























