Home 26AS TDS Reconciliation How do I change which row is used as the header row for my Books file?

How do I change which row is used as the header row for my Books file?

Last updated on Sep 08, 2026

Short Answer: In 'Configure file - Books', set the 'Header row' dropdown to the row number that contains your column headers; confirm via the Data preview.

PreRequisites

  1. Books file uploaded.

  2. 'Configure file - Books' modal is open.

Steps

  1. Open 'Configure file - Books' and locate 'Header row' in the Required fields panel.
    The 'Header row' dropdown is visible example shows '4'.

  2. Select the row number that contains the column headers in your spreadsheet.
    Data preview updates and column names align.

  3. Verify the mapping dropdowns now show expected column names for Party, Date and TDS amount.
    You can correctly map the required fields.

Troubleshooting

  1. Columns are still misaligned after changing header row.
    LikelyCause: Blank rows, extra metadata rows, or merged cells above headers in the spreadsheet.
    Action: Edit the source spreadsheet to remove blank or merged rows, re-upload the file, and set the Header row again.

Note: Header row in the example is set to '4'.