That stuff is explained in great detail somewhere on the GnuCash website but I am on my cellphone and unable to sesrch for it.
On Wed, Jul 26, 2023, 2:17 PM Stephen M. Butler <kg...@arrl.net> wrote: > GnC appears to keep track of the number of months and updates it without > any intervention on my end. > > Stephen M Butler > stephen.m.butle...@gmail.com > kg...@arrl.net > 253-350-0166 > ------------------------------------------- > GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 > > On 7/26/23 12:11, Gyle McCollam wrote: > > How does Gnucash update the "i" value each month or do you have to > > adjust manually? > > > > Thank You, > > > > *Gyle McCollam* > > > > Gyle McCollam > > > > gmccol...@live.com <mailto:gmccol...@gyleshomes.com>email > > > > ------------------------------------------------------------------------ > > *From:* gnucash-user > > <gnucash-user-bounces+gylemc=gmail....@gnucash.org> on behalf of > > Stephen M. Butler <kg...@arrl.net> > > *Sent:* Wednesday, July 26, 2023 2:20 PM > > *To:* gnucash-user@gnucash.org <gnucash-user@gnucash.org> > > *Subject:* Re: [GNC] Scheduled Transaction - Loan Amortization > > Here are the entries (3 splits) I use on my scheduled transaction: > > > > Split 1: Assets:Checking:xxx Credit -- $326.97 (payment > > comes from checking account) > > Split 2: Liabilities:Loans:yyy Debit -- 326.97 - ipmt( .04490 > > / 12.00 : i -2: 240.00 : 51,630.34 : 0 : 0 ) > > Split 3: Expense:Interest Paid Debit -- ipmt( .04490 / 12.00 : i > > -2: 240.00 : 51,630.34 : 0 : 0 ) > > > > Notes: .04490/12 is the monthly interest > > i-2 is the month number (found that > > adjusting by 2 months gave me numbers that matched the bank much better > > -- try with just i) > > 240 is the total number of months for loan > > (20 yrs -- RV) > > 51,630.34 is the original loan amount > > > > > > Stephen M Butler > > stephen.m.butle...@gmail.com > > kg...@arrl.net > > 253-350-0166 > > ------------------------------------------- > > GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8 > > > > On 7/26/23 07:09, Derek Atkins wrote: > > > There are pmt, ppmt, and ipmt functions. > > > -derek > > > Sent using my mobile device. Please excuse any typos. > > > On July 25, 2023 15:41:01 Gyle McCollam <gmccol...@live.com> wrote: > > > > > >> Is there a formula I can enter in SX that will automatically > > >> calculate the principal or interest payment on a car loan? Then is > > >> there a way to deduct that from the total payment to get the other > > >> value, other than TOTAL PAYMENT-the formula used above? > > >> > > >> > > >> Thank You, > > >> > > >> Gyle McCollam > > >> > > >> Gyle McCollam > > >> > > >> gmccol...@live.com<mailto:gmccol...@gyleshomes.com > > <mailto:gmccol...@gyleshomes.com>> email > > >> _______________________________________________ > > >> 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. > > > > _______________________________________________ > > 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. > _______________________________________________ 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.
