Income Tax Spreadsheet For the Year 2015

Federal Forms

New York State Forms

Form 1040

Form 8615 (1996 version)

Form IT201

Schedule A

Form 8817

Itemized Deductions

Schedule B

Form 8836

IT2105.9

Schedule C (1991 version)

Form 8880

IT272

Form 8949 A/B/C

Form 2210

IT112

Schedule D

 

 

Schedule E (Rental Income Only)

 

 

Schedule L

 

 

 

It is not a question and answer type program. You have to know how to do your taxes. The forms are not suitable for printing.

All you do is enter in the data where needed. All the computations and references within and across forms are done automatically as are all tax lookups (except for Form 2210).

Changes are immediately updated which is a significant advantage over most other tax programs.

It also includes the tax worksheets for computing the Standard Deduction for dependents, Exemptions, Social Security, the NY state itemized deductions and others.

If you have education expenses the sheets for that allow you to switch between the various options and see the resulting tax. This makes selecting the right options a lot easier to understand.

If you owe taxes and might have to pay a penalty, the Forms 2210 and IT2105.9 will help reduce or eliminate the penalty. They are useful if your income varies during the year. You can enter your income components in the calendar quarters you acquired it and get taxed only after you quire income. For example if you have an IRA that pays the Minimum Required Distribution in December, the IRS will assume it was paid equally in each quarter and charge you interest starting in the first quarter.

Of course, I assume no responsibility for the correctness of these spreadsheets. Use at your own risk.

I intentionally did not make these a printable version. You have to copy the numbers over to the forms. I usually go to one of the online tax companies that will free efile for some people. I usually don't qualify for the free efile but I let them do all the computations including NY state and compare their results to my values.

If you are doing the taxes for one or more children that have to file Form(s) 8615, these sheets are designed to allow all the linking of multiple Forms 8615.

Email me for instructions or if you have comments at the address below after removing the "NoSpam_".

[email protected].

If you let me know that you are using this spreadsheet I will notify you if I make any updates and corrections.

 


Right-click here and "Save Target As" to download the 2/28/2016 version of the spreadsheet (656k)

Return to Pete's Pages