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

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

Last updated on Sep 08, 2026

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