Table 8A vs PR Reconciliation Tool

Stop Wasting Days on Manual GSTR 9 ITC Reconciliation. Automate it in 19 Seconds!

Excel Utilities presents the ultimate solution: The Table 8A v/s Purchase Register Reconciliation Tool. This powerful, fully automated utility is meticulously engineered to guarantee 100% accuracy and deliver a reconciled report ready for your GSTR 9 filing.

The High Cost of Manual Compliance.

• Massive Time Commitment: Manually comparing thousands of invoices, checking for amendments, and segregating prior-year claims consumes days of valuable man-hours that could be spent on strategic client advisory or business growth.
• 
  
• ITC Loss & Audit Risk: Missing a valid ITC entry due to a nominal difference, or failing to correctly classify amended transactions, directly leads to financial loss and invites scrutiny from tax authorities.
• 
  
• High Risk of Costly Human Error: A single typo, a missed credit note, or an incorrect manual classification of a transaction as "Ineligible" can lead to inaccurate ITC claims. These small mistakes cascade into serious compliance issues, resulting in incorrect GSTR 9 filings and potential notices.
• 
  
• GSTR 9 Inaccuracy: Without precise matching and proper segregation of ITC into its respective financial years, filing GSTR 9 becomes a major liability. 
• 
  
• Significant Compliance Risk: Accurate reconciliation is the direct path to a flawless GSTR 9. An unreconciled difference between your books and Table 8A leaves your business vulnerable to audits, interest charges, and penalties.

• 
  

Transform Your Workflow to Automation & Mitigate the Risk.

Our tool is designed to systematically eliminate the biggest challenges you face, transforming your Table 8A reconciliation workflow from a liability into an asset.

• Reclaim Your Time: Slash your reconciliation time from days to under 19 seconds. Our intelligent engine runs through all eight matching levels instantly, freeing up your team for strategic analysis.

• 
  

• Automated Government Data Import: The tool seamlessly import, extract, and map all tabs (B2B, CDNR, ECO, amendments) from the downloaded Table 8A file into a single, clean sheet and automatically calculate and map which transactions are Part of 8A and not part of 8A with reasons.

• 
  

• GSTR 9 Ready to use Report : The Tool generates a report structured for direct use in your GSTR 9 filing. The tool correctly segregates ITC data for FY 23-24 availed in 24-25 and FY 24-25 availed in 24-25 and compares it with Table 8A data to align with the latest GSTR 9 reporting requirements for FY 24-25.
• 
  
• Eliminate Costly Manual Errors: Our 8-Level Reconciliation Engine automates the comparison, removing the risk of human error and guaranteeing your claim is 100% accurate, down to the last rupee.
• 
  
• Interactive Dashboard: The user can view results across three toggles: Table 8A Reconciliation, Month- wise ITC Comparison, and Reconciliation Summary, giving a holistic view of the reconciliation.
• 
  
• Detailed Tracking & Manual Adjustments: Review line-by-line reconciliation remarks with row number reference with which it is matched and if the user has make any manual match / adjustments, the same are then automatically updated via the refresh function.
• 
  
• Upgraded Features: The Tool also has the upgraded version which Includes a Multi-Month GSTR-3B Report Generator and a PR vs. 3B ITC Comparison Report to streamline your annual filing.
• 
  

How It Works: A Deep Dive into 4 Simple Steps

• 
  
• Click 'Import Table 8A' and select the file downloaded from the GST portal.
• 
  
• Bulk Consolidation: The tool automatically opens and processes downloaded report, consolidating data from all sections B2B, CDNR, ECO, and all amendments (B2BA, CDNA, ECOA) into a single, clean 'Table 8A' sheet.
• 
  
• Amendment Pre-Matching: It automatically links amended transactions (e.g., B2BA) back to their original counterparts (e.g., B2B) to correctly classify them and retrieve the Original ITC Availability Amounts.
• 
  
• Automatic Classification: The tool applies initial compliance logic, marking transactions that are "Not Part of 8A" due to being amended, having an Ineligible POS (Place of Supply), or being a Reverse Charge Document. All remaining records are provisionally marked "Part of 8A".

• Current Year Claims (PR sheet): Paste your core FY 2024–25 purchase data. This data must match the "All Other ITC" as per your GSTR-3B filings for the financial year.
• Subsequent Period Claims (PR 25-26 sheet): Paste transactions related to FY 2024–25 that were claimed in the subsequent period (April to October 2025).

Once your data is loaded across all sheets, simply press the main 'Reconcile' button on the dashboard. The entire 8-level matching process runs in approximately 19 seconds.

Our highly optimized, in-memory engine runs the following sequence to maximize your match rate:

