Hi Guys i am getting an rounding issues in my CSV ...
# csvimports
s
Hi Guys i am getting an rounding issues in my CSV file on a journal import.when i total the debit and credit it balancing but when i use a different column to subtraction on debit and credit and use only single column to import i getting few cents rounding issue,Does anyone encountered similar issue please see below screen shot of the file
f
How many decimal places out are your debit & credits. You may be displaying rounding to 2 places (what ever it is) - but the actual cell is multiple decimals. Pretty sure you need fix you amounts to a fixed value
n
Yeah I have encountered this. You need to round to 2 decimals and accept the fact that you may need to adjust by 1 or 2 cents. Having said that, I assume you are doing TB imports with foreign currency accounts? If so, I have a workaround for all periods except for the period right before go-live