Tag Archives: paste

IRS Form 8949: You Can ‘Copy & Paste’ Into 8949 At Least With The IRS ‘Free Fillable Forms’.



 ..by Anura Guruge

Related Posts:
>> IRS Form 8949 Should Be On An Exception Basis … — Apr. 11, 2013.
>> IRS Provided ‘Free Fillable Forms’: Huge Endorsement — Mar. 20, 2013.

As ‘Tax Day’ approaches, as was to be expected, there is growing interest in IRS Form 8949 — which only came into effect as tax year 2011.

If you use Quicken (which I refuse to do, because I really don’t see why it needs to know my inside leg measurements, what statin I take for my cholesterol and the make of car I drive), I gather that Fidelity (for one) will provide downloadable 8949 data that will get automatically filled in. Well, even that will not convince me to use Quicken (though I did use it, a decade ago, when I was honing my tax preparation skills). That Fidelity does not provide us with this data in Excel (comma separated data) form is inexcusable and I did complain about it this year. I assume that there must be other financial institutes that are gracious enough to provide this data in Excel form to their clients.

So what I do is create my own Excel using the PDF (or HTML) of the tax statements available online with Fidelity.

I will copy all the columns and then do a PASTE SPECIAL (Text) into a Word document. I will then use the global replace function of Word to add tabs. Then I do a Text –> Table conversion. Then I delete the columns I don’t want. I then copy the entries of this table to a new Excel spreadsheet — again doing a PASTE SPECIAL (Text).

Then, just because I enjoy messing around with Excel, I subtotals of all the transactions to make sure Fidelity got them correct! Having the subtotal also serves as a ‘check sum’ to make sure I that I haven’t lost any transactions.

Then I fire up Free Fillable Forms (FFF) and create a new Form 8949. I can then copy across a complete row, from Excel to FFF and then paste it.

So, if you notice I haven’t typed in any of the transactional data per se. All of it is essentially copy, paste …. copy, paste.

I can do this fairly quickly. That I have two monitors which enables me to keep the Excel on the left-hand side monitor and FFF on my (main) right-hand side monitor definitely helps.

Hope this helps. Enjoy.