Excel Bookkeeping Template

Full Setup

£149.00

• Double-entry bookkeeping with UK VAT: post every transaction in GENERALENTRIES; LEDGER & TRIAL BALANCE update automatically.
• VAT workflow: record Output/Input VAT, reconcile each quarter, then clear to VAT Liability and record payments/refunds to HMRC.
• Payroll (Timesheet → Payslip): EMPLOYEETIMESHEET rolls up weekly/monthly; A5 Payslip calculates PAYE (YTD method), Employee NI (PT/UEL), and fixed pension; YTD totals included.
• Sheets included: CONFIG (tax bands, NI thresholds, employees, pension), GENERALENTRIES, LEDGER, TRIAL BALANCE, P&L, BALANCE SHEET, optional MASTER INVENTORY / STOCKTRACKER / VARIANCETRACKER, SHORTTERM LIABILITIES.
• Protected/hidden logic: input cells are unlocked; formula columns are protected. System sheets (e.g., CHART OF ACCOUNTS) are hidden and pre-configured.
• RTI filing: Excel can’t submit FPS/EPS. Use HMRC Basic PAYE Tools or recognised software; copy period totals from the workbook.

• We set it up for you: COA & VAT accounts, opening balances, tax/NI thresholds, employees, payslip print preset.
• Handover call to walk through entries, VAT clearing, and reports.

Best for VAT-registered UK businesses that want clean double-entry with payroll and optional inventory.

Guided Setup

£89.00

• Same double-entry + VAT template and payroll features as Full Setup.
• Follow the guide’s Before you start and Clearing sample data safely steps.
• Email guidance while you enter opening balances, VAT scheme, employees and pay periods.
• Reminder of protected columns and hidden system sheets.

Template Only

£59.00

• Complete workbook with GENERALENTRIES → LEDGER → TRIAL BALANCE flow and example P&L / Balance Sheet links.
• Payroll sheets (Timesheet & A5 Payslip) with PAYE/NI YTD logic included.
• Optional inventory pack and SHORTTERM LIABILITIES sheet ready to use.
• Comes with the full user guide, including VAT patterns and payslip print settings.

Full Setup

£119.00

• Designed for salons, barbers and mobile stylists.
• Service menu & stylist chair tracking (chair rent/commission).
• Tips & cash takings log with daily till reconciliation.
• Colour stock tracker (tubes/bowls) and retail product margins.
• Built-in invoice/receipt templates for retail and services.

• Full Setup: We load your stylists, services, prices and opening balances.

With Guided Setup

£69.00

• Same template as Full Setup with a setup checklist.
• Email guidance while you add services, stylists and stock.

Template Only

£49.00

• Ready-made ledgers for services, retail, tips and expenses.
• Monthly salon performance summary and stylist earnings.

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 (SKU pulls from PRICELIST) → track in INVOICE PAYMENTTRACKER (receivables/payables) and PAYMENTS RECEIVED/MADE (feeds cash totals).
• Payroll: EMPLOYEETIMESHEET (clearly marked ENTER vs AUTO columns) → A5 Payslip (Weekly/Monthly). Uses Config for tax bands, NI cat & tax code, TaxBasis (CUM/W1M1), and weekly/monthly pension amounts.
• Loans/HP: SHORTTERMLIABILITIES builds amortisation (PMT/Interest/Principal/VAT). Tick PAID? monthly and post the cash out in the Journal.
• Income Tax: quick annual estimate — enter Taxable Income only.
• Setup sheets included: Stock Tracker Settings (Cover Days, Lead Time, Safety, Order Multiple + address), Suppliers, PRICELIST, CHARTOFACCOUNTS, Config.
• Printing presets: Payslip A5 (2 per A4); Invoice/PO print areas ready; export to PDF.

• Premium extras: onboarding checklist + email guidance while you complete first-time setup (Config bands, employees, PRICELIST, Suppliers, Stock settings).

Standard Package

£49.00

• Same full workbook as Premium (cash-basis Journal → Ledger → P&L, Inventory/Reorder/PO, Invoice & Payment tracking, Timesheet → Payslip, Short-term Liabilities, Income Tax).
• 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: GENERALENTRIES, LEDGER, PNL, Inventory, ReorderList, PurchaseOrder, Invoice, INVOICE PAYMENTTRACKER, PAYMENTS RECEIVED/MADE, EMPLOYEETIMESHEET, Payslip, SHORTTERMLIABILITIES, Income Tax.
• Includes the user guide with copy-ready formulas (e.g., Month helper, Inventory Reorder Qty) 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

£39.99

• What it does: Tracks hours → calculates Gross, PAYE, Employee NI, fixed Pension and Net pay; supports Weekly or Monthly pay with YTD totals. Produces a clean, print-ready A5 payslip. Works offline in Excel.
• Config (set once per tax year): enter tax bands/rates (PersonalAllowance, BasicUpperTaxable, HigherUpperTaxable, BasicRate, HigherRate, AdditionalRate), NI thresholds/rates (NI_PT_Wk/Mth, NI_UEL_Wk/Mth, NI_MainRate, NI_UpperRate), employees (Name, NI No, NI Cat, Tax Code, Tax Basis CUM/W1M1) and your fixed weekly/monthly pension amounts.
• EMPLOYEETIMESHEET (enter daily time): Enter: Employee • Date • Start/End time • Hourly rate • (optional) Deductions. Auto: Week No/Start, daily/weekly hours, weekly & monthly pay, PAYE, NI, pension. Note: period totals show only on the last row of the week/month per employee (blanks elsewhere are by design).
• Payslip (A5, print-ready): B4 Employee → D4 Weekly/Monthly → F4 pick Week start (Mon) or H4 pick Month (month-end date). Slip fills Gross, PAYE, Employee NI, Pension, other deductions (sum), Net, and YTD Gross/PAYE/NI.
• Printing: A5, Portrait, Fit to 1 page, Narrow margins. For two slips per A4: export to PDF → print “2 pages per sheet”.
• Important (RTI): Excel can’t submit RTI (FPS/EPS). File via HMRC Basic PAYE Tools (free) or HMRC-recognised payroll software.

• 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

£49.99

• What it does: Tracks delivery income and costs by vehicle and driver, calculates VAT, and builds automatic Ledger and P&L reports. Includes dropdowns for clients, suppliers, VAT codes, vehicle registration, and driver ID.
• Setup: Configure VAT scheme and rates, add vehicles, drivers, clients, and suppliers, then start entering your day-to-day records.
• 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 or special cases.
• Works with: Microsoft Excel 2016 or Microsoft 365 on Windows and Mac. Not designed for Google Sheets or Apple Numbers.

• 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.