[GNC] Loan repayments created not matching

Mon Nov 4 18:18:20 EST 2024

Hello Jason,

Glad to hear that everything was sorted out. I might have not seen the
comment about the issue with the principal figures, the important thing is
that it is working for you now.

Thank you

Regards,

Inma
Maria Inmaculada de la Torre

On Mon, 4 Nov 2024 at 22:45, Jason Seegers <jason.online at outlook.com> wrote:

> Hi Inma,
>
> Sorry, that was my fault as the principle for my original 338 payment was
> 25,080. I had a disposition error switching the 5 and 8.
>
> In my previous my email, I mentioned I managed to figure out what was
> going wrong. During the setup of the payment schedule, there is the screen
> (3rd or 4th) where you have to input the start date, total number of
> payments and remaining payments. I input the start date and the total
> number of payments. The remaining payments auto populated based on todays
> day so I left it "as is". Turn out it was calculating the full principle
> repayment over this term instead which is incorrect.
>
> When I changed the remaining payments to match the total payments in the
> term, the entries posted matched the calculated entries.
>
> Not sure why my previous email hasn't come through to everyone yet but if
> that is a bug, perhaps it needs to be looked at. If it's the intended
> function, then it's quite odd to even ask the question of "remaining
> payments" and would cause confusion (at least it did for me).
> ------------------------------
> *From:* Maria Inmaculada de la Torre <learning at 9999ways.com>
> *Sent:* Monday, November 4, 2024 3:55:15 PM
> *To:* Jason Seegers <jason.online at outlook.com>
> *Cc:* David H <hellvee at gmail.com>; gnucash-user at gnucash.org <
> gnucash-user at gnucash.org>
> *Subject:* Re: [GNC] Loan repayments created not matching
>
> Hello Jason,
>
> I have tried to replicate your issue first in Excel and later on in
> Gnucash and the payment for a loan of 28,050 with an interest rate of 6.69%
> with monthly payments for 96 periods is 378.11 not 338.08. You have done
> something during the setup of the loan and I guess that Gnucash is trying
> to balance things somehow. You might want to check all the steps of the
> setup. Did you click any of the options in the Loan Repayments Options?
> There is definitely something wrong with the calculation it is being made
> for the monthly payments.
>
> Try sharing screenshots of the full set up or check them yourself if you
> are adding something that should not be there.
>
>
> Thanking you.
>
> Regards,
>
> Inma
> Maria Inmaculada de la Torre
>
>
> On Mon, 4 Nov 2024 at 21:17, Jason Seegers <jason.online at outlook.com>
> wrote:
>
> Good to know that it works.
>
> In response to Stephens email, the main formula is pmt( 0.06690 / 12.00 :
> 96.00 : 28,050.00 : 0 : 0 ).
>
> How would I check the individual transactions formula and what should I be
> looking out for?
> ________________________________
> From: David H <hellvee at gmail.com>
> Sent: 04 November 2024 14:05
> To: Jason Seegers <jason.online at outlook.com>
> Cc: gnucash-user at gnucash.org <gnucash-user at gnucash.org>;
> stepbystepfarm at comcast.net <stepbystepfarm at comcast.net>
> Subject: Re: [GNC] Loan repayments created not matching
>
> Your images came through fine for me using gmail in the web browser and
> are also present in the archive  -
> https://lists.gnucash.org/pipermail/gnucash-user/2024-November/114010.html
> :-)
>
> Cheers David H.
>
> On Tue, 5 Nov 2024 at 05:10, Jason Seegers <jason.online at outlook.com
> <mailto:jason.online at outlook.com>> wrote:
> Hi,
>
> https://imgur.com/a/z2iKDyl
> [https://i.imgur.com/VhOjOm7.png?fb]<https://imgur.com/a/z2iKDyl>
> imgur.com<http://imgur.com/><https://imgur.com/a/z2iKDyl>
> Discover the magic of the internet at Imgur, a community powered
> entertainment destination. Lift your spirits with funny jokes, trending
> memes, entertaining gifs, inspiring stories, viral videos, and so much more
> from users.
> imgur.com<http://imgur.com/>
>
>
> I've only just realised now that the images I put in didn't actually
> remain as part of the email when I sent it. So above is an imgur link for
> the images.
>
> Basically, it is the system not posting what it says it will which I can't
> wrap my head around. I am not expecting the calculation to be the same as
> the bank, this is simply that the software is posting a different amount to
> what it tells me and the reality is the result it posts is completely wrong
> but the preview it provides for the result is actually correct.
>
> Example (in case images done work in imgur link) for period 1 or 1st
> payment.
>
> System calculates payment 1 as: 338 split as 199 for capital and 139 for
> interest
> System then posts: 338 split as 255 for capital and 83 for interest
>
> As you can see, this is completely incorrect and I don't understand why it
> isn't posting the numbers it is calculating?
> ________________________________
> From: gnucash-user <gnucash-user-bounces+jason.online=
> outlook.com at gnucash.org<mailto:outlook.com at gnucash.org>> on behalf of
> Michael or Penny Novack via gnucash-user <gnucash-user at gnucash.org<mailto:
> gnucash-user at gnucash.org>>
> Sent: 04 November 2024 09:27
> To: gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org> <
> gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>>
> Subject: Re: [GNC] Loan repayments created not matching
>
> On 11/3/2024 5:20 PM, Jason Seegers wrote:
> > Hi,
> >
> > Not sure what I am doing wrong here but when I use the loan repayment
> calculator as per the screenshots below, the transactions created don’t
> match what I am shown and I am stumped as to why.
> >
> > Any ideas to get this to actually agree?
>
> How far off?
>
> If a small discrepancy, the "why" is very simple. There is NOT one
> correct way to do the calculation and so no way to expect the result
> from the calculation the loan provider used will match the result from
> the calculation gnucash uses. There are a number of ASSUMPTIONS being
> made (one of the largest, how is the end of the loan handled if, as
> usual, not going to come out even).
>
> You simply can't expect exact agreement.
>
> Now as to the two amortizations shown in the screen shots, more useful
> would be the # of each "rent" (periodic payment). We have no way of
> knowing if those absolute dates correspond. In other words, we DON'T
> know if 3/21 is the nth payment on each. Since you are presumably
> dealing with loan start in the past, do you have that past lined up?
>
> Michael D Novack
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>
> To update your subscription preferences or to unsubscribe:
>
> https://gbr01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7Cc67205e490cb4c2f8d8f08dcfce55d6f%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638663309258461071%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=pA%2F8HYx%2FsSocUahrUOVI6AhhVj0F3VQLdrvD5MuEi3s%3D&reserved=0
> <https://lists.gnucash.org/mailman/listinfo/gnucash-user><
> https://lists.gnucash.org/mailman/listinfo/gnucash-user><
> 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.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>
> To update your subscription preferences or to unsubscribe:
> 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.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> 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.
>
>