Scheduled Transactions Question

[David T.]

That is one way to handle it, for sure. I was trying to have a single scheduled transaction for "The Mortgage Payment," ideally entered as a single split transaction, since this is how the bank takes it from my account. It's like when I go to an ATM that charges me a transaction fee. I enter "Got Cash" in Gnucash, with $102 taken from my checking account, a $100 split for Cash in Wallet, and a $2 split for the Transaction Fee. I'd expect to be able to do that in the scheduled transaction.

Of course, I could continue to do what I have been doing, which is to go back in and manually add the transaction fee split and change the total amount, but that would seemingly defeat some of the purpose of having a scheduled transaction in the first place (i.e., to predict as accurately as possible future expenditures).

Thanks,
David


________________________________
From: JWatYahooGroups <yhg at highlandsoft.net>
To: David T. <sunfish62 at yahoo.com>; Users Gnucash <gnucash-user at gnucash.org>
Sent: Wednesday, August 31, 2011 4:22 AM
Subject: Re: Scheduled Transactions Question

Mybe I'm being naive, but could you just schedule a separate $1 fixed-amount transaction for the same payment cycle as the mortgage? or *must* it be one of the splits for some reason?
JW


At 01:08 AM 8/31/2011, David T. wrote:
> I have a scheduled transaction for my mortgage that uses formulae to calculate the amounts of the principle and interest on the payment. However, in addition to this, my bank charges a $1 transaction fee for automatically making the payment. Every time I try to add this payment amount to the scheduled transaction, however, Gnucash tells me: "The Scheduled Transaction Editor cannot automatically balance this transaction. Should it still be entered?" I do not know what to answer to this question, and so I always say No.
> 
> 
> Before anyone asks, I have tried modifying the payment formula to include adding one (dollar) to the formula, along with a separate one dollar split for the transaction fee into an expense account. I have also tried adding a separate transaction to the template, adding a single split transaction from the asset account to the expense account. Both yield the same result.
> 
> Interestingly, I note that this transaction template has column headings "Debit Formula/Credit Formula", while other scheduled transactions have "Tot Funds In/Tot Funds Out" column headings.
> 
> 
> Am I to assume that Gnucash expects or requires all splits on a formulaic scheduled transaction to be formulas? If so, is there a way to create a "formula" for a $1 transaction fee? If not, can someone explain to me how I should do this correctly?
> 
> I am using 2.4.5 on a Mac.
> 
> TIA,
> David
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.