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!

Weekly output: financial and tax insecurity, Solo drone, future of radio, lost location apps

My trip to the NAB Show ended with a red-eye flight home to the East Coast, something I don’t think I’ve done for business travel since 1996. Let’s just say I can’t rally from the experience as well as I did back then.

Yahoo Tech tax-return fraud post4/14/2015: The Other Reason Tax Prep Should Make You Nervous, Yahoo Tech

I had meant to file this piece about financial-account security and tax-refund fraud before heading out to National Airport for the first of two flights to Vegas but instead pretty much wrote the whole thing on the ORD-LAS segment.

After reading it, please look over last year’s tax-time column: a recount of how Intuit, the company whose weak security helped grease the skids for a fair amount of identity-theft refund fraud, has worked to ensure it won’t face competition from federal or state governments when it comes to online tax prep.

4/15/2015: 3D Robotics’ Solo Drone Can Fly Circles Around You, Yahoo Tech

I’m still not sure what possessed 3D Robotics to debut this drone at a convention for the broadcast media, but I thought the product fascinating enough that it was worth writing up the experience. My one disappointment: Nobody besides my editor seems to have picked up on my “a Solo can shoot first” line.

4/15/2015: The Journalists Panel, NAB Show

My primary reason for going to the NAB Show was to participate on this panel, in which longtime radio exec Jeff Simpson quizzed Radio World editor Paul McLane and I about the competition AM and FM stations face from online alternatives. I emphasized locality: Stations should try to sound like where they are, something a worldwide app like Pandora can’t do. If only more commercial FM stations would follow my advice when it comes to music programming.

4/19/2015: How location-aware app can get lost on WiFi, USA Today

I’ve touched on this topic before, but this time I had the benefit of talking to some smart mobile-app developers who clued me into some important differences in how location-based apps work in iOS and Android.

I survived doing our own taxes (I think)

Over the last few weeks, I did the one thing I was sure I’d never do after leaving the Post: prepare my own taxes instead of paying a tax professional to do the work.

I’d outsourced my tax prep over the last three years with generally satisfactory results. But this time around my tax guy had raised his rates while my own financial situation had not gotten more complex; I felt like I had finally disciplined my once moronic, then merely slovenly accounting; it seemed wrong to go four years without even looking at a category of software millions of Americans do battle with every spring.

1099s and TurboTaxAnd so I renewed my acquaintance with Intuit’s TurboTax for the first time since 2011–not as a reviewer, but as a paying customer. It went better than I’d feared.

The biggest upgrade from my earlier agonies was effective record-keeping: I’d entered every cash expense last year into a Google spreadsheet on my phone within hours or, at worst, days, then imported business credit-card transactions into the same sheet every quarter. Between that and being able to consult last year’s return for guidance on what should go where, I had the outlines of my Schedule C knocked out in shockingly little time.

That’s a great reason to go to a tax pro in the first place: If you don’t know to do this stuff, you need somebody who can coach you. The results don’t just help at tax time, but throughout the year.

TurboTax’s ability to import tax forms for all of our mutual funds–something I’ve complimented in earlier reviews–was a great time-saver. And seeing each investment firm’s numbers flow into our return meant I got a direct look at the tax hit inflicted by some actively-traded mutual funds versus index funds. Ouch.

I was relieved to see that the stupid date-validation bugs I’d complained about in 2011 were gone–well, in most of the app.

Did I play this unnecessary game of tax-code-optimization as well as I could? I believe I did, but I won’t know for sure until after we actually file. Yes, although the 1040 and our assorted alphabetical schedules are done, I opted to file an extension. I will be dropping a sizable chunk of money into my SEP IRA to chisel down our tax bill, and I’d rather not completely clean out my account in the process.

I also did our Virginia taxes in TurboTax. Then I deleted that return after writing down the total it had calculated and the two numbers I’d need to put down on my state return. Intuit may have convinced a gullible General Assembly to scrap the state’s free iFile site in 2010, but that doesn’t mean I need to reward its successful regulatory capture with my own business when state taxes aren’t that hard and I can always file on paper.