Exact Online / accounting import: amounts wrong because of comma vs dot
Why amounts get multiplied or rejected in accounting imports and how to fix the decimal separator.
The message you see
Amounts imported wrong: 12,50 becomes 1250Fastest fix
Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.
Why this happens
- The file uses a decimal comma but the importer expects a dot (or the reverse).
- Thousands separators (1.250,00) are read as decimals.
- Currency symbols like € inside the amount column.
How to fix it
- 1Check the expected number format in the import settings.
- 2Remove currency symbols and thousands separators; use one decimal separator throughout.
- 3Compare totals before and after importing.
Related guides
HubSpot
HubSpot import error: “Make sure each column with data has a header”
ShopifyShopify CSV import: “Illegal quoting on line …”
Google SheetsPhone numbers turn into dates or lose their leading zero in Sheets/Excel
Still stuck? Ask SheetFix Support