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

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

Your post does not indicate what you actually want to do.

I still have no idea what you want to do. All I see is two photos with no directions or explanations on their relationship or expected outcome. Maybe I am missing something and someone else will be able to understand.

Note: What may be clear to you is not necessarily clear to us.

Ok I think i am starting to see what you are needing. Try this:

Please Login or Register  to view this content.