Index‎ > ‎


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


IRS CoronaVirus Relief

IR-2020-58, March 21, 2020

WASHINGTON — The Treasury Department and Internal Revenue Service announced today that the federal income tax filing due date is automatically extended from April 15, 2020, to July 15, 2020.

Taxpayers can also defer federal income tax payments due on April 15, 2020, to July 15, 2020, without penalties and interest, regardless of the amount owed. This deferment applies to all taxpayers, including individuals, trusts and estates, corporations and other non-corporate tax filers as well as those who pay self-employment tax.


Click on the following link
to download this year's spreadsheet.

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

  Versions from previous tax years are available below! 

Click on the following link
to download a 2020 tax forecast spreadsheet!

Updated on 9/15/2020.

If you are unable to download any spreadsheet,
don't hesitate to send an e-mail to:
I will send you one as soon as I can.
Improvements/changes with the 2019 version include:
  • o   Updated all forms, tax rates, deduction rates, etc.
    for tax year 2019

  • o Updated Form 1040, Schedule A, medical threshold
    from 10% to 7.5% 

  • o  Significant Revision of Form 1040

  • o Removed obsoleted Form 1040, Schedules 4, 5 and 6

  • o Added Form 8606, 
    Nondeductible IRAs

  • o Added new IRS Form 8863, 
    Education Credits
    (American Opportunity and Lifetime Learning Credits)

  • o Added new IRS Form 8995,
    Qualified Business Income Deduction Simplified Computation

    o Improved the Earned Income Worksheet 

  • o  Removed '80% Waiver' worksheet to Form 2210

  • o  Added new Form 4562, Depreciation and Amortization

Download Earlier Versions

To download earlier versions, click on one of the following links.

In 2007 through 2010, I was forced to split the spreadsheet.  This was due to the fact that earlier versions of Microsoft Excel limited the number of cell format changes.  For example, Schedules D-1, Continuation Sheet for Schedule D, and E, Supplemental Income and Loss, were split out because they contain a lot of format changes and they are mostly "stand alone" schedules. 

From 2011 through 2014, a newer version of Excel was used to prepare the spreadsheet; however, an Excel 97-2003 (Lite) version was available for users who do not have Excel 2010 (or later).

For 2015 (and later), the Lite version is discontinued.

Tax Year ->

 File -18_1040.xlsx 17_1040.xlsx 16_1040.xlsx     

Please provide feedback!!

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

Thank you!!!


This spreadsheet is free.  
However, if you would like to show your appreciation,
you may make a contribution by clicking this link or the PayPal logo (below):




(Yes. This address is correct.)




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!