How to Track Photography Bookings and Client Payments in a Spreadsheet

Photography cash flow splits across booking, deposit, balance, and delivery — easy to shoot a wedding Saturday while the spring portrait balance sits unpaid and the gallery deadline slips. A free photography client tracker spreadsheet lists client, session, package, payment status, and delivery status in one view.

One row per booking

Core columns:

1. Client and session type — wedding, newborn, corporate headshots, event.
2. Package and total price
3. Deposit paid — date and amount
4. Balance due — remaining before or after shoot per your contract
5. Payment status — deposit only, paid in full, overdue
6. Delivery status — editing, gallery sent, complete

Monthly income totals show what actually cleared, not what you quoted.

Invoice milestones match creative milestones

Typical wedding flow: retainer on booking, balance before wedding day, print order invoiced separately. Log each payment event as it happens — the sheet becomes your AR list and your delivery checklist.

Wedding budgets often span vendors beyond photography — clients may also use the wedding budget spreadsheet; your tracker is the photographer’s internal booking and payment log.

Do not deliver on unpaid balance without a policy

Filter balance due > 0 before marking gallery sent. The sheet makes policy enforceable — no relying on memory during busy season.

When CRM and gallery platforms replace the sheet

HoneyBook-style CRMs, online proofing, and contract e-sign earn their cost at high booking volume. Solo photographers and small studios often track money and delivery in a sheet until missed payments and late galleries cost more than software.

These templates are studio business tools, not copyright or licensing advice. Verify usage rights in your signed contracts.