How do I map my file columns in Configure customer statement?

Short Answer: Complete all fields under Required fields (1–6), verify the mapping in Data preview, then click ‘Save & apply’.

PreRequisites

1. Customer statement file is uploaded

2. Configure customer statement dialog is open

3. Data preview (20 rows) and Required fields panel are visible

Steps

1. Select the sheet.
   Under ‘1. Select sheet’, choose the sheet containing your data.

2. Set the header row.
   In ‘2. Header row’, select the row number that contains column headers.

3. Map the transaction date.
   Under ‘3. Transaction date’, choose the column with date values.

4. Define date format.
   In ‘4. Date format’, set the order of Day / Month / Year to match your file.

5. Choose reference fields.
   Use ‘5. Reference / Description’ to add or remove columns as chips based on what you want included.

6. Select amount representation.
   In ‘6. Amount representation’, choose:

   • Single signed amount column, or

   • Separate credit and debit columns

7. Verify mapping in preview.
   Check the Data preview (20 rows) to ensure values look correct.

8. Save the mapping.
   Click ‘Save & apply’ to confirm, or ‘Cancel’ to exit without saving.

Troubleshooting

1. ‘Save & apply’ is disabled or not working
   Likely Cause: One or more required fields are incomplete
   Action: Ensure all 6 fields are filled before saving

2. Dates appear incorrect in preview
   Likely Cause: Wrong date format selected
   Action: Adjust the order of Day/Month/Year to match your file

3. Reference fields are missing or incorrect
   Likely Cause: Wrong header row or sheet selected
   Action: Recheck ‘Select sheet’ and ‘Header row’

4. Amounts appear incorrect or empty
   Likely Cause: Incorrect amount representation
   Action: Switch between single column or separate debit/credit options

Note: Reference fields are populated from the selected header row—ensure headers are correctly identified for accurate mapping.