Quickfile adding extra penny on imported transactions

Bug Bug (Solved)
1

Quickfile adding extra penny on imported transactions. I’m using a very simple csv with just three transactions and two of them are getting rounded up and I don’t know why. Below are contents of the CSV pasted from notepad.

Date,Currency,Gross,Fee,Net,Transaction ID,Name
01/10/2019,GBP,9.99,-0.59,9.40,6E390640VD067354W,Ana Paola Lima Perea
01/10/2019,GBP,6.49,-0.49,6.00,65654615DR1390347,Angela Boyle
01/10/2019,GBP,6.99,-0.50,6.49,8XV23622L4281170F,alison padmore

The 1st and 3rd are getting rounded up by a penny when I import the CSV.

2

Which bit gets rounded up? Gross, fee or net?

3

Gross. The others are not mapped when I import.

I’ve just simplified the CSV even further still the same problem :frowning:

Date,Currency,Gross,Transaction ID,Name
01/10/2019,GBP,9.99,6E390640VD067354W,Ana Paola Lima Perea
01/10/2019,GBP,6.49,65654615DR1390347,Angela Boyle
01/10/2019,GBP,6.99,8XV23622L4281170F,alison padmore

4

Hi @karlj

I’m going to send you a private message to get a copy of the full original file if that’s OK, and we’ll take a look at what’s happening here.