[GNC] Reestablish my Scheduled Mortgage Transaction
gnucashmailinglist at fastmail.com
gnucashmailinglist at fastmail.com
Thu Dec 4 19:32:32 EST 2025
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
More information about the gnucash-user
mailing list