The Photography Business Expense Spreadsheet That Tracks Income, Deductions and Quarterly Tax

Search "photography business expense spreadsheet" and you'll find a lot of free templates — most of them a single tab with a Date, Description, and Amount column. That's fine for a first pass at listing expenses. It's not enough to actually run a photography business, where income arrives per client with deposits and balances, expenses need to be tagged deductible-or-not for tax time, mileage adds up fast across shoots, and self-employment tax is due quarterly whether you've planned for it or not.

This post walks through what a photography business spreadsheet needs to do, where the free versions genuinely hold up, and where they fall short for photographers specifically.

TL;DR

Free expense spreadsheets are fine for logging a running list of costs, but most photographers need more: income tracked per client and shoot (not just a lump monthly total), expenses tagged with a deductible flag and category, mileage logged separately with the current IRS rate, and a quarterly tax set-aside that updates as income comes in. If a free single-tab template covers your needs, use it — that's a fair choice for a slow month. If you're juggling multiple clients with deposits and balances, or you've been surprised by a quarterly tax bill before, Sheetfolk's Freelance Photographer Tax & Expense Tracker ($17) is built around exactly those four gaps: per-client income, categorized deductible expenses, standard-mileage tracking with an editable IRS rate cell, and a quarterly tax set-aside, all rolled up on a Dashboard.

What Should a Photography Business Expense Spreadsheet Actually Track?

At minimum: every dollar in, every dollar out, and enough structure to know what you owe in taxes before the bill arrives.

For a photography business specifically, that breaks into four pieces:

1. Income — ideally by client and by shoot, not just a running deposit total, since photography income often arrives in pieces (retainer, then balance) rather than one lump sum per job
2. Expenses — tagged by category and by whether they're deductible, since gear, software, studio time, and marketing all get treated differently at tax time
3. Mileage — shoots, client meetings, and location scouting add up to real miles, and they're one of the largest deductions available if logged correctly
4. Tax set-aside — self-employment income isn't withheld automatically, and quarterly estimated payments are due on a schedule regardless of whether you've saved for them

A lot of free templates cover the first two loosely and skip the last two entirely.

Free Photography Expense Templates: What They Get Right

To be fair to the free options: a basic Google Sheets or Excel expense template with Date, Category, Amount, and a running total is a completely reasonable way to start. If you're shooting a handful of jobs a year as a side activity, a single expense tab might be all the structure you actually need — there's no reason to pay for more spreadsheet than your business currently requires.

Free templates are also genuinely useful for the mechanics: SUMIF and SUMIFS formulas for category totals, conditional formatting to flag large expenses, and basic charts for a spending overview. If you want to build that formula layer yourself, our guide on 10 Google Sheets formulas every budget spreadsheet needs covers the exact functions that make a bare expense list into something that actually totals itself.

Where Free Templates Fall Short for Photographers

The gap shows up once you have more than one active client, more than a token amount of driving, or a quarterly tax payment due.

Per-Client Income and Balance Tracking

A single "Income" column that just totals deposits doesn't tell you which client still owes you money, or what any individual shoot actually netted. Photography income is rarely one clean payment — a wedding booking typically has a retainer up front and a balance due closer to or after the event, and if you shoot for multiple clients in the same month, a lump total hides which jobs are paid in full and which are still outstanding.

Tracking income by client and by shoot — with columns for retainer received, balance due, and date paid — turns "I think everyone's paid up" into a number you can actually check.

Deductible Expense Categories, Not a Blank Column

A blank "Amount" column doesn't tell you what's deductible or what category it falls under, which means you're sorting a year of expenses in April instead of as you go. As covered in our photographer tax deductions checklist, photography expenses span gear, software, studio, travel, insurance, education, and marketing — each treated a little differently at tax time. A spreadsheet that tags each expense with a category and a deductible flag as you enter it saves you from re-sorting everything later.

Mileage for Shoots and Client Meetings

Driving to shoots, consultations, and location scouting is usually one of the largest deductions a photographer has, and it's the one most likely to get left out of a generic expense template, since it isn't a dollar amount you paid — it's a distance you drove, tracked separately and multiplied by the current IRS standard mileage rate (the current rate is 72.5¢/mile for 2026 — confirm the exact figure on IRS.gov before calculating, since it changes annually). A generic template built for retail or freelance-writing expenses usually has nowhere to log this at all.

Quarterly Tax Set-Aside

