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 helps. Good luck with your business!

Advertisement

Weekly output: Windows XP (x2), Google Docs

It really is extraordinary (or maybe just sick) that this past week saw me still writing about an operating system that debuted in 2001.

Yahoo XP story in IE 64/8/2014: Die, XP, Die! Why the Operating System from 2001 Won’t Go Away, Yahoo Tech

I’ve been looking forward to writing this column for several years, and when the end of Microsoft’s support for Windows XP finally arrived I found it strangely enjoyable to revisit stories I’d written five and 10 years ago about XP. I’ve since heard from a few readers who say they prefer XP to Windows 7 or 8 not just because they need to run legacy apps or don’t want to buy a new PC, but because XP is easier. I’m wary of questioning a reader’s subjective judgment, but… um, no.

(Screenshot shows how the story renders in a copy of Internet Explorer 6 in Windows XP. Don’t ask how I sourced that image.)

4/8/2014: Windows XP, WTOP

I talked for a few minutes about the end of XP support and what users of that fossilized malware magnet of an operating system could do to stay safe.

4/13/2014: Why your browser doesn’t like copy and paste, USA Today

To judge from the low number of Facebook and Twitter shares displayed next to this story, almost nobody read my attempt to concisely how the intersection of browser security models with Web apps that look and work like local ones can lead to dysfunctional results. I’ll try to find a more enticing topic next week.