DJI Computer Solutions
Software Applications for Microsoft Excel
Check out our links to other Excel sites for the best Excel has to offer.
Tax Assistant for Excel - 2012 Tax Year (Version 5.1a)
* - The Personal Version is for personal use to prepare federal income tax returns for preparing up to 5 federal income tax returns. The Professional version is for use by tax professionals, active traders or other tax preparers who are preparing multiple tax returns beyond what would be required for personal use.
Tax Assistant for Excel is a custom application written for Microsoft Excel and requires Microsoft Excel 2007/2010/2013. It simplifies your Federal Income Tax preparation by providing Excel workbooks with IRS approved substitutes of Form 1040 and Form 1040A with Schedules A, B, C, C-EZ, D, E, SE, Forms 6251 (AMT), 4952, 6781, 8829 and 8949. There are also a number of worksheets related to deductions and Schedule D including the Social Security Benefits, Qualified Dividends and Capital Gain Tax, and Child Tax Credit worksheets.
Your sources of income, deductions, capital gain transactions as well as partnership and S corporation income are entered on separate worksheets. The data from these worksheets is then automatically entered into the correct forms. Tax Assistant for Excel helps you determine whether to itemize deductions, automatically calculates your tax and provides a computerized record of your tax filing. The program also provides an automated Schedule D and Form 8949 preparation that is especially helpful for active traders and other taxpayers with a large number of trades to report. The program allows you to easily enter or copy and paste your trades into the Capital Gains sheet and print out a Schedule D attachment as a substitute for preparing multiple Form 8949's, although the program will prepare up to 100 Form 8949's.
In addition to the more common income reporting, you can report income from up to five different businesses, rents, royalties, estates and trusts, as well as income from partnerships and S corporations
The trial version will remain fully functional for 7 days and the expiration can be removed with the registration passkey provided upon registering the program. Entering the registration passkey will also revive the program after the 7 day trial period has expired.
The forms provided in Tax Assistant for Excel are accurate reproductions of the actual forms and are approved by the IRS. While the program will help you with your tax preparation, it does require that you follow some IRS instructions in order to accurately complete your tax return. If you do not feel comfortable with this approach, you should purchase an interview based tax preparation software package or hire a professional to prepare your tax return. Even if you use other tax preparation software or a tax professional, Tax Assistant for Excel can provide IRS approved electronic copies of your tax return in the common Microsoft Excel file format for long term storage. It can also provide an easy way to estimate your taxes based on different scenarios.
Version 5.1a provides the following fixes and/or enhancements to version 5.1.
Version 5.1 provided the following fixes and/or enhancements to version 5.0.