Multiple criteria sumif array formula with 'only look at range above this row' logic

[Ed_Vee]

I’m trying to create a tab in a live google sheet that acts like a bank register with multiple accounts. It would have a sender ID column, a receiver ID column and a transaction amount column. What I’m now trying to build is a column which outputs an account balance for the sender at the point the transaction is requested based on all previous transactions to serve the purpose of validating whether they have enough funds in their account.

In order to do this I am attempting to create a cumulative cash in and cumulative cash out column that corresponds to the sender attempting to make the transaction which can then be used to calculate the balance for the sender.

I’m having trouble finding a formula that works for this purpose. It needs to say "sum if receiver ID matches this column’s sender ID AND if the transaction occurred prior to this one (is above this one in the sheet). It also needs to be an array formula to enable it to update automatically when new transactions are attempted to be made and are added to the bottom of the sheet.

Any ideas how to achieve this?

 

[Ed_Vee]

Correction: "sum if receiver ID matches this row’s sender ID"