I am toying with the idea of preparing a comprehensive excel workbook for preparing a computation of income, adjustments, deductions, taxes and credits similar to a software helping to prepare 1040 return. My idea is not exactly to prepare a tax forms for submission but a computation summary of four to five pages which helps the tax payers to appreciate their income and taxes (as against 200+ pages of tax return). Technically it will be a full fledged software but will be also a very good review and visulation tool and mybe a tax planning tool later. Is excel a good place to do that? Will python with excel be able to handle? I am a tax professional but not a tech guy. I am only looking at Federal preparation as of now.

​I am toying with the idea of preparing a comprehensive excel workbook for preparing a computation of income, adjustments, deductions, taxes and credits similar to a software helping to prepare 1040 return. My idea is not exactly to prepare a tax forms for submission but a computation summary of four to five pages which helps the tax payers to appreciate their income and taxes (as against 200+ pages of tax return). Technically it will be a full fledged software but will be also a very good review and visulation tool and mybe a tax planning tool later. Is excel a good place to do that? Will python with excel be able to handle? I am a tax professional but not a tech guy. I am only looking at Federal preparation as of now.  Read More

​