It was solved with a lot of tedious, manual work. I've been using ZenPayroll for the last few months, and I was surprised at how well done it is, how easy it is to use.