Here’s the Google spreadsheet I use to track my expenses

A friend of mine started freelancing at the end of last year, so I decided to give him a boring but useful present: a blank copy of the Google Docs spreadsheet I use to track my expenses.

old calculatorA systematic, easily smartphone-accessible way to record the costs of doing business–organized so you can copy the year-end totals into your Schedule C tax form–is exactly the thing I needed when I started freelancing almost eight years ago. Instead, I had to survive some excruciatingly stupid accounting practices and eventually thumb-wrestle my way to marginal competence.

I was glad to give my friend a boost past that phase, and now I want to do the same for any self-employed types reading this. Here you go: Make a copy of this template (go to the File menu and select “Make a copy…”) to your Google account and get to work.

This template is organized by types of expense, with the biggest categories in my case–travel and meals and entertainment–getting their own sheets. When possible, I’ve aligned types of costs with TurboTax’s vocabulary to reduce springtime tax-prep confusion. In addition, you’ll see a box in which you can plug in the relevant numbers for a home-office deduction, but I recognize that not every 1099-income type will claim that.

I’ve also left comments throughout the spreadsheet (look for the orange triangle at the upper-right corner of a cell) explaining what goes where. If you see ways to simplify this or if you think the spreadsheet is missing an important angle, please let me know in an e-mail or a comment below this post.

I hope this help. Good luck with your business!

Advertisements

6 thoughts on “Here’s the Google spreadsheet I use to track my expenses

  1. Why not use an expense tracking app? This spreadsheet was great several years ago, but by using an app you can scan your receipts allowing you to throw the original away and letting the app read the details to eliminate a lot (not all) of your typing. As a freelancer all you need to do is run some reports at the end of the year to show all your expenses. Not sure what Expensify gives you for free, but if it’s not enough look at Zoho.

  2. Pingback: Here’s my Web-services budget | Rob Pegoraro

  3. Pingback: A small consumer victory: exercising a Chase credit card’s trip-delay coverage | Rob Pegoraro

  4. Pingback: My continued struggles with quarterly accounting | Rob Pegoraro

What do you think?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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