How to avoiding rounding issues during IIF import that result in out of balance errors
Options
Datarec_ReckonLtd
Reckon Staff Posts: 1,062
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)
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
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)
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 *
Regards,
Reckon Data Recovery Team
How to ask good questions on the Reckon Community
Data Services Tip - Try this first before requesting a data service
0
Categories
- All Categories
- 6.9K Accounts Hosted
- 11 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.2K Reckon Payroll 🚀
- 20 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 3.1K Reckon One
- 7 📢 Reckon One - Announcements
- 11 Reckon Invoices App
- 14 Reckon Insights
- 114 Reckon API
- 830 Payroll Premier
- 326 Point of Sale
- 2K Personal Plus and Home & Business
- 74 About Reckon Community