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.
A 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’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.
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.