FAQ 147: Import cutting off pennies on contributions

Problem:

I uploaded data to ASC and my contributions (deferral/match/profit sharing) dollar amounts are rounded in the tests. My spreadsheet shown with 2 digit cents but ASC only took the rounded to dollar amount. The funny thing is the compensation loaded correctly, not rounded. I have tried several times. Would you mind let me know how to fix this?

Thanks



Solution:

See attached screenshot of the vif setup. When I opened the vif template file, the TYPE for the Number was 9999 for the deferral, match and profit sharing, rather than 9999.99. It may be that you edited the vif file on the second import file so that it worked properly, but you did not save the changes.
To edit the vif file now, you need to change the NUM format and then click on the POST button to save it.