Photography Invoice Template — Excel

Excel is the workhorse format for photographers who juggle multiple shoots a month. Drop in a new edited-image count and the total recalculates instantly, duplicate a tab for next week's engagement session, and sort the sheet to see which clients still owe a balance.

Create Your Excel Invoice — Free

Why Excel for Photographers

=SUM() handles session fees, prints, and travel in one cell

Add a line for extra retouching or a second shooter and the grand total updates the moment you hit Enter. No calculator on the kitchen table at 11pm trying to remember whether you already added the mileage.

Duplicate a sheet for recurring portrait or headshot clients

Right-click the tab, 'Move or Copy', and a monthly headshot client has a fresh invoice in three seconds. The formulas, logo, and terms carry over — you only change the date and image count.

Sort by status to see who still owes a balance

A single 'Balance Due' column combined with Excel's filter lets you pull up every outstanding wedding deposit in one view. Chase payments weekly without digging through emails or a separate spreadsheet.

Imports cleanly into QuickBooks Self-Employed and Xero

Save your invoice sheet as CSV and your bookkeeping tool ingests the line items without manual re-entry. At tax time, every session, print sale, and travel fee is already categorised the way you set it up.

Invoicing Challenges for Photographers

Deposits and Balance Payments

Most photographers require a deposit to book a session and collect the balance on delivery. Tracking which clients have paid deposits and what remains due across dozens of bookings gets complicated fast.

Licensing and Usage Rights

Commercial clients pay differently depending on how they use your images. A single image licensed for a billboard campaign costs more than the same image on a blog post, and your invoice needs to spell this out.

Travel and Equipment Expenses

Destination shoots, rental gear, and assistant fees add up. If you do not itemize these on the invoice, clients question the total or you end up absorbing costs you should be passing through.

Photography Excel Invoicing Tips

★

Build a licensing multiplier cell that scales the base image fee

Create a cell called 'License Factor' with values like 1.0 (personal), 2.5 (editorial), and 5.0 (national commercial). Reference it in the image-row formula: =ImageCount*BaseRate*LicenseFactor. Changing one cell reprices the entire invoice when a client upgrades from personal to commercial use — no manual math, no mistakes.

Define Packages Clearly

List exactly what each package includes — number of edited images, hours of coverage, print credits — so clients can see the value and you have a reference point for add-ons.

Specify Usage Rights on the Invoice

State the license type (personal, commercial, exclusive) and duration directly on the invoice. This protects your intellectual property and justifies premium pricing for commercial usage.

Collect Deposits Before the Shoot

Require a non-refundable deposit (typically 25-50%) to reserve the date. Show it as a line item on the final invoice so the client sees the remaining balance clearly.

Itemize Post-Production Separately

Editing, retouching, and color grading take significant time. Breaking out post-production as its own line item helps clients understand your pricing and opens the door for upselling premium retouching.

What to Include on a Photography Excel Invoice

Session date, time, and location
Package or session type selected
Number of final edited images included
Licensing terms and usage rights granted
Deposit paid and balance remaining
Travel and accommodation expenses
Additional retouching or print fees
Delivery timeline for final images

Generate Your Photography Excel Invoice Now

Create Invoice — Free, No Sign-Up

Frequently Asked Questions

Which Excel formula should I use to calculate a photography deposit balance?

Use =SessionTotal-DepositPaid in a 'Balance Due' cell. For multi-payment weddings, make it =SessionTotal-SUM(DepositRange) so every partial payment you log in a small table reduces the outstanding amount. This way the invoice always shows the true remaining balance on the day you reprint it.

How do I stop clients from seeing my pricing formulas in an Excel invoice?

Before you send, use File > Save As and choose PDF — or select your formula cells, right-click > Format Cells > Protection > Hidden, then protect the sheet with a password. Photographers often accidentally send working sheets where clients can click a cell and see the cost-plus markup in the formula bar.

Can I use Excel to track which images a commercial client has licensed?

Yes. Add a column for 'Image ID' (your catalog number) and another for 'License Scope'. Filter by client name to generate a running log of every licensed frame across all their invoices. This becomes invaluable when a brand asks to renew a license two years later and you need to find the original sale.