Cash Position Worksheet

We just implemented Cash Management and now we're setting up the Cash Position worksheet. We are getting current day bank statements in BAI2 format as well as prior day bank statements. The current day statements only show current day activity and available balance. If I pull in both balance and activity from the current day statement, the worksheet sums the balance and the activity and therefore not displaying the cash position correctly. Any help or point in the right direction is greatly appreciated.

Thanks in advance!

-Cleone