ITC Tracker

ExpressGST || ITC Tracker

ITC Tracker – Overview and User Guide

Overview
The ITC Tracker module is designed to provide structured monitoring, reconciliation, and action management of Input Tax Credit (ITC) with direct alignment to GSTR-3B Table 4.
It enables organizations and tax professionals to track the entire lifecycle of ITC and ensure that actions taken on invoice data are accurately reflected in GSTR-3B reporting.
The module follows a structured workflow:

Reconcile → Track → Take Action → Reflect in GSTR-3B Table 4 Summary

Through this process, users can manage ITC across monthly, quarterly, and annual periods while maintaining proper compliance controls.
The dashboard provides consolidated visibility of:
  1. ITC available as per GSTR-2B
  2. Temporary reversals
  3. Permanent reversals
  4. Reclaimable ITC balances
  5. ITC already claimed
  6. Pending or unresolved actions
The ITC Tracker also provides multiple analytical views for efficient data analysis and action management, including:
  1. Document Type View
  2. Supplier View
  3. Invoice-Wise View
  4. Table 4 Control View (GSTR-3B)
Records are categorized across different document types such as Invoices, Debit Notes, Credit Notes, Reverse Charge Mechanism (RCM), and Imports, allowing users to monitor ITC eligibility and reconciliation status more effectively.
The module also tracks upward and downward amendments separately, enabling users to identify additional credits or reductions arising from supplier amendments and corrections.
The Invoice Action Center mirrors the GSTR-2B dataset, allowing users to take structured actions such as:
  1. Claim ITC
  2. Temporary reversal
  3. Permanent reversal
  4. Reclaim previously reversed ITC
Each action automatically updates the Table 4 summary view, ensuring alignment between the tracker and GSTR-3B filing data.
Additional features such as Reversal and Reclaim tracking, Excel-based bulk actions, and automated validation alerts help users identify discrepancies and maintain compliance.

      

ITC Tracker – Process Flow
The ITC Tracker module enables systematic reconciliation, action tracking, and reporting of ITC data with alignment to GSTR-3B Table 4.
 
Step 1: Select the Company
  1. Select the company for which ITC data needs to be reviewed and managed.
Step 2: Access the ITC Tracker
Navigate to Reconciliation Table → ITC Tracker.

      

This will open the ITC Tracker dashboard where reconciliation data and actions can be managed.
 
Step 3: Import Book Data
Use the Import Book Data option to import accounting records for reconciliation with GSTR-2B data.

      

After importing the data, records will be categorized based on reconciliation results, such as:
  1. Matched records
  2. Partially matched records
  3. Books-only records
  4. 2B-only records
  5. POS mismatch cases
  6. ITC eligibility conflicts
These classifications assist users in identifying discrepancies and taking appropriate actions.

ITC Tracker Views
The module provides six structured views that allow users to review data and perform actions in different formats.

Idea
1. Doc Type View
The Document Type View categories records based on document type for easier analysis.
      

Features
Document Categorisation
Records are grouped under categories such as:
  1. Invoices
  2. Eligibility records
  3. RCM transactions
  4. Amendment records
  5. ISD transactions
  6. Import transactions (IMPG)
  7. E-commerce transactions (ECO)
Reconciliation Status
Each document category displays records based on reconciliation status:
  1. Reconciled
  2. Partially Reconciled
  3. Unreconciled
Filtering
Users can select a reconciliation status to view only the relevant records.

Steps to Perform Actions
  1. Open Document Type View.
  2. Select the required Document Type.
  3. Click the relevant Reconciliation Status.
  4. The system displays the corresponding records.
  5. Click the action menu (three dots) for a record.
  6. Select the required action:
    1. Accept
    2. Reject
    3. Pending
    4. Reversal
    5. Reclaim
      


Idea
2. Supplier View
The Supplier View enables users to analyse and manage ITC data at the supplier level.

      

Features
Supplier Filtering
Users can filter records based on supplier-specific parameters.

      
Bulk Action Capability
Actions can be applied to multiple invoices under a supplier without opening individual records.

      

