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