The structured amount parser uses a period for decimals and comma grouping for thousands. A decimal-comma value needs a reviewed conversion before it can be interpreted reliably in this workflow.
- Confirm the source locale and determine which character is the decimal separator.
- Prepare a working export with periods for decimals and consistent supported grouping, preserving every amount exactly.
- Check representative large values, values below one unit and negative amounts against the original.
Changing Separator to Semicolon only controls how columns split. It does not change the numeric convention inside an amount field.
Avoid ambiguous replacements
Do not blindly remove all commas. Depending on the source, that could turn a decimal amount into a value one hundred times larger. Use the spreadsheet’s or export tool’s confirmed number interpretation before saving the working file.
After reading the file, compare the total money in and money out with the original export and investigate any discrepancy. Retain the original file and record the formatting conversion. If you cannot establish the source convention confidently, obtain another bank export before importing the amounts.
Was this article helpful?
Tell us whether this answered the question you came with.