UPDATE- SOLVED!!!!!

I don't know whether to be embarrassed or frustrated but the answer to all my above problems: Reports have to be set to Accrual. Everything was on Cash and just not pulling info correctly.

Thank you to everyone for contributing to this post.