798667
turbotax icon
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Close icon
Do you have a TurboTax Online account?

We'll help you get started or pick up where you left off.

If I convert capital gains data (from .xlsx to .csv to .txf file format, what data columns (number and order) are necessary for TurboTax to accept the data?

My data is too extensive and complicated to enter by hand. Will TurboTax import .txf files and, if so, what data columns are necessary?

x
Do you have an Intuit account?

Do you have an Intuit account?

You'll need to sign in or create an account to connect with an expert.

1 Reply

If I convert capital gains data (from .xlsx to .csv to .txf file format, what data columns (number and order) are necessary for TurboTax to accept the data?

Consider the "Summary" option.

IRS requires details to be listed on Form 8949, or on your own forms (e.g. consolidated 1099-B) which have the same information and in the same manner as Form 8949.

Either way, if you choose to summarize, you have to mail the transaction details to the IRS within three business days of IRS accepting your tax return.

Exception: if you summarize Category A (Day Trading) or Category D, Form 8949 is not needed for transactions without adjustments. No mailing is necessary. TurboTax won't ask you about wash sales if you don't check the box.

If you have wash sales, it gets more complicated since those have to be itemized on Form 8949 and the summary totals adjusted accordingly.

Enter the wash sales on Form 8949, then use the subtotals on the bottom of that form to know how much to subtract. Be sure to NOT check the adjustments box in the summary window.

Unlock tailored help options in your account.

message box icon

Get more help

Ask questions and learn more about your taxes and finances.

Post your Question