Trying to do a JE Import and receiving an error that the balances do not match error when I import. The balances match out perfectly and I've normally never had issues with JE imports any suggestions from anyone that has had this in the past when they do indeed match?

Usually that means the decimal places on at least one of your numbers is more than 2 digits. Even though Excel shows them as 2 digits, your first line might actually be 11.254 or something for example. I think the CSV importer can "see" that and takes in into account when doing its balance checks. Probably if you do a round to two decimal places on each number, then copy paste values with the rounded numbers, it will fix it.

Have you used the same external id for all the line ? And check on your excel the number of decimal ( possible to have a line with 3 decimals )

agree with @RJMNS, if your numbers have a value in the thousandth decimal place (or further) then you could have an unbalanced transaction. Either change the format to expand the view of decimals to manually find your culprit or use the ROUND formula on all cells

Thank you for the suggestions, I did test changing the format to see if that would resolve it. Strangely what worked was removing all of the additional columns on the sheet outside of Account, Subsidiary, Debit, Credit. When I did this it worked but when I add the fields I remove it fails. It's only for this specific one as well I tested with larger JE transactions and no issues. I tried a new sheet to see if maybe the sheet had an issue.

Hi, is there a tax code? It might be that varies with the segments etc. I’ve seen that before.