Application Prototyping in Excel - 1095-C
Post date: Apr 5, 2016 7:14:38 PM
Excel is a perfect application prototyping platform. As such, it is also a perfect Q&D (Quick and Dirty) application development platform for many small programs. This is an example of both.
For those of us living in the USA, last year presented us with a major tax code change. To avoid penalties, individuals must prove they have health insurance. Since many people get health coverage from their employers, the government requires employers provide employees with evidence of coverage via a form 1095-C.. Announcements for this change caught many by surprise. Because of wide spread confusion the government indicated this year will be 'dress-rehearsal' for form 1095-C. Employers must still create one but accuracy problems won't cause penalties. Thus, we needed a quick and not so perfect (dirty) app to produce 1095-C forms.
Using XL made sense. XL allows us to download data we have from our payroll systems. XL also allows us to add data that our payroll systems don't have, such as special government codes without having to change our backend system which is expensive and time consuming. XL can merge its data with MS Word where we can place a scanned copy of the 1095-C and layer over it merge fields to print the required forms for every employee.
Next year will probably see major changes to the law and so we probably won't use this again. But what we learned by creating this Q&D app in XL will guide us when we create the real thing on whatever platform makes most sense.
If you would like a working copy of this project, download the PDF first and then, using the link in the PDF, download the zip file which contains:
Here is the link: https://www.dropbox.com/s/8l4kn1ylzd2y2ev/BXL%201095c.pdf?dl=0
