ESPP Form8949 adjustment cash only option #136
Labels
bug
Something isn't working
Comments
|
You're correct - should be Luckily there are no ESPP lots that have a basis over 128.60 (alternate gain calc threshold) so none of them should have a non-zero adjustment with |
hickeng
pushed a commit
that referenced
this issue
Apr 8, 2024
The adjustment calculation for ESPPs was incorrect on the cash-only display for non-zero values. It should be expressed as a negative and not positive number. Luckily, no ESPP lots have a non-zero adjustment, so when cash-only is selected the error isn't impactful. Fixes #136
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
In ESPP sheet, Form8949, adjustment (g), for "cash only" option, should the value equal to "gain - proceeds" instead of "proceeds - gain" ? Thanks.
=LET( proceedsStyle,Reference!$E$9, proceeds,AS8, gain,AW8, numVmwShares,D8, vmwBasis, AD8, avgoQty,AI8, avgoFMV,Reference!$B$18, cashReceived,AA8, avgoTotalValue, avgoFMV*avgoQty, vmwTotalBasis, vmwBasis*numVmwShares, alternateGainAmount,AJ8, basis1099B, AT8, SWITCH(proceedsStyle, "cashOnly", proceeds - gain, "combined", basis1099B - IF(cashReceived<alternateGainAmount, avgoTotalValue, vmwTotalBasis ) ))The text was updated successfully, but these errors were encountered: