Why sign in to the Community?

  • Submit a question
  • Check your notifications
Sign in to the Community or Sign in to TurboTax and start working on your taxes
Level 2
posted Feb 17, 2024 8:39:55 AM

I have errors on Form 1099-B Worksheet Morgan Stanley Capital Asset Sales worksheet

 I've imported form 1099 b from Morgan Stanley, it required review.  Turbo Tax is asking for an "Adjustment Amount".  I'm getting this message.

Check this Entry.  Form 1099-B Worksheet (Morgan Stanley Capital MGMT) -- Capital Asset Sales Wksht (1): Adjustment Amount must have a value when an adjustment code (other than C, M, or T) is entered.

 

What value is needed??

20 166 14893
24 Replies
Level 1
Feb 17, 2024 9:22:20 AM

I have the exact same error.  Not really obvious how to fix it.  I have Before and After trade purchase transactions and the After ones are correct.

 

Level 2
Feb 17, 2024 9:46:55 AM

I am getting this also! I am unsure of how to proceed.

Level 1
Feb 17, 2024 10:03:58 AM

Same error message here! 

Level 1
Feb 17, 2024 11:08:43 AM

I solved this problem. I backed out the MS download and entered it manually.

No issues. Either MS has an issue or TT. 

 

New Member
Feb 17, 2024 12:55:48 PM

My CX has this same issue. His MS/Etrade (same company) statement has hundreds of transactions and he cannot manually input into TT. He must download the 1099B. Is there another way to resolve this issue?

 

Level 1
Feb 17, 2024 12:57:57 PM

I have the same issue, this is beyond infuriating.  

Level 2
Feb 17, 2024 1:09:27 PM

Right, manually entering isn't a very good workaround either.

Level 1
Feb 17, 2024 3:00:48 PM

stuck in the same spot... im kind of thinking 0 is the answer, since all of these are stock liquidation sales, where i sold all holdings.

 

but ill await the correct answer

Level 2
Feb 17, 2024 3:18:09 PM

I found a solution.  This worked for me.   

 

Exit from the error check window.  This is important.  DO NOT try to edit Form 8949 directly.  You can enter the adjustment amount on the Capital Asset Sales Worksheet.   Go into Forms View and you will find

 this worksheet.  It is listed as Cap Asset Sales in the left side tree.  You will probably see the error show up here too.  Put a 0 into column G.  It will probably be

highlighted,

 and you can see it is blank.  Do this for each error.  Close Forms View and run the error check again. 

 

This worked for me.  Good luck.

Level 1
Feb 17, 2024 3:39:48 PM

I have the same errors from a Morgan Stanley etrade import.

 

Normal asset sales show with adjustment code N and the validation refuses to let me proceed as it isnt in the list of codes it accepts ( C, M, T)  without a value.

 

Having to manually enter 0 for several dozen transactions  to get past this broken ui validation rule isnt ok.

Level 1
Feb 17, 2024 4:04:15 PM

For some reason the N adjustment code comes in for wash sales as well and Turbotax won't let you proceed with any code at all if you have something in box 1G.  It says you have to delete the code but if you do, it just adds it right back in.  It seems like this is only happening for 1 of the 2 import files from Etrade.  I tried to manually add in the 2 transactions with a wash sale and it just adds in a code of N anyways.  I have no idea how to get around this.

Level 1
Feb 17, 2024 5:56:27 PM

Same with me from Morgan Stanley E*Trade 89 Errors

 

I sure hope they fix this as I just corrected all the none reported entries and lots and it took a very long time so do NOT want to have to do it again!!

 

Level 3
Feb 17, 2024 6:03:33 PM

Same annoying problem.


Level 3
Feb 17, 2024 7:10:38 PM

Agreed - Manually re-entering a large quantity of these transactions (>5) is not a feasible workaround. I have 30+ which I really don't want to manually re-enter.  That's like manually typing everything on a typewriter!

 

Downloading transactions are expected to SAVE TIME!

Level 3
Feb 17, 2024 7:26:57 PM

⚠️⚠️

Caution if using the 0.00 adjustment workaround 

⚠️⚠️

 

IRS defines Adjustment Code N as:

N = You received a Form 1099-B or 1099-S (or substitute statement) as a nominee for the actual owner of the property.

 

Report the transaction on Form 8949 as you would if you were the actual owner, but also enter any resulting gain as a negative adjustment (in parentheses) in column (g) or any resulting loss as a positive adjustment in column (g). As a result of this adjustment, the amount in column (h) should be zero. However, if you received capital gain distributions as a nominee, report them instead, as described under Capital Gain Distributions in the Instructions for Schedule D

Level 3
Feb 17, 2024 7:35:22 PM

@RyanH5 any ideas??

Level 3
Feb 17, 2024 7:39:12 PM

Similar issue reported here:

https://ttlc.intuit.com/community/taxes/discussion/1099-b-worksheet-incorrect-code-n-nominee/01/3197677/highlight/false#M1175943

 

Morgan Stanley isn't open until Tuesday (Bank Holiday Monday). Plan to call them - it could be a software issue on their side downloading incorrect data. 

Level 2
Feb 17, 2024 9:18:00 PM

I looked at my download file preview from MS, and it included the Adjustment code N in the transactions, which is not right, as this is my account trades, not a nominee.

 

As others said you can put a zero in but if you still have an N in the sales file. And if you have a transaction with a wash sale, (showing NW) there is no workaround to get out out of an error situation in that case.

 

I think they need to adjust the ETrade by Morgan Stanley downloadable Sales data to remove the N from the adjustment Code field in the import file on these transactions.

Level 2
Feb 18, 2024 4:23:20 AM

Same issue here 195 errors. I narrowed it down to the change-over to Morgan Stanley as the 1099-B before the change works great. My 1099 before the change did not have the code N. I imagine I will not get through to E-trade on Tuesday with all the issues. Hopefully an updated 1099-B will come out quickly or instructions.

Level 1
Feb 18, 2024 6:59:18 AM

This worked for me also.

Level 3
Feb 18, 2024 10:16:57 AM

Confirmed in the preview file as @furledd stated - Morgan Stanley is incorrectly sending the "N" Adjustment Code (screen shot below). All of my transactions have this incorrect adjustment code. 

 

 

This is a Morgan Stanley issue to resolve. Let's hope MS didn't send this incorrect data to the IRS!!!

 

Sent MS a secured email reporting the error - hoping it gets actioned before Tuesday (Monday is a Fed Holiday). Chat is not available on the weekends. 

 

Level 2
Feb 18, 2024 11:18:15 AM

"Morgan Stanley Capital" destroyed Etrade after buying them out - I faced the same problems with their tax docs, and ultimately ended up re-doing all trades in a spreadsheet based on their trade confirms and entering them manually. Unrelated, MS Capital also butchered ETrade's great service and trade execution, and are stealing more on each trade with fake bid/asks. You may have seen that MS recently got fined by the SEC for disclosing client trades to certain preferred clients before hand, allowing them to frontrun. They're done.

New Member
Feb 18, 2024 12:07:57 PM

Thanks. That works.

Level 2
Feb 18, 2024 1:52:18 PM

Just read about that 250 million fine. They made 100 million from their illegal action so it should have been a 350 million fine.