Home TDS Reconciliation

TDS Reconciliation

Reconcile TDS data efficiently by matching records, detecting mismatches, and ensuring accurate tax reporting in one streamlined workflow.
By Vishwesh Sarkar
• 21 articles

How do I edit an uploaded 26AS or books file before reconciliation?

Short Answer: On the main upload page, click the 'Edit' (pencil) on the file card to re-open the 'Review 26AS statement' or 'Configure books data' modal, make changes, then click 'Confirm & continue' or 'Save & apply'. PreRequisites 1. The file has already been uploaded and the file name is visible on the card. Steps 1. On the New Reconciliation page, locate the file card showing the uploaded file name and click the 'Edit' pencil icon. The corresponding modal ('Review 26AS statement' or 'Configure books data') re-opens. 2. For 26AS files, review the information in 'Review 26AS statement'. • If the details are correct, click 'Confirm & continue'. • If you need to stop the process, click 'Cancel'. 3. For books files, update the required mappings in 'Configure books data', such as: • Party • Transaction date • Date format • TDS amount Review the 'Formatted preview (first 5 rows)', then click 'Save & apply'. 4. After completing the edits, click 'Continue' to proceed to 'Party mapping'. The Party mapping modal opens to map the required parties. Troubleshooting 1. Clicking 'Edit' does nothing. Likely Cause: • Temporary UI issue. • The modal dialog is blocked by the browser. Action: • Refresh the New Reconciliation page and try clicking 'Edit' again. • Ensure browser extensions or pop-up blockers are not preventing the modal from opening. Note: Use the 'Edit' option to fix mappings or re-confirm the 26AS file before continuing with the reconciliation process.

Last updated on Apr 14, 2026

How do I review and adjust party mappings and run reconciliation?

Short Answer: In the 'Party mapping' modal, review matched pairs, use the 'Confidence filter' to find rows marked 'Needs review', select the correct deductor from the '26AS DEDUCTOR' dropdown for any 'Select deductor..' rows, and click 'Run reconciliation' when it becomes enabled. PreRequisites 1. Both 26AS and Books files are uploaded and confirmed/mapped. 2. You are currently on the 'Party mapping' modal. Steps 1. When the 'Party mapping' modal opens, review the list under the columns 'BOOKS PARTY', '26AS DEDUCTOR', and 'CONFIDENCE'. You will see matched parties along with confidence badges such as High, Medium, or Needs review. 2. Use the 'Confidence filter' and select 'Needs review' to quickly identify rows that require manual verification. This helps focus only on mismatched or uncertain mappings. 3. For rows showing 'Select deductor..', click the '26AS DEDUCTOR' dropdown and choose the correct deductor. Verify the PAN shown in the dropdown option where available to ensure the correct mapping. 4. After selecting the correct deductor, the chosen value appears in the '26AS DEDUCTOR' column, and the confidence level updates automatically. 5. Once the required rows are mapped and the confidence level is acceptable, click 'Run reconciliation'. The button becomes enabled, and the reconciliation process starts. Troubleshooting 1. 'Run reconciliation' is greyed out. Likely Cause: • Some rows still show 'Select deductor..' and are not mapped. • Required mappings are still incomplete. Action: • Use the 'Confidence filter' to find rows marked 'Needs review'. • Select the appropriate deductor from the dropdown for those rows. • After completing the mappings, click 'Run reconciliation'. 2. A books party has no matching 26AS deductor in the dropdown. Likely Cause: • The corresponding deductor does not exist in the uploaded 26AS file. Action: • Confirm that the 26AS file includes the missing deductor (PAN or name). • If necessary, update the books file so the party names match, then re-upload and remap. Note: The Party mapping modal shows progress such as '5 of 7 parties matched' to help track remaining mappings before reconciliation.

Last updated on Apr 14, 2026

How do I start a new 26AS TDS reconciliation?

