CSV Import file out of balance

[lsweeney]

Good afternoon,

I have a file that contains a journal entry that when formatted as a number correctly sums to 0, however, when saving as a CSV and trying to import into our accounting system it tells me the entry is out of balance. When I open the CSV file I get the sum of -1.93268E-12 which is why it is not importing. How do I eliminate this? I have tried copying to a new sheet, PS-Values, formatting, etc.

Thank you!

 

[Joe4]

Welcome to the Board!

I think that is the famous "floating point precision issue", rearing its ugly head!
See: Understanding Floating Point Precision, aka “Why does Excel Give Me Seemingly Wrong Answers?” - Microsoft 365 Blog

If this number is a calculation, one way to fix it would be to surround it in the ROUND function, i.e.
=ROUND(your formula,2)

Or you can use the "Set precision as displayed" option mentioned in that article.

 

[lsweeney]

Didn't work but thank you for the input!

 

[Joe4]

Didn't work but thank you for the input!

If it didn't work, why did you mark it as the solution?

It should work. If it doesn't, then you may not have applied it correctly.
Please let me know the exact steps you did, and I will see if I can identify where the issue is.