Choose Separate money in and out when the export uses separate columns for account inflows and outflows. Map Money out and Money in to the correct source columns and inspect the preview.
For a clean prepared CSV, put a positive amount in the applicable column and leave the other blank. One row should describe one movement. A row with nonzero values in both columns needs review.
Verify the direction
- Find a known withdrawal in the source and confirm that its amount maps to Money out.
- Find a known deposit and confirm that its amount maps to Money in.
- Compare totals and inspect any Problems messages before checking the rows against existing records.
The bank’s words Debit and Credit need to be interpreted in the context of the account and export. Use known transactions to verify the mapping rather than assuming that every statement layout uses identical column meanings.
If the export represents reversals with negative values inside a split column, read the sign-conflict message. A supported signed amount representation may be needed. Preserve the source transaction’s direction and amount when preparing that representation, and retain the original export for comparison.
Was this article helpful?
Tell us whether this answered the question you came with.