Re: [GNC] Loan

2021-02-07 Thread Stephen M. Butler
On 2/7/21 1:36 AM, Petros Tenezakis wrote: How do set up initital balance for a loan. I owe for an example 1 USD to Example Bank I find it best to break actions like this into the different components. 1.  First item is to realize this will result in you having a liability.  This means y

Re: [GNC] Loan

2021-02-07 Thread Maf. King
On Sunday, 7 February 2021 09:36:35 GMT Petros Tenezakis wrote: > How do set up initital balance for a loan. I owe for an example 1 USD to > Example Bank ___ Hi, pretty much the same as you would create any other account with an existing balance.

[GNC] Loan

2021-02-07 Thread Petros Tenezakis
How do set up initital balance for a loan. I owe for an example 1 USD to Example Bank ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash

Re: [GNC] Loan to family member: How do i setup the account structure

2020-09-23 Thread Stephen M. Butler
I presume that you currently "expense" the loans.  They really are not an "expense" but a change of asset (from your savings account to a receivable. 1.  Add a new Asset account called "FaF Loans"  (Friends and Family Loans).  Mark it as a placeholder. 2.  Under FaF add a new account for each per

[GNC] Loan to family member: How do i setup the account structure

2020-09-23 Thread John Mansfield
I have lent monies to a family member and now wish to track the balances on an ongoing basis. I have been looking at the guides etc but just cannot understand the concept / account hierarchy given my circumstances. The software I am using is: * Version: Version: 4.1, Build ID: 4.1+(2020-07

Re: [GNC] Loan with overpayments

2020-02-22 Thread elvis
On 23/2/20 8:23 am, David Cousens wrote: Claire Can you request a more detailed statement? "Trust us, we are a bank" is not a good modus operandi as we have found out recently in Australia. We had banks charging for services never rendered, continuing to charge fees to dead people along with

Re: [GNC] Loan with overpayments

2020-02-22 Thread David Cousens
Claire Can you request a more detailed statement? "Trust us, we are a bank" is not a good modus operandi as we have found out recently in Australia. We had banks charging for services never rendered, continuing to charge fees to dead people along with outrageous fees for letting the computer do

Re: [GNC] Loan with overpayments

2020-02-22 Thread Claire via gnucash-user
Thanks Stephen. I'm in the UK and it's usual to have interest calculated daily and applied in advance on the first of the month. Payment can be any date you choose. The bank only sends an annual statement with a single figure for the total interest that year - not at all helpful in this case. I g

Re: [GNC] Loan with overpayments

2020-02-21 Thread Stephen M. Butler
On 2/21/20 8:56 AM, Claire via gnucash-user wrote: > Hello > I have a loan at a fixed interest rate and was planning to use "Loan and > Mortgage Repayment...". However I do have the option to make overpayments. > I checked this mailing list and there was a thread regarding mortgages in > 2013 whi

[GNC] Loan with overpayments

2020-02-21 Thread Claire via gnucash-user
Hello I have a loan at a fixed interest rate and was planning to use "Loan and Mortgage Repayment...". However I do have the option to make overpayments. I checked this mailing list and there was a thread regarding mortgages in 2013 which said that the SX uses the original amount to calculate int

Re: [GNC] Loan and Mortgage scheduler | Escrow account for Tax rounds monthly payment up

2019-08-09 Thread Jeffrey Davidson
I noticed the same thing and thought that was strange. Checked to see if there was a rounding option in settings but did not find anything. So I manually edited the scheduled transaction in the editor to the correct tax and insurance and it kept it. So in the future the correct will be used...but b

Re: [GNC] Loan and Mortgage scheduler | Escrow account for Tax rounds monthly payment up

2019-08-08 Thread JimR
Anybody? Jim On 8/2/19 3:06 PM, JimR wrote: The title pretty well says it all, except I don't want it to round up, I want the exact amount I entered.  I entered USD 192.68, but GNUCash rounds up to USD193.00.  I can supply screen shots if necessary. Version 3.6+(2019-06-29) on Fedora 29, all

[GNC] Loan and Mortgage scheduler | Escrow account for Tax rounds monthly payment up

2019-08-02 Thread JimR
The title pretty well says it all, except I don't want it to round up, I want the exact amount I entered.  I entered USD 192.68, but GNUCash rounds up to USD193.00.  I can supply screen shots if necessary. Version 3.6+(2019-06-29) on Fedora 29, all patches up to date. -- 73 de Jim, KD1YV

Re: [GNC] Loan/Mortgage payments with "adjusted" principle (eg after an extra principle payment), SOLVED

2019-01-21 Thread peter_cd.cn
I think this part is answered, rename "config.user" to "config-user.scm" Still have questions for: the loan balance and remaining months. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnuca

Re: [GNC] Loan/Mortgage payments with "adjusted" principle (eg after an extra principle payment), SOLVED

2019-01-21 Thread peter_cd.cn
I am in a similar boat as you and glad that I found your solution. When I try to use your function, I get an error in the "Edit Schedule Transaction" window. Basically saying GNUCash doesn't know the function "imptFixed" and other "*Fixed" functions. "An error occurred while processing imptFixed

Re: [GNC] Loan/Mortgage payments with "adjusted" principle (eg after an extra principle payment), SOLVED

2019-01-21 Thread peter_cd.cn
I am in a similar boat as you and glad that I found your solution. When I try to use your function, I get an error in the "Edit Schedule Transaction" window. Basically saying GNUCash doesn't know the function "imptFixed" and other "*Fixed" functions. "An error occurred while processing imptFixed

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-09 Thread David Carlson
Yup! On the other hand, 1.29-0.71 = 0.58, so while one solution might be to create a transaction with those particular numbers, that method generates too much error for some calculations or combinations of values. That is why the developers are working to use real math whenever possible. I recen

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-09 Thread Stephen M. Butler
On 1/9/19 6:26 AM, Michael or Penny Novack wrote: > On 1/8/2019 11:50 PM, John Ralls wrote: >> The answer is probably in app-utils/calculation. All of that was >> probably written before Guile grew a rational number class and I >> think that GncNumerics get converted to doubles before being passed

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-09 Thread Fred Bone
On Wednesday, January 9, 2019 at 9:44, David Carlson said: > Absolutely, I was not expecting agreement with the bank, I just think the > creation of an unbalanced transaction is bad form. There is no reason to expect that taking three rational numbers A, B and C, such that A=B+C, converting to d

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-09 Thread David Carlson
Absolutely, I was not expecting agreement with the bank, I just think the creation of an unbalanced transaction is bad form. David Carlson On Wed, Jan 9, 2019, 9:03 AM John Ralls > > > On Jan 9, 2019, at 6:26 AM, Michael or Penny Novack < > stepbystepf...@comcast.net> wrote: > > > > On 1/8/2019

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-09 Thread John Ralls
> On Jan 9, 2019, at 6:26 AM, Michael or Penny Novack > wrote: > > On 1/8/2019 11:50 PM, John Ralls wrote: >> The answer is probably in app-utils/calculation. All of that was probably >> written before Guile grew a rational number class and I think that >> GncNumerics get converted to double

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-09 Thread Michael or Penny Novack
On 1/8/2019 11:50 PM, John Ralls wrote: The answer is probably in app-utils/calculation. All of that was probably written before Guile grew a rational number class and I think that GncNumerics get converted to doubles before being passed to the interest functions. That would pretty much guaran

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-09 Thread David Carlson
I have created https://bugs.gnucash.org/show_bug.cgi?id=797032. David C On Wed, Jan 9, 2019 at 2:29 AM David Carlson wrote: > With those numbers payment number 2 has an error. > > David C > > On Wed, Jan 9, 2019 at 2:23 AM David Carlson > wrote: > >> I am working on a test scenario.The interes

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-09 Thread David Carlson
With those numbers payment number 2 has an error. David C On Wed, Jan 9, 2019 at 2:23 AM David Carlson wrote: > I am working on a test scenario.The interest formula is ipmt( 0.03500 / > 12.00 : i : 180.00 : 172,000.00 : 0 : 0 ), the others have the same numbers > and the 71st payment contains t

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-09 Thread David Carlson
I am working on a test scenario.The interest formula is ipmt( 0.03500 / 12.00 : i : 180.00 : 172,000.00 : 0 : 0 ), the others have the same numbers and the 71st payment contains the error. I am using these numbers because they are exactly the same as the numbers that have already generated an erro

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-08 Thread John Ralls
The answer is probably in app-utils/calculation. All of that was probably written before Guile grew a rational number class and I think that GncNumerics get converted to doubles before being passed to the interest functions. That would pretty much guarantee rounding issues. Regards, John Ralls

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-08 Thread Christopher Lam
Well the SCM has numerous references to "round" and "rounding errors" so it's to be expected. Please file a bug with example numbers, and hopefully these errors may be fixed. On 9/1/19 7:35 am, David Carlson wrote: John, Thanks for the reference. Alas, I will need to do some homework to pr

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-08 Thread David Carlson
John, Thanks for the reference. Alas, I will need to do some homework to properly read SCM. There must still be some sort of rounding issue creeping in if the Scheduled Transaction SLR sometimes generates an imbalance from ppmt = pmt - ipmt. David C On Tue, Jan 8, 2019 at 3:44 PM John Ralls w

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-08 Thread John Ralls
The thee functions are defined in https://github.com/Gnucash/gnucash/blob/maint/libgnucash/app-utils/fin.scm, prefixed with gnc: (so gnc:ipmt etc.). At line 41ff you'll see that ppmt = pmt - ipmt. Regards, John Ralls > On Jan 8, 2019, at 12:48 PM, David Carlson > wrote: > > My point is tha

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-08 Thread David Carlson
My point is that the equations are defined by the assistant, and I think that they can be expressed in a form that concentrates all the errors into one line where a simple rounding would not generate a problem where the parts do not add up to 100%. Granted, the errors may sometimes cause inaccurat

Re: [GNC] Loan Mortgage repayment assistant problem

2019-01-07 Thread John Ralls
> On Jan 7, 2019, at 3:14 PM, David Carlson wrote: > > I just had a scheduled transaction that was set up by the loan/mortgage > repayment assistant appear with 0.01 Imbalance-USD. > > I would think that GnuCash should have an accuracy method that would > prevent this from happening. Is this

[GNC] Loan Mortgage repayment assistant problem

2019-01-07 Thread David Carlson
I just had a scheduled transaction that was set up by the loan/mortgage repayment assistant appear with 0.01 Imbalance-USD. I would think that GnuCash should have an accuracy method that would prevent this from happening. Is this a bug? I am using GnuCash 2.6.17 in Ubuntu 16.04 today. David C _

Re: [GNC] Loan & Insurance Rate

2018-11-06 Thread David Cousens
Antoine, There is no way you can simply incorporate the insurance payments into the GnuCash loan calculations, at least at present, as the wizard does not have the capacity to do this. It has not been programmed to treat this situation. It is possibly better to set up the loan calculation in a spr

[GNC] Loan & Insurance Rate

2018-11-06 Thread Antoine Michard
Hi, Today, I'm going to make a car loan at my bank, and I would like to add to my GnuCash account.So I ran Loan Wizard and follow it like my house loan... But, I take death insurance and it's a percentage of my present value. How can I add my Insurance amount in load wizard ?? Thx (Sorry for my p

Re: [GNC] Loan/Mortgage payments with "adjusted" principle (eg after an extra principle payment), SOLVED

2018-08-14 Thread Mike or Penny Novack
On 8/13/2018 11:29 AM, azalea4va wrote: I addressed this in the file I provided. There is one and only one correct answer mathematically. I am surprised the moderators have not stepped in. If you want to continue this, I suggest off list. Michael D Novack ___

Re: [GNC] Loan/Mortgage payments with "adjusted" principle (eg after an extra principle payment), SOLVED

2018-08-13 Thread azalea4va
>> I addressed this in the file I provided. There is one and only one >> correct >> answer mathematically. > > Not true.Depends, for example, on how many decimal places in the > calculations and whether only final rounding or rounding at multiple > places during the calculations. This was a t

Re: [GNC] Loan/Mortgage payments with "adjusted" principle (eg after an extra principle payment), SOLVED

2018-08-13 Thread Mike or Penny Novack
On 8/12/2018 12:58 PM, azalea4va wrote: Sorry, I missed this reply. So a little late, but ... I should perhaps have indicated that writing this sort of thing used to be "my line of country". I have written these things. Mike or Penny Novack-3 wrote a) method? << by "present value" of series o

Re: [GNC] Loan/Mortgage payments with "adjusted" principle (eg after an extra principle payment), SOLVED

2018-08-13 Thread azalea4va
Sorry, I missed this reply. So a little late, but ... Mike or Penny Novack-3 wrote > a) method? << by "present value" of series of "rents" or by "trial and > error" >> I am not sure what ""present value" of series of "rents"" means, but the answer is by math. This is just a mathematical calcu