Neat Wren Studio

Home › Small business and work

Photography Business Spreadsheet UK

Run a photography business from one file. Shoots price themselves from your packages, with the deposit, the balance and when each was paid. 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

  • Prices each shoot from your packages and works out the total, deposit and balance, with the balance due a set number of days before the shoot
  • Flags gallery due dates as Editing, Due soon or Late until you type the date delivered
  • Tracks clients: shoots, booked value, what is not paid yet, how they found you and whether image consent is signed
  • Keeps a gear register with cost, serial number and what to insure it for, plus invoices with a printable A4 invoice
  • Sorts expenses under Self Assessment headings and logs mileage at 45p for the first 10,000 business miles and 25p after (rates editable)
  • Shows a 2026/27 dashboard with income, profit, tax set-aside at your own % 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