Wedding Photographer Bookkeeping Spreadsheet | Income, Expense & Profit Dashboard + Invoice & Tax Planner

Take control of your wedding photography business finances with one simple, organized bookkeeping dashboard. 📸💍

The Wedding Photographer Bookkeeping Spreadsheet is an easy-to-use Excel financial tracker created specifically for wedding photographers, elopement photographers, and photography business owners who want to understand exactly where their money is going.

Instead of juggling separate spreadsheets for invoices, expenses, weddings, mileage, and taxes, this all-in-one dashboard keeps your important business numbers together.

Track your photography income, business expenses, client payments, retainers, outstanding invoices, wedding profitability, mileage, and estimated tax set-aside from one organized workbook.

✨ Know What You Actually Earn From Every Wedding

Not every $5,000 wedding means $5,000 in profit.

Assign each wedding a Job ID and track costs such as:

• Second shooters
• Editing and outsourcing
• Albums and prints
• Travel and accommodation
• Equipment rentals
• Payment processing fees
• Other wedding-specific expenses

Your dashboard automatically calculates your expected revenue, direct expenses, expected profit, cash received, and profit margin for each wedding.

💰 Track Income & Client Payments

Stay on top of every payment with a dedicated invoice and income tracker.

Track:

• Retainers
• Final balances
• Engagement sessions
• Albums and prints
• Add-ons
• Travel fees
• Invoice numbers
• Payment due dates
• Amount invoiced
• Amount received
• Payment methods
• Outstanding balances

Quickly see how much clients have paid and exactly how much money is still outstanding.

📊 Visual Photography Business Dashboard

Your financial dashboard automatically summarizes your business so you can see the numbers that matter without manually calculating them.

View:

Revenue Received

Business Expenses

Net Cash Profit

Estimated Tax Set-Aside

Outstanding Invoices

Mileage Deduction Estimate

Booked & Completed Weddings

Expected Direct Profit Margin

You'll also get visual charts showing your monthly revenue, expenses, profit trends, and expense categories.

🧾 Organize Photography Business Expenses

Keep your business spending organized with photography-specific expense categories including:

Second shooters, editing, albums, travel, photography gear, software subscriptions, insurance, advertising, education, professional fees, payment processing, studio expenses, and more.

You can also record:

• Vendor
• Expense date
• Wedding Job ID
• Payment method
• Deductible percentage
• Receipt status
• Notes

🚗 Business Mileage Tracker

Record business travel for weddings, engagement sessions, venue visits, equipment pickups, client meetings, and other photography-related trips.

Simply enter your mileage rate and the spreadsheet calculates your estimated mileage deduction automatically.

🧮 Tax Set-Aside Planner

Stop reaching tax season wondering how much money you should have saved.

Enter your preferred tax set-aside percentage and the workbook provides a simple planning estimate based on your recorded business activity.

View estimated reserves by:

Q1 • Q2 • Q3 • Q4 • Full Year

💍 Made Specifically for Wedding Photographers

Unlike a generic small-business bookkeeping spreadsheet, this template is designed around the real workflow of a wedding photography business.

Track:

Wedding dates • Couples • Venues • Photography packages • Contract values • Retainers • Add-ons • Travel fees • Wedding expenses • Lead sources • Booking status • Profit per wedding

This makes it easier to answer one of the most important questions in your business:

Which weddings are actually the most profitable?

📂 What's Included?

You'll receive an editable Microsoft Excel (.xlsx) Wedding Photographer Bookkeeping Dashboard containing:

1. START HERE Guide

Simple instructions to help you set up your workbook.

2. Setup & Business Assumptions

Customize your business name, reporting year, tax reserve percentage, and mileage rate.

3. Business Dashboard

See your most important photography business financial metrics at a glance.

4. Weddings & Job Profitability Tracker

Track revenue, costs, payments, and profit for individual weddings.

5. Income & Invoice Tracker

Manage retainers, final balances, invoices, payments, and outstanding amounts.

6. Business Expense Tracker

Organize photography expenses and connect costs to individual weddings.

7. Mileage Tracker

Record business travel and estimate mileage deductions.

8. Tax Set-Aside Planner

Plan quarterly and annual cash reserves.

9. Custom Lists & Categories

Editable dropdown options for packages, payment methods, lead sources, expenses, and more.

👩‍💻 Perfect For

Wedding photographers, elopement photographers, destination wedding photographers, photography studios, freelance photographers, and creative business owners who want a cleaner way to manage the financial side of their business.

📥 Digital Download

This is a digital Excel spreadsheet template. No physical product will be shipped.

After purchase, download the workbook, customize the Setup page, and begin entering your own weddings, income, and expenses.

⚠️ Important Disclaimer

This spreadsheet is an organizational and financial planning tool only. It does not provide accounting, legal, financial, or tax advice.

Tax rules, deductible expenses, mileage rates, and filing requirements vary by country, location, business structure, and individual circumstances. Always use rates appropriate to your situation and consult a qualified professional where necessary.