Complete your
US Federal Income Tax
Form 1040
using my Microsoft Excel®
spreadsheet.


IMPORTANT INSTRUCTIONS:

The compressed file has been given the file names "YY_1040.zip" , where YY is represents the tax year.

No PASSWORD is needed!
If a cell is protected, it is because it contains a calculated value.
Many times, a manual override cell is provided if you need to override the calculated value.  
After a while, you will figure out that the spreadsheet is completely functional without needing to unprotect it. 
Please don't ask for the password.

 

 

IMPORTANT TIP
Manually enter your data.
Pasting data into this Excel spreadsheet can cause undesirable cell property changes.
For example, pasting can cause normally unlocked cells to become locked.
Also, pasting can create links to closed or missing spreadsheets.
The small benefit gained by pasting is not worth the large problems it can cause.

If you still really want to paste data, use Paste Special, Values.
Doing so will not change cell properties but will not always work when merged cells are involved.

 

Check your results carefully and let me know if you find any errors!

Choose your download:

To download, right-mouse click on one of these hyperlinks and select "Save Target As...".
NOTE: The "zip" files are compressed versions of the same "xls" files.

Tax Year ->

 2009 2009 Schedules D1 & E* 2008 2008 Schedules D1 & E*
XLS File 09_1040.xls 09_Schedules_D-1_and_E.xls 08_1040.xls 08_Schedules_D-1_and_E.xls
ZIP File 09_1040.zip   08_1040.zip  

Download file size:  09_1040.zip -> 532 KB     09_1040.xls -> 2,084 KB     08_Schedule_D-1_and_E.xls -> 77 Kb

*Due to the fact that Microsoft Excel limits the number of cell format changes, I have been forced to split out part of the spreadsheet.  I chose Schedules D-1, Continuation Sheet for Schedule D, and E, Supplemental Income and Loss, because they contain a lot of format changes and they are mostly "stand alone" schedules.  This made it possible to add the new Earned Income Credit calculation!

Earlier versions:

To download, right-mouse click on one of these links and select "Save Target As...".
NOTE: The "zip" files are compressed versions of the same "xls" files.

Tax Year ->

 2006 2007 2007 Schedule E
ZIP File 06_1040.zip 07_1040.zip 07_ScheduleE.xls

 

Tax Year ->

 2001 2002 2003 2004 2005
ZIP File 01_1040.zip 02_1040.zip 03_1040.zip 04_1040.zip 05_1040.zip

Tax Year ->

 1996 1997 1998 1999 2000
ZIP File 96_1040.zip 97_1040.zip 98_1040.zip 99_1040.zip 00_1040.zip

NOTE: You may need to download a copy of PKZIP to uncompress the ZIP files.

NOTE: To ensure the spreadsheet looks like it should,
Macintosh users may need to download the MARLETT font:
Download: MARLETT.SUIT.SIT

Please provide feedback!!

Help me and your fellow taxpayers out by letting us know what you think.

Thank you!!!

TaxCalculator

This spreadsheet is free.  
However, if you would like to show your appreciation,
you may make a donation by clicking the following link to PayPal and
sending money to 'taxcalculator@mchsi.com'.

paypal_logo.gif (902 bytes)

Address:
Glenn Reeves
(Tax Calculator)
1 Burlingwood Ct.
Burlington, KS  66839-2418

Note 1:  I will report all donations as income.
Note 2:  I will contribute 10% of any and all donations to my local church!
Thanks!!!

If you have questions about your taxes, visit MSN Money Central.


Natural Advantage
Natural Advantage

 

Initial page count:  100,000    1/19/2009 at 12:00 PM
Initial page count:  11,000    1/18/2006 at 6:00 AM
Initial page count:  24,677    1/5/2005 at 7:00 PM
Initial page count:  15,000    1/19/2004 at 9:30 PM
Initial page count:  1932    1/1/2002 at 5:30 PM