[GNC] Scheduled transactions details

[Kalpesh Patel]

Oh, that is good to hear. Appreciate that tip, Tommy.

 

With that I can make it fit into my needs for sure, for a scheduled transaction.

 

As for amortized loans, it is indeed difficult to use in GNC as there is not a clean way to have it recalculate based on the fact that you may have made additional principal payments now and then but the next payment does not recalculate up correctly. If there is a way to do so then I simply haven’t gotten to know the specific mechanics at this time and that education is definitely welcome. I know Quicken was very good at loans but I have moved away from it for good so that is one sure thing I miss from there …

 

PS: No need to worry about late responses … it is always  better to get it in then never …

 

From: Tommy Trussell <tommy.trussell at gmail.com> 
Sent: Monday, November 15, 2021 10:51 PM
To: Kalpesh Patel <kalpesh.patel at usa.net>
Cc: David Carlson <david.carlson.417 at gmail.com>; Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] Scheduled transactions details

 

 

On Thu, Nov 4, 2021 at 2:34 PM Kalpesh Patel <kalpesh.patel at usa.net <mailto:kalpesh.patel at usa.net> > wrote:

David,

Thank you for that primer appreciate it.

Boy was I under huge mis-understanding behind their intent for sure. My understanding of “value” was more aligned with like value of the transaction at hand for me, for example like $90 for the monthly train pass as a scheduled transaction.

Since I deal only with US Dollars currency, should that be just a value of 1? I reckon that I won’t have any transactions that creates imbalance.

 

I know I'm way late responding here (behind on my email) but I'd like to say your understanding of value is exactly correct. I don't doubt you can use it as explained (for currency conversion) but you can also use it as a placeholder that fills in and/or calculates the result in a scheduled transaction. Just type a "single word" string in the numeric part of a scheduled transaction and the Since Last Run dialog will prompt you for the value of that single word used as a variable.

 

For example, if you put the word Pass in both the debit and credit fields instead of a numeric value, the dialog will put "Pass" on the dialog and prompt you for the amount to fill in.

 

You can also enter a more complicated transaction with (one or more?) variable and numeric actions, such as Pass*1.09 (to automatically add nine percent to any amount you type).

 

You will quickly run into some limitations -- for example it would be really keen if you could automatically calculate the splits on amortized loans, but the needed functions just don't exist in the Scheduled Transaction parser. Back when I had a mortgage in my scheduled transactions, I just had it insert a realistic split every month for the principal, escrow, etc. then go back and fix the amounts to the penny every quarter to correspond with the bank's statement. 

 

-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.