Row has both money in and money out means the split-column import found nonzero values in both directions for one transaction. Review the source row and column mapping before deciding how to represent it.
- Check whether Money in and Money out were accidentally mapped to the wrong columns, such as a transaction amount and a running balance.
- Compare the row with the original bank export. Determine whether it contains one movement or a summary of several movements.
- Prepare one supported movement per row using the original evidence, then preview the file again.
Do not subtract the columns automatically just to produce one net amount. A row can represent a malformed export, a subtotal or separate transactions whose evidence needs to be preserved.
Check similar rows
If every row has the same problem, investigate the file layout or mapping before editing individual values. If only one row fails, inspect its original source closely.
Retain the original export and any explanation for a corrected working file. When the source genuinely uses a signed movement column, the One amount column layout may fit better. Confirm cash direction for both payments and deposits before proceeding.
Was this article helpful?
Tell us whether this answered the question you came with.