The parser rejects repeated or conflicting direction markers in one amount. A leading minus combined with parentheses, a trailing minus or a CR/DR suffix can make the intended direction unclear.
- Compare the complete raw value with the bank’s original export.
- Identify the actual posted movement and whether it is money in or money out.
- Prepare one consistent supported sign representation, then check the interpreted direction in Preview.
Do not rely on ordinary arithmetic rules to cancel two negative markers. In a bank export, repeated signs may be a formatting error rather than a deliberate mathematical expression.
Check the whole column
If the repeated markers were introduced by spreadsheet formatting, repair the conversion for the whole affected range and compare totals. Avoid correcting only the first visible row while leaving later rows inconsistent.
A split Money out or Money in column already supplies direction through its role, so inspect the column layout as well as the sign text. Preserve the original export and the verified amount. If the source remains contradictory, leave the row unresolved and ask for clearer bank evidence before committing it.
Was this article helpful?
Tell us whether this answered the question you came with.