How do I map the transaction date and set the date format?

Short Answer: Select the date column in ‘3. Transaction date’ and set ‘4. Date format’ (First/Second/Third value) to match your file’s day/month/year order.

PreRequisites

1. Header row is correctly set

2. Date values are visible in Data preview (20 rows)

Steps

1. Select the transaction date column.
   Click ‘3. Transaction date’ and choose the column that contains date values (e.g., Value Date).

2. Set the date format.
   In ‘4. Date format’, define the order using:

   • First value

   • Second value

   • Third value
     Match this to your file’s format (e.g., Month / Day / Year).

3. Verify in preview.
   Check Data preview (20 rows) to ensure dates appear correctly after mapping.

Troubleshooting

1. Dates appear incorrect or swapped
   Likely Cause: Wrong date format selected
   Action: Adjust First/Second/Third values to match your file

2. Date column not visible in dropdown
   Likely Cause: Incorrect header row or sheet selected
   Action: Verify ‘Header row’ and ‘Select sheet’ settings

Note: Always match the date format exactly to your source file to ensure accurate parsing and reconciliation.