Photography Bookkeeping Spreadsheet Google Sheets Photographer Videographer Income Expense Tracker Session Profit Calculator Mileage Deposit

Do what you love. Get paid what it's worth. This spreadsheet shows what each shoot really earns. 📷

Photographers have a money flow no generic template handles: deposits come in months before a session, balances are due at delivery, and a "good" package can quietly lose money once you subtract editing hours, a second shooter, gear, and travel. The EasyVault Photographer & Videographer Bookkeeping Spreadsheet fixes all of it — with a session profit calculator, deposit-vs-balance tracking, a mileage log, a 1099 contractor tracker, and 10 charts across 10 tabs.

✦ THE PROBLEM THIS SOLVES:
A $3,200 wedding isn't $3,200 of profit. After a second shooter, 12 hours of editing, the album, and travel, your real number comes into focus — and it changes how you price. This template calculates true profit per session (with margin and profit per editing hour), tracks every deposit and outstanding balance so you never chase a payment, and captures every deductible mile, gear purchase, and contractor payment.

✦ WHAT'S INSIDE (10 TABS):

📷 Welcome — The photographer money playbook, with a quick-start guide
🎞️ Session Profit Calculator — True profit per shoot after all costs ⭐
📸 Session Tracker — Bookings with deposit paid & balance due
🚗 Mileage Log — Venues, consults & scouting → deduction at the IRS rate
🧾 Expenses — Gear, software, props & studio rent by category
📊 Dashboard — Revenue, profit & outstanding balances at a glance
👥 Contractors — Second shooters & editors, with 1099 flagging
📈 Profit & Loss — Your true bottom line by month
📉 Annual Trends — Revenue, expenses & profit across the year
📒 Guide & Notes — The money playbook, plus your notes

✦ KEY FEATURES:
• Session profit calculator — package price minus editing, second shooter, gear & travel
• Shows profit margin AND profit per editing hour for every shoot
• Suggested minimum price helper at your target margin
• Deposit-vs-balance tracking so you always know who still owes you
• Mileage log with deduction at the IRS standard rate you set
• 1099 contractor tracker that flags anyone paid $600+
• Photography-specific expense categories: gear, software, props, studio & more
• Full Profit & Loss and annual trends
• 10 charts total — pie, doughnut, bar & line
• Moody, editorial charcoal & amber design
• Works on desktop, tablet & mobile

✦ CHARTS & VISUALS (10 total):
• Pie — Where your package price goes
• Pie — Collected vs outstanding
• Pie — Expenses by category
• Doughnut — Where revenue goes (dashboard)
• Bar — Collected vs outstanding
• Bar — Contractor pay (1099 watch)
• Line — Revenue vs expenses by month
• Bar — Revenue → net profit (P&L)
• Line + stacked bar — Annual trends

✦ BONUS INCLUDED:
A prefilled SAMPLE spreadsheet shows the whole system working — a quarter of weddings, portraits, and commercial shoots with deposits and balances, a mileage log, categorized expenses, and contractor 1099 tracking for a profitable studio — so you can see it in action before adding your own numbers.

✦ HOW TO USE:
1. Purchase & download the PDF with your Google Sheets link
2. Click the link and go to File → Make a Copy
3. Price a shoot on the Session Profit Calculator
4. Log bookings (deposit & balance), mileage & expenses
5. Watch your profit and outstanding balances on the Dashboard!

✦ WHAT YOU GET:
• 1x Photographer & Videographer Bookkeeping Spreadsheet (Google Sheets — blank)
• 1x BONUS Sample Spreadsheet (Google Sheets — prefilled)
• Step-by-step instructions included

✦ REQUIREMENTS:
• Free Google account (works with Google Sheets)
• Also opens in Excel
• Works with any currency
• Works on any device with internet access

✦ PERFECT FOR:
Wedding photographers • Portrait & family photographers • Videographers & filmmakers • Newborn & maternity photographers • Commercial & brand photographers • Event photographers • Second shooters going solo • Any photo or video creative who wants to price for profit and keep clean books

✦ WHY EASYVAULT?
This isn't a generic income list — it's built around how photographers actually get paid, with a real session profit calculator, deposit-vs-balance tracking, and 1099 contractor flagging, so you price with confidence and keep more of every shoot.

⚖️ DISCLAIMER:
This product is for informational purposes only. EasyVault does not provide financial, tax, or legal advice. Mileage rates, depreciation of equipment, and tax treatment vary — always confirm the current IRS rate and your situation with a qualified professional. All calculations are estimates based on the numbers you enter.

Please note: This is a DIGITAL product. No physical item will be shipped. Listing images show example data for demonstration; the template is blank and ready for your input (a prefilled sample is included too).

© EasyVault. All rights reserved. Personal use only.
Wishing you a fully-booked, profitable season — we'd love a ⭐⭐⭐⭐⭐ review!