paste amount into split may input too much decimal digits

[Pierre Ladouceur]

The calculation from the "Expense" value and the "Balance" value is wrong.

Trying to reconcile my credit card account, I have been looking for hours for a one penny difference and finally found it. I have been using HomeBank for about a year now and installed any upgrade (and donated) but this is the first time I see this problem. The attached pdf will show the problem. Thank You.

I use:

Windows 10 PRO 64-bit
Version 1909
OS build 18363.1256

Homebank 5.4.3
Running against GTK+ 3.24.18

[Maxime DOYEN (mdoyen)]

- I suppose you have loaded from a file the staement ?

- can you share the detail of the split ?

- can you add more decimal digit to the currency to see if you have more number, after the 2 digits ?

thx

[Pierre Ladouceur (pladouceur26)]

-----Original Message-----
From: <email address hidden> <email address hidden> On Behalf Of Maxime DOYEN
Sent: January 9, 2021 4:06 AM
To: <email address hidden>
Subject: [Bug 1910819] Re: Error in account calculation

- I suppose you have loaded from a file the statement ?

[Pierre Ladouceur]

No, all entries were entered manually in chronicle order.

- can you share the detail of the split ?

[Pierre Ladouceur]

 See image below …

- can you add more decimal digit to the currency to see if you have more number, after the 2 digits ?

[Pierre Ladouceur]

[Pierre Ladouceur]

thx

** Changed in: homebank

       Status: New => Incomplete

--

You received this bug notification because you are subscribed to the bug report.

 <https://bugs.launchpad.net/bugs/1910819> https://bugs.launchpad.net/bugs/1910819

Title:

  Error in account calculation

Status in HomeBank:

  Incomplete

Bug description:

  The calculation from the "Expense" value and the "Balance" value is

  wrong.

  Trying to reconcile my credit card account, I have been looking for

  hours for a one penny difference and finally found it. I have been

  using HomeBank for about a year now and installed any upgrade (and

  donated) but this is the first time I see this problem. The attached

  pdf will show the problem. Thank You.

  I use:

  Windows 10 PRO 64-bit

  Version 1909

  OS build 18363.1256

  Homebank 5.4.3

  Running against GTK+ 3.24.18

To manage notifications about this bug go to:

 <https://bugs.launchpad.net/homebank/+bug/1910819/+subscriptions> https://bugs.launchpad.net/homebank/+bug/1910819/+subscriptions

[Maxime DOYEN (mdoyen)]

nota: connect to lanchpad to reply, or if you reply by email, please cut the history, thx

ok, so the point is to determine how you can get those numbers with imprecision after the 2 frac digits.

if you look at your image001.jpg:
- the sum of the split is -71.10610, which is the problem

=> if you input a split txn with the exact same value in your image002, you will have -71.11, the correct value
=> can you make the test to confirm that ?

worse thing is that, looking at your running balance column in the same image, you also have numbers after the 2nd digit, which indicate other transaction have the same problem.

on 2021-01-09, I asked if you were importing the transaction from a file, or manually input it ?
- if this is a file, is it a OFX, QIF, CSV ?
- how many digits the file contains for amount ?

thx,

[Pierre Ladouceur (pladouceur26)]

Okay, I re-entered the four split values with 2 digit decimals and the total showed 71.11

It did fix the problem in the ‘Balance’ value.

On January 09, U sent you an email as shown below where I answered that all entries were entered manually in chronicle order.

However, some figures might have been pasted from the Windows calculator clipboard. [Ctrl+C] & [Ctrl+V]

I removed the history but left the original message I am replying too. Is that what you wanted?

-----Original Message-----

From: <email address hidden> <email address hidden> On Behalf Of Maxime DOYEN

Sent: January 23, 2021 5:18 AM

To: <email address hidden>

Subject: [Bug 1910819] Re: Error in account calculation

nota: connect to lanchpad to reply, or if you reply by email, please cut the history, thx

