Answers to Frequently Asked Questions
Typically, each new updated spreadsheet is available around January 15. Sometimes, sooner.
Absolutely! This spreadsheet is constructed using only cell equations and formatting. No macros or other 'code' are used. This spreadsheet is not capable of causing any harm to your computer or sharing your personal information. It's just a spreadsheet. The only hyperlinks are to spreadsheet 'sheets' or to well-known places such IRS.gov, PayPal.com, etc.
The IRS publishes rules about what computer generated sheets need to look like. Although I try to make the sheets look like the real ones, I have made no specific attempt to comply with any IRS rules. I, myself, have printed the sheets and have sent them in without problem. However, I cannot say that you will have the same good luck. Now, I use my own spreadsheet to calculate my Federal income tax return and then submit my return electronically using a free filing service.
No password is needed. When using this spreadsheet, you may encounter protected cell warnings. If you find a data entry cell to be protected, it is because it is a calculated value using input from another location in the spreadsheet. Read the instructions for that line to determine where the values are derived. However, for most calculated cells, a manual override cell is provided if you need to override the calculated value. After a while, you will figure out that the spreadsheet is completely functional without needing to unprotect it.
In most cases, protected data entry cells are darker blue. Unprotected data entry cells are white or light blue.
See pages 7 through 11 of Publication 550. Because the rules related to savings bonds are so complicated it is beyond the scope of my spreadsheet. Hopefully, you'll be able to review the publication and determine how to report income from your particular savings bond and associated circumstances.
The instructions for Form 1099-MISC are very complicated. The form has yet to be implemented on this spreadsheet. Refer to IRS Form 1099-MISC and associated instructions:
Instructions for Form 1099-MISC may be downloaded from the IRS:
Form 1099-MISC may be downloaded from the IRS:
For taxable incomes of less than $100,000, you are required to use the Tax Table. The tax listed on the Tax Table is for the mid-range amount between the “At Least” amount and the “But Less Than” amount.
For example, using the 'Official Tax Rates' for a filing status of 'Single', calculating the tax on a taxable income of $70,733 yields a tax of $11,178.26. However, the 'Tax Table' calculation uses a taxable amount of $70,725. The tax amount is $11,177.
My spreadsheet performs the calculation of every single amount listed in the Tax Table using the 'Official Tax Rates' formulae using the mid-range amount. All of the amounts listed in the spreadsheet have been electronically verified against the amounts in the official IRS Tax Table.
The General Instructions for Form 1040, Line 5b, Pensions and Annuities, reads:
"If your pension or annuity is fully taxable, enter the total pension or annuity payments on line 5b; don’t make an entry on line 5a...."
On the Form 1040 sheet, cell AJ68, you will find how your tax was calculated. If it says “Cap Gain TW” or “Sch. D Tax WS”, then you’re a winner! The spreadsheet saved you money by using a tax worksheet that you might have otherwise overlooked.
NOTE: As always, be sure to check the spreadsheet and its calculations against the actual IRS forms and your own calculations.
No. Electronic filing is beyond the scope of this spreadsheet and, most likely, way beyond my ability.
No. However, most people report that it does not take very long to re-enter their information when migrating to a new version of the spreadsheet. Please be careful when using copy and paste. (See below. Always use Paste Special, Values.)
Pasting data into this Excel spreadsheet can cause undesirable cell property changes. For example, pasting can cause normally unprotected cells to become protected. Also, pasting can create links to closed or missing spreadsheets. The small benefit gained by pasting is not worth the large problems it can cause.
If you still really want to paste data, use Paste Special, Values. Doing so will not change cell properties but will not always work when merged cells are involved.
To fix a cell that has been inadvertently protected due to pasting, copy (Ctrl-C) another unprotected cell from the spreadsheet and paste it (Ctrl-V) into the damaged cell. (This does not always work. You may need to start again using a new copy of the spreadsheet.)
Users of this spreadsheet tell me they save it as a LibreOffice spreadsheet by performing the following steps:
1) Load the spreadsheet as an .xlsx file, then save it as an .fods file.
2) Close the .fods file. Then re-open the .fods file.
3) Save the .fods file as an .ods file.
4) Close the .ods file. Then, re-open the .ods file.
The "Too Many Columns" warning message is the result of a known compatibility issue between LibreOffice and MSExcel.
Reports are that the spreadsheet will work after the warning message is acknowledged
Because I upgraded my computer and because the "Too Many Cell Formats" error was limiting my ability to maintain the spreadsheet, I was forced to upgrade to MSExcel 2010. This version of MSExcel resolves the "Too Many Cell Formats" problem, but is not always compatible with older versions.
Be a tester. Take the spreadsheet for a test drive. Compare the words on the spreadsheet to the actual IRS forms and enter in data to test every condition. Report any problems to: incometaxspreadsheet@gmail.com.
Send money! While the spreadsheet is truly a hobby and labor of love, receiving money for it feeds my ego. It keeps me wanting to do it again and again. (Since 1997!)
Have a question? Email incometaxspreadsheet@gmail.com.