Free Accounting Spreadsheet for Photographers


I created this spreadsheet for you, the busy photographer, who prefers a spreadsheet over tricky bookkeeping software. The tabs help you organize the information you or your accountant will need for tax time – all in one place!

  • INCOME – Use this sheet to record client/customer sales. Be sure that you do NOT include sales tax collected in the amounts recorded on this sheet.
  • EXPENSES – Use this sheet to track the money you spend from your business. Again, do NOT include the sales tax payments you make to your state.
  • MILEAGE – Track the mileage to and from business meetings. These would include photoshoots, pre-shoot client meetings, and even trips to the post office to mail client products.
  • TAXES – Use this sheet to calculate an estimate of what you should be saving and paying in for your quarterly income tax payments (this is NOT sales tax).
  • SALES TAX – Track the sales tax you’ve collected from your clients as well as the payments you’ve made to your state. If your state doesn’t have sales tax, count yourself lucky and ignore this sheet!


ADA Tax Credits and Deductions for Small Businesses

Can Pass-Through Taxation Save You Tax Money?


Amy Northard, CPA

The Accountant for Creatives®
+ taxes + bookkeeping + consulting
+ Hang out with me over on Instagram!

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Are things like taxes & bookkeeping getting in the way of your creative time? Let's Chat!
Bookkeeping & Tax Tips
Sign up for free tax tips and advice sent straight to your inbox!
By clicking on the submit button, you agree with our Privacy and Terms Policy.