Home

Support

Privacy Statement

Security

DJI Computer Solutions

Software Applications for Microsoft Excel

Software Products

Checkbook for ExcelCheckbook for Excel

ExcelleratorExcellerator

Golf Tracker for ExcelGolf Tracker for Excel

Handicap Manager for ExcelHandicap Manager for Excel

Project Manager for ExcelProject Manager for Excel

Scheduler for ExcelScheduler for Excel

Tax Assistant for ExcelTax Assistant for Excel

Data Importing and Translation ServicesData Importing

Give the Gift of SoftwareGive a Gift of Software

 

Register Online

Register by Mail

Golf TipsGolf Tips

Excel-lent Links

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.

Tax Help -We act on your behalf and provide the help needed to resolve your IRS tax problems.  www.guardiantaxresolutions.com

Previous Versions of Tax Assistant for Excel

 

Version 5.1a provides the following fixes and/or enhancements to version 5.1.

  • Fixed a problem with the Excel 97-2003 version causing Excel 2000 to crash.
  • Fixed a miscalculation on Scheduled D, Line 2 (Short-term, Code B total) when there are less than 33 total capital gains transactions.

Version 5.1 provided the following fixes and/or enhancements to version 5.0.

  • Provided improved Capital Gains reporting to accommodate IRS changes to Schedule D and Form 8949.
  • Integrated an additional copy of Schedule E into the program for reporting additional rental properties.
  • Updated for the 2012 tax season and provides several formatting improvements.
  • Improved cell comment hints and other program guidance.
  • Improved Capital Gains error checking.

Return to DJI Computer Solutions