Excel Bookkeeping Templates UK | Self Assessment Tax Return Calculator

Full Setup

£149.00

• Complete double-entry accounting system: enter transactions in ‘GENERALENTRIES’; the ‘LEDGER’, ‘TRIAL BALANCE’, P&L, and ‘BALANCE SHEET’ update automatically.
• Smart invoice & payment tracking: invoices are issued and tracked with automatic payment matching, overdue highlighting, balances, and overpayments.
• Automated payroll system (Timesheet → Summary → Payslip): employees log hours in ‘EMPLOYEETIMESHEET’; the system calculates weekly/monthly pay, PAYE (YTD method), Employee NI, pension, and deductions. Payroll summaries generate clean totals ready for posting into accounts.
• Payroll accounting ready: automatically separates gross wages, PAYE, NI, pension, and net pay — making it easy to post accruals and clear liabilities (HMRC, pensions, wages payable).
• VAT-ready workflow: track input/output VAT, reconcile returns, and post directly to VAT liability with clear audit trail.
• Inventory & price list integration: manage products, suppliers, categories, and cost prices in ‘PRICELIST’; inventory sheets auto-populate when items are selected.
• Fully integrated system:‘GENERALENTRIES’ → ‘LEDGER’ → ‘TRIAL BALANCE’ → financial statements, with payroll, VAT, and inventory all feeding into accounts.
• Sheets included:‘CONFIG’, ‘GENERALENTRIES’, ‘LEDGER’, ‘TRIAL BALANCE’, P&L, ‘BALANCE SHEET’, ‘EMPLOYEETIMESHEET’, ‘PAYROLLSUMMARY’, ‘PAYROLLEXPENSES’, ‘SHORTTERM LIABILITIES’, ‘ASSETDEPRECIATION’, optional ‘INVENTORY’ tools.
• Protected & automated: input areas are user-friendly; formulas, calculations, and system logic are protected and pre-configured.
• RTI reminder: Excel does not submit FPS/EPS. Use HMRC Basic PAYE Tools or recognised software — totals are ready to copy.

• We set everything up for you: chart of accounts, VAT structure, payroll settings, tax thresholds, employees, and opening balances.
• 1-to-1 handover: walkthrough of payroll, VAT, invoicing, and double-entry posting so you understand exactly how it flows.

Ideal for UK businesses that want a fully controlled, transparent bookkeeping system — without monthly software subscriptions.

Guided Setup

£109.00

• Same complete system including double entry, VAT, payroll, and inventory features.
• Step-by-step guidance to configure your business (VAT, payroll, opening balances, employees).
• Email support while setting up your workbook.
• Clear instructions on using payroll summaries, liabilities, and posting into accounts.

Template Only

£79.00

• Full Excel system with automated GENERALENTRIES → LEDGER → TRIAL BALANCE flow.
• Built-in payroll system with timesheets, summaries, and payslip calculations (PAYE, NI, pension).
• Invoice tracking, VAT structure, and optional inventory tools included.
• Ready-to-use financial statements and liability tracking.
• Includes full user guide with setup and workflow instructions.

Full Setup

£129.00

• Built on the same bookkeeping structure as the VAT Registered Business Edition, with double entry bookkeeping, VAT recording, ledger, trial balance and reporting.
• Salon-specific stock tracking: designed for colour, products and treatment stock, with a different stock tracking system better suited to hair and beauty businesses.
• Appointments and bookings tracking: record bookings by service, employee and date.
• Employee and chair tracking: track services completed by each stylist, rental chair use, chair rent and related salon income.
• Service and appointment management: monitor services booked, appointment activity and salon performance alongside bookkeeping records.
• Includes user guide and built-in workbook structure for salon bookkeeping and operations.

• Full Setup: We load your stylists, services, prices, opening balances and salon setup details for you.

With Guided Setup

£89.00

