Google Sheets Templates for a Photography Business

A Google Sheet can run a small photography business if you keep three tabs and update them the same day: leads, bookings and expenses. It stops being enough when several people edit it, payments arrive in instalments or you want contracts and invoices sent from the same place. Here are the layouts that work, and the signs it is time to move on.

Leads sheet

One row per inquiry. Columns:

Use data validation on Status so you can only pick from a list. Add conditional formatting that turns the follow-up cell red when the date has passed. A filter view called "Needs follow-up" shows rows where the date is today or earlier.

The most valuable habit is replying quickly and logging it. Our post on responding to a photography inquiry explains what a good first reply contains.

Bookings sheet

One row per confirmed job, or one row per event if a client books several.

• Client name and project name.
• Event date and venue.
• Package and add-ons.
• Total price.
• Amount paid so far, amount due and next payment date.
• Crew assigned.
• Delivery deadline and status.

Use a formula for balance: total minus paid. Another for status, such as "Overdue" when the next payment date is before today and the balance is above zero. Keep payments on their own tab, one row per payment with job name, amount, date and method, and use SUMIF to total them against each booking.

Expenses sheet

One row per cost: date, amount, category, job (if it belongs to one), vendor and a receipt link. Categories could be gear, travel, crew, software, marketing and tax.

With a job column filled in, you can calculate profit per job on a summary tab: price minus crew cost minus direct expenses. The post on profit per job walks through it. If you work in a country with VAT, sales tax or GST, record the tax separately and confirm treatment with a local accountant; for a UK example, see VAT for photographers.

Limits

Honest drawbacks:

• Shared editing. Two people on the same row at the same time cause errors. Version history helps but does not prevent them.
• No reminders to clients. A sheet cannot send a payment reminder or a day-before message.
• Everything is visible. Share the sheet with a second shooter and they can see all prices unless you hide tabs, and even hidden tabs are not secure.
• Dates are manual. If an event moves, you re-type every date linked to it.
• No client experience. The proposal, contract and invoice live elsewhere.
• Accuracy depends on you. Formulas break when someone inserts a column.

When to switch

Switch when one of these happens:

• You miss a follow-up or a payment because the sheet did not tell you.
• You spend an hour a week copying the same details between documents.
• You hire an editor or second shooter and need to keep prices private.
• You want the client to pick a package and sign on a phone.

Moving is not hard. Clean your columns, export to CSV, import a small batch and check it. Our import guide has the steps, and Sprout Studio alternatives and the best CRM for photographers list tools to consider.

ClickBook accepts imported clients and gives you a lead list with reply tracking, proposals, contracts, payment plans that follow the event date, invoices, crew and the edit queue. You can book a demo and bring your sheet with you.

Tips for the sheet period

Name tabs plainly, freeze the header row, use one date format everywhere and never merge cells. Keep a "Read me" tab explaining each column, so you or a helper can understand it in six months. Back up by making a copy each month. These habits make the move to a CRM far easier, because clean data imports cleanly.

Habits that keep a sheet reliable

Update it the same day, every day. Record a payment when it arrives, not at the end of the month. Log every reply with the date, because that single habit tells you how fast you really answer. Colour only for meaning, such as red for overdue. Put a short note in the first row of each tab saying what belongs there. Lock the header rows and protect formula columns so they are not typed over by accident. And finally, schedule a monthly ten-minute check where you compare the bookings sheet with your bank statement, to catch any payment you forgot to record.

A starter formula set

Use COUNTIF to count leads by status, SUMIF to total payments by job, and a simple IF to flag a follow-up date in the past. These three formulas cover most of what a small studio needs from a sheet. Keep them on a summary tab so you can see leads waiting, money outstanding and jobs overdue in one glance each Monday.

Frequently asked questions

Is Google Sheets good enough to run a photography business?

For a small number of bookings, yes. It is free, familiar and flexible. It gets harder when several people edit, payments come in instalments or you need client-facing contracts.

What columns should a leads sheet have?

Name, contact, source, event date, venue, budget, status, owner, first contact date and next follow-up date. Keep statuses to a short fixed list.

Can Sheets calculate profit per job?

Yes, if you record price, expenses and crew cost against each job. It takes discipline to keep updated.

How do I move a sheet into a CRM?

Clean the columns, export to CSV, map the columns to the CRM fields and import a small batch first to check the result.