Amount is zero marks a row that has no nonzero movement under the selected mapping. Inspect it before treating it as a transaction that needs importing.
- Confirm that the actual amount column is mapped and that a blank or unrelated field was not selected.
- Compare the source row with the bank export. It may be a note, a zero-value authorization, a summary line or another nonmovement record.
- If it is a real movement whose value was lost during export, obtain the correct amount from source evidence. Otherwise leave it out of the movement import.
Do not replace zero with a small amount to force acceptance. That creates financial activity the source does not show.
Review split columns
When both Money in and Money out are blank or zero, the row also has no importable movement. If the bank uses another column for its amount, revise the mapping rather than filling the split fields arbitrarily.
After correcting the source or mapping, compare the nonzero transaction count and totals with the statement. Keep the original export so excluded informational rows can still be explained during later review.
Was this article helpful?
Tell us whether this answered the question you came with.