Simple Business Bookkeeping System; Plug-and-Play Excel for UK Business Owners

Whether you run a cleaning company, a care business, a food operation, a recruitment agency, or sell products online, this spreadsheet was built for you.

Most new business owners either don’t track their finances at all, or use a messy mix of notes and bank statements come tax time. This tool gives you a professional, organised system from day one, one that your accountant can actually use to help you file.

What’s inside:

📅 12 Monthly Tabs (January to December)

Each month includes a clean section for Money In, Money Out, Invoices Sent, Upcoming Bills, Staff Wages, and a simple Profit & Loss summary, all on one scrollable sheet.

📊 Annual Dashboard

See your full year at a glance. Total income, total expenses, net profit, profit margin, and outstanding invoices, all auto-calculated. No formulas to write.

📋 Invoice Tracker

Log every invoice you send. The sheet automatically flags which ones are unpaid, partial, or overdue and shows you your total outstanding at all times.

🧾 Upcoming Bills

Never miss a payment. Log what you owe, when it’s due, and mark it paid when done. Auto-calculates what’s still outstanding.

👷 Staff & Wages

Track gross pay, deductions, and net pay for up to 6 staff per month. Leave blank if you have no employees yet.

⚠️ VAT Threshold Monitor

Even if you’re not VAT registered, the dashboard quietly tracks your running annual income against the £90,000 threshold and alerts you when you’re getting close.

Works for:

✅ Service businesses (cleaning, care, consulting, recruitment)

✅ Product businesses (food, retail, imports, e-commerce)

✅ Digital businesses (coaching, design, content creation)

✅ Any sole trader or limited company in the UK

File details:

∙ Format: Microsoft Excel (.xlsx)

∙ Compatible with: Excel (Mac & PC), Google Sheets

∙ Colour-coded: Blue cells = you type · Green cells = auto-calculated

∙ Zero formula errors; everything works straight out of the download

WHAT YOU GET:

∙ Readme Bookkeeping System

• 1 × Excel file (.xlsx)

∙ 14 sheets (Settings, Dashboard, 12 monthly tabs)

∙ Dropdown menus for all categories; no typing errors

∙ Instant download after purchase