2020 Federal Income Tax Form 1040 (Excel)

1. Microsoft Excel spreadsheet for US Federal Income Tax Form 1040

Free Federal Income Tax Form 1040 (Excel Spreadsheed)

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 1116: Foreign Tax Credit

• Form 2210: Underpayment of Estimated Tax by Individuals, Estates, and Trusts

• Form 2441: Child and Dependent Care Expenses

• Form 2555: Foreign Earned Income

• Form 6251: Alternative Minimum Tax – Individuals

• Form 8283: Noncash Charitable Contributions

• Form 8889: Health Savings Accounts (HSAs)

• 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 (PTC)


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

• 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

• Earned Income Calculation


Five additional worksheets complete the tool:

• A disclaimer worksheet that also includes a high-level summary

• A new Instructions worksheet

• W-2 input forms that maintain up to four employers and their spouse

•  1099-INT interest income input forms for up to ten payers

• 1099-DIV dividends and distributions for up to ten payers

• 1099-R retirement input forms for up to nine payers each for a taxpayer and their spouse

• SSA-1099 input form to record Social Security benefits

• An EIC (earned income credit) table

• A tax table

• A change worksheet that records revisions to the spreadsheet


2. Taxvisor Income Tax Planning Spreadsheets

More about 1040 form

Principal Business or Professional Activity Codes for Schedule C (Form 1040 or 1040-SR)