What is the best way to track my wheel trades for tax purposes?

Keeping a simple spreadsheet is the best way to track your wheel trades for tax purposes — at least until your account grows large enough to justify paying for dedicated software. The IRS doesn't care how pretty your system looks, but they do care that you can reconstruct every transaction if you get audited.

Here's the thing most beginners miss: the wheel strategy creates a paper trail that's messier than it looks. You're not just buying and selling stock. You're selling puts, potentially getting assigned, collecting premium, selling calls against your shares, potentially getting called away — and each of those events has its own tax treatment. If you don't track them as they happen, you'll be staring at a 1099-B in February trying to remember what you were thinking in March.

What You Actually Need to Record

For every trade, capture these six things the moment you place it: the ticker, the date opened, the date closed, the strike price, the expiration date, and the net premium collected or paid. That's it for the core record. But you also want a "notes" column where you can write things like "assigned on 100 shares at $145" or "called away, combined P&L with original put premium."

Why the notes column? Because when you sell a cash-secured put on NVDA at a $420 strike and collect $8.50 in premium, then get assigned, your broker will show the assignment on your 1099 as a stock purchase at $420 — but your actual cost basis is $411.50 per share ($420 minus the $8.50 premium). Some brokers handle this adjustment automatically. Many don't. If you don't have your own record, you might overpay taxes on the eventual stock sale.

A Real Example: AAPL in a Three-Month Wheel

Say you started a wheel on AAPL in January. You sold a February $170 put for $3.20 in premium. It expired worthless. Then you sold a March $168 put for $2.80 — and got assigned. Your cost basis in those 100 shares isn't $168. It's $168 minus $3.20 minus $2.80, which is $162. That's $600 in premium that reduces your effective cost basis.

Then you sold covered calls against those shares for two months, collecting another $4.10 in total premium before finally getting called away at $175. Your spreadsheet should show the entire chain: two puts, two covered calls, and the final stock sale. Your actual profit is the difference between $162 (adjusted cost basis) and $175 (sale price), which is $1,300 on 100 shares — not the $700 the raw stock transaction would suggest.

If you handed that chain of trades to a tax preparer without explanation, they might calculate your gain incorrectly. Your own records are what protect you.

The Wash Sale Problem

This is where tracking gets genuinely important and where a lot of wheel traders get surprised. If you get assigned on AAPL, sell it at a loss, and then sell another put on AAPL within 30 days — you've triggered a wash sale. The loss gets deferred. Your broker may or may not flag this correctly on your 1099.

Your spreadsheet should have a column for "wash sale risk" that you check whenever you close a position at a loss. It sounds tedious, but it takes about 30 seconds per trade and can save you a real headache come April.

Tools That Actually Work

A Google Sheet or Excel file is genuinely fine for most people running a wheel on five to ten positions. Build one tab per year, with columns for all the fields mentioned above. Color-code assigned trades differently so you can trace the full wheel cycle visually.

If you're running more than 15 simultaneous positions or trading across multiple accounts, consider TradeLog or Tradervue. TradeLog specifically handles wash sale calculations and imports directly from most major brokers. It runs about $99 to $199 per year depending on the plan. Worth it if you're doing real volume; overkill if you're selling five puts a month on blue chips.

Your broker's built-in tax tools (Thinkorswim, Fidelity's tax lot viewer, Tastytrade's transaction history) are useful for verification but should not be your primary record. They don't know your strategy. They don't know which put led to which assignment. Only you know the full picture.

The One Thing to Do This Week

Export your last three months of options transactions from your broker right now and build your tracking spreadsheet. Don't wait until December. Every trade you reconstruct from memory is a trade where you might get the numbers slightly wrong — and wrong numbers either cost you money in overpaid taxes or create risk if you're ever reviewed.

Set a calendar reminder for every Friday to update your sheet with that week's trades. It takes maybe ten minutes. That ten minutes is the difference between a clean tax filing and a February panic where you're trying to figure out whether that NVDA put from eight months ago was part of a wash sale chain.

Your records are your protection. Build them now, maintain them weekly, and you'll walk into tax season with confidence instead of dread.