Home Intercompany Reconciliation Dates in the data preview show timestamps e.g., 2025-01-05T00:00:00. How do I fix header/column alignment so dates display correctly?

Dates in the data preview show timestamps e.g., 2025-01-05T00:00:00. How do I fix header/column alignment so dates display correctly?

Last updated on Sep 08, 2026

Dates in the data preview show timestamps e.g., 2025-01-05T00:00:00. How do I fix header/column alignment so dates display correctly?

Category: Troubleshooting

Short Answer: Open 'Configure file', set the correct 'Header row', and select the correct 'Date' column for example 'Document Date' so preview columns align and dates display properly.

Answer

PreRequisites

  1. File uploaded

  2. 'Configure file' modal open

Steps

  1. Click the pencil icon on the uploaded file to open 'Configure file'.
    Data preview and mapping fields are visible.

  2. Set 'Header row' to the row number where headers are located example: change to '5'.
    Preview's header row aligns with column names.

  3. Under 'Date (optional)' select the column that holds dates e.g., 'Document Date'.
    Date column is associated correctly and preview shows dates.

  4. If timestamps still appear, format the date in the source file to a standard date format and re-upload.
    Preview displays clean date values.

Troubleshooting

  1. Dates remain in ISO timestamp format after changing header row.
    LikelyCause: Source file uses non-standard or text-formatted dates.
    Action: In the source spreadsheet, re-format the column as a date and save, then re-upload and re-check 'Date' mapping.