Amounts multiplied by 100

Amounts multiplied by 100

#43866
Need more info Opened

My amounts appear correctly in CSV and in the mapping table. But when I import them into quicken they get multiplied by 100. I tried dividing them by 100 in excel but then quicken rounds the numbers up to the nearest whole number. Please help

Jea*** Sat, 16 Feb 2019 - 12:04

Same over here

CSV*** Sat, 21 Dec 2019 - 16:27

Queueing this issue for testing

Eug*** Mon, 4 May 2020 - 16:34

<p>Same here.</p>

CSV*** Sat, 22 Aug 2020 - 20:55

In reply to by Eug Fernandez

Can you please send the CSV and explain how you are mapping it. Also, what country/currency you are using.

 email contact@csvconverter.biz

Kon*** Sat, 21 Aug 2021 - 00:24

I'm having the same issue!

 

CSV*** Thu, 4 Nov 2021 - 22:00

I had a look at the CSV attached, it turns out CSV Converter doesn't support currencies with 3 decimal places.

I created an issue for this and added to the queue https://csvconverter.biz/project/issues/77889

For other users that face the same issue but have 2 decimal places on their currency, make sure you select the correct country on the second step of the converter

 

t*** Thu, 27 Jan 2022 - 07:39

Amounts were multiplied by 100 after importing the file in MS Money too. 

After changing checking the setting <Tools><Options><Editing> Automatically insert decimal point in amount field the issue is solved and amounts are shown correct. It is not a conversion issue, but a setting in MS Money. 

 

t*** Thu, 27 Jan 2022 - 07:40

Amounts were multiplied by 100 after importing the file in MS Money too. 

After checking the setting <Tools><Options><Editing> Automatically insert decimal point in amount field the issue is solved and amounts are shown correct. It is not a conversion issue, but a setting in MS Money. 

 

CSV*** Tue, 1 Feb 2022 - 19:24

Some users are reporting issue, that is caused by decimal points.

When you select the country, it automatically sets the decimal point to , or .

I noticed that AED is configured as ,

If you use AED currency, please select USD (United States)