26AS TDS Reconciliation

Reconcile TDS data efficiently by matching records, detecting mismatches, and ensuring accurate tax reporting in one streamlined workflow.

By Vishwesh Sarkar

• 10 articles

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

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'.

Last updated on Sep 08, 2026

How do I configure the Books file columns (header row, party, date, TDS amount)?

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 1. Books file uploaded and 'Configure file - Books' modal open. 2. You are on the 26AS TDS reconciliation flow. Steps 1. 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). 2. Set 'Header row' to the row number that contains column headers using the dropdown. Column headings align correctly in the Data preview. 3. Set 'Party / Ledger name' to 'Party / Customer Name'. Party names display correctly in the preview. 4. Set 'Date' to 'Voucher Date'. Dates appear normalized in the Live normalized preview. 5. Set 'TDS amount' to 'TDS Receivable (Rs.)'. TDS values populate in the preview. 6. 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 1. 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. 2. 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'.

Last updated on Sep 08, 2026

How do I download, share, copy, or delete a reconciliation report?

Short Answer: Click 'Download report' to export; open the three-dot menu next to it to 'Share', 'Copy reconciliation', 'Delete records', or 'Delete report'. PreRequisites 1. On the TDS report page report loaded. Steps 1. To download, click the 'Download report' button at the top-right of the report page. Report download begins file saved to your device. 2. Click the three-dot menu next to 'Download report' to open additional actions. Dropdown displays 'Share', 'Copy reconciliation', 'Delete records', and 'Delete report' red. 3. Choose 'Share' to start the share workflow or 'Copy reconciliation' to create a copy of the report. The chosen action begins share modal or copy created. 4. If you must remove data, choose 'Delete records' or 'Delete report'. Note 'Delete report' is red—exercise caution. A confirmation prompt appears before deletion. Troubleshooting 1. Clicking 'Download report' does nothing. LikelyCause: Browser pop-up blocked or network issue. Action: Check browser download/pop-up settings, refresh the page and retry. 2. Three-dot menu or certain actions missing. LikelyCause: Insufficient permissions on your account. Action: Request appropriate permissions from your account admin. Note: The three-dot menu lists 'Delete report' in red—confirm before proceeding.

Last updated on Sep 08, 2026

How do I open matched transaction details and unmatch a matched pair?

Short Answer: Click the matched row to open 'Matched transaction details', review the 'Match basis' and click the red 'Unmatch' button to separate the Books and 26AS entries. PreRequisites 1. On the results page with transactions displayed. 2. You have a matched transaction to inspect. Steps 1. Click the matched transaction row in the table e.g., under 'Fully matched'. The 'Matched transaction details' modal opens. 2. Review the 'Match basis' area; it shows 'Reference ID' + 'Amount' and the text 'Transactions matched using Identifier and Amount.' You can confirm why the transactions were matched. 3. Click the red 'Unmatch' button to separate the pair. The pair is unlinked and totals update on the results page. Troubleshooting 1. 'Unmatch' does not change totals or modal remains open. LikelyCause: Network timeout or server-side error. Action: Refresh the page and try 'Unmatch' again; if it still fails, wait a moment and retry or contact support. 2. 'Unmatch' is not available for a row. LikelyCause: The transaction may be in a locked state or requires different action. Action: Check your user permissions and ensure the transaction is eligible for manual unmatching; consult your admin if needed. Note: Modal shows both 'Books / ledger transactions (Books)' and '26AS statement transactions (26AS statement)' along with totals and 'Difference'.

Last updated on Sep 08, 2026

How do I review and edit party mappings between my Books and the 26AS deductors?

