Home Bank Reconciliation How do I map columns in the Bank statement file?

How do I map columns in the Bank statement file?

Last updated on Mar 17, 2026

Short Answer: Open 'Configure bank statement', use 'Data preview (first 20 rows)' to identify columns, set '1. Transaction date', '2. Date format', '3. Description / Narration', choose '4. Amount representation', then select the appropriate '4. Amount column' and click 'Save & apply'.

PreRequisites

  1. Bank statement file uploaded and visible on the Bank statement card

  2. Source file columns present in the first 20 rows

Steps

  1. Open 'Configure bank statement' by clicking 'Edit' on the Bank statement card.
    'Configure bank statement' modal opens with 'Data preview (first 20 rows)'.

  2. Review the 'Data preview (first 20 rows)' to identify the correct column headers for dates, narration, and amounts.

    You can see column headers like 'Transaction Date', 'Value Date', 'Description'.

  3. For '1. Transaction date' use the 'Select column' dropdown to pick the column that contains the transaction date, then set '2. Date format' using 'Select date format'.
    Transaction date column and matching date format selected.

  4. For '3. Description / Narration' choose the column that contains the description.
    Description / Narration column selected.

  5. Under '4. Amount representation' choose either 'Single signed amount column' or 'Separate credit and debit columns', then set the '4. Amount column' (use 'Select column').
    Amount representation and the appropriate amount column selected.

  6. Click 'Save & apply' to store mappings and close the modal.
    Mappings are saved and the Bank statement card is ready for reconciliation.

Troubleshooting

  1. Dates are parsed incorrectly after saving (wrong day/month or blank).
    Likely Cause: Selected 'Date format' does not match the date column format in the file.
    Action: Re-open 'Configure bank statement', choose a different option under 'Select date format' that matches the preview and click 'Save & apply' again.

  2. Amounts show as '5.22E+11' or look truncated in preview.
    Likely Cause: Large numbers are stored in scientific notation in the source file or Excel cell formatting.
    Action: Format the amount cells as plain numbers (no scientific notation) in the source file, save, and re-upload; then re-select the correct 'Amount column'.

  3. Descriptions appear incomplete or missing.
    Likely Cause: Wrong column selected for 'Description / Narration'.
    Action: Use the 'Data preview (first 20 rows)' to identify the correct column and re-select it under '3. Description / Narration'.

Note: The 'Data preview (first 20 rows)' helps confirm column selection before you click 'Save & apply'.