Open Sheets UK Business Tools
16 Free UK Bookkeeping Spreadsheets + 8 Guides

Free Bookkeeping
Spreadsheets & Guides

Free, professional Excel spreadsheets and plain-English guides designed for UK small business owners, sole traders, and landlords. No subscriptions. No jargon.

16

Free Templates

8

In-Depth Guides

0

Cost to You

100%

Open & Free

Built For

Sole Traders Self-Employed Landlords Freelancers Small Businesses Startups Contractors

Most Popular Templates

These are the spreadsheets our community downloads most. Start with one of these and take control of your business finances today.

Popular

Cash Book & Income Tracker

Track income and expenses month by month with automatic running balance, bank reconciliation, and profit summary.

Popular

Cash Book with Balance Sheet

Everything in the Cash Book plus a full Balance Sheet to track assets, liabilities and your business net worth.

Popular

Self-Employed Income & Expense Log

Designed for sole traders and freelancers. Simple transaction list that auto-summarises into HMRC-friendly categories.

Why Simple Spreadsheets
Beat Complex Software

No Monthly Subscription

Save £15-£40 every month. Our templates are completely free. Excel or Google Sheets is all you need.

You Own Your Data

Your financial data stays on your computer. No cloud servers, no risk of service shutdowns, no privacy concerns.

Built for UK Tax

Unlike generic templates, ours use HMRC expense categories, UK VAT calculations, mileage rates, and SA103/SA105 box numbers.

Learn as You Go

Spreadsheets show you how the calculations work. Understanding your numbers makes you a better business owner.

📊

16

Templates

📖

8

Guides

🔢

1,800+

Formulas

All

HMRC Categories

Total Value

£0.00

Everything here is completely free

For Landlords

Rental Property Tracking Made Simple

Managing rental properties comes with unique financial complexities. Our property tracker is built specifically for UK landlords with HMRC SA105 categories built in.

  • Track up to 5 properties in one workbook
  • Mortgage interest tax relief calculated at 20%
  • Section 24 restrictions built in automatically
  • Annual summary ready for your tax return
  • MTD quarterly update template available
Making Tax Digital

MTD Is Coming.
Are You Ready?

From April 2026, landlords and self-employed people with income over £50,000 must submit quarterly updates to HMRC digitally. Our guides explain what you need to do and when.

April 2026

MTD for Income Tax starts (income over £50k)

April 2027

Threshold drops to £30,000

April 2028

Threshold drops to £20,000

Read the MTD Guide

Frequently Asked Questions

Quick answers to common questions. For more detail, read our guides.

Ready to Get Started?

Download your first template in under a minute. No email required, no account to create. Or read our guides to learn the essentials first.