Photography Business Spreadsheet | Photographer CRM, Pricing Calculator, Bookkeeping & Invoices | Google Sheets Template

Run your whole photography business from one Google Sheet: clients, jobs, payments, pricing, expenses, mileage, reports and invoices, all connected, so you type each thing once.

━━━ WHAT YOU GET ━━━
- A START-HERE PDF with two "Make a copy" buttons:
– Ready-to-use copy for your own business
– Sample copy filled with a full year of an example photography business, so you can see how it works
- A 14-page PDF guide (setup, every tab, a typical workflow, FAQ, troubleshooting)

━━━ 14 CONNECTED TABS ━━━
DASHBOARD – revenue, booked pipeline, balances and profit; upcoming shoots, galleries due, money to collect and follow-ups; income vs. expenses and revenue-by-session charts
JOBS – every job from inquiry to paid; pick a package and the price fills in; deposit, balance, payment status, gallery due date and job profit calculate for you
CLIENTS – contact details, lead source, jobs, revenue and balance owed per client
PAYMENTS – deposits, balances, tips and refunds, linked to each job
PRICING – cost-of-doing-business calculator: what you need to earn, your hourly floor, your minimum price per session, and a package builder that flags packages priced below your floor
EXPENSES – purchases by category with business-use %, optional job link and receipt links
MILEAGE – business drives and your mileage deduction
REPORTS – profit and loss by month, expenses by category, quarterly tax set-aside estimate, revenue by session type, lead sources
INVOICE – printable quote, invoice or receipt for any job, built from its package, add-ons, discount and payments
DELIVERY BOARD – your editing queue with on-time rate and average turnaround
SESSION PLANNER + PLAN ITEMS – a printable shoot plan per job: timeline, shot list, gear and to-dos, with reusable templates (Wedding, Family, Newborn, Listing Photos)
SETTINGS – your business info, invoice details, deposit %, turnaround, mileage rate, tax %, and your own dropdown lists
START HERE – a 5-step setup checklist and a map of how everything fits together

━━━ REAL ESTATE PHOTOGRAPHERS ━━━
Switch Business mode to Real Estate or Both for listing-photo session types, square-footage pricing tiers, add-ons (drone, twilight, floor plan, video, virtual staging) and agents as repeat clients.

━━━ HOW IT WORKS ━━━
1. Buy and download the START-HERE PDF
2. Click a button while signed in to Google, then "Make a copy"
3. Open your copy and follow the setup checklist on the Start Here tab

━━━ GOOD TO KNOW ━━━
- Google Sheets only: you need a free Google account. This is not an Excel file.
- Works in any browser on a computer, tablet or phone. Setup is easiest on a computer.
- Nothing to install, no add-ons, no scripts.
- Sales tax isn't included in prices, invoices or reports. The tax set-aside is an estimate, not tax advice.
- Prices show in US dollars; you can switch the currency format.
- Dates use US Eastern time by default; you can change it in File → Settings.
- Screenshots show the sample copy with made-up data.

━━━ LICENSE ━━━
For use by one person or one business. Please don't resell, share or redistribute the template or its links. Digital download: no physical item will be shipped. Because it's a digital file, returns aren't accepted, but if something isn't working, message me and I'll help.