[GNC] Loan repayments created not matching

[Jason Seegers]

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>
-----
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.