Short Answer: On New Reconciliation — 26AS TDS Reconciliation, select '26AS TDS reconciliation', upload the 26AS TXT file and your books file, confirm and map the required fields, then continue to Party mapping and click 'Run reconciliation'. PreRequisites 1. Be on New Reconciliation — 26AS TDS Reconciliation (/products/reconciliation/new). 2. Form 26AS downloaded as a TXT file from the Income Tax Portal. 3. Books file in CSV, XLS, or XLSX format. 4. Each file size ≤ 10 MB. Steps 1. Open New Reconciliation — 26AS TDS Reconciliation and confirm 'Select reconciliation type' = '26AS TDS reconciliation'. The page shows two upload cards: '26AS Statement' and 'Books / Books of Accounts'. 2. Upload the 26AS file in the '26AS Statement' card. • Click 'Upload file' or drag & drop the TXT file. • Supported format: TXT. The 'Review 26AS statement' modal appears showing Assessee details and Data preview (first 20 rows). 3. In the 'Review 26AS statement' modal, verify the Assessee details and review the Data preview (first 20 rows). If everything looks correct, click 'Confirm & continue'. The 26AS file upload is accepted and the modal closes. 4. Upload the books file in the 'Books / Books of Accounts' card. • Click 'Upload file' or drag & drop your CSV/XLS/XLSX file. The 'Configure books data' modal opens to configure column mappings. 5. Map the required fields in 'Configure books data': • 1. Party / Ledger name • 2. Transaction date • 3. Date format • 4. TDS amount Verify the Formatted preview (first 5 rows) to ensure Date, Party, and TDS Amount appear correctly. 6. Click 'Save & apply' to save the mappings and return to the main page, then click 'Continue'. The page now shows uploaded file names and proceeds to 'Party mapping'. 7. In the 'Party mapping' modal, review the matched rows, resolve any rows showing 'Select deductor..', and then click 'Run reconciliation' when it becomes enabled. The reconciliation process begins once the button is clicked. Troubleshooting 1. Continue button remains disabled on the main page. Likely Cause: • One or both files are not uploaded. • The 26AS file has not been confirmed. Action: • Upload both '26AS Statement' (TXT) and 'Books / Books of Accounts' (CSV/XLS/XLSX). • Confirm the 26AS file by clicking 'Confirm & continue'. 2. Upload is rejected or file is not accepted. Likely Cause: • Incorrect file format. • File size exceeds 10 MB. Action: • Ensure the 26AS file is in TXT format. • Ensure the books file is CSV, XLS, or XLSX. • Confirm the file size is ≤ 10 MB before uploading. Note: The 26AS file must be TXT, and the books file must be CSV, XLS, or XLSX. Always review the Formatted preview (first 5 rows) before clicking 'Save & apply' to confirm the correct mappings.

Last updated on Apr 14, 2026

How do I upload and review my 26AS statement?

Short Answer: In the '26AS Statement' card, upload the TXT file (drag & drop or 'Upload file'), review the 'Review 26AS statement' modal, then click 'Confirm & continue'. Answer PreRequisites 1. Form 26AS available as a TXT file downloaded from the Income Tax Portal. 2. File size ≤ 10 MB. Steps 1. On New Reconciliation — 26AS TDS Reconciliation, locate and open the '26AS Statement' card. - The card shows the upload area with 'Drag & drop your file here' and 'Upload file' options. 2. Click 'Upload file' or drag & drop your 26AS TXT file into the 26AS Statement card. - The 'Review 26AS statement' modal appears showing 'Data preview (first 20 rows)'. 3. In the 'Review 26AS statement' modal, verify the 'Assessee details', including: - Name - PAN - Financial Year - Assessment Year Also inspect the Data preview (first 20 rows) to ensure the sample rows look correct. 4. If the details are correct, click 'Confirm & continue'. - If the information is incorrect, click 'Cancel' and re-upload the correct 26AS file. 5. After confirmation, the 26AS file is accepted, and you return to the main upload screen to continue the reconciliation process. Troubleshooting 1. Assessee details are missing or do not match your entity. LikelyCause: • The wrong 26AS file was uploaded. • The file may belong to a different PAN or financial year. Action: • Download the correct Form 26AS TXT file from the Income Tax Portal. • Upload the correct file again. 2. Upload button does nothing or the file fails to load. LikelyCause: • The file format is not TXT. • The file size exceeds 10 MB. Action: • Ensure the file format is TXT. • Confirm the file size is ≤ 10 MB, then retry the upload. Note: Use the 'Assessee details' section to verify the PAN and financial year before clicking 'Confirm & continue'.

