@Kathy_Lewis, @John_Borelli, unfortunately we do not know how the data is being dealt with or how its being reported. From what I see you are getting the data via two different ways, but are having the same issues when comparing your data back to Infusionsoft.
The only way to see what’s wrong is to run tests alongside Infusionsoft and their Development Team. Its either going to be Infusionsoft, or your code, or combination of both being wrong. Or maybe something else that has not been factored into the data.
Although I have not provided any practical solutions, just my thoughts on what is maybe happening here.