Photography Business Profit Tracker Excel with shoot pricing, package margins, expenses by category, and a monthly P and L dashboard. Know what every shoot actually made — and which package actually pays. Built for…
About this template
Photography Business Profit Tracker Excel with shoot pricing, package margins, expenses by category, and a monthly P and L dashboard. Know what every shoot actually made — and which package actually pays. Built for freelance photographers, portrait and wedding photographers, and small studios who need to know, shoot by shoot and month by month, whether the price covers the gear, the travel, and the hours — without accounting software. If a shoot type is eating your time for little money, this workbook shows it before the next booking.
$39
Excel & Google Sheets template — instant download on Etsy
Shoots and Sessions — date, client, shoot type, hours, price, cost, profit per shoot, and profit per hour for every session. Cost is the second shooter, travel, prints, assistant, or anything else that shoot cost you. Totals show revenue, hours, and average price per shoot.
Packages — package name, what's included, price, cost per booking, margin in dollars and percent, bookings, total revenue, and total margin. See which package actually pays, not just which one books most often.
Gear and Expenses — every business expense by category: gear, software, travel, marketing, and other. Category totals show where the money goes — gear is the biggest category in the example.
Monthly P and L — revenue, shoot costs, and gear and expenses by month, Jan-Dec, with net profit, margin, and profit per hour. All formulas from sheets 1 and 3.
Dashboard — total revenue, expenses, net profit and margin, total shoots and hours, average price per shoot, profit per hour, best shoot type, best package, and costs by category.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — Photography Business Profit Tracker
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Photography Business Profit Tracker track?
The Photography Business Profit Tracker tracks Shoots and Sessions; Packages; Gear and Expenses; Monthly P and L; Dashboard.
What do the example numbers show?
The included example shows: Total revenue 27,300 from 22 shoots and 89 hours; average price per shoot 1,240.91. Shoot costs 3,615; shoot profit 23,685; shoot profit per hour 266.12.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.