Neat Wren Studio

Home › Small business and work

Personal Trainer Business Spreadsheet UK

Run a personal training business from one file. The sessions log works out every charge, late cancellations and no-shows included, and block bookings count themselves down. A dashboard shows what to move to the tax pot.

£10.19 on EtsyUK price, VAT included. Instant download, nothing is posted.

Bought it already? Here's where your files are.

What it does

  • Logs sessions and works out every charge, including late cancellations and no-shows; a session booked on a block uses a credit
  • Counts block bookings down, showing used, left and expiry date, flagged Running low, Expires soon or Used up
  • Shows each client's session credits at a glance, and who to offer a new block
  • Tracks each client's current programme, flagged Review this week or Review overdue
  • Makes invoices with a printable A4 invoice, and sorts expenses under Self Assessment headings
  • Logs mileage at 45p for the first 10,000 business miles and 25p after (rates editable), with a 2026/27 dashboard and two charts

What you get

  • Four colourways: Pastel, Bright, Dark and Earthy
  • For each colourway: an Excel file with example numbers, a blank Excel file and a Google Sheets copy link
  • A PDF with the Google Sheets link for each colourway
  • A zip of the Excel files (.xlsx)

Good to know

  • Works in Google Sheets (free Google account needed to make your copy) and Excel 2016 or newer
  • Input cells have a coloured border; everything else is worked out and protected, with no macros to enable
  • Works on a phone in the Google Sheets app, though setting up is easier on a laptop
  • A bookkeeping aid, not tax advice: the set-aside is a budgeting estimate, so check what is allowable with official guidance or an accountant

You might also like