Value in the field does not match with the data type supported by us.
I'm trying to import statements from my bank, and I am having an issue with the Amount field. Amounts from my bank are formatted as such: 150000,00 where the comma is the decimal delimiter.
When mapping fields, I select the 1234567,89 format but I am still getting the "Value in the field does not match with the data type supported by us." error. If I attempt to map using the 1234567.89 format (dot instead of comma) the import succeeds but the values are obviously wrong.
Example value from CSV: Description,Type,"-10000,00",Payee
What am I doing wrong?