[GNC] Mortgage & Loan Repayment schedule tool

Adrien Monteleone adrien.monteleone at lusfiber.net
Fri Jan 10 23:24:58 EST 2020


Sorry, I meant also that maybe you *just* ran the tool after the fact.

I don’t think it is designed to back-fill transactions.

Thus, it works right when you enter it before the actual first payment.

If you didn’t have any manual transactions entered, and used the loan druid, it should have entered scheduled transactions for the past 10 months or so, but they would not have automatically executed.

If you exit and then restart GnuCash, *or* go to Actions > Scheduled Transactions > Since Last Run..., they will fire off. Thus, depending on your scheduled transaction settings, you should have had the opportunity to review them upon creation.

There (sadly) is no current mechanism to fire off scheduled transactions *unless* you close and restart GnuCash or use the Since Last Run feature. (it runs automatically when you start the app)

Personally, I have this issue because I rarely shut the app down, so I have to remember to run the action, which kind of defeats the purpose.

Regards,
Adrien

> On Jan 10, 2020 w2d10, at 10:17 PM, Don Ireland <gnuCash at donireland.com> wrote:
> 
> No I ran the tool FIRST.  It did NOT create the past transactions -- and I assumed that was because it would only create the scheduled transactions.  So I manually entered the last ones myself -- I used an amortization schedule in an excel spreadsheet to tell me what each month's P & I would be.
> 
> What I'm having trouble with is the fact that the scheduled transaction says the next due date is 4/1/2019.
> 
> I'll take another look at the guide.  
> 
> On January 10, 2020 10:08:35 PM CST, Adrien Monteleone <adrien.monteleone at lusfiber.net> wrote:
>> You entered several payments manually, *then* decided to use the tool,
>> and are confused as to why the tool doesn’t reflect your manually
>> entered payments?
>> 
>> *I’m* confused as to why you think it would.
>> 
>> But my advice would be to either abandon the tool, or fix the manual
>> entries to accommodate the tool. Then all will be well regardless of
>> the choice.
>> 
>> I’m no expert on the loan druid/wizard (whatever it is called) but I’d
>> hazard the guess to otherwise, use 2/1/20 as the next payment date,
>> *AND* use the balance as of that date, not the original loan balance.
>> This may or may not accurately calculate your actual payments. Since
>> you are only less than a year out, I’d personally opt to fix the
>> historical transactions and stick with the original loan numbers.
>> 
>> Finally, be certain to read over the Tutorial & Concepts guide
>> concerning loans/mortgages to make sure you aren’t stumbling on any
>> pitfalls/sandtraps. While the GnuCash workflow for many if not most
>> things is fairly reasonable, it is based on standard accounting
>> practices which most people are not familiar with in their personal
>> finances. Thus, some things are not at first, as intuitive as you might
>> expect.
>> 
>> Regards,
>> Adrien
>> 
>>> On Jan 10, 2020 w2d10, at 9:54 PM, Don Ireland
>> <gnuCash at donireland.com> wrote:
>>> 
>>> I have a mortgage on my home that I bought in March 2019.  I used the
>> mortgage & loan repayment schedule tool to schedule my monthly
>> payments.  When it asked for the loan beginning date, I entered 3/1/19
>> thinking it would need that to accurately calculate the payments.  When
>> I look at the resulting scheduled transaction, I see that it thinks the
>> "next payment date" is April 1, 2019.
>>> 
>>> If I chang that date to 2/1/20, will that mess things up?
>>> 
>>> I already manually entered all the payments that I've already made so
>> I don't need it to do that for me.
>>> 
>>> Thanks!
>>> Don Ireland
>> 
>> _______________________________________________
>> 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
>> If you are using Nabble or Gmane, please see
>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> Don Ireland
> _______________________________________________
> 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
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.




More information about the gnucash-user mailing list