Tax Tracking Spreadsheet for Wheel Traders

# Tax Tracking Spreadsheet for Wheel Traders

The most expensive mistake wheel traders make is not a bad trade — it is trusting the broker 1099. Wheel strategies generate dozens of opening, closing, rolling, and assignment events per quarter, and the cost-basis logic inside most retail broker tax reports was not built for that volume or that complexity. The result: misclassified short-term gains, missed wash sales, and an IRS Form 8949 that does not match what actually happened in the account.

This post covers what to track, how the IRS classifies wheel trades, where broker 1099s typically go wrong, the Section 1256 confusion that has been floating around the community, and a downloadable spreadsheet schema you can use as a starting point.

Wheel tax tracker template — coming soon. Email support@retirewheel.com to get notified when it ships.

Why broker 1099s misclassify wheel trades

Three structural problems show up in nearly every retail 1099-B for wheel traders:

1. Assignment cost basis adjustment. When a CSP is assigned, the premium received reduces your cost basis in the shares. Many brokers report the share basis at strike price and the put premium as a separate short-term gain — double-counting income and inflating your share basis. The IRS publication on this is clear; the broker software often is not.
2. Wash sale tracking across the option/stock boundary. A loss on a covered call closed for a debit, followed by selling another covered call on the same shares within 30 days, can trigger wash sale rules. Few brokers flag this correctly. Some flag it when they should not. Either way, you cannot trust the wash sale column.
3. Rolling treated as two unrelated trades. When you roll a CSP — buy to close the current contract, sell to open the next — most brokers report two separate transactions. For your records you need to understand them as a connected position; the IRS does not care about that, but you do when you are reconciling.

The fix is not to fight the broker. The fix is to keep your own log, then reconcile against the 1099 at year-end. Differences get researched and either corrected on Form 8949 with adjustment codes or accepted as broker-correct.

What to record on every trade

The minimum fields for a defensible tax record:

