This site under reconstruction.
This week was one of those weeks were obstacles or problems just kept littering my path. On Sunday night/Monday morning I could not fall asleep until sometime around 4 am so I woke up very late: at about the time to leave the house. So with just 4 hours of sleep, I got up and then…
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…
You must be logged in to post a comment.