Report this item to Etsy

Photographer Bookkeeping Spreadsheet | Photography Business Income, Expense & Gear Tracker (Google Sheets, Excel)

NowPrice:$7.49

Original Price: $14.99

50% off

•

Sale ends on November 6

Includes Etsy Purchase Protection

You can only make an offer when buying a single item

Highlights

  • Designed by ProfitDrawer
  • Digital download
  • Digital file type(s): 3 Files

A complete photographer bookkeeping spreadsheet with monthly and annual dashboards. Track income and expenses, see your profit, chase unpaid invoices and get a tax summary - in Google Sheets or Excel.

Gear is the biggest deduction most photographers under-claim. Every lens, body and bit of software gets logged where your accountant can find it.

12 tabs, every formula already written and locked. No subscription. No sign-up. One payment and the files are yours to keep.


WHAT'S INCLUDED

- Bookkeeping-Template.xlsx - the 12-tab workbook, works offline in Excel
- Google-Sheets-Setup.pdf - import it into your own Google Drive in three clicks
- READ-ME-FIRST.pdf - the setup steps and what every tab does

There is no shared link to expire. You import the file into your own Google Drive, so the spreadsheet is yours and cannot break.


SET UP IN FIVE MINUTES, NO VIDEO NEEDED

Seven plain-English setup steps are built into the first tab. No tutorial to sit through, nothing to install and no account to make with me.


THE 12 TABS

- Annual Dashboard - income, expenses, net profit, money owed, tax set-aside, miles, your best month, a profit-goal ring and charts of where the money comes from and goes
- Monthly Dashboard - pick any month from a dropdown: profit, change vs last month, progress to your monthly goal and every category
- Quarterly - pick Q1 to Q4 for totals, the months inside it and the tax to put aside for quarterly payments
- Income - date, client, invoice number, category, amount, paid yes/no
- Expenses - date, paid to, category, amount, receipt link; business or personal fills itself in from the category
- Mileage - from, to and miles; the deduction is worked out with your own rate
- Unpaid Invoices - every unpaid invoice, oldest first, flagged at 30 and 60 days
- Top Clients - ranked by what they paid this year, with invoices and amounts still owed
- Monthly Summary - income, expenses, profit, margin, unpaid and miles for every month
- Tax Summary - totals by category, deductible amounts, mileage deduction and a suggested tax set-aside
- Settings - business name, financial year, currency symbol, mileage rate, tax %, profit goal and your categories
- Start Here - the seven setup steps


BUILT PROPERLY, NOT THROWN TOGETHER

- Your financial year can start in any month, and every tab follows it
- Any currency: set your symbol once on Settings
- Every formula is locked so it cannot be broken by accident
- Categories are dropdowns already set up for photographers, and you can rename them
- Owner draw and personal spending are kept out of profit and tax
- Room for 1,000 income rows, 1,000 expenses and 500 trips a year


WHO IT'S FOR

Wedding, portrait and commercial photographers tracking shoots, gear and travel.


WHAT YOU NEED

Microsoft Excel 2010 or newer (Windows or Mac), or a free Google account for Google Sheets. Nothing else. The Excel file works with no internet connection.


INSTANT DOWNLOAD

Nothing is posted to you. Your files are ready the moment your order goes through - find them under You, then Purchases and reviews, then Download Files.


REFUNDS

Because the files are delivered instantly and cannot be returned, all sales are final. But if a file will not open, will not calculate, or is not what was described, message me and I will fix it or refund you. I would always rather solve the problem than leave you with something you cannot use.


PLEASE NOTE

This is a spreadsheet, not tax advice. The tax summary adds up your categories so you have clean figures to give your accountant. It does not file anything for you.

The images show the spreadsheet filled with sample data. Your copy arrives with five example rows per tab that you clear before you start.

Your purchase is for your own business use. Please do not resell or redistribute the files.


I reply to every message within 24 hours.

Instant Download

Your files will be available to download once payment is confirmed.  Here's how.

Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases — see program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Assortment of wedding items that are available on EtsyAssortment of wedding items that are available on EtsyAssortment of wedding items that are available on Etsy

Get personalized picks for your big day!

Wedding date
No date yet? Explore wedding ideasOpens a new tab

Top wedding searches to shop

Bridesmaid gifts

Groomsmen gifts

Wedding gifts

Engagement gifts

Explore related searches

Photographer Bookkeeping

Listed on Aug 28, 2026
Homepage Paper & Party Supplies Paper Stationery Design & Templates Templates Bookkeeping Templates