Templates · Google Sheets

Photographer Bookkeeping & Mileage Tracker

Simple bookkeeping for your photography business: log what comes in, what goes out and the miles you drive, and Reports shows your monthly profit, a tax set-aside estimate and income by category.

Track income & expenses
Log business miles
See your profit and tax set-aside

$12.00

Buy on Etsy

Instant download on Etsy. Checkout on this site is coming soon.

Photographer Bookkeeping & Mileage Tracker in Google Sheets on a laptop, shown with sample data

What's inside

Start HereYour welcome page: a 4-step setup checklist, how the tabs fit together, a guide to every tab with clickable links, and the color legend.
ReportsYour year at a glance: income, expenses, net profit and the tax set-aside as tiles, then a month-by-month profit & loss, expenses by category, the quarterly tax set-aside, income by category and a chart of income against expenses.
IncomeEvery payment you receive: date, payer, description, category, type (Payment, Tip or Refund), method and amount. Income and Month calculate by themselves.
ExpensesEvery business purchase: date, vendor, category, amount, business-use %, how you paid, a receipt link and notes. Business Amount and Month calculate by themselves.
MileageEvery business drive: date, client or shoot, from, to, purpose, one-way miles and round trip. Total Miles and the Deduction calculate from the rate in Settings.
SettingsSet up once: your business name, the month your fiscal year starts, your tax set-aside %, the mileage rate, and your income, expense and payment lists.

A closer look

Profit & loss, month by month: Income, expenses, mileage, net profit and a tax set-aside, added up for you. (Bookkeeping Tracker, sample data)

Income by category: See where your money comes from, next to income vs. expenses by month. (Bookkeeping Tracker, sample data)

Log every payment: Payments, tips and refunds, with a category for each. (Bookkeeping Tracker, sample data)

Expenses with business-use %: Log purchases, keep receipt links, and count only the business share. (Bookkeeping Tracker, sample data)

Mileage log and deduction: Log drives; the deduction uses the rate in Settings. (Bookkeeping Tracker, sample data)

Screenshots show the Sample copy with made-up data.

Get set up in minutes

Open your copy's Start Here tab.
Settings: your business name, fiscal year start, tax set-aside % and this year's mileage rate.
Settings lists: your income and expense categories.
Log this month's income, expenses and drives.
Open Reports to see your profit and tax set-aside.

Good to know

Google Sheets: you need a free Google account. This isn't an Excel file.
Works in any browser on a computer, tablet or phone. Setup is easiest on a computer.
Nothing to install: no add-ons, no scripts.
You get a ready-to-use copy plus a Sample copy filled with example data, and a step-by-step PDF guide.
Built for photographers, but works for any small service business: just rename the categories.
The tax set-aside is an estimate to help you save, not tax advice.

Want it all connected?

The Photographer Business Command Center includes the Bookkeeping Tracker plus clients, jobs, payments, pricing, bookkeeping, invoices and more, in one file.

See the Command Center · $29.99