• Table 8A Reconciliation (GSTR 9 Ready): This gives you a report structured to be used directly in your GSTR 9. It intelligently segregates your PR data into:
• - ITC of 23-24 availed in 24-25
• - ITC of 24-25 availed in 24-25
• It then compares your Table 8A with only the second part to align with the latest compliance updates. It maps transactions that were claimed, not claimed, or are ineligible, aiming for a final unreconciled difference of zero. 
• Please Note : This reconciliation is based on the provided data, so kindly verify before using the reconciliation in GSTR 9.
• 
  
• Month-Wise ITC Comparison: Provides a quarterly view of reconciled and mapped transactions between PR ( ITC of 24-25 availed in 24-25) with Table 8A, making it easy to identify differences per period.
• 
  
• Reconciliation Summary: This gives a clear financial breakdown of your matched, mismatched, and missing amounts.

• Drill-Down Verification: The ‘Reconciliation Remarks’ column explains the exact match type or mismatch reason, along with a row reference to the linked transaction in the corresponding sheet for easy cross-verification.
• Manual Adjustments: For complex, case-specific adjustments, you can update the remarks to “Manual Matched”, include your row reference, and hit 'Refresh' on the dashboard. The tool instantly updates the final totals based on your manual inputs.
• Final Export: Click 'Export Report’ to extract all 3 types of summary reports along with the reconciled raw data sheets (PR, Table 8A, PR 25-26) into a single, comprehensive workbook.

The Upgraded Compliance Version

For end-to-end annual filing preparation, the Upgraded Version includes two powerful modules:

1) Multi-Month GSTR-3B Report Generator: 

• Instantly generates a holistic summary from all 12 GSTR-3B JSON files (FY 24-25).

• Provides a detailed, month-wise view of your entire year's summary data, which is essential for accurate GSTR 9 preparation.

2) PR vs. 3B Comparison Report:

• Compares the monthly PR totals directly against the figures reported in your GSTR 3B (ITC OTH).

• Instantly highlights monthly differences that are less than ₹5 but not zero, catching nominal discrepancies before final filing of GSTR 9.

Features That Empower Your Business

This isn't just a spreadsheet; it's a complete GSTR 9 compliance powerhouse packed with features designed for tax professionals and finance teams.

• 19-Second, 8-Level Reconciliation Engine: Our highly optimised VBA engine executes a full, multi-stage reconciliation with a single click, completing eight distinct checks (including Perfect, Strict, Loose, and Monthly GSTIN matching) in just 19 seconds.

• 
  

• Bulk & Intelligent Data Import: Save immense time by importing and consolidating data from downloaded Table 8A file. The tool automatically extracts data from B2B, CDNR, ECO, and all amendment tabs into a single, structured sheet.

• 
  

• GSTR 9 Ready Reporting Logic: The tool's calculation module intelligently segregates your Purchase Register data into claims for 'ITC of 23-24 availed in 24-25' and 'ITC of 24-25 availed in 24-25' to align perfectly with the complex GSTR 9 reporting requirements.

• 
  

• Interactive Compliance Dashboard: The clean, visual dashboard offers three essential views - Table 8A Reconciliation, Month-wise ITC Comparison, and Reconciliation Summary, allowing for clear, instant oversight of your ITC status.

• 
  

• Granular Mismatch & Tracking: The tool doesn't just show missing entries; the Remarks column provides line-by-line remarks and a Row Reference to the corresponding matched/mismatched row in the other sheet, saving hours of manual investigation.

• 
  

• Manual Override & Refresh: Allows users to manually mark complex entries as “Manual Matched” and then instantly update all dashboard totals and reports with a single click, accommodating necessary adjustments.

• 
  

• Professional Report Export: Generate a clean, ready-to-share Excel report that includes all summary views and the reconciled raw data sheets (PR, T8A, PR 25-26) for clients, management, or audit records with a single click.

Who is This Tool For?

This tool is a must-have for anyone dealing with the complexities of GST compliance in India:

• Chartered Accountants (CAs) and CA Firms looking to increase efficiency and accuracy while managing multiple clients.

• Tax Consultants and Practitioners who need a reliable tool to deliver fast and accurate reconciliation reports.

• Corporate Accounts Managers and Finance Teams responsible for internal GST compliance and reporting.

• Small and Medium Business Owners who handle their own accounting and need a simple yet powerful solution to stay compliant.

• GST and Indirect Tax Professionals.

Download Your Free Demo Today!

Still not convinced? See the power of automation for yourself. Download a free, feature-limited demo version to experience just how easy GST reconciliation can be.

Click Here to download a Free Demo

Exclusive Launch Offer Pricing

Take advantage of our limited-time launch discount, valid until November 15, 2025. This offer is perfectly timed to provide maximum support ahead of the GSTR 9 filing deadline of December 31, 2025.

Please Note - The purchase of the Table 8A v/s PR Reconciliation Tool is a one-time purchase with validity till January 30, 2026, granting you full access to the licensed version.