Skip to main content
neog
January 16, 2024
Question

IIF invoice import recalculates the rate

  • January 16, 2024
  • 3 replies
  • 0 views

When we're trying to import the invoice with one of the lines having the quantity of 23.34, rate of 10.25, and line total of 239.24 (rounded by us from 239.235), we're getting incorrect rate displayed on the imported invoice, the rate appearing on the invoice is 10.25021. The same happens if we don't round the line total and try to import it as 239.235 instead of 239.24. We can, however, manually edit the rate back to 10.25 after the import, but there are thousands of lines like this. Is there any setting not to round or recalculate the rate on import, or any way to generate an IIF file that would be imported as is, without changing the rate?

3 replies

Rasa-LilaM
January 16, 2024

Thank you for visiting the Community today, neog.

 

I can see how the rounding off of the rate caused an incorrect figure on the imported invoice. Let me share some insights about this behavior and share an alternate solution. 

 

The rate displayed after importing may vary due to the system's automatic rounding or calculation adjustments, which is how it's designed to work. QuickBooks Desktop (QBDT) doesn't provide a direct setting to prevent rounding or recalculation of rates during the import process. 

 

Make sure to enter the precise quantity and rate to prevent this from happening. This will guarantee that the amount displayed is accurate.

 

Feel free to browse this article for more in-depth information about the.IIF tool: IIF Overview: import kit, sample files, and headers.

 

Moreover, these resources provide in-depth information about the import and export limitations of the IIF tool. They also offer practical resolutions to fix errors and effectively manage customer-related tasks. Click each one to view the complete details: 

 

Feel free to get in touch with me again if you have any other QuickBooks concerns or if you need assistance with importing your bills via IIF and managing your customer's transactions. I am here to lend a helping hand. Have a great rest of the day, neog.

BigRedConsulting
BigRedConsulting
January 16, 2024

@Rasa-LilaM  RE: To keep this from happening, make sure to enter the exact quantity and rate. This is to ensure the amount will show the exact amount. 

 

Why should the user have to do that when a) you don't have to do that in the user interface, and b) there is a  way to import the transactions as the user wants to?

BigRedConsulting
BigRedConsulting
January 16, 2024

Yes, the "new and improved" (not) standard import workflow does this - and much worse things.

 

You can avoid it, and have QuickBooks record what you specify in the IIF file, by using the old and reliable import method, which still exists (lucky for all of us):

 

See BRC QuickBooks 2019+ IIF Import Changes and Recommendations for easy steps.

Terms & ConditionsAccessibility statement