> > *From:* gnucash-user
> > on behalf of
> > Stephen M. Butler
> > *Sent:* Wednesday, July 26, 2023 2:20 PM
> > *To:* gnucash-user@gnucash.org
> > *Subject:* Re: [GNC] Scheduled Transaction - Loan
:17 PM
To: Gyle McCollam ; gnucash-user@gnucash.org
Subject: Re: [GNC] Scheduled Transaction - Loan Amortization
Not sure how GnC does it. I do nothing.
Stephen M Butler
stephen.m.butle...@gmail.com<mailto:stephen.m.butle...@gmail.com>
kg...@arrl.net<mailto:kg...@arrl.ne
lf of
Stephen M. Butler
*Sent:* Wednesday, July 26, 2023 2:20 PM
*To:* 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
com
mes.com>email
*From:* gnucash-user
on behalf of
Stephen M. Butler
*Sent:* Wednesday, July 26, 2023 2:20 PM
*To:* 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: Ass
tephen M. Butler
Sent: Wednesday, July 26, 2023 2:20 PM
To: 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:xxxCredit -- $326.97 (payment
comes from checking
M. Butler
Sent: Wednesday, July 26, 2023 2:20 PM
To: 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:xxxCredit -- $326.97 (payment
comes from checking
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:
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 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
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