• Includes the same salon bookkeeping workbook as Full Setup, based on the VAT Registered template structure.
• Includes the salon stock tracker, bookings tracker, appointments tracking and employee/chair rental tracking features.
• Email guidance while you add your services, stylists, prices, stock items and booking setup.

Template Only

£69.00

• Salon bookkeeping workbook based on the VAT Registered template, adapted for salons, barbers and mobile stylists.
• Includes bookkeeping sheets, salon stock tracking, bookings tracking, appointments tracking, employee performance tracking and rental chair tracking.
• Ready-made structure for services, retail products, salon activity and business reporting.

Premium Package

£59.00

• Cash-basis workflow:GENERALENTRIES → LEDGER → PNL. Enter all cash In/Out (dd/mm/yyyy); running bank balance and monthly P&L update automatically.
• Inventory & Reorders:Inventory with Method (Reorder Point or Min Max), Reorder? (TRUE/FALSE), target level, order multiple → auto ReorderList → printable PurchaseOrder.
• Sales & collections: printable Invoice → track in INVOICE PAYMENTTRACKER and PAYMENTS RECEIVED/MADE.
• Payroll:EMPLOYEETIMESHEET → A5 Payslip with tax bands, NI, tax code and pension settings.
• Loans/HP:SHORTTERMLIABILITIES builds amortisation.
• Income Tax: quick annual estimate — enter Taxable Income only.
• Setup sheets included:Stock Tracker Settings, Suppliers, PRICELIST, CHARTOFACCOUNTS, Config.
• Printing presets: Payslip A5; Invoice/PO print areas ready; export to PDF.

• Premium extras: onboarding checklist + email guidance while you complete first-time setup.

Standard Package

£49.00

• Same full workbook as Premium.
• Follow the built-in Quick start (5 minutes) steps and first-time setup notes in the user guide.
• All protected headers/helpers and print areas are pre-configured.

Template Only Package

£39.00

• Download-and-use workbook with the complete cash-basis toolset.
• Includes the user guide with copy-ready formulas and tips/troubleshooting.

Template Only

£25.00

• Weekly and daily calendar views with time blocks.
• Service duration, staff allocation and no-show tracker.
• Automatic daily totals and capacity utilisation.
• Works nicely alongside the Hairdresser Bookkeeping template.

Template Only

£59.99

• What it does: Tracks hours → calculates Gross, PAYE, Employee NI, fixed Pension and Net pay; supports Weekly or Monthly pay with YTD totals.
• Config: enter tax bands/rates, NI thresholds/rates, employees and pension amounts.
• EMPLOYEETIMESHEET: enter daily time, date, rate and deductions; totals calculate automatically.
• Payslip: print-ready A5 layout.
• Printing: export to PDF for two slips per A4.
• Important (RTI): Excel can’t submit RTI.

• Scope: Weekly/Monthly pay, PAYE, Employee NI, fixed Pension, YTD totals, print-ready payslips.
• Not included: RTI submission, Employer NI, pension-provider upload files, auto-enrolment comms, multi-user concurrency.

Template Only

£79.99

• What it does: Tracks delivery income and costs by vehicle and driver, calculates VAT, and builds automatic Ledger and P&L reports.
• Setup: Configure VAT scheme and rates, add vehicles, drivers, clients, and suppliers.
• Journal & records: Record sales, purchases, fuel, mileage, and delivery-related expenses with automatic VAT, gross, and net calculations.
• Reports: Includes VAT Return, Ledger, Profit & Loss, and summary reports by vehicle and by driver.
• Extras: Optional RateCard for pricing and an Invoice sheet for direct client work.
• Works with: Microsoft Excel 2016 or Microsoft 365 on Windows and Mac.

• Scope: Delivery income and expense tracking, VAT calculations, fleet and driver records, mileage and fuel logging, Ledger, P&L, and VAT Return reporting.
• Not included: HMRC submission, tax advice, accounting advice, or support for Google Sheets / Apple Numbers.