Self-employment income isn't taxed as you earn it — you're generally expected to pay estimated tax quarterly, and nothing in a basic expense sheet tells you what to set aside. Our quarterly tax estimator guide covers the mechanics of turning net income into a set-aside percentage. The piece a static free template is missing is connecting that set-aside directly to income as it's logged, so the number updates itself instead of needing a manual recalculation every quarter.

A Worked Example: Tracking One Wedding Booking End to End

Here's how one booking might move through a spreadsheet built for this, illustrated with example numbers:

*Mileage and the resulting net figure depend on the current-year IRS standard mileage rate — check IRS.gov for the exact figure before calculating your own number. The set-aside percentage is specific to your income and situation; confirm it with a tax professional rather than using a flat rule of thumb.

A single expense column with no client or category structure can't produce this view — it can tell you what you spent, but not what any one booking actually made you, or what portion you should be setting aside before it's spent on something else.

Free vs. Paid: Which One Do You Actually Need?

If you're shooting occasionally and just want a running expense list, a free template is a legitimate answer — don't pay for structure you don't need yet. If you're juggling several clients a month, driving to shoots regularly, and want your quarterly tax number to update itself instead of being recalculated by hand, Sheetfolk's Freelance Photographer Tax & Expense Tracker is built for that gap specifically: an Income tab by client and shoot, an Expenses tab with a deductible flag and category list, a Mileage tab using the standard mileage method with an editable IRS rate cell, and a quarterly Tax Set-Aside, all summarized on a Dashboard. It's a one-time $17.

How to Set One Up Yourself

If you're building your own version:

1. Create an Income sheet with columns: Date, Client, Shoot Type, Retainer Received, Balance Received, Total
2. Create an Expenses sheet with columns: Date, Category, Description, Amount, Deductible (Y/N)
3. Create a Mileage sheet with columns: Date, Purpose, Miles, Rate, Amount (with the rate pulled from a single editable cell so you only update it once a year)
4. Add a Dashboard or Summary sheet that pulls totals from the three with SUMIF/SUMIFS
5. Calculate a quarterly tax set-aside from net income at whatever percentage your tax professional recommends

For the formula side of step 4, see 10 Google Sheets formulas every budget spreadsheet needs. Set a weekly routine to update all four sheets — the same habit that works for side hustle income tracking applies here: 15 minutes logging shoots and receipts as they happen beats reconstructing a year of client payments in April.

If the weekly habit is the part that slips, a tool like TaskDrain can send you a recurring reminder so updating the spreadsheet doesn't depend on remembering.

Frequently Asked Questions

Do I need a paid template, or is a free one enough? If you're shooting a handful of jobs and just want a running expense list, a free template is enough. Once you have multiple clients with deposits and balances, regular mileage, and a quarterly tax number to manage, the structure of a purpose-built tracker saves real time.

Can I just use my bank statement instead of tracking separately? A bank statement shows what moved, not what category it belongs to, whether it's deductible, or which client a payment was for — you'll still need to sort it eventually, so tracking as you go is faster than reconstructing it later.

How is this different from a general freelancer expense tracker? Photography has specific patterns — deposit-plus-balance income per client, gear-heavy deductible categories, and mileage to shoots — that a generic freelance template usually doesn't structure for directly.

The Bottom Line

A free single-tab template is a perfectly reasonable starting point, and there's no reason to pay for structure you don't yet need. But once your photography business involves multiple clients, real mileage, and a quarterly tax bill, the gap between "a list of expenses" and "a system that tells you what each shoot netted and what to set aside" starts costing more time than the $17 a purpose-built tracker costs.

Want the structure without building it yourself? Sheetfolk's Freelance Photographer Tax & Expense Tracker tracks income by client and shoot, tags every expense with a category and deductible flag, logs mileage with the standard method and an editable IRS rate cell, and calculates a quarterly tax set-aside automatically, with a Dashboard that pulls it all together.

Disclaimer: This post is for informational purposes only and is not tax, legal, or financial advice. Deduction eligibility, the standard mileage rate, and quarterly estimated tax requirements depend on your specific situation and change year to year. Confirm current figures and eligibility with a licensed tax professional or IRS.gov before filing.

See Also

• Photographer Tax Deductions: What Freelance and Wedding Photographers Can Write Off
• Freelancer and Maker Quarterly Tax Estimator in Google Sheets
• How to Track Mileage for Uber/Lyft Without Losing Your Deduction at Tax Time
• 10 Google Sheets Formulas Every Budget Spreadsheet Needs