When exporting transactions to Excel the .CSV format is used. The comma is used as separator. However the comma is also used as a delimiter for the thousands. As a result importing transactions or balances larger than one thousand messes things up.
03 May 2017 , Exchange to EUR , , â‚¬15.71 , , , 1, 298.05, general
Because of the comma “1,298.05” is interpreted as two separate values “1” and “298.05” in stead of the value “1298.05”.
You might remove the comma as delimiter for thousands when exporting to CSV. Thanks!