Excel1040

Excel1040 -- Tax Software for Spreadsheet Enthusiasts

Couple doing financial planning at home
Christopher Futcher/E+/Getty Images

Ever wish you could just do your taxes in Excel? Well, thanks to Glenn Reeves, you can.

Glenn Reeves first created Excel spreadsheets to prepare Form 1040 and related schedules 19 tax seasons ago. Reeves has produced spreadsheet versions of Form 1040 for the years 1996 through 2015. As of the 2015 tax year, Reeves offers a full 1040 version in the .xlsx format that supports Schedules A, B, C, D, E, F and SE.

It also supports Forms 2441, 6251, 8949, 8959, 8960 and 8962. 

What's New for the 2015 Tax Year 

New additions for 2015 include:

How It Works 

The spreadsheets are organized with tabs that allow you to enter data from your Form W-2s, Form 1099s and Forms SSA-1099. Tabs for Form 1040 appear after these data input screens, then there are tabs for other supporting forms arranged in alphabetical order beginning with Schedule A. Data input cells are formatted with a blue background, and the spreadsheet updates its calculations after the date is entered. 

Each tax form is formatted in the spreadsheet to look like the paper version of the form, which makes the spreadsheet visually appealing and easy and familiar to work with.

All the worksheets are password protected. 

Excel1040 is pretty fast and easy to use, especially if you're comfortable with using spreadsheets and familiar working manually with tax forms. I find these spreadsheets a useful and quick way to calculate federal income taxes.

Reeves also offers a "lite" version of Excel1040 in the .xls format, but it does not include support for Schedules C, E and SE or Form 6251.

The Best Part 

The spreadsheets are offered free of charge, but donations can be made to support Mr. Reeves' work at his website

A Couple of Precautions

Reeves recommends checking your Excel results against the results obtained when you do your taxes the good old-fashioned way with Internal Revenue Service forms and instructions, although the spreadsheet does include some error-checking prompts. He can't guarantee that the IRS will accept printed versions of his Form 1040, and even he says he uses his Excel program first, then he transfers the information over to file his tax return online. 

You might want to try Excel1040 out before your taxes are due so you're savvy with the program when crunch time comes. Learn the ropes before the tax man actually cometh. 

To learn more and try the spreadsheet for yourself, visit:

Check Reeves' website for updates and new features in upcoming tax years. Mr. Reeves is onto something here for the spreadsheet lovers among us, and he can probably be counted on to continue tweaking his product.