This site under reconstruction.
In my last post, I didn’t go into too much details about using Excel to produce xml files, and I still won’t but I will elaborate just a little further. It appears that with Excel, your requirements on the schema have to be on the simpler side: no parent-child relationships or list of lists. (Schemas…
I’m learning something new – xml. Phase II of the ACA / 1094-1095C reporting is to electronically send the data to the IRS. But the electronic submission can’t be just any ol’ submission. The information needs to be in xml. So, I have been doing a lot of reading and experimenting to see how I…
Finished! We got out the 2200 ACA 1095C forms out to the employees, with a few days to spare. My Excel got us 75% of the way through and then we had to plow through the remaining 25%, a lot of it due to discrepancies in data. The printing of the forms turned out to…
I’m still working on the ACA report but it looks like we have about 80% of the data locked down. The other 20% appears to have data that doesn’t make sense when you compare various pieces of the data (hire date, term date, date coverage began, date ended, paycheck dates). The HR VP is now…
I’ve been testing, testing, and testing the ACA reporting, trying to make sure the results are right. I had about 50% of the reports done with the hope that an assumption for the additional 40% would turn out to be right. For me, dates are always problematic. There are always unforeseen results that come out…
I was so giddy with possible success that it was a shocking upset to see it fail. Was I going to have to start all over? [ap_divider color=”#CCCCCC” style=”double” thickness=”1px” width=”100%” mar_top=”20px” mar_bot=”20px”] A couple of days ago I was working on creating a form in Word that looked like the IRS 1095-C form for mail…
You must be logged in to post a comment.