Re: [GNC] Canadian Mortgage

2022-02-03 Thread Michael or Penny Novack
On 2/3/2022 2:51 PM, David G. Pickett via gnucash-user wrote: .. My last code change at Bank of America was to add a very tiny bit to balance transfer fees so that cent was not lost, not to satisfy the bank, but to satisfy testers validating a huge software update. LOL and among othe

Re: [GNC] Canadian Mortgage

2022-02-03 Thread David G. Pickett via gnucash-user
Banks here cannot round up (charge above the contracted/advertised rate), so their calculations are truncated.  However, many are lured into using computer binary floating point numbers to do money (Sybase, SQL Server), and it can lose a tiny fraction of a cent, and so lose the last cent (1.0 /

Re: [GNC] Canadian Mortgage

2022-01-31 Thread Edward Doolittle
Subject: [GNC] Canadian Mortgage How can I use gnuCash for a Canadian mortgage? I need: 1) frequency of payments as bi-weekly (not semi-monthly) 2) a compounding period of 6 months These are not available in version 4.9-1 Actions->Scheduled Transactions->Mortgage & Loan Repayment I am u

Re: [GNC] Canadian Mortgage

2022-01-31 Thread R. Victor Klassen
Happily, in Canada, Escrow is not nearly as common a practice as in the US. So that complication likely does not apply. But since this thread wandered off into the question of banks making money off the rounding (in Australia), there was a case in Canada - back in the 70s or 80s, as I recall

Re: [GNC] Canadian Mortgage

2022-01-31 Thread Stan Brown
On 2022-01-31 07:00, Michael or Penny Novack wrote: > > Speaking as somebody who has written software to produce mortgage > amortization tables, don't sweat it. It would be close to impossible for > you to exactly match what the bank has. The problem is that there are > simply too many places wh

Re: [GNC] Canadian Mortgage

2022-01-31 Thread Michael or Penny Novack
On 1/30/2022 9:40 PM, Al Maloney wrote: Victor Thanks. What you say about formulae and bank practice makes sense to me. Your advice says to me: "Don't sweat the small stuff". Al Maloney Velox Versutus Vigilans Speaking as somebody who has written software to produce mortgage amortization tab

Re: [GNC] Canadian Mortgage

2022-01-31 Thread David Carlson
If there is a way (and there definitely is) to congregate between two cents and six cents of rounding losses per account times millions of accounts per year, count on bankers to find it. On Mon, Jan 31, 2022 at 3:56 AM Liz wrote: > On Sun, 30 Jan 2022 21:40:37 -0500 > Al Maloney wrote: > > > Th

Re: [GNC] Canadian Mortgage

2022-01-31 Thread Liz
On Sun, 30 Jan 2022 21:40:37 -0500 Al Maloney wrote: > Thanks. > What you say about formulae and bank practice makes sense to me. > Your advice says to me: "Don't sweat the small stuff". Some years ago, in Australia a number of people took to the courts to get the banks to recalculate their mort

Re: [GNC] Canadian Mortgage

2022-01-30 Thread Al Maloney
Victor Thanks. What you say about formulae and bank practice makes sense to me. Your advice says to me: "Don't sweat the small stuff". Al Maloney Velox Versutus Vigilans On Sun, 30 Jan 2022 at 21:28, R. Victor Klassen wrote: > My experience is that if I do interest compounded semi-annually, a

Re: [GNC] Canadian Mortgage

2022-01-30 Thread Al Maloney
Derek Thanks. I'll check this out. As an absolute neophyte, I'll need some time. Al Maloney Velox Versutus Vigilans On Sun, 30 Jan 2022 at 15:08, Derek Atkins wrote: > Hi, > > On Sun, January 30, 2022 2:13 pm, Al Maloney wrote: > > How can I use gnuCash for a Canadian mortgage? > > > > I need

Re: [GNC] Canadian Mortgage

2022-01-30 Thread R. Victor Klassen
My experience is that if I do interest compounded semi-annually, and the right payment frequency, the interest/principal breakdown still doesn’t match the bank’s, because they say compounded semi-annually on the mortgage documents, but then they calculate what the equivalent is and calculate it

Re: [GNC] Canadian Mortgage

2022-01-30 Thread Derek Atkins
Hi, On Sun, January 30, 2022 2:13 pm, Al Maloney wrote: > How can I use gnuCash for a Canadian mortgage? > > I need: > 1) frequency of payments as bi-weekly (not semi-monthly) On the Loan Repayment page, select: Frequency: Weekly Every 2 weeks > 2) a compounding period of 6 months If you know w

[GNC] Canadian Mortgage

2022-01-30 Thread Al Maloney
How can I use gnuCash for a Canadian mortgage? I need: 1) frequency of payments as bi-weekly (not semi-monthly) 2) a compounding period of 6 months These are not available in version 4.9-1 Actions->Scheduled Transactions->Mortgage & Loan Repayment I am using macOS 10.14.6 or macOS 12.2 Al Malon