ok, so the point is to determine how you can get those numbers with imprecision after the 2 frac digits.

if you look at your image001.jpg:

- the sum of the split is -71.10610, which is the problem

=> if you input a split txn with the exact same value in your image002, you will have -71.11, the correct value => can you make the test to confirm that ?

worse thing is that, looking at your running balance column in the same image, you also have numbers after the 2nd digit, which indicate other transaction have the same problem.

on 2021-01-09, I asked if you were importing the transaction from a file, or manually input it ?

- if this is a file, is it a OFX, QIF, CSV ?

- how many digits the file contains for amount ?

thx,

[Maxime DOYEN (mdoyen)]

Hello Pierre,

thanks for the answer, I did miss the reply in your email due to the density, but no problem, I did have a track to follow now (the windows calculator), I will do some further test with that.

Thanks again for your time.
Maxime.

[Pierre Ladouceur (pladouceur26)]

Thanks for the update.

On Sat., Feb. 6, 2021, 04:50 Maxime DOYEN <email address hidden>
wrote:

> ** Changed in: homebank
> Importance: Undecided => Low
>
> ** Changed in: homebank
> Status: In Progress => New
>
> ** Changed in: homebank
> Milestone: None => 5.5.1
>
> ** Changed in: homebank
> Assignee: (unassigned) => Maxime DOYEN (mdoyen)
>
> ** Summary changed:
>
> - Error in account calculation
> + windows: paste from calculator input too much decimal digits
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1910819
>
> Title:
> windows: paste from calculator input too much decimal digits
>
> Status in HomeBank:
> New
>
> Bug description:
> The calculation from the "Expense" value and the "Balance" value is
> wrong.
>
> Trying to reconcile my credit card account, I have been looking for
> hours for a one penny difference and finally found it. I have been
> using HomeBank for about a year now and installed any upgrade (and
> donated) but this is the first time I see this problem. The attached
> pdf will show the problem. Thank You.
>
> I use:
>
> Windows 10 PRO 64-bit
> Version 1909
> OS build 18363.1256
>
> Homebank 5.4.3
> Running against GTK+ 3.24.18
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/homebank/+bug/1910819/+subscriptions
>

[Maxime DOYEN (mdoyen)]

you should check your other split txn, as if you did input the same way,
there is probably similar round problems in others

to check do the same, add more digits to identify the split txn
then get back to 2 digits and reenter the values

[Pierre Ladouceur (pladouceur26)]

I reconcile all my accounts monthly and this was the first time I came across this problem which I only detected because I couldn't balance my totals.. I seldom use Windows calculator copy/paste feature and now that I know the issue, I won't use it anymore.

-----Original Message-----
From: <email address hidden> <email address hidden> On Behalf Of Maxime DOYEN
Sent: February 10, 2021 4:57 PM
To: <email address hidden>
Subject: [Bug 1910819] Re: paste amount into split may input too much decimal digits

you should check your other split txn, as if you did input the same way, there is probably similar round problems in others

to check do the same, add more digits to identify the split txn then get back to 2 digits and reenter the values

--
You received this bug notification because you are subscribed to the bug report.
https://bugs.launchpad.net/bugs/1910819

Title:
  paste amount into split may input too much decimal digits

Status in HomeBank:
  Fix Committed

Bug description:
  The calculation from the "Expense" value and the "Balance" value is
  wrong.

  Trying to reconcile my credit card account, I have been looking for
  hours for a one penny difference and finally found it. I have been
  using HomeBank for about a year now and installed any upgrade (and
  donated) but this is the first time I see this problem. The attached
  pdf will show the problem. Thank You.

  I use:

  Windows 10 PRO 64-bit
  Version 1909
  OS build 18363.1256

  Homebank 5.4.3
  Running against GTK+ 3.24.18

To manage notifications about this bug go to:
https://bugs.launchpad.net/homebank/+bug/1910819/+subscriptions