Photography Client & Session Tracker Spreadsheet: Inquiry to Final Payment

You know how many shoots you did last month. You probably don’t know, without checking, how many of those shoots are still carrying an unpaid balance, which inquiry from three weeks ago never got a follow-up, or what your actual profit was after the second-shooter fee, the gas, and the print lab.

That isn’t a discipline problem. It’s a structure problem. A photography business generates information in six different places — the DMs where inquiries arrive, the calendar where shoots live, the payment app where deposits land, the editing queue, the gallery host, and the bank account — and none of those six systems talks to the other five. The tracker’s job is to be the one place where all six become the same row.

This is how to build that, what belongs in each tab, and where the money actually leaks.

The six-stage pipeline everything hangs off

Every photography job moves through the same six states, and each transition is a specific failure point:

Almost every photographer tracks stage 3. Almost nobody tracks the gap between stage 1 and stage 2, or the gap between stage 3 and stage 6. Those two gaps are where the money is.

A single Stage column with those six values turns your client list into a business report. Sort by stage and you instantly have three lists you couldn’t produce before: everyone who needs a follow-up, everyone who owes you money, and everyone waiting on a gallery.

The tabs, and what each one actually does

You need seven working tabs. Fewer and you’ll cram unrelated data together; more and you’ll stop maintaining it.

1. Setup & Pricing

Everything that repeats lives here once: your package menu with prices, your standard deposit (flat amount or percentage), your expense categories, your mileage rate, and your monthly booking and revenue goals.

This tab exists so that when you raise prices, you change one cell instead of hunting through 60 rows. Every other tab should read from it.

2. Client Pipeline (the CRM)

One row per lead, not per shoot — a client who books you three times is one relationship with three sessions.

Lead source is the column people skip and later wish they hadn’t. After 30-40 inquiries it tells you, with no guesswork, whether the hours you spend on Instagram produce bookings or whether every paying client actually comes from two venues and a wedding planner. That answer changes how you spend your week.

3. Session Calendar

One row per shoot. Date, start time, duration, location, travel distance, package booked, package price, deposit amount, deposit date, balance due, balance due date, balance paid date, second shooter, and the client’s name to link it back to the pipeline.

The one formula that matters: Balance due = Package price − Deposit received. It sounds trivial. It’s the difference between knowing your outstanding receivables at a glance and reconstructing them from bank statements twice a year.

4. Income & Expenses

Every dollar in and out, with a category column that matches your Setup tab list. Income rows come from deposits, balances, print orders and session fees. Expense rows cover gear, software subscriptions, insurance, second shooters, props, travel, print lab costs, marketing and studio rent.

Add a mileage section — date, purpose, miles — because for most photographers the vehicle deduction is one of the largest ones available, and it’s also the one most often abandoned for lack of a log.

5. Gallery & Delivery

Session, edit deadline, editing status, date gallery sent, gallery link, expiry date, print order placed, print order value.

The reason this deserves its own tab rather than a column on the calendar: the delivery clock runs on a completely different schedule from the shooting clock. You can have a light shooting week and a brutal delivery week, and you will not see that coming unless deadlines are listed somewhere you can sort by date.

6. Tax Summary

Income and deductible expenses totalled by category, plus the mileage deduction. This is a reporting tab — it should contain almost no typing, just sums pulling from the Income & Expenses tab.

7. Dashboard

Revenue year to date, expenses, net profit, sessions booked against goal, outstanding balances, and revenue by shoot type. All formulas. If you’re typing on the dashboard, something upstream is wrong.

A worked month

Here is a full month for an illustrative portrait photographer. Every figure is an assumption for this example — your packages, your rates, your costs. The point is the arithmetic, not the numbers.

Setup assumptions: Mini package $250, Standard portrait $475, Extended family $650, Brand session $900. Deposit is 30% of package, non-refundable, due to hold the date. Balance due the day before the shoot.

Booked revenue: $3,400. Collected: $2,315. Outstanding: $1,085.

