Re: [GNC] Mortgage & Loan Repayment schedule tool

2020-01-11 Thread Stephen M. Butler
On 1/11/20 1:52 PM, Don Ireland wrote: > Thanks. I really understood that -- there are lots of variables that can > alter the interest versus principal portions of rhe payment (such as thr > payment was processed at the bank on the 15th but you entered it into the > system on the 20th. You

Re: [GNC] Mortgage & Loan Repayment schedule tool

2020-01-11 Thread Stephen M. Butler
On 1/11/20 12:26 PM, Michael or Penny Novack wrote: > Do not fault the tool if it does not agree with the bank. I have > written these things. There are simply too many assumption about how > to do the calculation, where to round off, etc. << I ended up with a > fancy version that allowed

Re: [GNC] Mortgage & Loan Repayment schedule tool

2020-01-11 Thread Dale Alspach
I found the wizard confusing for setting up the escrow. I suggest using the wizard to set the principal and interest payment approximately. Then either edit the scheduled transaction created or add a separate scheduled transaction to handle the escrow account. The escrow is an asset. There should

Re: [GNC] Mortgage & Loan Repayment schedule tool

2020-01-11 Thread David Carlson
Don, I think that the mortgage tool should not have a problem with fixed amount lines like escrow. There must be extra lines in the SX transaction that was created by the tool. You can manually edit that SX transaction after it has been entered once into the register or alternatively in the SX

Re: [GNC] Mortgage & Loan Repayment schedule tool

2020-01-11 Thread Don Ireland
Thanks. I really understood that -- there are lots of variables that can alter the interest versus principal portions of rhe payment (such as thr payment was processed at the bank on the 15th but you entered it into the system on the 20th. You now have 5 extra days of interest). But

Re: [GNC] Mortgage & Loan Repayment schedule tool

2020-01-11 Thread Michael or Penny Novack
Do not fault the tool if it does not agree with the bank. I have written these things. There are simply too many assumption about how to do the calculation, where to round off, etc. << I ended up with a fancy version that allowed instructions where to adjust that could get agreement to a penny

Re: [GNC] Mortgage & Loan Repayment schedule tool

2020-01-10 Thread Don Ireland
I forgot to cc the list again. It's been a long time since I took part in a mailing list. I keep forgetting. On January 11, 2020 12:56:38 AM CST, Don Ireland wrote: >I was abke to figure out that I needed to use the "Since Lasr Run" >function. That did in fact generate the past payments.

Re: [GNC] Mortgage & Loan Repayment schedule tool

2020-01-10 Thread David Carlson
One of many ways to start the loan wizard retroactively would be to set it up with the original figures to start with the first payment in the series and plan on deleting the past payments that it creates. That may or may not work well for your particular case. David Carlson On Fri, Jan 10,

Re: [GNC] Mortgage & Loan Repayment schedule tool

2020-01-10 Thread Adrien Monteleone
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

Re: [GNC] Mortgage & Loan Repayment schedule tool

2020-01-10 Thread Adrien Monteleone
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

[GNC] Mortgage & Loan Repayment schedule tool

2020-01-10 Thread Don Ireland
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