On 2025-12-04 07:32 PM, [email protected] wrote:
Please help me reestablish what I had before <sob story>. I cannot get a hit on this in the mail
archive that doesn't simply direct me to the "wizard". I've tried recreating the transaction in
the "wizard" so many times I've memorized by setup numbers, but I never get it correct. I have
even tried to manually enter formulas and if that is the answer, I'll do it.
As I recall the way it used to be was on the monthly basis a scheduled
transaction transferred money from checking to escrow in the amount of (pmt
formula) + escrow). Each year after escrow analysis all I had to do was go in
and edit the escrow constant.
I think I remember a second scheduled transaction of ppmt and ipmt formulas
crediting Escrow and debiting Liability:Mortgage and Expense:Interest
respectively, leaving the Escrow increased by the about at the end of the pmt
formula.
I don't ask you to reteach me all the details, but please help me find the
documentation? As I recall it was a community member that knew the right way to
pay through escrow so all transactions were tracked. It was considered to be
pedantic but correct, and since it only has to be done once with minor tweaks
on the months that a penny needs adjustment, it was worth it. It was so
elegant that I was able to reconcile Liability:Mortgage remaining and Escrow
balance on every monthly statement in just like my bank accounts.
TIA
_______________________________________________
gnucash-user mailing list
[email protected]
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.
I don't see that you ever got a response.
I had actually never used this before. I was surprised to find that:
Tools > Loan Repayment Calculator
https://wiki.gnucash.org/docs/C/gnucash-guide/loans_calcs1.html
just helps you figure out things like effective interest rates, which
you may need for...
The item you want:
Actions > Scheduled Transactions > Mortgage and Loan Repayment
https://wiki.gnucash.org/docs/C/gnucash-manual/trans-sched-loans.html
will create the ppmt and ipmt lines in a scheduled transaction for you.
I also think you may need to create this scheduled transaction through
the tool, as I have no idea how it tracks which period is current.
For someone who has had a 30-year mortgage going for the last, say, 15
years, and has another 15 years left, it looks like that will be
something to be cautious about: that the start of the loan was back in
2010, so one would need to enter that 2010 start date and also that you
only want to record payments from 2025 to 2040.
Best of luck!
_______________________________________________
gnucash-user mailing list
[email protected]
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.
