Credit for Small Employer Health Insurance Premiums

Moss Adams, LLP is a regional accounting firm that is based in Seattle, Washington with offices up and down the west coast. Moss Adams’ main customer base is comprised of small to medium sized companies that oftentimes have fewer than twenty-five employees. Many of these clients qualify for a tax credit called the Credit for Small Employer Health Insurance Premiums. This credit is for taxpayers that provide an employer sponsored health insurance program for its employees and their dependent families. Unfortunately, the credit is very confusing and has many nuances that make it difficult for the tax preparer to calculate the credit. The benefit of the credit is oftentimes negated because of the cost it takes to calculate the correct amount of the credit available. This VBA program is designed to simplify the credit calculation, in turn saving money for the client.

In order to calculate the credit, information must be input into the program by both the Moss Adams professional and the client. The program allows the Moss Adams professional to input client tax information and then password protect the information so that the client cannot inadvertently change information. The client is given access to a limited number of worksheets where they will be able to upload employer and employee information needed in calculating the credit. The program fills in each line of the Credit for Small Employer Health Insurance Premiums (Form 8941) so that the Moss Adams professional need only input the form into their tax preparation software.

• http://files.gove.net/shares/files/15f/mgood/FInal_Project_-_Marshall_Goodrich_Form_8941.xlsm

• http://files.gove.net/shares/files/15f/mgood/Final_Write-Up.pdf

• http://files.gove.net/shares/files/15f/mgood/Moss_Adams_Client_8941_Template_Instructions.docx

• http://files.gove.net/shares/files/15f/mgood/Moss_Adams_Professional_8941_Template_Instructions.docx