[GNC] Dealing with escrow account

[Jediator]

One way to automate the bill generation would be to create a payment 
plan in a spreadsheet.  It should be fairly easy to calculate principal 
and interest in each installment in a spreadsheet, and convert that 
spreadsheet in to csv format for bill generation in GC, and import the 
csv file to GC to populate the bills.  You may have to create two CSVs, 
one with PMI and the other without PMI (i.e., when your principal 
reaches 10% of your loan as in the US).

On 11/2/23 9:00 AM, Michael or Penny Novack wrote:
> a) The amounts principal vs interest going to be changing each payment 
> (if here in the US with amortizing mortgages). How to automate that 
> not easy especially as the lender may have calculated the amortization 
> table differently (chance you and they used same method very small) .