I survived yet another year of self-inflicted tax prep

The annual exercise in accounting self-abuse that is me doing my own taxes ended three months later than originally scheduled and yet still on time, thanks to the IRS pushing Tax Day back to July 15 to make up for the coronavirus ruining everything.

That delay taught me what I’d needed all along to make this math masochism easier: a dress rehearsal a month and a half before the real deadline. Here, my thanks must go to the Virginia Department of Taxation, which extended the deadline to pay state taxes but only by a month–from May 1 to June 1–and left in place the automatic six-month extension to file state returns.

I didn’t want to send too much or too little money to Richmond, so I needed to get our federal taxes close enough to done for me to plug the relevant figures into our Virginia return and get a reliable estimate. I plowed through TurboTax, as usual needing much more time to calculate my business profit after expenses than for any other part of the return. As much as I miss having itemized deductions make a large amount of our tax bill vanish, getting them right did eat up a lot of hours.

(Side rant: My TurboTax labors also went faster than usual because I finally figured out the freakshow workaround required to import statements from some old American Funds holdings. Without that, I would have had to type in those figures by hand because the PDF download this inept investment firm provided was a giant image without any selectable numbers.)

That work yielded nearly-final figures for the federal return that I could flow into a Virginia return in TurboTax. Then I double-checked that result by redoing the state math in Intuit’s woeful Free Fillable Forms online app, what I actually use to file because I refuse to reward Intuit for its rent-seeking strategy of getting states to retire their own online-filing tools.

In past years, TurboTax and Free Fillable Forms have agreed on what I’d owe Richmond or what Richmond owed us. This year, the stone tablet of spreadsheets said we’d owe $10 more than what TurboTax estimated for our Virginia bill. I ignored that at the end of June but went back through all the numbers again this week without finding any reason for the difference. Which is fine–maybe we paid Virginia a Hamilton we don’t owe, but I’m sure my state could use the help these days.

After going over our federal returns one last time Wednesday night, I had them e-filed before 10 p.m. Wednesday, then had the state returns dispatched an hour later. That left one last tax-prep chore: tweaking the Google Docs freelance expenses spreadsheet template that I shared here two winters ago to make it a little clearer which home-office expenses should be added together.

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!

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.