Last updated on Apr 14, 2026

My TDS amounts look wrong or empty in the formatted preview — how do I fix that?

Short Answer: Open 'Configure books data', ensure 'TDS amount' is set to the correct column, verify values in 'Formatted preview (first 5 rows)', then click 'Save & apply'. PreRequisites 1. Books file uploaded and 'Configure books data' modal open. Steps 1. Open 'Configure books data' for your books file. You will see mapping fields including 'TDS amount' and a 'Formatted preview (first 5 rows)'. 2. Under 'TDS amount', click 'Select column' and choose the column that contains TDS values from your file. The TDS values populate in the 'Formatted preview (first 5 rows)'. 3. If values include currency symbols or appear parsed incorrectly, clean the source column in your file so it contains numeric values only, then re-upload the file, or select a different column if appropriate. Correct numeric TDS amounts should appear in the preview. 4. Click 'Save & apply' to persist the corrected mapping. The books mapping is saved with correct TDS amounts for reconciliation. Troubleshooting 1. TDS shows 0.00 or blank after selecting column. Likely Cause: • Values include text or formatting that prevents numeric parsing. Action: • Remove non-numeric characters (such as commas or currency symbols) from the source column and re-upload the file, or choose the correct numeric column. Note: Check 'Formatted preview (first 5 rows)' immediately after selecting the TDS column to confirm the values are correct.

Last updated on Apr 14, 2026

How do I download the 26AS TDS reconciliation report?

Short Answer: Click the "Download report" button on the report page. If the report is still processing (shows "Normalizing books TDS data"), wait for processing to finish then try again. PreRequisites 1. You can access the report (signed in if the report is Private). 2. Reconciliation processing has finished (no "Normalizing books TDS data" spinner). Steps 1. Open the "26AS TDS reconciliation report" detail page. You can see the report title, top action buttons and summary cards. 2. Click the "Download report" button at the top of the page. Browser download prompt appears or file download starts. 3. If you are viewing the public (non-logged) page, open the public report link and click "Download report". Download starts without requiring login if the report is Public. 4. If the download does not start and the page shows a processing message, wait for processing to complete (or refresh and retry). Processing completes and "Download report" becomes actionable. Troubleshooting 1. Clicking "Download report" does nothing or download fails. LikelyCause: Report is still processing (shows "Normalizing books TDS data") or you don't have access because the report is Private. Action: Wait for processing to finish, refresh the page, or sign in / request access if the report is Private. 2. Cannot download as a public user. LikelyCause: Report is set to Private and you are not signed in or not granted access. Action: Ask the report Owner/Admin to share the report or change Report access to Public via the "Share" modal. Note: If you need the report for auditing, note the Recon ID (top-right) before downloading.

Last updated on Apr 14, 2026

How do I share this reconciliation report with teammates?

Short Answer: Click the "Share" button, enter email addresses in "Enter email address", choose role from the dropdown, pick "Private" or "Public", then click "Save & send invites" or "Copy link". PreRequisites 1. You are signed in. 2. You have permission to share the report (Owner/Admin may be required). 3. Report detail page is open. Steps 1. Open the reconciliation report page. Top action buttons including "Share" are visible. 2. Click the "Share" button. The "Share this report" modal opens. 3. In the modal type email addresses into the "Enter email address" field and use the role dropdown (e.g., "Member") to assign a role. Emails appear in the invite field and the selected role is displayed. 4. Review "People with access" to confirm existing viewers and roles. List shows current users and their roles (e.g., Richard Roe — Admin). 5. Under "Report access" choose "Private" (Only team members can view) or "Public" (Anyone with the link can view). Selected access option is highlighted. 6. Click "Save & send invites" to send invites (or click "Copy link" to get the shareable link). Invites are sent (or link copied) and people gain access as configured. Troubleshooting 1. I cannot find or click the "Share" button. Likely Cause: You do not have permission to share reports. Action: Ask the Organisation Owner or an Admin to add the people or change access settings. 2. Invite emails are not delivered or invalid. Likely Cause: Incorrect email format or mail delivery issue. Action: Verify the email addresses in "Enter email address" and resend; use "Copy link" as a fallback. Note: Choose "Public" only when you want anyone with the link (no login) to view the report; public view shows the site header with "Sign in" and "Start for free".

