Home / Templates / Freelance Photographer Tax & Expense Tracker
2026 edition · Google Sheets template
Freelance Photographer Tax & Expense Tracker
Every shoot, expense and business mile in one sheet — income by client and shoot type, deductible expenses, an automatic mileage deduction, and a quarterly tax set-aside built for self-employed photographers.
Excel · Google Sheets · LibreOffice · one-time $17
Instant digital download — all sales are final, but if anything is genuinely broken we fix it fast or make it right. Email [email protected].
The actual file
Browse it before you buy
Every screenshot below is the real Freelance Photographer Tax & Expense Tracker workbook — real headers, real sample numbers, real formulas. Click a tab.
Click a tab — this is the real file, not a mockup. 6 tabs total.
Tab by tab
What's inside
5 tabs shown below, matched to the real column headers in the file.
Income by Client
Log each shoot by client and shoot type (Wedding, Portrait, Event, Commercial, Other) with what you invoiced and what's been paid — the outstanding balance calculates itself, with a collected-by-shoot-type rollup and an outstanding-balance total below.
Expenses
Business costs by category (gear, software, studio, props, travel, insurance, marketing, education) with a Deductible? flag, so your tax-deductible total is always known.
Mileage
Log business miles per trip; the deduction (miles × the IRS standard mileage rate you confirm in the settings cell) calculates itself.
Tax Set-Aside
Pulls taxable profit by quarter (collected income − deductible expenses − mileage deduction) straight from the other tabs, and shows what to park at your chosen set-aside rate.
Dashboard
Total invoiced, collected and outstanding, deductible expenses, mileage deduction, estimated taxable profit, tax parked, take-home, and a collected-income breakdown by shoot type.
Before you type a thing
It ships filled in — with sample data
Every tab you saw above already has worked example numbers in it, so you can see how Freelance Photographer Tax & Expense Tracker behaves before you touch it. Study it, then overwrite it — nothing is "real" until you replace the samples with your own numbers.
Honey cells are yours
Any cell shaded honey is an input — type over the sample value with your own. These are unlocked and unprotected.
Grey cells calculate themselves
Pale grey cells hold formulas and are locked. Leave them alone — totals, dashboards and progress bars update automatically as you fill in the honey cells.
Delivery & format
How you get it
Pay with Stripe, land instantly on a download page with your .xlsx workbook — plus an email backup of the same link, in case you lose the tab.
Open it your way: double-click for Excel or LibreOffice, or upload to Google Drive and choose Open with → Google Sheets.
Updates to this 2026 edition are emailed to you free — no repurchase, ever.
Because this is an instant digital download, all sales are final — but if anything is genuinely broken we fix it fast or make it right. Email [email protected].
Set expectations
What this is not
- Manual data entry — no bank or invoicing-tool sync; you log each shoot, cost and trip yourself.
- One shared file — sharing and permissions are handled through your own Google Drive, not a built-in login system.
- No native charts — totals and breakdowns show as bold cells and data bars, not chart objects.
- Room for 60 shoots, 50 expenses and 40 mileage rows — generous for most photographers; more than that means extending the SUM ranges yourself, or duplicating the file per year.
- Standard mileage method only — it does not compute the actual-expense method; the mileage rate already covers gas, maintenance and depreciation, so don't also deduct those.
- No depreciation schedule — big gear purchases over the de-minimis threshold may need to be depreciated rather than fully expensed in year one; the Expenses tab notes this in plain language but doesn't build the depreciation math (out of scope — confirm the treatment with a professional).
- Tax figures are rough estimates, not tax advice — the IRS mileage rate and set-aside rates change; confirm the current rate and your treatment with a professional.
- US-dollar formatting by default — changeable for any currency via Format → Number.
Getting started
Set up in 4 steps
Log each shoot on Income by Client — pick the shoot type and enter what you invoiced and what's been paid; the outstanding balance calculates itself.
Record business costs on Expenses and flag which are tax-deductible.
Confirm the IRS standard mileage rate in the honey cell at the top of Mileage, then log each business trip — the deduction calculates itself.
Tax Set-Aside shows what to park each quarter; the Dashboard totals collected income, deductible expenses, taxable profit and take-home.
Good to know
Freelance Photographer Tax & Expense Tracker FAQ
What format does it come in?
A single .xlsx workbook. It opens natively in Excel and LibreOffice, and in Google Sheets via "Make a copy".
How do I use it in Google Sheets?
Upload the .xlsx to Google Drive, right-click it, choose Open with → Google Sheets, then File → Make a copy to get your own editable version.
Is this built for photographers specifically?
Yes — income is tracked by client and by shoot type (Wedding, Portrait, Event, Commercial, Other) rather than by a selling platform, and the Expenses categories (gear, software, studio, props, insurance) match a photography business. It works whether you shoot weddings, portraits, events or commercial.
Which mileage rate does it use?
You confirm it. The Mileage tab has an editable settings cell for the IRS standard mileage rate — it ships defaulting to the 2026 business rate ($0.725/mile, per IRS Notice 2026-10), which you confirm against IRS.gov because the IRS sets a new rate each year. Every trip's deduction uses that one cell.
Does it handle depreciation on big gear purchases?
No — that's intentionally out of scope. Gear over the de-minimis safe-harbor threshold may need to be depreciated over several years rather than expensed all at once. The Expenses tab flags this in plain language, but it doesn't build a depreciation schedule. Confirm the right treatment with a tax professional.
Is the tax set-aside number accurate?
It's a rough estimate — taxable profit by quarter (collected income minus your deductible expenses and mileage deduction), times a set-aside rate you choose. Rates vary by country, state and total income, so confirm the right number with a tax professional.
What's your refund policy?
Because this is an instant digital download, all sales are final — but if anything is genuinely broken, we fix it fast or make it right. Email [email protected].
Instant download · No subscription · Free 2026-edition updates