This site under reconstruction.
Hopefully today’s post will be a short post on some of the changes I had to make in the macro that help generate the XML file. The actual generation of the XML file is done through using the Source feature found under the Developer tab in Excel. The method hasn’t changed although the starter file…
These past two weeks, I spent a lot of time doing creative problem solving to get rid of empty tags in the ACA electronic submission file. Last year, I was able to submit my electronic file with a bunch of empty tags but this year, the government is not allowing the empty tags. So I…
Two weeks ago, just before I got sick, I was working on the ACA reporting and was on the third attempt to use the new data. I believe my last post on the ACA was about how I needed to finish up the review of data, and the hope was that I would have about 80%…
My eyes are starting to swim from looking at rows upon rows upon rows of data. I’m working on that ACA reporting again this year, using my Excel spreadsheet to assign the code 1 and code 2 series, based upon hire/term dates and medical enrollment dates. Last year’s set of algorithms got me through about…
Let the games begin! It’s time to do the ACA Reporting. Last year, when we were at the stage of developing the paper report, reviewing the data was so onerous that the HR VP said that we were going to do it differently the next year (meaning 2017). So I kind of took it to…
The week before I wrote a post about somebody fudging the numbers instead of fixing the errors. I saw at least 3 instances of fudging but there is no telling how many people have figured out how to manipulate the numbers. So last by the end of last week, I rolled out a password and…