Home VAT/Sales Tax Reconciliation How do I set the Header row so column names import correctly?

How do I set the Header row so column names import correctly?

Last updated on May 18, 2026

Short Answer: Select the numeric row that contains your file's column headings using the 'Header row' dropdown the example shows '1'.

PreRequisites

  1. The dialog 'Configure VAT / sales tax statement' is open.

  2. You can see rows in 'Data preview (20 rows)'.

Steps

  1. Look at the table under 'Data preview (20 rows)' to find which line contains the column names.
    You identify the row index that holds the headers.

  2. Open the 'Header row' dropdown in the 'Required fields' panel and choose that row number example: '1'.
    Header row is set to the correct index.

  3. Verify the column headings in Data preview update to readable names e.g., 'Return Date', 'V A T Period'.
    Column headers display correctly for mapping.

Troubleshooting

  1. Columns still show generic names like 'Column4'.
    LikelyCause: Wrong header row selected or file has blank rows above headers.
    Action: Try a different 'Header row' number until headers align; if the file lacks headers add them in the source file and reopen the import dialog.

Note: Header row is the starting point — set it before mapping other fields so dropdown labels match your columns.