Scorpion,
You are missing much of the July data in your report.
Just check the close value for each account in June with the opening value in August. If you think that the ons and offs for July are zero then the June closing would have to equal the August opening value.
In just about every case those two values dont match, proving that you are missing July transactions.
Its a simple integrity check.