Security Taxable Income Worksheet

Working Through Taxable Income from Securities

Most people treat investment income like it's straightforward. It isn't. You have gains, losses, dividends, wash sales, and various holding periods that all interact in ways that will cost you money if you get them wrong. A Security Taxable Income Worksheet is basically the structure that keeps all of that from collapsing into itself.

How to Use a Security Taxable Income Worksheet

I keep one spread sheet that tracks every taxable event across all accounts. Not per trade. Per transaction lot. The worksheet has columns for acquisition date, disposition date, proceeds, cost basis, gain or loss classification, and whether a wash sale applies. That's it on the surface. The real work happens in the mapping. Short-term gains go on Schedule D line 1. Long-term gains go on line 8. Qualified dividends should be separate from ordinary dividends. And that's before you account for the wash sale rule, which disallows a loss if you buy substantially identical securities within thirty days before or after the sale. People routinely miss the window going backwards from the sale date. Here's a concrete example. I had a client who sold a position at a loss in March, claimed the loss on his taxes, and then quietly bought the same ETF back two weeks later to average down. The IRS caught it on audit, disallowed the entire loss, and added penalties. The fix was a full lot-by-lot reconciliation before filing, not after.

I built my current Security Taxable Income Worksheet after years of wrestling with mismatched 1099-B forms from different brokerages. Every broker reports cost basis differently. Some use average cost. Some use FIFO. Some don't report basis at all, which means you're working blind. The worksheet forces you to reconcile each lot against what the broker actually reported.

What Most People Miss

The wash sale rule is the big one. It applies across all your accounts, not just within a single brokerage. If you sell a stock at a loss in your IRA and then buy it in your taxable account, or vice versa, the loss is still disallowed. I've seen tax preparers only check the same account. That's incorrect. The IRS doesn't care about account boundaries here. Another thing nobody talks about is the difference between reported basis and adjusted basis. Your 1099-B shows what the broker calculated. Your actual basis might differ because of reinvested dividends, return of capital distributions, or prior wash sale adjustments. Those get added to the cost basis and reduce your gain. If you don't track them, you overreport income.

There's also the holding period question. Inherited securities get a step-up in basis to the fair market value at the date of death. Gifts get a carryover basis in most cases, unless the fair market value at the time of the gift was less than the donor's basis, which creates a dual basis system for gain and loss. This shows up on the worksheet as a different input column, but it trips people up constantly.

When the Worksheet Breaks

It falls apart if you try to use it for complex instruments. Options, futures, short sales, and partnership K-1s don't fit cleanly into a standard security lot structure. Options require tracking exercise dates, strike prices, and premium calculations. Futures have mark-to-market rules that bypass the worksheet entirely. If you're dealing with those, you need separate schedules and the worksheet becomes a partial tool at best. Foreign securities add another layer. The IRS requires reporting of foreign tax credits and foreign asset disclosures that exist outside the normal U.S. security framework. You can tack those onto the same document, but you're really running two worksheets in one now, and the maintenance burden increases significantly.

Where to Get One

You can find free templates through the IRS website under Publication 550 materials, or build your own in a spreadsheet program. The commercial tax software versions are fine if you only have domestic equities and mutual funds. Once you cross into international holdings or derivatives, you'll want something that lets you flag each transaction type separately rather than forcing everything into a gain-loss binary. I use a custom Google Sheets version that pulls 1099 data via CSV import, auto-calculates holding periods from acquisition and disposition dates, and flags any transaction that falls within a wash sale window. It takes about twenty minutes to set up once. After that, I add new lots as they come in throughout the year instead of trying to reconstruct everything in April.

The bottom line is that the worksheet works as long as your situations stay within reasonable bounds. Standard stock and fund sales, qualified and ordinary dividends, simple capital loss carryovers. Anything more complex than that is where the tool starts to show its limits and you need to layer on additional schedules or professional help.