Choose One amount column when each CSV row has a single amount whose sign indicates money in or money out. Map Amount (signed), then set Amount sign to match the bank’s convention.
- Identify a known payment out and a known deposit or refund in the original export.
- Choose Negative is money out or Positive is money out (card exports), based on those source examples.
- Compare the interpreted amounts in Preview. Check that the direction of both examples agrees with the bank record.
Do not select a sign convention from the filename or account type alone. The export’s actual representation determines how its values should be read.
Check the aggregate result
Review the money-in and money-out totals and the date range before continuing. If nearly all deposits appear as expenses, revisit the sign choice instead of changing each number individually.
A refund in a card export may use the opposite sign from an ordinary purchase. Keep both kinds of movement in the preview check. Once the mapping is correct, use Check rows against the books to identify duplicates, closed periods and other row-specific conditions before committing the import.
Was this article helpful?
Tell us whether this answered the question you came with.