How to Use Excel to File Form 1040 and Related Schedules for 2016

Spreadsheets and graphs on a desk
xfgiro/istock

It remains to be seen if 2017 will be a sea-change year for the US tax code, but you can still count on using Microsoft Excel to compute your clients’ 2016 liability.

In case you don’t already know, the 21st spreadsheet-based version of Form 1040, formally known as the US Individual Income Tax Return, is now available for free at www.excel1040.com. Glenn Reeves of Burlington, Kansas, has been tweaking and improving this spreadsheet-based tax software since the mid-1990s.

Mr. Reeves’ spreadsheet empowers anyone to prepare their tax return spreadsheet using Excel 2007 and later. Last year he had to abandon a “lite” version that offered broader compatibility with other spreadsheet applications. Increasing complexity in the tax code requires the modern XLSX document format. The elaborate formatting that replicates the dozens of IRS forms and worksheets comprised in this workbook simply overwhelmed the capabilities of the now obsolete XLS document format.

As always, be aware that Mr. Reeves does not offer any assurance that the IRS will accept printed versions of his spreadsheet. He chooses to file his return online after computing his return in Excel. The spreadsheet can be useful to citizens currently residing outside the country, as the encryption used within traditional tax return software programs often isn’t exportable to other countries.

Excel 2016 Form 1040 1

Figure 1: Yes, you can complete 2016 federal income tax returns in Microsoft Excel.

The 2016 version of the spreadsheet includes both pages of Form 1040, as well as these supplemental schedules:

  • Schedule A: Itemized Deductions
  • Schedule B: Interest and Ordinary Dividends
  • Schedule C: Profit or Loss from Business
  • Schedule D: Capital Gains and Losses (along with its worksheet)
  • Schedule E: Supplemental Income and Loss
  • Schedule F: Profit or Loss from Farming
  • Schedule SE: Self-Employment Tax
  • Form 2441: Child and Dependent Care Expenses
  • Form 2555: Foreign Earned Income
  • Form 6251: Alternative Minimum Tax – Individuals
  • Form 8949: Sales and Dispositions of Capital Assets
  • Form 8959: Additional Medicare Tax
  • Form 8960: Net Investment Income Tax – Individuals, Estates, and Trusts
  • Form 8962: Premium Tax Credit

The spreadsheet also includes several worksheets:

  • Line 10: State and Local Income Tax Refund Worksheet
  • Lines 16a and 16b: Simplified Method Worksheet
  • Lines 20a and 20b: Social Security Benefits Worksheet
  • Line 32: IRA Deduction Worksheet
  • Line 33: Student Loan Interest Deduction Worksheet
  • Earned Income Calculation
  • Line 40: Standard Deduction Worksheet for Dependents
  • Line 42: Deduction for Exemptions Worksheet
  • Line 44: Qualified Dividends and Capital Gain Tax Worksheet
  • Line 52: Child Tax Credit Worksheet
  • Line 66: Earned Income Credit (EIC)

Five additional worksheets complete the tool:

  • W-2 input forms that maintain up to four employers and their spouse
  • 1099-R retirement input forms for up to seven payers and their spouse
  • SSA-1099 input form to record Social Security benefits
  • An EIC table
  • A tax table
  • A change worksheet that records revisions to the spreadsheet

All of the worksheets included in the 1040 workbook are password-protected, and most of the formulas are hidden. However, you can add new worksheets to the file or create links to other workbooks. Mr. Reeves contends that users won’t need to access any of the protected cells. As shown in Figure 2, the spreadsheet offers some limited error checking.

Excel 2016 Form 1040 2

Figure 2: The spreadsheet offers limited error-checking prompts.

Although optional, Mr. Reeves does accept donations for his work. The total donations received grow bigger every year, which he writes on his website “feeds his ego” and encourages him to continue to pursue this “labor of love.” Mr. Reeves reports all amounts on his tax return as income, in addition to passing a share of all donations on to his church. Spreadsheet-based versions of Form 1040 are available for tax years 1996 through 2016 at www.excel1040.com.

Replies

Please login or register to join the discussion.

avatar
Mar 11th 2017 16:57

How do I copy the "data" from one version to the latest download?

Thanks (0)
avatar
By snaagar
Jul 10th 2017 09:51

nice article and thanx for shairing here

Thanks (0)
avatar
Jul 23rd 2017 06:22

Thanks,This article will helps me when i will work on this topic.Thanks again for sharing cool status together.

Thanks (0)
avatar
By Amar ck
Aug 1st 2017 04:38

Mr. Reeves’ spreadsheet empowers anyone to prepare their tax return spreadsheet using Excel 2007 and later.
How do I copy the "data" from one version to the latest download?
best whatsapp status

Thanks (0)
avatar
By Ayu
Aug 15th 2017 07:39

What a great information to provide. I was thinking to write on the same topic, but you've done a better job. So, I will share your article as much.
Thanks!
And yeah, Independence Day Wishes from my side to all the Indians here.
Have a good day!

Thanks (0)