Skip to main content
A
Alexs1217
September 28, 2024
Solved

IIf file multiply the amount by 100

  • September 28, 2024
  • 2 replies
  • 0 views

Hey, When I import the IIF file to quickbooks desktop I found that the amount of 149,00$ in the IIf files change for 14.900,00$ in QuickBooks and I tried the same file in my partner PC QuickBooks and the amount is correct 149,00 $ How I can fix this in my quickbook Desktop?

Best answer by Aldren18

Thank you for bringing this to my attention, Alexs. I’m dedicated to providing the guidance and support you need to resolve the discrepancies in amounts when importing the IIF file. Together, we can narrow down the root cause of this issue.

 

In QuickBooks Desktop, currency and decimal settings on your device play a crucial role in the amount interpretation during the import process. It is essential to ensure that your Windows regional settings align with the locale of your QuickBooks version. This alignment helps prevent any confusion or errors when importing transactions.

 

To configure your system correctly, let's begin by verifying your current regional settings. 

 

  1. Check your notification area to see if there is a Windows language bar.
  2. If you see codes for other languages like EN and JP, you need to change your regional settings to English (United States/Canada).
  3. If you can't see any letters, English (United States/Canada) is likely already set.

 

To start changing your regional settings to the US, follow the detailed steps:

 

  1. On your keyboard, press Windows+R to open the run command.
  2. Type in the control panel, then select OK.
  3. Choose Clock, Language, and Region, then select Change Location.
  4. In Home Location (Current Location in Windows 7 and Vista), select United States/Canada.
  5. On the Administrative tab, select Change System Locale, then choose English (United States/Canada).
  6. Hit on Apply, then OK.
  7. Reboot the computer.

 

Furthermore, ensure that the quantity and rate in your IIF file are correct. Double-check your IIF file for any formatting issues, especially with decimal points or commas, which could lead to further miscalculations.

 

Moreover, I'll share this comprehensive guidance to deepen your understanding of the IIF import process. These resources provide valuable insights, practical tips, and detailed instructions to help you navigate any challenges you may encounter:

 

 

You’re always welcome to revisit this post for any concerns or inquiries about importing the IFF file in QBDT. Drop a reply here or create a new one. Your questions are important, and I’m committed to ensuring you get the help you need.

2 replies

A
Aldren18Answer
September 28, 2024

Thank you for bringing this to my attention, Alexs. I’m dedicated to providing the guidance and support you need to resolve the discrepancies in amounts when importing the IIF file. Together, we can narrow down the root cause of this issue.

 

In QuickBooks Desktop, currency and decimal settings on your device play a crucial role in the amount interpretation during the import process. It is essential to ensure that your Windows regional settings align with the locale of your QuickBooks version. This alignment helps prevent any confusion or errors when importing transactions.

 

To configure your system correctly, let's begin by verifying your current regional settings. 

 

  1. Check your notification area to see if there is a Windows language bar.
  2. If you see codes for other languages like EN and JP, you need to change your regional settings to English (United States/Canada).
  3. If you can't see any letters, English (United States/Canada) is likely already set.

 

To start changing your regional settings to the US, follow the detailed steps:

 

  1. On your keyboard, press Windows+R to open the run command.
  2. Type in the control panel, then select OK.
  3. Choose Clock, Language, and Region, then select Change Location.
  4. In Home Location (Current Location in Windows 7 and Vista), select United States/Canada.
  5. On the Administrative tab, select Change System Locale, then choose English (United States/Canada).
  6. Hit on Apply, then OK.
  7. Reboot the computer.

 

Furthermore, ensure that the quantity and rate in your IIF file are correct. Double-check your IIF file for any formatting issues, especially with decimal points or commas, which could lead to further miscalculations.

 

Moreover, I'll share this comprehensive guidance to deepen your understanding of the IIF import process. These resources provide valuable insights, practical tips, and detailed instructions to help you navigate any challenges you may encounter:

 

 

You’re always welcome to revisit this post for any concerns or inquiries about importing the IFF file in QBDT. Drop a reply here or create a new one. Your questions are important, and I’m committed to ensuring you get the help you need.

A
Alexs1217Author
September 30, 2024

Thank you very much, It works very well now

BigRedConsulting
BigRedConsulting
September 28, 2024

Always specify amounts in an IIF file using a decimal point only between the dollars and cents, and no other punctuation, regardless of your local currency settings.  IIF import is very US centric.

 

In your case, when specifying "149,00", QuickBooks ignores the "," resulting in "14900", or fourteen thousand nine hundred."

To specify one hundred and forty nine,  specify either "149" or "149.00".

 

When specifying larger numbers, where there is traditionally a thousands separator, omit it altogether. So, one hundred thousand and forty nine one hundreds should be "100000.49", not "100,000.49".

Terms & ConditionsAccessibility statement