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
Update on Feb 14 : The Schedule D Excel sheet has been updated by Jatin for year 2010
Update on Feb 23 : The Schedule D Excel sheet has been updated by Jatin for a date defect encountered by some users . Thanks to Krishna for pointing this out
Update on March 1 : One of the user has requirement to correct data in data_sheet before generating the schedule. This file is modified to allow user to generate Schedule D1 from pre-populated data.
Update March 12: This excel generates Schedule D as well as Schedule D1 forms
Update May 2 : Defect in calculation for Line#21 has been fixed
Update March 10 , 2102 : Jatin has updated Schedule D 2009, updated Schedule D 2010 and created updated Schedule D 2011 for the readers. A big thanks to Jatin for all the hard work. Schedules are attached above
Update April 10 2012 : Jatin has updated the excel with following new fetaures
Note :
Dear Readers
Jatin has been maintaining this excel sheet from 2010 . If this wash sale has been helpful to you, donate some amount to his paypal id at this email id jat_patan@rediffmail.com
Thanks for the program, this’ll make things much easier. I have a question though, it looks like the wash sales are being duplicated some how, I think this is the same issue Anup has.
This is from the IB .txf file,
^
TD
N321
C1
L1
P1 GOOG 06AUG10 510 C
D8/5/2010
D7/30/2010
$171.81
$48.99
^
TD
N682
C1
L1
PWash Sale – 1 GOOG 06AUG10 510 C
D8/5/2010
D7/30/2010
$0.00
$122.83
^
So it has the original sale, and the wash sale that cancels out the loss. The generated data sheet comes up with these 3 lines,
Sell : 1 GOOG 06AUG10 510 C 08/05/2010 07/30/2010 48.99 171.81 (122.82)
Sell : Wash Sale – 1 GOOG 06AUG10 510 C 08/05/2010 07/30/2010 122.83 0.00 122.83
Wash sale : Wash Sale – 1 GOOG 06AUG10 510 C 08/05/2010 07/30/2010 0 122.83 (122.83)
Thanks!
@corey
Hi Corey,
Here are the steps to get TXF from scottrade and then use this excel.
1) Login to your scottrade account and then select “My Account”
2) Select “Gain/Loss & Tax Center” from left side panel.
3) Select “Tax Report” option now.
4) Select Year 2010 and click on Go. It will ask you to open or save the txf file. Save the file on your PC
5) Now download this excel to your PC and open it. If it ask for Macro option, Select Enable Macro.
6) Press “Ctrl+Shift+J” (all together). It will ask you for txf file. Select TXF file from your PC.
Rest will be done by this program.
Hope this will help you.
Thanks,
Jatin
@Anup
Updated excel is available now. You can download and use it.
Thanks,
Jatin
@Jatin
Many thanks Jatin. Definitely will double check for the errors. The txf from IB somehow created some duplicate records in washsale transactions after the transfer and that’s why I prefer a two step process.
Thanks for the download. I cannot figure out how to get my Scottrade txf. file transfered over..any help would be greatly appreciated.
Thank you,
Corey
@Anup
Hi Anup,
I will modify the excel and send it to Vinay for upload.
Note that this process works based on data in .txf file. Predefined code within txf file is used to identify short term or long term or wash sale.
Updating data or Deleting row from Data sheet may generate wrong schedule. It is a risk that you need to take.
Thnaks,
Jatin
Hi Jatin/Vinay, Thanks for the great work.
Is there a way to update the initial data sheet with some corrections (delete rows, change amount..etc due to incorrect data in txf from broker) and then to have schedule d sheets generated from the updated data?
After pressing ‘No’ to edit the contents, it goes to Good bye message,so not sure whether it is possible just to enable the generator from that stage.
Thanks.
@James
James – You can go with this format.
@Krishna
Krishna – This issue is fixed now. Download latest excel that should help you.
Cheers,
Jatin
@Surya
Thanks Surya. The post has been updated with his email id. I was think of doing the same for him and it is a coincidence you mentioned the same.
@James
Hi James the file has been updated
Great Job – thanks – you have saved me atleast $30.
drop me a mail with your paypay id – would like to donate $5 to you to help you make this even better and maintain it.
YL.
How do you edit .txf file ?
Thank you
This saves me a lot of money. Thank you.
Magic tool.
Qbmedi
I have the same problem as Krishna’s. It seems to be related to the txf date format using 1 or 2 digits for month and day. For example, if change “4/7/2010″ to “04/07/2010″, it may work.
Here is the some data from the Txf file first page
V041
AInteractive Brokers
D 2/2/2011
^
TD
N321
C1
L1
P5 QCOM 17APR10 43 C
D4/7/2010
D4/17/2010
$239.82
$0.00
^
TD
N321
C1
L1
P1 AAPL 22MAY10 230 P
D4/20/2010
D5/5/2010
$339.86
$148.99
^
TD
N321
C1
L1
P3 AAPL 17JUL10 270 C
D4/21/2010
D4/21/2010
$2,402.14
$2,611.31
^
TD
N321
C1
L1
P4 AAPL 17JUL10 280 C
D3/30/2010
D4/20/2010
$1,122.86
$1,357.14
^
TD
N321
C1
L1
P4 AAPL 17JUL10 280 C
D4/7/2010
D4/21/2010
$1,402.26
$2,121.74
^
@Krishna
Hello Krishna,
Can you put some sample data from your “txf” file for the dates that are printing wrong.
Will have a look into it.
Thanks,
Jatin
Hi,
I am getting some dates in this format,
/2-D4/-2010
0/-D4/-2010
1/-D4/-2010
0/-D3/-2010
/2-D4/-2010
1/-D7/-2010
/2-D8/-2010
3/-D4/-2010
8/-D6/-2010
10/08/2010
10/13/2010
How to change it, I am using Excel 2007
Ivan,
Another thing I noticed is that the font on the 2010 D1 is a different font than 2009. I tried to copy and paste but it won’t do it. Do you think this matters to the IRS? I’m thinking I should ask.
James
Ivan,
Another thing I noticed is that the year on 2010 D1 is a different font than 2009. I tried to copy and paste but it won’t do it. Do you think this matters to the IRS? I’m thinking I should ask.
James
Hey Ivan,
Thanks, but I’m just not getting it. I don’t have any problem changing it but I don’t know how to group all the worksheets together making them all change at once. Can you walk me through it.
Thank you,
James Volosin
Cool macro thanks,
To change the year all you have to do is group the worksheets and change 2009 to 2010 changing it in one sheet will change them in all just make sure to ungroup them when done. Right click and worksheet tab and select ungroup.
Thank you!
Hi James
I will request the Guru of this Schedule D generator to create a new version.
Do you have a schedule D generator for the 2010 tax year?
Forgot to mention if anyone wants to examine the TXF file format in detail:
http://turbotax.intuit.com/txf/
The latests there is version 041, but TT Quicken 2009 generated V042 (but it should be essentially the same, especially for stock sales).
If you examine the format of the TXF file in any capable text editor you will see that it is ordinary text and every transaction is separate. So to combine the files all you need to do is remove the header from the 2nd file (first 4 lines of the file including the line with the caret). Your first file will have it’s last transaction ending with a caret line. Copy and paste the remaining 2nd file into your first file.
Now this assumes that you have software that can sort them from here by date because this was not a merge this was a concatenation. If the sofware can’t read the file and sort them to calculate the wash sales and gain/loss, then you would be stuck with hand pasting each transaction from the 2nd file into its proper chronological place in the first file.
Thanks, the reason I need to put two txf’s together is they are from different brokers and I have a couple of the same stocks may have some wash sales with different brokers.
Not sure Galen. Will check with the creator of this program
This is a great program, but I have txf files from two brokers, do you know how I can combine them into one file so I can run the generator on it? Thanks!
@Don
Try it with Excel 2003 or 2004. Users had used with this version and did not had issues.
I’m receiving a Microsoft Visual Basic error. The error is : Run-time error ‘1004′ and it also states :Application-defined or object-defined errror”.
I’m using Windows XP, Scottrade’s “txf” report and Excel 2000.
Could you please provide help such that this macro can be used?
Thanks in advance.
Peter
The file has been updated to take care of long term sales. Thanks to Jatin for responding to your requirements.
@ 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.
Help?
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.
VBA project password? I’m an ignoramus, but I wanted to look at the Macro…….
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.
Check the profit and loss statement from your broker . Does it also reflect short term ?
This excel file does conversion of your .txf file.
I am using excel 2003, does that matter?
How about open office?
All my transactions are coming up on short term, even though held well over one year. Ideas?
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!!!
@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 .
One more question…in what order should the columns be in the txf. file?
i.e:
symbol, quantity, date, etc.?
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!
@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 also seem to be having trouble with Excel 2008. Is your generator compatible with excel 2008?
Thanks again!
Amanda
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
@John Thanks for feedback. I am glad this Schedule D generator helped you.
excellent schedule D generator. had lots of wash sales this year. this thing saved my life.