The structured amount parser accepts parentheses as a negative marker. In a signed amount column, a value such as (45.20) is read as negative before the selected Amount sign convention determines cash direction.
- Check a known transaction in the original export to establish what parentheses mean there.
- Use One amount column and the sign convention that matches the source.
- Compare the interpreted amount and direction in Preview with the bank record.
Avoid combining parentheses with a second sign marker, such as a leading minus. The parser rejects repeated or conflicting direction markers rather than guessing which one should win.
Split-column files need a separate check
A negative value in a Money in or Money out column can conflict with that column’s meaning. Read the row problem and use a supported signed representation for reversals when the source requires it.
Do not strip parentheses without checking direction. Turning a negative amount into an unsigned value can reverse a movement. Keep the original file and compare totals after any formatting repair so the accounting result preserves the bank evidence.
Was this article helpful?
Tell us whether this answered the question you came with.