Last updated on Apr 14, 2026

What do the status tags (Fully matched, Short TDS, Excess TDS) indicate?

Short Answer: Status tags summarise reconciliation outcome for a party: 'Fully matched' means totals align, while 'Short TDS' or 'Excess TDS' flag a shortfall or excess between 26AS and Books — open details to see exact numbers. PreRequisites 1. Report table is loaded and you can expand row details. Steps 1. Locate a party row in the matched table and note the Status column (e.g., "Short TDS", "Excess TDS", "Fully matched"). You see the reconciliation tag for that party. 2. Check the "Difference" column in the same row to see the numeric difference between sides. You can see whether the Difference is positive or negative and how it relates to the Status tag. 3. Open the party's matched details modal to view the 26AS and Books totals and confirm why the tag was applied. The modal confirms which side is higher and the exact residual difference. 4. Investigate underlying transactions for the party and correct Books entries if needed. Discrepancies can be remedied at the transaction level. Troubleshooting 1. Tag meaning is unclear for a party. LikelyCause: The Status tag is a summary and the numeric Difference sign may be displayed according to internal calculation. Action: Open the party details (Matched TDS details modal) to see the explicit 26AS total, Books total and the exact Difference. Note: Always open the matched/unmatched details to confirm the exact amounts behind a status tag

Last updated on Apr 14, 2026

What do the summary cards (Total TDS as per 26AS, Total TDS as per Books, Matched TDS, Difference, Unmatched – 26AS TDS, Unmatched – Books TDS) mean?

Short Answer: Each card shows a high-level reconciliation metric: totals from 26AS and Books, the amount matched between them, the net Difference, and totals/counts of unmatched transactions. PreRequisites 1. Report detail page is open and data has finished loading. Steps 1. Locate the summary cards below the assessee details on the report page. You see six metric cards (26AS total, Books total, Matched, Difference, Unmatched – 26AS, Unmatched – Books). 2. Read the value and the small note under each card showing counts (e.g., "4 parties, 1,286 transactions"). You understand how many parties and transactions contribute to each total. 3. Use the 'Matched'/'Unmatched' toggle and the table below to investigate the items that make up each card. You can drill into the matched table or unmatched sections for details. 4. If totals look unexpected, check for processing state ("Normalizing books TDS data") or open the unmatched sections to find missing items. You identify whether processing or unmatched transactions cause the discrepancy. Troubleshooting 1. Summary totals differ from what you expect. LikelyCause: Reconciliation is still running (data normalizing) or there are unmatched transactions. Action: Wait for processing to finish, then expand matched and unmatched sections to inspect contributing transactions. Note: The 'Matched TDS' card includes a textual note like "(4 parties, 48 26AS transactions matched with 52 book transactions)" to show matched counts.

Last updated on Apr 14, 2026

What does 'No book entries found' mean in an unmatched party modal and how do I fix it?

Short Answer: "No book entries found" means the selected party has 26AS transactions but no matching book transactions; check your books upload and party identifiers and rerun reconciliation. PreRequisites 1. You have opened the unmatched party modal. Steps 1. In the "Unmatched – 26AS" section expand the party (e.g., "HDFC Bank") and open the details modal. The modal shows '26AS transactions' and an empty 'Books transactions' area with 'No book entries found'. 2. Verify that your books import includes transactions for that party and that identifiers (party name/PAN) match systems used for reconciliation. You find whether the party exists in your books data. 3. If entries are missing in your books, add or correct them and then use "Run new reconciliation" to reprocess. After re-run, the unmatched list updates and the party may move to Matched or disappear from Unmatched. 4. If book entries exist but still show none, check for naming/format differences and re-import or normalize the party identifiers. Fixing identifiers should allow the system to match transactions on the next run. Troubleshooting 1. Books contain the transaction but the modal still shows 'No book entries found'. Likely Cause: Party naming, PAN or other identifier mismatch between 26AS and Books data. Action: Normalize party identifiers in your books import to match the 26AS records, then rerun reconciliation. Note: The modal highlights that the 26AS total exists but Books total is ₹0.00 for that party.

Last updated on Apr 14, 2026