July 29, 2026 · ViaSheet Team
The Ultimate Photography Client Tracker: Excel & Google Sheets CRM Guide
Discover how to track photography bookings, contract signatures, payment retainers, and gallery delivery deadlines using Google Sheets or Excel without monthly fees.
For professional photographers, taking stunning photos is only half the battle. Running a profitable photography business requires managing client inquiries, sending quotes, collecting retainer deposits, enforcing contract signatures, meeting strict gallery delivery deadlines, and collecting final balance payments.
According to a survey by the Professional Photographers of America (PPA), the average freelance photographer spends over 60% of their working hours on administrative management, rather than behind the camera or editing images. More critically, up to 35% of solo photographers admit to missing final balance payments or delaying gallery deliveries simply because they lacked a structured client tracking system.
While dedicated studio management software like HoneyBook, Dubsado, or Sprout Studio exist, their monthly subscription fees ($240 to $600 per year) add unnecessary overhead for independent wedding, portrait, and commercial photographers.
In this comprehensive guide, we will show you how to structure a complete Photography Client & Booking Tracker in Google Sheets or Excel, helping you manage every stage from initial inquiry to 5-star Google review requests.
Why Monthly CRM Subscriptions Burden Freelance Photographers
Dedicated SaaS platforms offer flashy email templates, but for many creative solos, they introduce unnecessary friction:
- High Subscription Overhead: Paying $35/month for software when you shoot 30 to 70 sessions a year directly reduces your profit margin by $10–$20 per client.
- Feature Overkill: Most photographers do not need complex automated multi-step email drip campaigns. They need to know four simple things: Who has signed their contract? Who owes a deposit? When is the shoot? When is the gallery delivery due?
- Data Lock-In: Platform subscriptions lock your booking data into proprietary interfaces. A spreadsheet gives you raw, portable data that can be exported, archived, or analyzed at any time.
- Offline Accessibility & Speed: Opening a lightweight Google Sheet or Excel spreadsheet on your laptop or phone takes seconds, whether you are on location, at a venue, or in your editing suite.
The 7-Stage Photography Client Lifecycle
To design a high-converting client spreadsheet, you must map your database columns to the seven distinct milestones of a professional photography booking:
[1. Inquiry] ➔ [2. Contract & Retainer] ➔ [3. Shoot Logistics] ➔ [4. Session Day] ➔ [5. Editing & Delivery] ➔ [6. Final Payment] ➔ [7. Review Request]Milestone 1: Lead Inquiry & Quote
Capturing the client’s preferred date, shoot location, session type (Wedding, Portrait, Commercial, Event, Real Estate), and estimated package budget.
Milestone 2: Contract Signing & Retainer Deposit
A booking is never confirmed until the client signs your terms of service and pays a non-refundable retainer (typically 25%–50% of the total package fee).
Milestone 3: Pre-Shoot Preparation & Logistics
Gathering questionnaire details, location permits, shot lists, timeline schedules, and venue contact details.
Milestone 4: Shoot Execution
Conducting the session and logging raw image files onto backup drives immediately post-session.
Milestone 5: Editing & Gallery Delivery Deadline
Tracking your post-processing pipeline. Setting firm turnaround deadlines (e.g., 2 weeks for portraits, 6 weeks for full weddings).
Milestone 6: Final Balance Payment Collection
Enforcing that final payments are cleared prior to or immediately upon gallery link delivery.
Milestone 7: Review Request & Referral Follow-Up
Prompting satisfied clients for a Google Review or referral 7 days after gallery delivery while their excitement is highest.
Building Your Photography CRM Spreadsheet: Step-by-Step
Let’s build a dedicated Photography Booking Database in Google Sheets or Excel.
1. Set Up Column Headers
Open a new sheet named Booking Pipeline and add the following headers in Row 1:
| Column | Header Name | Data Type | Formula / Rule |
|---|---|---|---|
| A | Booking Code | Formula | =IF(ISBLANK(B2), "", "BOOK-" & TEXT(ROW()-1, "000")) |
| B | Client Full Name | Text | Primary client name (e.g., Sarah & Mark Johnson) |
| C | Email Address | Contact email | |
| D | Phone Number | Text | Contact phone |
| E | Session Type | Dropdown | Wedding, Portrait, Commercial, Event, Mini-Session |
| F | Shoot Date | Date | Scheduled date of the shoot |
| G | Shoot Location | Text | Venue / Address / Studio name |
| H | Package Price ($) | Currency | Total contracted agreement price |
| I | Retainer Paid ($) | Currency | Amount paid upon booking |
| J | Final Balance ($) | Formula | =H2 - I2 |
| K | Contract Status | Dropdown | Draft Sent, Signed, Pending Signature |
| L | Payment Status | Dropdown | Unpaid, Retainer Paid, Paid in Full |
| M | Delivery Deadline | Formula | =IF(ISBLANK(F2), "", F2 + 21) (Adds 21 days to shoot date) |
| N | Gallery Link | URL | Client proofing gallery link (Pixieset, Pic-Time, ShootProof) |
| O | Review Requested | Dropdown | Not Sent, Sent, Received ⭐️ |
2. Automating Essential Photography Formulas
A. Automated Outstanding Balance Calculation (Column J)
In cell J2, calculate the remaining balance owed by subtracting the retainer from the package price:
=IF(ISBLANK(H2), 0, H2 - I2)B. Automated Gallery Delivery Deadline (Column M)
For portrait shoots, galleries are typically due 14 days after the shoot. For weddings, 30 days is standard.
In cell M2, calculate an automated 21-day turnaround deadline from the Shoot Date (Column F):
=IF(ISBLANK(F2), "", IF(E2="Wedding", F2 + 30, F2 + 14))Explanation: If the session type in Column E is “Wedding”, it automatically calculates a 30-day delivery deadline from the shoot date. For any other session type, it sets a 14-day turnaround.
C. Automated Overdue Gallery Alert
Apply Conditional Formatting to Column M (Delivery Deadline):
- Select Column M.
- Click Format → Conditional formatting.
- Rule: Date is before → Today.
- Formatting: Fill Light Red (
#FEE2E2), Text Dark Red (#991B1B).
This instantly highlights any booking where the gallery delivery deadline has passed!
Creating the Annual Revenue & Booking Dashboard
A successful photography business must track financial metrics by session type to identify which services yield the highest hourly rate.
Create a tab named Revenue Analytics and set up the following dynamic KPI tables:
1. Revenue by Session Type Table
| Session Type | Total Bookings | Gross Revenue ($) | Average Booking Value ($) |
|---|---|---|---|
| Wedding | =COUNTIF('Booking Pipeline'!E:E, "Wedding") | =SUMIF('Booking Pipeline'!E:E, "Wedding", 'Booking Pipeline'!H:H) | =IFERROR(C2/B2, 0) |
| Portrait | =COUNTIF('Booking Pipeline'!E:E, "Portrait") | =SUMIF('Booking Pipeline'!E:E, "Portrait", 'Booking Pipeline'!H:H) | =IFERROR(C3/B3, 0) |
| Commercial | =COUNTIF('Booking Pipeline'!E:E, "Commercial") | =SUMIF('Booking Pipeline'!E:E, "Commercial", 'Booking Pipeline'!H:H) | =IFERROR(C4/B4, 0) |
| Event | =COUNTIF('Booking Pipeline'!E:E, "Event") | =SUMIF('Booking Pipeline'!E:E, "Event", 'Booking Pipeline'!H:H) | =IFERROR(C5/B5, 0) |
2. Outstanding Receivables Summary
To calculate total money owed to your photography studio across all uncollected balances:
=SUMIFS('Booking Pipeline'!J:J, 'Booking Pipeline'!L:L, "<>Paid in Full")This formula immediately tells you how much money is currently outstanding across pending client retainers and final payments!
5 Productivity Hacks for Photography Spreadsheets
- Embed Client Gallery Links Directly: Store your Pixieset, Pic-Time, ShootProof, or PassGallery links directly in Column N so you can resend links to clients on demand without digging through emails.
- Track Equipment Maintenance Log: Add a second tab to record lens calibrations, camera sensor cleanings, memory card retirement dates, and gear insurance policy expiration dates.
- Log Client Birthdays & Anniversaries: Record wedding anniversaries for wedding clients. Set an automated notification to send them an email offering an Anniversary Couple Shoot discount 11 months after their wedding date.
- Use Color-Coded Shoot Days: Apply conditional formatting to Column F so upcoming shoots taking place within the next 7 days highlight in bright blue.
- Enforce Pre-Payment for Galleries: Never send a live gallery password until Column L displays
Paid in Full. Use conditional formatting to highlight unpaid delivered galleries in yellow.
Seasonal Booking & Revenue Forecasting for Photographers
Photography is an inherently seasonal business. Wedding photographers often experience a massive surge in bookings between May and October, followed by a quieter winter period. Commercial and portrait photographers frequently experience heavy demand during Q4 holiday marketing campaigns and family mini-session season.
To prevent cash flow shortages during slow months, incorporate a Monthly Seasonality Forecasting Table into your spreadsheet dashboard:
=SUMIFS('Booking Pipeline'!H:H, 'Booking Pipeline'!F:F, ">=2026-01-01", 'Booking Pipeline'!F:F, "<=2026-01-31")Explanation: Replace the date parameters for each month (2026-01-01 to 2026-01-31, 2026-02-01 to 2026-02-28, etc.) to generate a 12-month projected revenue chart.
Benefits of Seasonal Forecasting in Spreadsheets:
- Predict Cash Flow Gaps: Identify months where retainer income drops so you can schedule promotional mini-sessions 60 days in advance.
- Budget for Equipment Upgrades: Plan major lens, body, or lighting purchases during your highest revenue quarters.
- Set Realistic Booking Targets: Determine exactly how many portrait sessions or weddings you must close each month to reach your annual revenue goals.
The Ultimate Client Onboarding & Post-Shoot Workflow Checklist
To maintain a 5-star reputation, consistency is essential. Use this master checklist in tandem with your spreadsheet status columns:
Phase 1: Onboarding (Days 1–3)
- Initial inquiry response sent within 4 hours.
- Consultation video call or phone chat completed.
- Proposal & customized package quote sent.
- Contract signature received & archived in Google Drive.
- 50% non-refundable retainer invoice issued & cleared.
- Booking confirmation email & preparation guide delivered to client.
Phase 2: Production & Shooting (Shoot Day)
- Shot list and venue timeline printed or saved offline on phone.
- Camera batteries charged, dual memory cards formatted and tested.
- Session conducted at agreed location & time.
- Memory cards backed up to primary external SSD and secondary cloud storage immediately upon returning to studio.
Phase 3: Post-Production & Delivery (Days 1–21)
- Culling completed (selecting top 15% best shots).
- Color correction, retouching, and export finalized.
- Online proofing gallery created and password protected.
- Final balance invoice verified as
Paid in Full. - High-resolution gallery link delivered to client via email.
- Backup copy archived on studio cold storage drive.
Phase 4: Follow-Up & Retention (Days 28–60)
- Personalized thank-you note or printed print gift delivered.
- Automated 5-star Google Review request email triggered.
- Permission obtained for social media portfolio sharing.
- Calendar reminder set for 11-month anniversary shoot outreach.
Frequently Asked Questions (FAQ)
Can I share specific booking views with second shooters or assistants?
Yes. In Google Sheets, you can create a Filter View filtered by location or date and share that view with second shooters or lighting assistants without giving them access to your financial revenue summaries.
How do I store signed client contract PDFs alongside my spreadsheet?
Create a folder in Google Drive named Client Contracts. Paste the direct Google Drive sharing link for each signed PDF document into a dedicated Contract PDF Link column in your spreadsheet for instant access.
Is a Google Sheets CRM secure for storing client addresses and phone numbers?
Yes. Google Sheets utilizes Google Cloud enterprise encryption. Ensure your Google account has Two-Factor Authentication (2FA) enabled, and avoid sharing the sheet publicly on the web.
Streamline Your Photography Business with ViaSheet
Building your own custom photography tracker takes time and formula testing. If you want a pre-built, beautifully formatted solution designed specifically for professional photographers, explore our Photography CRM Spreadsheet.
The ViaSheet Photography CRM includes:
- Executive Dashboard: Real-time stats on monthly inquiries, confirmed bookings, outstanding balances, and gallery delivery deadlines.
- Booking & Lead Pipeline: Track clients from initial inquiry to signed contract and retainer payment.
- Payment & Retainer Register: Keep meticulous logs of initial retainers, final balances, print sales, and sales tax.
- Gallery Delivery Tracker: Never miss an editing deadline or forget to request a 5-star client review.
- Annual Financial Reports: Automatic breakdown of revenue by session type (Weddings, Portraits, Commercial).
- One-Time Purchase: Pay just €19 once for lifetime access in Google Sheets and Microsoft Excel—no monthly fees ever.
Take back your time, eliminate administrative stress, and run a streamlined photography business. Download the ViaSheet Photography CRM Template today!