Entering peer to peer lending returns - need to take 50% as is joint account

[fraslin]

Looking for ideas on how to best enter in returns/losses for a peer-to-peer (Lending Club/Prosper) lending account that is jointly held by myself and my ex-wife.  It is used for college savings for one of our kids.

I can import from lending club but then I have hundreds of lines that I need to adjust to 50% of the amounts. (628 to be exact)

 I can get them into excel and manipulate there pretty easily with formulas but don't know how to get them into Turbotax from there.  I don't want to really import the data from lending club and then edit all 600+ lines so any ideas appreciated!

[Carl]

Bottom line is, you flat out can't do it without manually editing each and every entry after you import it.

If offered, and you can download it to your computer as a TXF (Tax Exchange Format) file, then you can use excel to edit the TXF file. Then you can import the .TXF file on your computer into the TTX program *IF* it's formatted in a way the program can recognize and work with.

[fraslin]

Thanks Karl, appreciate it.  Found a few converters online from excel excel to TXF so may give that a shot before I start editing.

Messy either way