Photography Sales Pipeline Tracker

You're losing booked clients to photographers who follow up faster — and you don't even know which leads went cold.

Track every photography lead from first inquiry to final gallery delivery with this end-to-end sales pipeline built specifically for photographers running 80–150 shoots per year.

If you've ever lost a booking because a lead slipped through the cracks, or wondered at the end of the month how many inquiries actually converted — this is the system you needed six months ago.

**WHAT YOU'LL GET OUT OF THIS IN THE FIRST WEEK:**
- A clear view of exactly where every lead stands in your pipeline — no more "wait, did I send that contract?"
- Your actual booking conversion rate, broken down by shoot type (weddings, portraits, commercial, events)
- Every retainer, payment, and final balance tracked in one place so nothing falls through at delivery

---

**WHAT'S INSIDE LENS & LEDGER SALES PIPELINE**

This spreadsheet is built around the real stages of a photography booking — not some generic CRM template designed for a software sales team. Every column, every calculation, and every dashboard view was designed for a photographer who is also the salesperson, the scheduler, the contract sender, and the follow-up department.

**Lead Intake and Inquiry Tracking**
Log every incoming inquiry the moment it arrives — name, contact info, shoot type, event date, referral source, and inquiry date. When you can see your full lead list in one place, the ones going cold become obvious fast.

**Pipeline Stage Management**
Move each lead through clearly defined stages: New Inquiry → Contacted → Proposal Sent → Contract Out → Retainer Collected → Shoot Confirmed → Gallery Delivered → Closed/Lost. At any moment you can see exactly how many leads are sitting in each stage and where your bottlenecks are.

**Retainer and Payment Tracking**
Log retainer amounts, due dates, and final balance payments per booking. The dashboard surfaces outstanding balances so you're never chasing money at the last minute before a shoot.

**Revenue Forecasting**
The pipeline shows you projected revenue from confirmed bookings versus leads still in negotiation — giving you a real number to plan against, not just a hope. Useful whether you're trying to hit a monthly revenue target or deciding whether to take a last-minute booking.

**Booking Conversion Rate by Shoot Type**
See which category of work — weddings, portraits, commercial, events — converts inquiries to signed contracts at the highest rate. If your wedding leads close at 60% but your portrait leads close at 20%, that's information that changes how you spend your marketing time.

**Follow-Up Log**
Every lead has a built-in follow-up tracker. Log the date of last contact and the next scheduled touchpoint. Stop relying on memory or sticky notes to know who needs a nudge today.

**Referral Source Tracking**
Where are your best clients actually coming from? Instagram? Past clients? Wedding directories? This pipeline tracks it at the lead level so you can see, over time, which sources bring in leads that actually book — not just inquiries that waste your time.

**Second Shooter Assignment**
Working with one or two second shooters? Log their assignment per booking directly in the pipeline so your roster is visible alongside the full shoot schedule.

**Annual Shoot Volume Dashboard**
If you're running 80–150 shoots per year, volume management is as important as sales. The dashboard tracks confirmed bookings by month so you can see where you're overbooked, where you have capacity, and how your year is pacing against last year.

---

**WHO THIS IS FOR**

This template is built for the full-time working photographer who runs their business like a business — not a hobbyist tracking a handful of sessions in a notebook. If you shoot weddings, portraits, commercial work, events, or a mix of all four, and you're handling your own client communication, contracts, and payments, this pipeline was built around your workflow.

It works equally well for solo photographers and small teams with one or two second shooters.

---

**FORMAT AND COMPATIBILITY**

Delivered as an Excel file (.xlsx) that also works fully in Google Sheets — no macros, no VBA, just clean formulas and structured tables that run on any device. If you prefer Google Sheets, simply upload the file to Google Drive and open it — everything transfers cleanly.

**License:** Personal and single-business use only.

---

**DOING THIS MANUALLY — THE REAL COST**

Let's be honest about what it looks like without a system like this. You've got inquiry emails in your inbox, a notes app with names and dates, a separate spreadsheet for payments that's three months out of date, and a general sense that a few leads probably fell through somewhere in the last quarter. You don't know your conversion rate. You don't know which referral source is actually worth your time. You don't know if you're on pace for the revenue goal you set in January.

A generic CRM costs $40–$80 per month, requires a learning curve, and was designed for a sales team — not a photographer. This pipeline costs $24.99 once, lives in a tool you already know, and is built around the actual stages of a photography booking.

Running 100 shoots a year and losing even one booking because a lead went cold unnoticed is a $500–$3,000 loss depending on your pricing. This template pays for itself before you finish setting it up.

---

📸 **@bizgrid_co** on Instagram for template previews and setup walkthroughs.

Questions before purchasing? Send a message — happy to confirm this fits your workflow.

Perfect for: Full-time photographer managing 80-150 shoots per year across weddings, portraits, commercial, or events — working solo or with 1-2 second shooters

Why now: Photography inquiries now flood in from 6+ platforms simultaneously (The Knot, Instagram DMs, Google, referrals, Honeybook leads) and most photographers are losing bookings simply because they have no systematic follow-up — while studio software subscriptions cost $50-100/month for features most photographers never use

✓ Instant digital download
✓ Works with Microsoft Excel (Mac & PC) and Google Sheets
✓ No technical skills required
✓ Formulas and calculations already built in

📋 LICENSE: Personal and single-business use only. This template may not be resold, redistributed, or used to create derivative products for sale.