That third number is the one nobody can produce from memory, and it’s 32% of the month.

Now the expense side:

Mileage matters enough to do properly. The IRS standard business mileage rate for 2026 was set at 72.5 cents per mile, then revised to 76 cents per mile effective July 1, 2026 (IRS). For a September shoot the 76-cent rate applies: 214 × $0.76 = $162.64.

Total expenses: $200 + $118 + $23 + $12 + $64 + $31 + $162.64 = $610.64

Net profit on booked revenue: $3,400 − $610.64 = $2,789.36 (82.0% margin) Net profit on cash actually collected: $2,315 − $610.64 = $1,704.36

Two numbers, both true, more than a thousand dollars apart. If your mental model of the month is “I made about $2,800,” you are describing a month that has not fully happened yet. That’s exactly the gap a session tracker closes.

Where photography businesses actually leak money

Five leaks, in rough order of how much they cost:

1. Dates held without a deposit. A pencilled-in date is a date you turned other work away for. If the deposit column is empty, the row is a lead, not a booking. Colour it differently.

2. Balances that outlive the gallery. Once the client has the images, chasing a balance is a relationship problem instead of an admin task. A balance-due-date column that you can sort against today is the entire fix.

3. Untracked mileage. At 76 cents a mile, a photographer driving 4,000 business miles a year is looking at a deduction over $3,000 — abandoned because nobody wrote down the trips. The log takes twenty seconds per shoot.

4. Print orders that were never asked for. The gallery-sent date without a print-order-followed-up column means every gallery is a coin flip. A single column turns it into a routine.

5. Pricing set without knowing the cost of a session. Almost every underpriced photographer arrived there by pricing against local competitors rather than against their own cost of doing business. There’s a calculation for this, and it usually produces an uncomfortable number.

Stop rebuilding this every January

Everything above is buildable by hand. The tabs are named, the columns are listed, the formulas are one subtraction and a pile of SUMIFs, and if you want to construct it yourself you now have the full spec.

The Photography Client & Session Tracker is that system already assembled. It’s 8 tabs: a Setup & Pricing tab holding your package menu, deposit rule, expense categories and monthly goals that drive everything else; a Client Pipeline CRM running Inquiry → Booked → Shot → Edited → Delivered → Paid with lead source, quote and follow-up on every lead; a Session Calendar where entering the package and deposit returns the balance due automatically; an Income & Expenses log including mileage; a Gallery & Delivery tab for editing status, galleries sent, print orders and deadlines; a Tax Summary totalling income and deductible expenses by category; and a Dashboard showing revenue, profit, bookings against goal and outstanding balances live. Sample data is pre-filled so you can see how the tabs connect before you type over it.

Go deeper on each piece

Each part of this system has its own decisions and gotchas:

• Spreadsheet or software? — the honest break-even between a one-time template and a monthly photography CRM subscription, and the four features that genuinely justify the subscription: photography CRM vs spreadsheet
• What to charge — a full cost-of-doing-business calculation that works backwards from your target income to a per-session price floor: how much to charge for a photo session
• Deposits and balances — seven specific mistakes that leave photography balances uncollected, and the columns that prevent each one: photography deposits and unpaid balances
• Tax time — the Schedule C categories photographers actually use, what’s deductible, and the two 2026 mileage rates: photographer tax deductions checklist

The bottom line

A photography tracker isn’t a filing system. It’s the only place your business exists as a single object — where the inquiry that arrived in a DM, the date on the calendar, the deposit in the payment app and the gas in the tank are all the same row.

Build the six-stage pipeline, keep the money columns in the same row as the shoot, log the miles, and give delivery deadlines their own sortable list. Do that and four questions you currently answer with “let me check” become things you read off a dashboard: what I’ve booked, what I’ve actually collected, what I’m owed, and what I kept.

This article is general business-organization information, not tax, legal or accounting advice. Deductibility depends on your circumstances — see IRS Publication 535 and Schedule C instructions, or a tax professional, and have a lawyer review your booking contract and deposit terms.