Short Answer: Open 'Configure file - Books', set 'Header row', choose 'Party / Customer Name' for party, 'Voucher Date' for Date, and 'TDS Receivable (Rs.)' for TDS amount; verify via Live normalized preview.
PreRequisites
-
Books file uploaded and 'Configure file - Books' modal open.
-
You are on the 26AS TDS reconciliation flow.
Steps
-
Open the 'Configure file - Books' modal. It appears after Continue or when configuring the Books file.
Data preview shows rows from your Books file Data preview (20 rows). -
Set 'Header row' to the row number that contains column headers using the dropdown.
Column headings align correctly in the Data preview. -
Set 'Party / Ledger name' to 'Party / Customer Name'.
Party names display correctly in the preview. -
Set 'Date' to 'Voucher Date'.
Dates appear normalized in the Live normalized preview. -
Set 'TDS amount' to 'TDS Receivable (Rs.)'.
TDS values populate in the preview. -
If a required column is missing, click 'Add column' and create/derive the column required for mapping.
New column appears and can be selected in mapping dropdowns.
Troubleshooting
-
Dates display as '2025-04-10T00:00:00' or incorrect format.
LikelyCause: Wrong header row selected or wrong column mapped as Date.
Action: Change 'Header row' to the correct row and re-select 'Voucher Date' as the Date column; confirm with Live normalized preview. -
TDS column not available in mapping dropdown.
LikelyCause: Header row misaligned or the column header is different.
Action: Adjust 'Header row' so headers are recognized or use 'Add column' to create/rename the TDS column before mapping.
Note: Use the 'Live normalized preview' to confirm mappings before you proceed. Header row in example is set to '4'.