Home Intercompany Reconciliation How do I map the transaction date column for reconciliation?

How do I map the transaction date column for reconciliation?

Last updated on Apr 24, 2026

Short Answer: Under '3. Transaction date' select the column that contains your transaction dates (example: 'Posting Date').

PreRequisites

  1. Dialog open with 'Data preview (20 rows)' visible

  2. '2. Header row' set so column names are available

Steps

  1. Find '3. Transaction date' in the Required fields panel.
    '3. Transaction date' control is visible (example shows 'Posting Date').

  2. Open the dropdown and choose the column that contains transaction dates.
    The selected column becomes the source for transaction dates.

  3. Check the 'Data preview (20 rows)' to verify date values come from the selected column.
    Preview displays expected date values under the chosen column.

  4. If dates do not parse correctly after selection, adjust '4. Date format' to match your file's ordering.
    Dates parse correctly when format matches.

Troubleshooting

  1. Selected transaction date column shows blanks or incorrect values.
    LikelyCause: Wrong column selected or '2. Header row' is incorrect.
    Action: Verify the header row and select the correct column under '3. Transaction date'. Then set the proper '4. Date format'.