1.Executive Summary

The AI-Powered End-to-End ITR Filing Automation System is a next-generation, intelligent automation framework purpose-built for Chartered Accountant (CA) firms and tax professionals. By seamlessly integrating Python automation, Google Workspace, AI-based document processing, and smart workflow orchestration, the system eliminates repetitive manual work across the entire Income Tax Return (ITR) filing lifecycle.

The solution covers every critical stage — from client onboarding and document collection through AI-driven compliance verification, automated follow-up, ITR filing support, and final document delivery — creating a completely connected, auditable digital workflow.

Key Automation Pillars

1. Smart Document Collection —Google Forms + auto-folder creation in Drive
2. AI Document Identification —Content-based classification & standardised renaming
3. Compliance Engine— AIS & Form 26AS auto-download, unlock, and reconciliation
4. Intelligent Reminders— Automated emails, Google Meet invites, and follow-ups
5. One-Click Delivery— Post-filing document packaging and client communication

The system is built on a centralised Google Sheet-based Client Tracker that serves as the live control centre — providing real-time visibility into every client's filing status, from first submission to final closure.

2.End-to-End Process Flowchart

3. Tools & Scripts Used in the Use Case

The solution is composed of eight precision-engineered tools — two Google Forms, three Apps Scripts, and three Python Scripts — each handling a distinct automation layer of the ITR filing pipeline.

Technology Integration Overview

4. How to Run the Use Case

This section provides a step-by-step operational guide. Screenshots from the live system are embedded at each stage for reference.

4.1 Prerequisites & Initial Setup

1. Google Workspace account with Sheets, Drive, Forms, and Apps Script access
2. Python 3.9+ environment with required libraries (google-api-python-client, selenium, pdfplumber, openai, etc.)
3. Income Tax Portal credentials stored securely in the Credential Repository sheet
4. Service Account JSON key configured for Google Drive and Sheets API access

4.2 Step-by-Step Execution Guide

Stage A— Client Onboarding & Tracker Setup

1. Open the Client Master Tracker Google Sheet.
2. Add the new client record: Name, PAN, Email, and Income Tax Portal credentials.
3. The Drive folder is auto-created on first document submission via Google Form 1.
4. Share the Google Form 1 link with the client via email (Apps Script 1 sends this automatically).

Screenshot 1 — Client Master Tracker (Google Sheet) showing client records, status columns, and credential repository

Stage B— Document Collection (Google Form 1 + Apps Script 1 & 2)

1. Client opens Google Form 1 and uploads all required documents.
2. Apps Script 1 fires on form submission — sends acknowledgement email and updates tracker status to 'Documents Received'.
3. If no submission within SLA, Apps Script 2 dispatches automated escalating reminders.

Screenshot 2 — Google Form 1 (Initial Document Collection) showing upload fields and submission confirmation

Screenshot 3 — Apps Script 1 trigger log and sample acknowledgement email sent to client

Stage C— Smart File Identification (Python Script 1)

1. Run Python Script 1 from terminal or scheduled trigger: python smart_file_identifier.py --client <PAN>
2. Script connects to Drive, reads each file's content, and classifies document type using AI.
3. Files are renamed using the convention:<PAN>_<DocType>_<FY>.pdf (e.g., ABCDE1234F_Form16_FY2425.pdf).
4. Tracker is updated with 'Identification Complete' status.

Screenshot 4 — Terminal output of Python Script 1 showing file identification, classification results, and rename log

Before

After (files are renamed based on the contents)

Screenshot 5 — Google Drive folder before and after Smart Renaming (standardised file names)

Stage D— Document Analysis & Compliance Check (Python Script 2)

1. Run Python Script 2: python itr_document_analyzer.py --client <PAN>
2. Script auto-logs into the Income Tax Portal using stored credentials.
3. Downloads AIS and Form 26AS for the relevant assessment year; unlocks password-protected files.
4. Runs reconciliation: compares government data against all client-uploaded documents.
5. Generates a comprehensive Analysis Report (Google Sheet / PDF) with: missing documents, income mismatches, red-flag transactions, and estimated total income.
6. Tracker status updated to 'Analysis Complete — Pending Additional Docs' or 'Ready for Filing'.

Screenshot 6 — Income Tax Portal automated login session (Python Script 2 in action)

Screenshot 7 — AIS & Form 26AS reconciliation output showing matched, unmatched, and red-flag items

Screenshot 8 — Generated Analysis Report with missing document list and estimated income summary

Stage E— Follow-Up & Additional Documents (Python Script 3 + Google Form 2)

1. If gaps detected, run Python Script 3:python itr_reminder_meeting.py --client <PAN>
2. Script emails client with: itemised missing document list, Google Form 2 upload link, and deadline.
3. Optionally, a Google Meet invitation is generated and sent for advisory discussion.
4. Client uploads additional documents via Google Form 2. System loops back to Stage C and D automatically.

Screenshot 9 — Sample Reminder Email with missing document list and Google Form 2 link (Python Script 3 output)

Screenshot 10 — Auto-generated Google Meet invite for ITR finalisation discussion

Stage F— ITR Filing & Document Delivery (Apps Script 3)

1. CA files ITR on the portal manually after review. Updates tracker: Filing Status = 'Filed', Filing Date = <date>.
2. Click the 'Send Filing Documents' button in the tracker (triggers Apps Script 3).
3. Script compiles: ITR-V Acknowledgement, Computation of Income, Tax Summary, Refund/Tax Payable Summary.
4. One automated email delivers all documents to the client. Tracker status set to 'Case Closed'.

Screenshot 11 — Client Tracker showing 'Filed' status and one-click 'Send Filing Documents' button

Screenshot 12 — Automated client delivery email with all four filing documents attached (Apps Script 3 output)

5.Benefits of the Use Case for CA Firms in Practice

The AI-Powered ITR Automation System delivers transformative, measurable value across every dimension of a CA firm's operations. Below is a detailed breakdown of the benefits across six strategic areas.

Operational Impact Comparison

Strategic Value for Growing CA Practices

1. Season-Proof Operations — Manage peak filing periods (July & March) without quality degradation or staff burnout
2. Competitive Differentiation — Offer faster TAT and transparent client communication vs. traditional manual practices
3. Data-Driven Insights — Aggregated client data across the tracker enables practice-level analytics and planning
4. Future-Ready Infrastructure — Modular design allows easy integration of additional AI models, e-filing APIs, or CRM systems
5. Team Empowerment — Staff focus on high-value advisory work; automation handles routine execution