amount added by date (running total)

[tiverson]

I am trying to create a bank statement summary that is updated daily.

I want to be able to lookup the data from the current daily statement and add it to a summary.

However, since this will be done each day, I need to keep the prior day's amounts also.

I have attached a statement, and the summary page that I am trying to create.

Bank statement example (need to look for transactions that have "lockbox" in the details)

I want to create a summary that looks up the daily values, yet keeps the past activity

Thanks,

Todd