Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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?
Solved! Go to Solution.
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.
To start changing your regional settings to the US, follow the detailed steps:
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.
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.
To start changing your regional settings to the US, follow the detailed steps:
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.
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".
Thank you very much, It works very well now
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here