Short Answer: In the 'Party mapping' modal use the 'Confidence filter', edit the '26AS deductor' dropdown per row or click 'x' to remove, then click 'Run reconciliation'. PreRequisites 1. Completed file configuration and Review 26AS statement. 2. 'Party mapping' modal is open. Steps 1. Open the 'Party mapping' modal. It appears after file review. List of 'Books party' rows with corresponding '26AS deductor' and 'Confidence' shown. 2. Use 'Confidence filter' All, High, Medium, Needs review to narrow which mappings to review first. Rows update to reflect the selected confidence level. 3. For any incorrect mapping, open the '26AS deductor' dropdown on that row and choose the correct deductor. The selected deductor appears in the row. 4. To clear a mapping, click the 'x' on the row. The mapping is removed for that Books party. 5. After reviewing mappings, click 'Run reconciliation' bottom-right. Reconciliation runs and results page loads. Troubleshooting 1. Correct deductor not available in dropdown. LikelyCause: Deductor name is missing or formatted differently in the 26AS file. Action: Verify deductor names in the 26AS TXT; if necessary re-download 26AS or select the closest match and correct in source files. 2. 'Run reconciliation' button appears inactive. LikelyCause: Required review or validation still pending in the modal. Action: Scroll the modal and ensure required rows are addressed, then click 'Run reconciliation' again.

Last updated on Sep 08, 2026

How do I review the uploaded 26AS statement before reconciliation?

Short Answer: Open the 'Review 26AS statement' modal, confirm the data preview and Assessee details Name, PAN, Financial Year, then click 'Confirm & continue'. PreRequisites 1. 26AS statement TXT file uploaded. 2. You have completed Books file configuration or reached the Review step. Steps 1. Open the 'Review 26AS statement' modal. It appears after uploading the 26AS TXT. Data preview first 20 rows of the 26AS file is displayed. 2. Review 'Assessee details' on the right Name, PAN, Financial Year, Assessment Year, File creation date. Details match your company and the expected period. 3. If all details are correct, click 'Confirm & continue'. Modal closes and the flow proceeds to Party mapping. Troubleshooting 1. PAN or Financial Year in Assessee details is incorrect. LikelyCause: You uploaded the wrong 26AS TXT file. Action: Cancel, upload the correct 26AS TXT from the Income Tax Portal, and re-open the review modal. 2. Data preview is blank or garbled. LikelyCause: TXT file is corrupted or not a valid Form 26AS TXT. Action: Re-download the Form 26AS as a TXT from the Income Tax Portal and try again.

Last updated on Sep 08, 2026

How do I run reconciliation and read the Fully matched, Partially matched and Unmatched results?

Short Answer: After clicking 'Run reconciliation', review the summary cards Total, Fully matched, Partially matched, Unmatched, then use the tabs and '+ Add filter' to inspect transaction lists. PreRequisites 1. You have run reconciliation clicked 'Run reconciliation'. 2. You are on the TDS report results page. Steps 1. Click 'Run reconciliation' from the Party mapping modal to start the process. The app runs reconciliation and opens the results page with summary cards. 2. On the results page review the summary cards: 'Total', 'Fully matched', 'Partially matched', 'Unmatched'. Each card shows Books / ledger and 26AS totals and transaction counts. 3. Scroll down to the transactions table and click 'Fully matched', 'Partially matched', or 'Unmatched' tabs to view corresponding rows. The selected tab displays a list of transactions for review. 4. Use '+ Add filter' to narrow results by available fields. Filters are applied and table updates accordingly. 5. Click any transaction row to open details and inspect match reasons. The details modal opens Matched transaction details for that row. Troubleshooting 1. Summary 'Difference' shows a non-zero value. LikelyCause: There are partially matched or unmatched transactions causing the difference. Action: Open 'Partially matched' and 'Unmatched' tabs, inspect rows, correct mappings or source data and re-run reconciliation. 2. Applying filters returns no rows. LikelyCause: Filter criteria are too narrow or incorrect. Action: Remove or broaden filters using '+ Add filter' and retry.

Last updated on Sep 08, 2026

How do I upload my Books ledger and 26AS statement and start the 26AS TDS reconciliation?

