Photography Business Spreadsheet UK | Shoot Tracker, Deposits and Balances, Gallery Dates, Gear List, Tax Set-Aside (Google Sheets & Excel)

Seller's description

A UK spreadsheet that runs a photography business from one file: shoots, deposits, gallery dates, gear and tax set-aside. You get a PDF with Google Sheets copy links plus Excel files, for Google Sheets (free) or Excel. For photographers who work for themselves in the UK. If it doesn't work on your device, we fix it or refund you.

PHOTOGRAPHER BUSINESS HUB UK: run a photography business from one file. Clients; shoots that price themselves from your packages, with the deposit and the balance, their due dates and when each was paid; gallery due dates that flag themselves; a gear register for insurance; invoices with a printable A4 invoice; expenses under Self Assessment headings; mileage; and a dashboard with what to move to the tax pot.

FOUR COLOURWAYS, ALL INCLUDED
- Pastel: a soft pastel rainbow, each tab and category in its own pastel.
- Bright: bold, saturated colour blocks.
- Dark: deep navy with glowing accents, easy on the eyes.
- Earthy: sage, sand and terracotta.
Each colourway comes as an Excel file with example numbers, a blank Excel file and its own Google Sheets copy link. The formulas are identical, so pick the look you like (or switch later).

WHAT IT DOES
- Packages: hours, edited images, price, deposit % and gallery time for each one, plus extras such as prints and albums, all editable
- Shoots: pick the client, package, location and status (enquiry, booked, shot, delivered, cancelled with the deposit kept or refunded); extras and discounts; total, deposit and balance worked out
- Balance due by a number of days before the shoot (your choice), with Deposit due, Balance due, Balance overdue, Paid in full or Deposit kept
- Gallery due date from the package, flagged Editing, Due soon or Late until you type the date delivered
- Clients: shoots, booked value, not paid yet, how they found you and whether image consent is signed (yes or no)
- Gear register: cost, serial number, what to insure it for, in use, spare or sold
- Invoices for business clients: separate deposit and balance invoice numbers, amount, paid, status and days overdue; printable A4 invoice
- Expenses: pick a category and the sheet knows if it is allowable and which Self Assessment heading it goes under
- Mileage log at HMRC's 45p for the first 10,000 business miles and 25p after, rates editable
- Working from home: HMRC's flat rate (£10, £18 or £26 a month by hours) if you use it, editable
- Dashboard for 2026/27: income received, booked, not paid yet, expenses, mileage, profit, tax set-aside at your own %, what to move to the tax pot, Self Assessment totals by heading, and two charts
- Colour means something: each tab has its own colour, categories keep their colour in the tables and the charts, and green, amber and red show good news, keep an eye on it, and over or overdue, always with a word as well. Text on every coloured fill meets the WCAG AA contrast level.

TABS
- Start here: five small steps
- Dashboard
- Clients
- Shoots
- Packages
- Gear
- Invoices
- Invoice (printable A4)
- Expenses
- Mileage log
- Settings (your details, tax %, balance due days, lists)
- Notes
- Export to Calm Money

WORKS WITH THE CALM MONEY APP
The last tab, Export to Calm Money, turns your paid income and your expenses into one CSV that our Calm Money budget app imports in a tap, so business and home money sit side by side. The Calm Money app is sold separately in this shop.

GOOGLE SHEETS AND EXCEL, BOTH INCLUDED
Input cells (they have a coloured border) are yours to type in; everything else is worked out for you, so a stray click cannot break a formula (locked in Excel; Google Sheets asks before you edit a worked-out tab). No macros, nothing to enable. Works on a phone in the Google Sheets app; setting it up is easier on a laptop. A bookkeeping aid, not tax advice: the set-aside is an estimate for budgeting, and HMRC's guidance or an accountant confirms what is allowable for you.

HOW YOU GET IT
From your Etsy downloads page (open etsy.com in a web browser, not the Etsy app):
- A PDF with a Google Sheets link for each colourway: tap the one you like and choose Make a copy (free Google account needed).
- A zip with the Excel files (.xlsx) for every colourway, for Excel 2016 or newer.
- A blank version of each, ready for your numbers, and an example version so you can see how it works first.
Not editable in the Etsy app; use a browser or the Google Sheets or Excel apps.

BUY TWO OR MORE: use code PICK2 at checkout for 20% off any two or more items from the shop, until 31 January 2027.

Google Sheets and Excel are trademarks of their owners, who do not make or endorse this product.

INSTANT DIGITAL DOWNLOAD. Nothing is posted. Open your download from etsy.com in a web browser, not the Etsy app. If it doesn't open, doesn't work on your device or isn't as described, message us and we will fix it or refund you. This does not affect your legal rights.
Personal use only. Please do not share, resell or redistribute the files or the link.
Stuck? Message the shop with a screenshot and a person replies within a day.

Designed and built by Neat Wren Studio.