A trailing minus can represent a negative value in a bank export. The structured parser recognizes that marker, but you still need the correct Amount sign convention for the account’s export.
- Find a known outgoing movement and confirm whether the source uses a trailing minus for it.
- Map the single signed amount column and choose the matching sign convention.
- Inspect Amount as read and the interpreted amount together, then check a movement in the opposite direction.
Do not add a leading minus to a value that already has a trailing minus. Repeated sign markers are rejected because they can conceal a mistaken direction.
Repair the representation, preserve the value
If you prepare a working copy with conventional leading minus signs, convert consistently and compare it with the original export. The number’s magnitude and financial direction should remain unchanged.
If the row still fails after the sign is correct, inspect decimal precision, currency markers and the separator. Several independent formatting checks apply to an amount. Resolve the displayed problem rather than changing the amount to a nearby number that happens to pass.
Was this article helpful?
Tell us whether this answered the question you came with.