Skip to content
No results
  • Home
  • Shop
    • Right Sidebar
    • Left Sidebar
  • Contents
  • E-shop
  • Contact
  • Products
    • My Account
Accountant's e-shop
  • About
  • Guides
  • Blog
  • Contact
Shopping cart 0
  • Buy and download templates for:
  • Accounts
  • Car
  • CIS Scheme
  • Payroll
  • Tenancy
  • United Kingdom
  • Ireland
Accountant's e-shop
Shopping cart 0
Home Templates Accounts UK – Simple Bookkeeping Excel Spreadsheet Template
🔍
UK - Simple bookkeeping - Business details - Cash basis
UK - Simple bookkeeping - Sales - Cash basis
UK - Simple bookkeeping - Expenses - Cash basis
UK - Simple bookkeeping - Flat rate expenses Page 1
UK - Simple bookkeeping - Flat rate expenses Page 2
UK - Simple bookkeeping - Flat rate expenses Page 3
UK - Simple bookkeeping - Capital allowances Page 1
UK - Simple bookkeeping - Capital allowances Page 2
UK - Simple bookkeeping - Profit and Loss Account
UK - Simple bookkeeping - Profit and Loss - Self-employment tax return
  1. UK - Simple bookkeeping - Business details - Cash basis
  2. UK - Simple bookkeeping - Sales - Cash basis
  3. UK - Simple bookkeeping - Expenses - Cash basis
  4. UK - Simple bookkeeping - Flat rate expenses Page 1
  5. UK - Simple bookkeeping - Flat rate expenses Page 2
  6. UK - Simple bookkeeping - Flat rate expenses Page 3
  7. UK - Simple bookkeeping - Capital allowances Page 1
  8. UK - Simple bookkeeping - Capital allowances Page 2
  9. UK - Simple bookkeeping - Profit and Loss Account
  10. UK - Simple bookkeeping - Profit and Loss - Self-employment tax return

UK – Simple Bookkeeping Excel Spreadsheet Template

€9

Clear
SKU: N/A Categories: Bookkeeping, MS Excel, Templates, Accounts, New Templates, United Kingdom Tags: Accountancy spreadsheet, Accounting software, Accounting templates, Accounts Extracts, Basic bookkeeping, Bookkeeping software, Business Accounting, Capital Allowances, Cash Basis Accounting, Cash Basis Scheme, Cheap accounting, Cheap bookkeeping, Daily bookkeeping, Daybook, Doing business, Download template, Excel bookkeeping spreadsheet, Excel template, Expenses, Fixed Assets, Flat rate expenses, Forms, Income and Expenses, Income statement, Northern Ireland, Profit and Loss Account, Profit and Loss Statement, Self Assessment, Self employment, Self-employed, Simple accounting, Simple bookkeeping, Single-entry bookkeeping in excel, Small business, Sole trader, Spreadsheet, Start-up bookkeeping, Tax Return, Template for partnership, Template for self-employed, Template for sole trader, United Kingdom
  • Description
  • Additional information

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.

Spreadsheet

MS Excel, PDF

Related products

  • Contractor CIS Record Book

    UK – Contractor CIS Record Book

    €6
    • Accounts, CIS Scheme, MS Excel, Templates, United Kingdom
    Select options This product has multiple variants. The options may be chosen on the product page
  • CIS Multi Payment Deduction Statement Screenshot

    UK – CIS Multi Payment Monthly Deduction Statement

    €3
    • CIS Scheme, MS Excel, PDF, Templates, United Kingdom
    Select options This product has multiple variants. The options may be chosen on the product page
  • Vehicle Sale Agreement

    Vehicle Sale Agreement

    €3
    • Car, MS Word, PDF, Templates
    Select options This product has multiple variants. The options may be chosen on the product page
  • Car Purchase Agreement

    Car Purchase Agreement (One Page)

    €3
    • Car, Ireland, MS Word, PDF, Templates, United Kingdom
    Select options This product has multiple variants. The options may be chosen on the product page

Popular now

CIS Yearly Set Off Statement
UK – CIS Yearly Set Off Statement Template
CIS Multi Payment Deduction Statement Screenshot
UK – CIS Multi Payment Monthly Deduction Statement
UK Capital Allowances Template - Annual Investment Allowance AIA
UK – Capital Allowances Template
UK CIS Single Payment Deduction Statement Screenshot
UK – CIS Single Payment Deduction Statement Template

Topic

  • Accounts
  • CIS Scheme
  • Bookkeeping
  • Bookkeeping Spreadsheets
  • Car
  • Profit and Loss Account
  • CIS Scheme
  • Payroll
  • Financial Statements
  • Tenancy Agreement
  • Payroll
  • Car Purchase Agreement
  • Tenancy

Format

  • MS Excel
  • MS Word
  • PDF

Country

  • Ireland
  • United Kingdom

Important Links

  • Policies
  • Cookie
  • Terms & Conditions

This website uses only essential cookies, which are necessary for website functioning.

Contact Info

Acconote Limited

Registered in Ireland with registration number 688517.

  • Address: Office 2, 12A Lower Main Street, Lucan Co. Dublin, K78 X5P8, Ireland
  • Email: info@taxaccounts.ie

Copyright © 2012 - 2026 Acconote Limited, Office 2, 12A Lower Main Street, Lucan Co. Dublin, K78 X5P8, Ireland ● eMail: info@taxaccounts.ie