Invoice Drill-Down
Users can select a supplier to view detailed invoice-level records.

Steps
  1. Open Supplier View.
  2. Select the Supplier Category.
  3. Click the required Reconciliation Status.
  4. Review the displayed records.
  5. Use the action menu (three dots) to perform actions such as Accept, Reject, Pending, Reversal, or Reclaim.
Idea
3. Table 4 View – GSTR-3B
The Table 4 View provides a summary of ITC data aligned with Table 4 of GSTR-3B.

      

Features
  1. Alignment with GSTR-3B Table 4
  2. Summary of ITC actions
  3. Real-time update of action impact
  4. Tracking of reversals and reclaims
This view helps users verify that ITC values are correctly reflected before filing GSTR-3B.

Idea
4. Invoice-Wise View
The Invoice-Wise View provides detailed control at the individual invoice level.

      

Features
  1. Detailed invoice-level records
  2. Action history tracking
  3. Visibility of reconciliation status
  4. Amendment tracking
      
Steps
  1. Open Invoice-Wise View.
  2. Select the required invoice category.
  3. Click the relevant reconciliation status.
  4. Review the displayed records.
  5. Use the action menu (three dots) to perform the required action.
       

Idea
5. Use Excel to take Actions
The system supports Excel-based action processing for handling large datasets.

      
Steps
  1. Download the Excel Action Template.



  2. Update the required action fields in the template.



  3. Upload the updated file into the system.
  4. The system processes the file and applies the actions automatically.
This feature helps users perform bulk updates efficiently.

Idea
6. Extra Insights
The ITC Tracker provides automated alerts to help identify potential issues.

      

These include:
  1. Invalid GSTIN format
  2. Duplicate invoices
  3. Supplier risk alerts
  4. Amendment impact notifications
  5. High-value mismatches
  6. Reversal alerts
  7. ITC eligibility warnings
  8. Pending ITC alerts
      

These validations assist users in identifying discrepancies and maintaining accurate ITC records.

Alert
Default System Behaviour
  1. When the ITC Tracker is opened, the system automatically selects the due month of the currently pending GSTR-3B return.
  2. By default, records with “Pending / No Action” status are displayed.
  3. Users can enable the “Show All” option to view all available records.

Alert
Table 4 – Action Summary
After actions are taken within the ITC Tracker, the results are reflected in the Table 4 – Action Summary.

      
      

This summary helps users review the final ITC position and prepare or update Table 4 of GSTR-3B accordingly.

 

    • Related Articles

    • ExpressGST || Invoice Management System (IMS) Dashboard - DIY

      The Invoice Management System (IMS) within ExpressGST is a comprehensive utility that enables recipients to manage and act upon invoices filed by suppliers through GSTR-1, GSTR-1A, or IFF. This feature allows users to accept, reject, or mark invoices ...

    • ExpressGST || Invoice Management System (IMS) Dashboard

      The Invoice Management System (IMS) is an integrated feature within the GST framework that enables recipients to manage invoices filed by suppliers through GSTR-1, GSTR-1A, or IFF. Recipients can take necessary actions—Accept, Reject, or Mark as ...

    • ExpressGST || GSTR-6 Preparation and Filing Process

      Detailed Step-by-Step Guide Step 1: Access PAN View Navigate to the PAN View section in ExpressGST to verify the GST status of all companies associated with the selected PAN. Step 2: Select the ISD-Registered Company You may select the company using ...

    • ExpressGST || GSTR-6 Reconciliation & ITC Distribution

      An Input Service Distributor (ISD) is a registered taxpayer that receives invoices for services utilized by its branches. The ISD distributes the tax paid—referred to as Input Tax Credit (ITC)—to the respective branches proportionally by issuing ISD ...

    • ExpressITR || Excel Import and Export Functionality

      The Excel Import and Export functionality in Express ITR is introduced to streamline data entry and management for schedules and sections involving large or complex datasets. This feature allows users to download standardized Excel templates, perform ...