Home Credit Card Reconciliation How do I map my file columns to the required fields for reconciliation?

How do I map my file columns to the required fields for reconciliation?

Last updated on Apr 29, 2026

Short Answer: Use the 'Required fields' panel to set 'Header row', pick the 'Transaction date', choose 'Date format', map 'Description / Narration', select 'Amount representation', then click 'Save & apply'.

PreRequisites

  1. Your statement file is loaded and visible in 'Data preview (20 rows)'

  2. You can identify column names in the preview (e.g., Post Date, Trans Date, Description)

Steps

  1. Open the Configure credit card statement modal.
    You see 'Data preview (20 rows)' and the 'Required fields' panel.

  2. Set '1. Header row' to the row number containing your column headers.
    Column names align correctly in the preview.

  3. Under '2. Transaction date', choose the column with transaction dates (e.g., Post Date).
    This column becomes the date source.

  4. Set '3. Date format' by choosing First / Second / Third value (Day / Month / Year) to match your file.
    Dates parse correctly based on your selection.

  5. In '4. Description / Narration', select one or more fields (e.g., Description, Reference, Category).
    These fields combine to form the narration.

  6. Under '5. Amount representation', choose:

  • Single signed amount column, or

  • Separate credit and debit columns
    Then select the correct 'Amount column' (e.g., Debit (USD)).

  1. Review the 'Formatted preview (first 5 rows)'.
    Preview shows how dates, descriptions, and amounts will appear.

  2. Click 'Save & apply' to confirm mapping or 'Cancel' to discard.
    Mappings are applied and the dialog closes.

Troubleshooting

  1. Dates appear incorrect in preview.
    LikelyCause: Wrong date format order.
    Action: Adjust First / Second / Third value to match your file (e.g., Day → Month → Year).

  2. Description is empty or incomplete.
    LikelyCause: Incorrect or missing fields selected.
    Action: Update selections under 'Description / Narration' and recheck preview.

  3. Amounts are missing or incorrect.
    LikelyCause: Wrong amount representation or column.
    Action: Select the correct representation and choose the proper Amount column.

  4. Columns look misaligned or incorrect.
    LikelyCause: Wrong Header row selected.
    Action: Set the correct header row and verify column labels in preview.

Note: Always validate using 'Formatted preview (first 5 rows)' before clicking 'Save & apply' to avoid mapping errors.