How to avoiding rounding issues during IIF import that result in out of balance errors

ReckonDataRecovery
ReckonDataRecovery Reckon Staff Posts: 817 Reckon Staff
edited December 2016 in Reckon Accounts (Desktop)
Some 3rd Party applications that generate transaction export files in the IIF format will in some cases use rounding of dollar values for figures that have more than 5 decimal places.

Example: An widget item called "Widget Parts" has a price of $125.123456 gets rounded down to $125.12346

When these are used in transactions that have tax (use tax codes) the calculation of the tax amount can result in amounts being rounded up/down and cause the error message "transaction out of balance" to be displayed.

(see community article Out of balance error with importing IIF invoice transaction)

image



The solution which has been successful is to change the item prices to be only 4 decimal places.

Example: $125.12345 --> $125.1235




Other community posts that are related.

IIF Journal file does not balance error

Importing General Journal IIF file - problem with GST



Here is a site that describes common error messages you may encounter when manually creating your own IIF import files to bring in transactions from external sources into Reckon Accounts.
Troubleshooting IIF import errors


* Data Recovery Team *