Re: [GNC] Scheduled transactions details
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 Sent: Monday, November 15, 2021 10:51 PM To: Kalpesh Patel Cc: David Carlson ; Gnucash Users Subject: Re: [GNC] Scheduled transactions details On Thu, Nov 4, 2021 at 2:34 PM Kalpesh Patel mailto:kalpesh.pa...@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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Scheduled transactions details
On Thu, Nov 4, 2021 at 2:34 PM Kalpesh Patel 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. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Scheduled transactions details
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. From: David Carlson Sent: Tuesday, November 02, 2021 12:43 PM To: Kalpesh Patel Cc: Gnucash Users Subject: Re: [GNC] Scheduled transactions details I'll take a stab at answering these questions. 1 the value column comes into play when there are accounts valued in more than one currency or security and there is an exchange involved. The most common case is an investment transaction. The Since Last Run needs manual input to assign an exchange valuation to the transaction. 2 All transactions must be balanced with equal debits and credits. The Scheduled Transaction Editor cannot test amounts defined with variables for balance. The Since Last Run can force the user to assign an exchange rate where needed, but for cases where there is still an imbalance in a single currency GnuCash will automatically assign it to an imbalance account in the specific currency. On Tue, Nov 2, 2021, 9:02 AM Kalpesh Patel mailto:kalpesh.pa...@usa.net> > wrote: Hi Everyone – Two questions – 1 - I noticed that the “Value” column next to “Status” in the “Since Last Run …” window that pops-up when GNC is launched or manually run from ‘Actions” à ‘Scheduled Transaction’ à ‘Since Last Run…’ is blank. I know I have some scheduled ones that have fixed amount so I was wondering where that setting is configured to show the value of that transaction. All of my scheduled transactions are set as reminder in advance and create in advance if that is in play somehow. 2 – In scheduled transaction editor, is there a column that shows the amount of the transaction, whether fixed amount or the formula? I think not given that it could be a split transaction that would be difficult to represent in a condensed format. I checked the column selector drop down and I don’t see one so not likely but I figure I ask in case it is there and can be made to seeable. I am running GNC 4.8 on Windows 10. Thanks. ___ gnucash-user mailing list gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Scheduled transactions details
I'll take a stab at answering these questions. 1 the value column comes into play when there are accounts valued in more than one currency or security and there is an exchange involved. The most common case is an investment transaction. The Since Last Run needs manual input to assign an exchange valuation to the transaction. 2 All transactions must be balanced with equal debits and credits. The Scheduled Transaction Editor cannot test amounts defined with variables for balance. The Since Last Run can force the user to assign an exchange rate where needed, but for cases where there is still an imbalance in a single currency GnuCash will automatically assign it to an imbalance account in the specific currency. On Tue, Nov 2, 2021, 9:02 AM Kalpesh Patel wrote: > Hi Everyone – > > > > Two questions – > > > > 1 - I noticed that the “Value” column next to “Status” in the “Since Last > Run …” window that pops-up when GNC is launched or manually run from > ‘Actions” à ‘Scheduled Transaction’ à ‘Since Last Run…’ is blank. I know I > have some scheduled ones that have fixed amount so I was wondering where > that setting is configured to show the value of that transaction. All of my > scheduled transactions are set as reminder in advance and create in advance > if that is in play somehow. > > > > 2 – In scheduled transaction editor, is there a column that shows the > amount > of the transaction, whether fixed amount or the formula? I think not given > that it could be a split transaction that would be difficult to represent > in > a condensed format. I checked the column selector drop down and I don’t see > one so not likely but I figure I ask in case it is there and can be made to > seeable. > > > > I am running GNC 4.8 on Windows 10. > > > > Thanks. > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.