Short Answer: Upload your Books Excel file and the 26AS TXT file, click 'Continue', configure file columns, review the 26AS, complete Party mapping and click 'Run reconciliation'. PreRequisites 1. Be signed in to Cointab and on the 26AS TDS reconciliation page. 2. Have your Books file Excel ready e.g., TDS_Receivable_Books_FY25_26.xlsx. 3. Have Form 26AS downloaded as a TXT from the Income Tax Portal. Steps 1. Upload the Books file by clicking inside the left 'Books' box or 'Add more files to Books' and select your Excel file. The Books filename appears inside the Books box e.g., TDS_Receivable_Books_FY25_26.xlsx. 2. Upload the 26AS statement by clicking the right '26AS statement' box or 'Add more files to 26AS statement' and select the TXT file you downloaded. The 26AS TXT filename appears inside the 26AS statement box. 3. Click 'Continue' at the top-right to proceed to file configuration. You are taken to the file configuration flow Configure file modal or Review 26AS modal. 4. In 'Configure file - Books' set Header row and map 'Party / Ledger name', 'Date', and 'TDS amount' to the correct columns. Live normalized preview shows correct party names, dates and TDS values. 5. Review the 'Review 26AS statement' modal and confirm the Assessee details Name, PAN, Financial Year. Assessee details match your company and period; click 'Confirm & continue'. 6. In 'Party mapping', review mappings, adjust any incorrect '26AS deductor' selections or remove mappings, then click 'Run reconciliation'. Reconciliation runs and the results page shows summary cards and transaction tabs. Troubleshooting 1. The 26AS upload fails or file not accepted. LikelyCause: You did not upload a TXT Form 26AS or the file is corrupted. Action: Download Form 26AS as a TXT file from the Income Tax Portal and upload the .txt file. Re-download if file is corrupted. 2. 'Continue' does nothing. LikelyCause: One of the required files is not uploaded or required fields are not configured. Action: Ensure both Books and 26AS files appear in their boxes and complete required mappings in 'Configure file - Books' Header row, Party / Ledger name, Date, TDS amount. 3. Reconciliation fails or times out. LikelyCause: Large files, temporary server or network problem. Action: Retry after a few minutes, check network, or split very large source files. Contact support if the issue persists. Note: 26AS must be a TXT file downloaded from the Income Tax Portal. Books should include a TDS column such as 'TDS Receivable (Rs.)'.

Last updated on Sep 08, 2026

What is the 'Confidence filter' in Party mapping and how do I use it?

Short Answer: The 'Confidence filter' lets you view mappings by the algorithm's confidence All, High, Medium, Needs review so you can focus manual checks on low-confidence matches. PreRequisites 1. 'Party mapping' modal is open after file review. Steps 1. Open the 'Party mapping' modal. The 'Confidence filter' is visible at the top with options All, High, Medium, Needs review. 2. Click 'High' to see high-confidence matches or 'Needs review' to focus on low-confidence pairs. Rows update to only show mappings that match the selected confidence level. 3. Manually review and correct rows listed under 'Needs review' before running reconciliation. Problem mappings are corrected or cleared. Troubleshooting 1. No rows appear when selecting a confidence level. LikelyCause: There are no mappings in that confidence category for this run. Action: Select 'All' to view every mapping and identify rows to review.

Last updated on Sep 08, 2026

Why is a transaction partially matched or unmatched and how do I fix it?

Short Answer: Partial/unmatched items occur when amounts, identifiers, or party names differ; check column mappings, party mappings and the 'Match basis' e.g., Reference ID + Amount, fix source data and re-run reconciliation. Answer PreRequisites 1. Have run reconciliation and can access Partially matched / Unmatched tabs. 2. Access to source Books and 26AS files for corrections. Steps 1. Open the 'Partially matched' or 'Unmatched' tab to locate affected transactions. List of problem transactions appears for review. 2. Click the transaction row and review 'Matched transaction details' to see 'Match basis' and the 'Difference'. You can identify which field caused the mismatch identifier, amount, or party. 3. If amounts differ, verify and correct the 'TDS amount' mapping in 'Configure file - Books' or correct the source file. Amount values align after correction. 4. If parties do not match, open 'Party mapping' and correct the '26AS deductor' selection for the Books party. Party mapping updated; re-run reconciliation. 5. Re-run the reconciliation to confirm the fixes moved transactions to Fully matched. Previously partial/unmatched rows move to Fully matched if resolved. Troubleshooting 1. Small decimal differences appear, e.g., -0.03. LikelyCause: Rounding or precision differences between source files. Action: Check source files for rounding; adjust precision in Books or correct values in source files; re-run reconciliation. 2. Reference ID missing for a row. LikelyCause: Identifier column not present or not mapped. Action: Map the identifier column in 'Configure file - Books' if available, or use party mapping to match by party and amount.

Last updated on Sep 08, 2026