Free Schedule D generator with Wash Sale Calculation
If your broker provides a .txf file for your stock transactions and you do not want to spend big bucks on turbo tax, use the simple Schedule D generator excel sheet below.
Steps to generate wash sale and schedule D 1. Download latest txf file from your broker site save in a directory
2. Download the Schedule D generator excel file and save in a directory
3. Open Schedule D generator excel and press “Ctrl+Shift+J”
4. It will open a location for you on your computer. Point it to the directory where you have saved .txf file and select the file
5. Boom .. the magic starts. At the end it will prompt “Process Completed. Want to generate Schedule D ? ”
6. Say yes.
7. Enter your name and SSN and it will generate the Schedule D for you
What is Schedule D generator doing on Skill-Guru ?
Thanks to Jatin , an enthusiastic programmer with a very good understanding of finances and tax returns who created this excel sheet program for himself and then donated to our readers.
PS: Jatin send us an updated version of Schedule d1 generator which works for all .txf file provided by any broker like Scottrade, Ameritrade. We have updated the above link with new file. Thanks Jatin !
Update : This Schedule D wash sale calculation has been updated to take care of long term sales
excellent schedule D generator. had lots of wash sales this year. this thing saved my life.
@John Thanks for feedback. I am glad this Schedule D generator helped you.
Hi – I am trying to use your schedule d generator. I have downloaded the trades into a csv format. How can a change the format from csv to txf so that I can use the generator?
Thanks so much for your help!
Amanda
I also seem to be having trouble with Excel 2008. Is your generator compatible with excel 2008?
Thanks again!
Amanda
@Amanda When you download the file from your broker , it would be in a .txf format. I had used scottrade and they give the file in .txf format.
No we have not used this with excel 2008. It was done with excel 2004 but I do not think there should be any issue. Excel supports backward compatibility
I am downloading from Scott Trade for years 2005-2007. It gave me the option for csv. and money/quicken. Do you know if the money/quicken option is the txf. format? The Scott Trade web-site is down for maintenance through the weekend.
Thanks!
One more question…in what order should the columns be in the txf. file?
i.e:
symbol, quantity, date, etc.?
@Amanda I think I would not be able to answer your questions now. I will talk to Guru of this Schedule D, Jatin Thakkar who has created this Schedule D .
I was able to successfully convert the csv to a txf. Thank you so much for you help and creating this file. It is definitely a life saver!!!
All my transactions are coming up on short term, even though held well over one year. Ideas?
I am using excel 2003, does that matter?
How about open office?
Check the profit and loss statement from your broker . Does it also reflect short term ?
This excel file does conversion of your .txf file.
My profit/loss from broker confirms there is a bug…. The Sched D has the numeral “8″ where (long term) “description of Property” should go, and there seems to be a cell split/merge issue at that particular point (beginning of long term listings on sched. D). (?) It did not capture ANY long-term holdings at all – I Know this is not right., as I have examined the trades, and ALL were long term, save One.
This would be THE SLICKEST, If I could get it to work right.
VBA project password? I’m an ignoramus, but I wanted to look at the Macro…….
I’m using scottrade too. Downloaded TXF ‘tax report’ opened with generator, examined data, ran ‘generate’ …………………….. ALL short term on sched D.
1. Scottrade ‘tax report’ TXF
2. Windows XP SP 2
3. dell latitude laptop, Pentium 4
4. Excel 2003
Thank you for your efforts.
Help?
@ peter
@peter
I am not creator of this wash sale calculation excel sheet. Jatin is the Guru of this file.
I will request him to reply to your queries.
Peter
The file has been updated to take care of long term sales. Thanks to Jatin for responding to your requirements.