Transaction Rpt Running Balance

[Chris Good]

Hi Derek,

The sub accounts are being intermingled because my wife & I keep track of our individual equity within each bank account. This way we know how much we have to spend and don't have to be worried about upsetting the other partner by spending money on something the other may not wish to. So each bank account has a sub account for each person and every transaction is allocated or split  against the sub accounts and not the bank account itself. There is also a sub account 'joint' for regular joint expenses like council fees & groceries.

Each month after entering the credit card statement we do a report on the balance of the sub accounts in the credit card, and do transfers from the savings account to the credit card to pay off the credit card. We have a scheduled monthly transfer within the savings account that moves a budgeted amount from our personal sub accounts to the joint sub account.

We don't have separate bank accounts to avoid bank fees for low balance accounts.
If anyone can suggest another way of doing this, I'd be interested to hear.

Regards,

Chris Good

On 11/12/2012, at 3:06 AM, Derek Atkins <warlord at MIT.EDU> wrote:

> Hi,
> 
> "Chris Good" <chris.good at ozemail.com.au> writes:
> 
>> Is there a way to get a Running Balance on a Transaction Report like the
>> Balance column when you open an account that includes subaccounts by using
>> 'Open Subaccounts'?
>> 
>> Everything way I've tried, the Balance column value is from the subaccount,
>> not a Running Balance of the transactions reported.
> 
> That is correct, the balance in the report is showing the entry in the
> Split's Balance field, which is the Split's Account Balance when in
> Register Sort Order.  It is not computed on the fly, and does not
> intermingle with multiple accounts.
> 
>> I've tried using a common Account Code on all the sub accounts in the parent
>> account, and making the Primary Key Account Code, but the Balance column
>> still shows the subaccount balance.
> 
> This begs the question of why subaccount transactions are being
> intermingled?
> 
>> Thanks for help offered.
> 
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> -derek
> 
> -- 
>       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>       Member, MIT Student Information Processing Board  (SIPB)
>       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>       warlord at MIT.EDU                        PGP key available