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> 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> > Sent: 04 November 2024 14:05 > To: Jason Seegers <jason.onl...@outlook.com> > Cc: gnucash-user@gnucash.org <gnucash-user@gnucash.org>; > stepbystepf...@comcast.net <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>> 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....@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>> > Sent: 04 November 2024 09:27 > To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> < > 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> > 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@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. > _______________________________________________ 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.
