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
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









Jatin!
You Rock! you are the man, I am impressed!
John
Hi Jatin,
I just tried your 2010 generator and it worked like a charm. However, I received a notice from IRS for the same for 2009. Can you please email me the generator for 2009 ? I really appreciate it.
@Jatin
Hi Jatin,
I am really impressed by this, great job! Only problem I have is that I need to do it for 2009, for some reason they dont have my tax return for that year
If you can Id really appreciate a 2009 version of this software too.
Thanks
Justin
@philip
I too would greatly appreciate a 2009 version of this great tool.
Can some one please share Schedule D for 2009
@Barry
Hi Barry,
As of now, I do not have any customized program to print all Schedule D1 pages. However you can print all the pages as guided below.
In excel, got to File -> Print option
Print dialogue box will open. On this dialogue box, select “Entire Workbook” option under “Print What” category
This will print all the pages including Schedule D as well. Note that this will also print data sheet.
Regarding an 8 in the first line of the long term listing. This form is exact replica of federal provided form meaning empty form from federal website has an 8 printed on it.
For 2009 schedule, I sent you 2009 schedule excel in separate email. Hope it will help.
Thanks much and sorry for late reply.
Jatin
Hi again,
I notice that my messages have been removed or at least not showing!
I sent you a gift and hope you can get this to work better.
Issue 1. could NOT generate schedule D1 pages. Did get Schedule D printed. The only way I could find to print Schedule D1 pages is to select each of the 84 pages and print. The front would have short term and the back long term. These had an 8 in the first line of the long term listing.
Issue 2. had no way of designating 2009 instead of 2010 and IRS can go back 3 years. So if you are required to resend data to them it would be impossible to do years 2007,2008,2009
Hope you can fix these problems. The Schedule D generator is a much needed thing.
Also would like to mention http://www.excel1040.com has an excellent program that would help many to do there taxes using excel. What it is lacking your program has.
I hope you don’t delete this post.
Thanks for the program.
Barry
Hi, Can’t figure out how to go back and print d1 pages. Got the Schedule D printed but no D1. Oh, and it still has the 2010 and not 2009 don’t know if IRS will nab me or not. Any help would be appreciated.
Thanks
Hi, I love this generator! I printed out the Schedule D using an old computer with excel and worked like a charm. Haven’t got the D1 pages though. I clicked on the generator for Sch D file and it opens with the Schedule D that it generated before. How do I print the D1s or do I need to send them to IRS with 1040? Also… the txf file is 2009 and it prints 2010… does this matter? I will be sending 2010 again also. IRS has requested 2009 and 2010.
Your help is much appreciated!
Hi Jatin, I am having a problem with LibreOffice Calc. When I press the Ctl Shift J. LebreOffice Calc is using Ctl Shift J activate full screen. Is there a work around this problem?
Thanks for your help
Barry
In openoffice calc, ctrl shft j does not work and if I try to run the macro from Tools>Macro>Run Macro it does not work either. Any suggestions?
I am using openoffice calc. when I press ctrl shft j nothing happens. macros are enabled. please respond if you can. thanks
How can I create my Schedule D for 2009? I did run my .txf file against the 2010 schedule D generator and it seems to be doing the correct thing. However, I need the data to be displayed on a 2009 Schedule D and D1 forms (yes I am one of those lazy guys, who waited this long for filing my return from 09).
@drajjo
Hi,
Line 6 and Line 14 are editable and does not ask for password.
For Line 6, write negative amount in excel Column N Line 26 (N26).
For Line 14, write negative amount in excel Column N Line 48 (N48).
Thanks,
Jatin
@Jatin
It works like a charm until I try to populate line 6 on Schedule D form for Capital Loss Carryover from previous year. It asks for a password to make any changes there. Is there a way to add this info prior to generating the schedule D form?
& thanks for your prompt response Jatin!!
@drajjo
Hi,
Once you have the TXF file with you, you can open this excel and press “Ctrl+Shift+J” to call the macro.
This will ask you for the location of TXF file, once selected, data will be populated in this excel. It will also gives you option if you want to generate Schedule D forms. Select No. This will allow you to update/modify the data in data_sheet as par your requirement.
Once modified the data, press “Ctrl+Shift+J” again and proceed with form generation.
Thanks,
Jatin
@Steve Baldasti
Hi Steve,
Download the txf from Schwab to your computer.
Open this excel file and Press “Ctrl+Shift+J” together. This will ask you to select the txf file from your computer.
Once you select the file, It will copy data into this excel and then ask you for the option if you want to generate the forms.
Select Yes and forms will be generated for you.
If you have any question, feel free to contact me on jat_patan@rediffmail.com
Thanks,
Jatin
Awesome work you guys!!!!
What password would unprotect the worksheet so data could be entered manually?
Many thanks!!
I keyed all the transactions into an Excel file. I tried to convert that file to a .txf file. Excel created the file but the Marco didn’t see the file.
Could I download a .txf from say Schwab, then copy and paste all the transaction into this file then execute the Macro?
@qwizzy
Hi,
This macro is written on Windows plateform using Excel 2003. I never tried this one on Mac and I do not know how to handle it on Mac.
May be you can try to open this file again and this time proceed WITH Macros. It may work. I am not sure about it though.
Thanks,
Jatin
@Nick
Hi Nick,
Can you please provide me transaction details from TXF file for the stock that is causing issue.
I will have a look into it.
You can change stock name to any random name while sending over.
Thanks much.
Jatin
@Pete Calinski
Hi,
As of now, this macro is made to use TXF file only.
To invoke the macro, press “Ctrl+Shift+J”.
Once you select the TXF file, data will be created in data sheet and it will prompt you if you want to generate the Schedule. Select NO.
Now edit data as par your desire and then press “Ctrl+Shift+J”. When prompted, select “Yes” option and it will generate Schedule D based on data in data sheet.
Hope this will help. Let me know if any question.
Thanks,
Jatin
I used this script but in the end, it gave me invalid numbers. Essentially, the problem is that the script can’t determine if there’s a wash sale at the end of the year because the .txf file doesn’t contain information about the stock I purchased after selling at a loss. This happens because I haven’t yet sold the replacement stock. It’s sold at the beginning of 2011 but still makes the last sell in 2010 subject to wash sale rules.
Other than that, this has been a great script for helping me check my numbers. Thanks.
Mac using Excel 2008. Warning pops up re: macros. Options: to strip macros, to keep macros but open anyway, to use AppleScript to rebuild macros so Excel 2008 can use them. I proceeded w/o macros but CTRL+SHIFT+J would not open anything. So no auto-run to printout. Please advise. Thanx!!
Is there a version of this macro that can use .xls files. I can’t seem to get a txf type file from ETrade.
Also, is there a way to restart the Schedule D generation after editing the file? Believe it or not GainsKeeper computed a sale incorrectly. Apparently it can’t cope with a sale for negative amount. I placed an order to sell a large number of options and they sold in two lots. The broker put the full commission against the first lot and that commission wiped out all the cash from the sale and $139 more resulting with a -$139. GainsKeeper changed it to a positive amount.
Thanks
@Sniup
Hi,
Generated three lines are correct. Whenever there is a wash sale, 2 lines gets generated to wash out the sale transaction.
There is a chance that entry in IB.TXF is not correct as I see $0.00 as sale amount in file.
See below example of wash sale entry in TXF file:
^
TD
N682
C1
L1
P100.0000 of Direxon Fin Bear (FAZ)
D03/25/2009
D03/27/2009
$2,300.00
$1,992.98
^
Similar example is also available on various tax filing web sites like Turbo Tax.
You can export transactions for this particular stock from your broker site and use some external utility to generate sample TXF file. You can compare it with IB.TXF.
OR you can send me transaction data for this particular stock and I will check it for you.
Also, the excel is now modified to give you more control on data sheet so that you can manipulate data as par your desire.
Jatin