[GNC] Reestablish my Scheduled Mortgage Transaction

[NoobAlice]

On 2025-12-04 07:32 PM, gnucashmailinglist at fastmail.com 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
> gnucash-user at 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.

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!