NAVIGATING THE CORPORATE GRID: UK EQUITY SURVIVAL MANUAL

So, you got paid in virtual corporate scrip (RSUs) rather than cold, hard cash. Congratulations, pioneer. You've earned the right to be dual-siphoned by two separate sovereign tax syndicates, calculated on a paper value you couldn't even sell at. Here is your extraction protocol to climb out of this digital hellscape.

STEP 1 — SCRAPE THE DATA FROM THE MAINFRAME

You need to jack into E*Trade's user-hostile architecture and download two conflicting datasets, because presenting them in a single, coherent format would violate their corporate core values:

• BenefitHistory.xlsx — The Scroll of Eternal Regret. A ledger of every vest event since you sold your soul to the enterprise. Locate it at: At Work → My Account → Benefit History → Download Expanded. DO NOT open this spreadsheet on your local rig unless you want to crash your neural interface; it is a formatting disaster. Our engine will dissect it safely in the background.
• Your orders — The digital receipt of your commercial desperation. Under My Account → Orders, drag the date filter back to your very first day of wage slavery, highlight the entire HTML table, and paste it raw into the input field. Cancelled trades? Let them burn; the engine automatically filters out the garbage.

Market data is pulled directly from Yahoo Finance because E*Trade has a habit of vesting your shares on weekends when the markets are physically offline, while HMRC demands accounting based on daily spot rates. Naturally.

THE FISCAL MEAT GRINDER: UK STOCK TAX

• Income Tax + NI at Vest: The Tax Overlords intercept up to 47% (or 62% if you're stuck in the child benefit trap) of your shares before they even land in your wallet. You are taxed on the theoretical peak value on vesting day under the HMRC Securities Options Manual (ERSM110000), which covers RSUs and LTIPs. If the stock plunges five minutes later, you still owe tax on that high-water mark. Oh, and your employer might legally dump the Employer's National Insurance levy onto you via a Joint NICs Election (see HMRC's guidance on transferring secondary NICs). Delightful.
• CGT When You Liquidate: If you survive the initial vesting tax and the stock somehow goes up, you get hit with Capital Gains Tax. This is calculated using a matching algorithm that feels like it was designed by a sadistic AI.
• The Currency Matrix: Your assets trade in greenbacks (USD), but the tax-drone syndicate requires calculations in Sterling (GBP). Every transaction must be converted to GBP using daily averages. No, you can't use the conversion rate you actually received when you withdrew it. That would make too much sense.

THE ACQUISITION DATE — WHERE WAGE-SLAVES FAINT

Repeat after me: Your acquisition date is NOT the settlement date. Under the sacred text of TCGA 1992 s.119A, your acquisition date and cost basis are welded to the vesting date (rolled to the next active trading day if the market was shut). That vest-day value is what you paid Income Tax on, and it becomes your CGT base cost (see the HMRC HS287 Helpsheet). Do not listen to the slackers in the company chat room telling you it's the date the shares actually arrived in your account (usually 2-3 days later). That's just latency. Basing your CGT on the settlement price is a one-way ticket to an audit.

SECTION 104: A SPECIAL CIRCLE OF SHELL-COMPANY HELL

HMRC matches your sales to your acquisitions in a strict priority queue, designed to neutralize tax-avoidance strategies (see the HMRC HS284 Helpsheet and the technical Share Identification Manual CG51560):

1. Same-Day Match: Shares acquired and disposed of on the same calendar day (s.105).
2. 30-Day "Bed & Breakfast" Protocol: Disposals matched against acquisitions in the 30 days following the sale (s.106A). Crucially, a new vest counts as an acquisition!
3. Section 104 Pool: The digital septic tank. Every other share gets thrown into one averaged-cost sludge pool (s.104). Your shares lose their unique identities and join the collective. Resistance is futile.

The catch: because E*Trade takes days to clear vested shares, you normally can't sell on vest day. Thus, almost all your sales fall into the Section 104 pool. Anyone claiming "I sold the day after, it's a same-day sale" is legally incorrect and begging for trouble.

THE CHRONO-EXPLOIT: THE BUFFER METHOD

The CGT engine doesn't care about the physical shares, only the transaction dates. If you keep a buffer (a pre-existing stack of settled shares) in your account, you can execute a sale on the vest day itself using those settled shares. By date, this creates a true Same-Day match against the new vest, resulting in £0 Capital Gains Tax. The newly vested shares settle a few days later and replenish your buffer. You can roll this exploit indefinitely to bank your vests with no CGT drag. Almost no UK employee knows this is possible because they're too busy staring at the pretty charts.

HARVEST THE SMOLDERING CRATER: THE FOUR-YEAR CLOCK

If the stock collapsed after you were taxed at the peak, you have capital losses. But a loss is just electronic noise until you officially claim it. Under TMA 1970 s.43, you must report these losses to the tax-drones within four years of the end of the tax year in which they occurred, or they dissolve into the ether forever. The Word report generated by this tool will list your remaining time windows. Don't let them expire.

OPTIONS, FEES & OTHER GREMLINS

• Options: Treated as shares once exercised. Cash-exercise-and-hold enters the pool; same-day cashless exercise-and-sell nets to £0 CGT (though you still get hammered on option income tax at exercise under the HMRC Securities Options Manual (ERSM110000)).
• Fees: E*Trade conceals transaction fees in the depths of their statements, so they aren't parsed automatically. Export your disposals CSV, manually add a fee column (convert your £14.99 or $19.99 to USD), and deduct it. Note that wire fees and FX spreads are not tax-deductible; the tax-drones demand their pound of flesh without deduction.
• ISA / SIPP Shelters: Trying to wash US shares directly into a UK tax shelter? You're entirely on your own, pilot.

THE BOTTOM LINE

This tool exists because E*Trade's UI looks like it was designed in the late 90s and HMRC's systems are run on steam-powered abacuses. Built by someone who got tired of spreadsheets and the realization that the system is deliberately complex to extract maximum tribute. Run the calculations, grab your reports, and may the odds be ever in your favor.

⚠️ Not financial or tax advice. Check every figure and consult a professional. Provided “as is”, no warranty of accuracy. Click 💼 Go Corporate for the sober version.