Home Vendor Reconciliation How do I choose which column is used as the transaction date?

How do I choose which column is used as the transaction date?

Last updated on Apr 28, 2026

Short Answer: Select the desired date column using the "3. Transaction date" dropdown (for example, "Value Date" or "Document Date").

PreRequisites

  1. Header row is set so column labels are visible

  2. The date column appears in the Data preview

Steps

  1. Ensure "2. Header row" is correct so column labels appear in mappings.
    Column labels like "Value Date" and "Document Date" are available.

  2. Click the "3. Transaction date" dropdown and select the column to use (e.g., "Value Date").
    The selected column appears in "3. Transaction date".

  3. Confirm dates look correct in the "Data preview (20 rows)".
    Preview rows show the expected dates from the selected column.

Troubleshooting

  1. Date values are empty or nonsensical after selection.
    LikelyCause: The selected column doesn't contain dates or header row is wrong.
    Action: Confirm the column you selected contains dates in the preview and correct the "2. Header row" if necessary, then re-select under "3. Transaction date".