• Date opened / Date closed (or expiration / assignment date)
• Underlying ticker
• Trade type (CSP, CC, roll-out, roll-down, assignment, called-away)
• Strike
• Expiration
• Contracts
• Premium received / paid (per contract and total)
• Commissions and fees
• Net P/L
• Holding period (for short-term vs long-term classification on assigned shares)
• Linked trade ID (for rolls — so you can reconstruct the position)
• Cost basis adjustment (for assigned shares — strike minus net premium)
• Wash sale flag (your own check, not the broker's)
• Account (taxable, IRA, Roth — matters for routing, not for 8949)
• Notes (any unusual handling, manual basis adjustments, deferred losses)

The template at the link above gives you a row schema with these columns plus three summary tabs: per-position roll-up, monthly P/L, and a year-end 8949 reconciliation worksheet.

Form 8949 and Schedule D basics

For most wheel traders in taxable accounts, the income lands on:

• Form 8949, Part I — short-term gains and losses (options held under one year, which is essentially all wheel positions).
• Schedule D — totals from 8949 flow here.
• Form 1040 — Schedule D totals flow to the main return.

If your broker reports basis to the IRS (covered transactions), you use Box A. If basis is not reported (rare for retail options), Box B. Adjustments — wash sales, basis corrections — go in column (g) with the appropriate adjustment code in column (f). The IRS publishes the code list; the common ones for wheel traders are W (wash sale loss disallowed) and B (basis correction).

The 8949 reconciliation tab in the template lets you list every closed lot, your broker-reported figure, your corrected figure, and the adjustment code. If your broker is right, the columns match and you copy through. If not, you have the receipts to defend the adjustment.

Wash sale rules for wheel traders

Wash sale rules disallow a loss when you buy a "substantially identical" security within 30 days before or after the loss. For wheel traders the common triggers are:

• You closed a covered call for a loss, then sold another covered call on the same shares within 30 days. The IRS position on this has been debated; the conservative read is that selling another short option on the same underlying within the window can trigger a wash. Many CPAs disagree on options-to-options wash sales — verify with yours.
• You took an assignment loss on shares, then re-entered a CSP on the same ticker within 30 days that was later assigned. The new lot's basis gets adjusted by the disallowed loss.
• You closed a stock position at a loss in one account and bought it back in another — including an IRA. Yes, the cross-account wash sale rule applies, and a loss disallowed by an IRA purchase is permanently lost (not added to IRA basis).

The defensive move is to log every closed losing trade with a wash-window flag, then check the flag before re-entering on the same ticker.

Section 1256 confusion: SPYI vs XDTE and friends

This is the most common tax misunderstanding in the wheel community right now. The short version:

• Section 1256 contracts get 60/40 treatment: 60% long-term capital gains rate, 40% short-term, regardless of holding period. They are also marked-to-market at year-end. The list is narrow: broad-based index options (SPX, NDX, RUT), regulated futures contracts, and certain non-equity options.
• SPYI (Neos S&P 500 High Income ETF) uses SPX index options internally, and the fund passes through Section 1256 treatment on the options-related portion of its distributions. So yes — SPYI distributions do include 1256-treated income at the fund level, which is one of the reasons it appears in tax-optimized income portfolios. The 1099 you receive will reflect the 60/40 split.
• XDTE (Roundhill S&P 500 0DTE Covered Call Strategy ETF) is a different animal. Despite the index-option exposure, a substantial portion of XDTE's distributions has historically been classified as Return of Capital (ROC), not 1256 capital gains. ROC is not 1256. ROC reduces your cost basis in the fund and defers tax until you sell. It is not a free lunch; it is a deferral.

The practical implication: if you are running income ETFs alongside your wheel positions, do not assume an "option-income ETF" is Section 1256. Read the most recent 19a-1 notices and the fund's tax classification statement. SPYI and XDTE are taxed differently. So are JEPI, JEPQ, QYLD, and the YieldMax suite — each fund's structure determines treatment. Your spreadsheet should have a per-ETF tax-character column so you do not reconcile blind in April.

Verify the current Section 1256 list with your CPA before filing — the IRS occasionally updates which contracts qualify, and fund-level treatment can change with prospectus amendments.

Reconciling the 1099 to your log

The year-end workflow:

1. Export your broker 1099-B and your in-account trade history (CSV).
2. Open the tracker. Paste broker data into the "Broker Reported" tab.
3. The reconciliation tab compares each closed position to your log row. Differences flag in red.
4. For each flagged row, decide: broker is right (delete your log entry), you are right (file 8949 adjustment), or it is a wash sale the broker missed (log code W).
5. Sum the corrected short-term and long-term totals. Those numbers feed Schedule D.

Plan an afternoon. For a moderately active wheel account — say 200–400 closed positions per year — this is a two- to four-hour exercise once a year. It is not optional.

Routing the proceeds: 25 / 50 / 25

The framework most disciplined wheel traders use for handling realized premium is a three-bucket route:

• 25% to Tax. Set aside in a separate sweep account. Quarterly estimated payments come from here. At year-end, true up against actual liability — overage flows back into Growth.
• 50% Retained. Kept inside the trading account as working capital. This is what funds the next CSP cycle and gives you the buffer for assignment.
• 25% to Growth. Pulled out monthly into a separate long-term portfolio — index funds, individual equities, or whatever your growth allocation is. This is where the wheel income compounds outside the wheel.

The tracker has a tab to log realized P/L by month and auto-route to the three buckets so you are not making the allocation decision case by case.

Bottom line

The wheel strategy generates more tax-reporting complexity than buy-and-hold by an order of magnitude. Keep your own log, reconcile against the 1099, file the 8949 adjustments where the broker is wrong, and route the proceeds before they get spent. The downloadable template is a starting point — your CPA will likely want to add columns for state-specific items.

Educational content only. Not tax, legal, or investment advice. Past results do not predict future returns. Wash sale rules, Section 1256 classification, and ETF tax treatment are technical and change over time. Consult a licensed CPA before filing, and a fiduciary financial advisor before changing your investment plan.