calculation sum per day per administration

Hi, I have an issue I'm trying to work through.    I have a list which is updated daily of bank balances, with numerous bank accounts of multiple administrations. I have made a new table to ...