How do you show all account balances from a single ledger sheet?

[u3rick]

Tsjallie

I have the OwnersPayable WorkSheet working thanks of course to your guidance and help! The next thing I would like to tackle is the balance column on the OwnersPayableList sheet. I, from my accounting background, would just make a sheet for each owner. If I remember correctly the programers thinking here is formulas and filtering. So, when you have time can you give me some ideas on how to move forward on this step.

I am wanting to show each account balance on my total page (OwnersPayableList) BALANCE column.

Screen Shot 2015-10-29 at 8.14.56 AM.png

by using my ledger (TransactionList) below and without making a ledger sheet for each account? So I want to
total each account on the list by account name and a total balance (+ or -) from the sum of that account name. Then I want show it in the BALANCE column on the sheet above. Let me know if you need more info? I will keep trying to get it focused and understandable.

Screen Shot 2015-10-29 at 8.17.42 AM.png

Thanks

u3rick