Photography CRM vs Spreadsheet: Which One Does a Solo Photographer Need?

The pitch for photography CRM software is always the same, and it’s always slightly dishonest: stop drowning in spreadsheets and run your whole business in one place. The implied comparison is between a subscription platform and a mess of half-finished tabs you built at 11pm.

That’s not the real comparison. The real comparison is between a subscription platform and a properly structured spreadsheet, and once you make that comparison the answer stops being obvious.

Here’s the honest version.

What each one is actually good at

Strip the marketing away and the two tools do different jobs that happen to overlap.

Look at where the “No” answers cluster. Every single one is on the client-facing side. Everything on the internal-tracking side — the part you look at, not the part clients touch — a spreadsheet does.

That’s the whole decision in one sentence: you are not choosing between two trackers, you are deciding whether you want to buy client-facing automation.

The break-even math

Subscription pricing for studio-management platforms changes constantly and varies by plan, so don’t take a number from an article — open the pricing page and put your own real quote into this calculation.

The calculation. Let M be the monthly subscription you were actually quoted. Then:

Annual software cost      = M × 12
One-time template cost    = T  (typically $15-30, paid once)
Year-one difference       = (M × 12) − T
Year-three difference     = (M × 36) − T

At a hypothetical $39/month — an assumption for this example, not a quote — against a $16.99 template:

Now the other side of the ledger, because a cost comparison alone is a rigged comparison. What does the software buy back?

The time test. Time yourself for one booking. How long does it take you to: draft and send the contract, chase the signature, create the invoice, send it, and send two payment reminders? For most solo photographers doing this by hand, that’s somewhere between 25 and 45 minutes of fiddly context-switching per booking.

Say it’s 35 minutes, and say you book 4 sessions a month:

35 min × 4 bookings   = 140 min/month = 2.33 hours
2.33 hours × 12       = 28 hours a year of admin

At $39/month you’re paying $468 to remove 28 hours. That’s $16.71 per hour of your time bought back. If your effective rate as a photographer is above that — and if you’re pricing correctly it should be well above it — the software wins on pure arithmetic.

Now run it at 1 session a month:

35 min × 1 booking × 12 = 7 hours a year
$468 ÷ 7 hours          = $66.86 per hour

At that volume you’re paying $66.86 an hour to avoid admin you could do while the coffee brews. The template wins, decisively.

The break-even is volume, not sophistication. Somewhere around 40-60 sessions a year — depending on your rate and how automatable your workflow is — the equation flips. Below that line, a subscription is a fixed cost bolted onto a variable-revenue business, and it bites hardest in exactly the months where you booked nothing.

The argument nobody makes for spreadsheets

Three real advantages that don’t show up on comparison charts:

1. No monthly floor in a dead month. February with two bookings costs a spreadsheet user nothing. It costs a subscriber the full monthly rate against reduced revenue. Photography is seasonal for almost everyone, and a fixed cost on a seasonal business is a worse deal than the annual average suggests.

2. You can reshape it. Shoot a genre nobody’s software anticipated — pet photography with a vaccination-record column, real estate with a square-footage-tier price, aerial work with flight-log fields — and a spreadsheet takes one column. In a platform, you file a feature request.

3. The data stays yours. If you stop paying a platform, you get an export. If you stop using a spreadsheet, you have a spreadsheet: same file, same formulas, opens in ten years.

The argument nobody makes for software

And three real advantages the spreadsheet camp likes to skip:

1. It chases money while you sleep. An automated payment reminder is not a small feature. It removes the single most-avoided task in the business — asking a nice person for money — and does it on schedule, without awkwardness. If you have ever let a balance sit because you didn’t want to send the message, this is worth money to you.

2. Clients think it looks professional. A signature link and a pay button read as an established business. A PDF contract emailed as an attachment with “just Venmo me the deposit” reads as a side hustle. Whether that’s fair is beside the point.

3. One less place to be disciplined. A spreadsheet updates when you update it. A platform updates when the client signs, pays or books. That difference doesn’t matter in a good month; it matters enormously in a busy one.

A hybrid that works better than either

The setup a lot of working photographers land on, and it isn’t a compromise so much as a correct division of labour:

• Spreadsheet for everything internal: pipeline, session calendar, deposits and balances, expenses, mileage, tax categories, dashboard. This is the record of the business.
• A payment app (per-transaction fees, no monthly floor) for invoices and card payments.
• An e-signature tool for contracts — several have free tiers adequate for a handful of documents a month.

Cost shape: one-time template plus per-transaction fees. No fixed monthly cost. You keep the pay button and the signature; you lose the automated reminders and the client portal.

If, after running that for a season, the reminders are the thing you keep wishing for — that’s a genuine signal to subscribe. Wanting a shinier dashboard is not.

Which is right for you

Choose the spreadsheet if: you’re under roughly 40 sessions a year, your revenue is seasonal, you shoot a genre with unusual data, you’d rather own than rent, or you’re at the stage where a fixed monthly cost is a real consideration.

Choose the software if: you’re past the volume line, you routinely need contracts signed before you’ll hold a date, you have unpaid balances you’ve avoided chasing, or you’re spending more than a couple of hours a month on booking admin.

The wrong reason to subscribe is that your current spreadsheet is a mess. A badly built spreadsheet loses to software; a well-built one doesn’t. Fix the structure first and then decide — otherwise you’re paying $468 a year to solve a problem that was actually a missing column.

The tracker, already built

If the spreadsheet side is where you’re landing, the structure matters more than the tool. The Photography Client & Session Tracker is the internal half of a photography CRM, assembled: a Client Pipeline running Inquiry → Booked → Shot → Edited → Delivered → Paid with lead source and follow-up dates, a Session Calendar where the deposit and balance calculate themselves, Income & Expenses with mileage, Gallery & Delivery deadlines, a Tax Summary by category, and a live Dashboard with outstanding balances. One purchase, no monthly floor, and it’s yours in February whether you shot anything or not.

Related reading

• The full system, tab by tab, with a worked month: photography client and session tracker spreadsheet
• What to charge, worked backwards from your target income: how much to charge for a photo session
• The seven ways balances go uncollected: photography deposits and unpaid balances

The bottom line

Photography CRM software and a spreadsheet are not competing at the same thing. The spreadsheet is a better record; the software is a better assistant. Below about 40-60 sessions a year the assistant costs more per hour than it saves, and above it the assistant pays for itself.

Run the two calculations with your own real numbers — your quoted monthly rate, your actual admin minutes, your actual booking volume — and the answer stops being a matter of taste.

Software pricing and feature sets change frequently; check current pricing pages directly rather than relying on figures in any article, including this one. The dollar amounts above are clearly-labelled assumptions for the worked example.