Balance Sheet from CCK and Views Across Multiple Nodes

This seems like a no brainer to me, but I can't seem to figure it out, and it doesn't look like others have solutions. Anyway, I'm trying to create a simply project management system in Drupal. Part of this is a budget and account function. What I've done is create a content type of accounts, which is simply an account name and meta data. Then I have a transaction content type, which just like you have on a bank checking account. It list the dollars in and out, with some descriptions / meta data of the transaction. What I want is a simple balance sheet that lists the various project accounts and then the current funds / balance. So, somehow I need to sum all the transactions associated with each account. I tried views calc, but it doesn't seem to sum fields of a different node -- or more specifically if I filter out / hide the transactions, then the sum total doesn't display. Is there a module out there that does this, or is there a trick / recipe using a combination of CCK, Views, and other. Or am I really looking at writing my own 'module' page display? Thanks in advance for the assistance.