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 <learn...@9999ways.com> Sent: Monday, November 4, 2024 3:55:15 PM To: Jason Seegers <jason.onl...@outlook.com> Cc: David H <hell...@gmail.com>; gnucash-user@gnucash.org <gnucash-user@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.onl...@outlook.com<mailto:jason.onl...@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 <hell...@gmail.com<mailto:hell...@gmail.com>> Sent: 04 November 2024 14:05 To: Jason Seegers <jason.onl...@outlook.com<mailto:jason.onl...@outlook.com>> Cc: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> <gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>>; stepbystepf...@comcast.net<mailto:stepbystepf...@comcast.net> <stepbystepf...@comcast.net<mailto:stepbystepf...@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.onl...@outlook.com<mailto:jason.onl...@outlook.com><mailto:jason.onl...@outlook.com<mailto:jason.onl...@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/><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/><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....@gnucash.org<mailto:outlook....@gnucash.org><mailto:outlook....@gnucash.org<mailto:outlook....@gnucash.org>>> on behalf of Michael or Penny Novack via gnucash-user <gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org><mailto:gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>>> Sent: 04 November 2024 09:27 To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org><mailto:gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>> <gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org><mailto:gnucash-user@gnucash.org<mailto:gnucash-user@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@gnucash.org<mailto:gnucash-user@gnucash.org><mailto:gnucash-user@gnucash.org<mailto:gnucash-user@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@gnucash.org<mailto:gnucash-user@gnucash.org><mailto: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 ----- 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<mailto:gnucash-user@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@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.
