Create summary Pivot from Multi account & currency transactions

[warrior_k]

I'm trying to create an excel sheet that captures transactions from various accounts using various currencies. For e.g., I may purchase currency2 from Bank1 using currency1 and it gets deposited to Bank2. Then From Bank2, I may purchase currency3 using currency2 and deposit to Bank3. Once, I all these transactions in place, I'm trying to figure out which bank has how much of each currency. One bank may have amount in multiple currencies. Not sure to which extent this is a real time scenario, but I'm creating this for learning purpose. Now, at the end, I want to present information as below:

Bank1 - currency1 - 230
Bank2 - currency2 - (100) -> negative balance here means, I don't have any deposits to account in this currency format. There are only expenses using currency2 from this bank account.
Bank2 - currency3 - 100
Bank3 - currency1 - 20

I've created excel sheet with sample transactions list and created a pivot table. But, not able to achieve what I was looking for. Can someone have a look at attached Tracker.xlsx and guide me get the result I am looking for?