Accurate GST compliance is essential for every business, accountant, and GST practitioner in India. If you want to claim the maximum eligible Input Tax Credit (ITC) without facing tax notices from the GST department, learning how to reconcile GSTR 2B with Purchase Register in Tally Prime is a critical skill. At Accounting Sikho, we empower accountants, business owners, and finance professionals with practical, step-by-step training to master GST workflows effortlessly.
In this comprehensive guide, we will walk you through the entire process of matching your purchase books with the auto-drafted GSTR-2B statement generated on the GST portal using Tally Prime.
What is GSTR-2B and Why is Reconciliation Essential?
GSTR-2B is an auto-drafted, static Input Tax Credit (ITC) statement generated for every registered taxpayer on the 14th of every month. It reflects the tax credits available based on the sales returns (GSTR-1, IFF, GSTR-5, GSTR-6) filed by your suppliers.
Under the current GST rules (specifically Rule 36(4) of the CGST Rules), a taxpayer can only claim ITC that appears in their GSTR-2B statement. This makes it mandatory to reconcile GSTR 2B with Purchase Register in Tally Prime before filing monthly GSTR-3B returns.
Benefits of Regular Reconciliation with AccountingSikho:
Prevent Tax Credit Losses: Identify missing supplier invoices so you can prompt suppliers to upload them before tax deadlines.
Avoid Penalties & GST Notices: Prevent excess ITC claims that lead to interest payments and legal notices under Section 73/74.
Cash Flow Optimization: Ensure your business pays only the necessary net cash liability after claiming legitimate tax credits.
Eliminate Duplicate Entries: Spot duplicate purchase entries entered incorrectly into your accounting books.
Prerequisites Before Starting GSTR-2B Reconciliation in Tally Prime
Before initiating the reconciliation process, ensure you have the following ready:
Tally Prime Update: Ensure you are using Tally Prime 3.0 or later (Tally Prime 4.0 or 5.0 recommended), as automated GST reconciliation features are natively available in these versions.
Updated Purchase Vouchers: Ensure all purchase invoices, debit notes, and credit notes for the tax period are accurately entered in Tally Prime.
GSTIN Details: Ensure correct GSTIN numbers and tax ledgers (CGST, SGST, IGST) are assigned to suppliers.
Downloaded GSTR-2B File: Download the JSON or Excel file of GSTR-2B from the official GST Portal (
www.gst.gov.in) for the relevant month.
Step-by-Step Guide: Reconcile GSTR 2B with Purchase Register in Tally Prime
Following this step-by-step process taught by Accounting Sikho will allow you to complete your monthly GST reconciliation in just a few minutes.
Step 1: Download GSTR-2B from GST Portal
Log in to the GST Portal using your credentials.
Go to Services > Returns > Returns Dashboard.
Select the Financial Year and Month (e.g., April 2026).
Under GSTR-2B (Auto-drafted ITC Statement), click on Download.
Download the JSON file (recommended for direct import into Tally Prime) or the Excel file.
Step 2: Open GST Reports in Tally Prime
Launch Tally Prime and select your company data.
Go to Gateway of Tally > Display More Reports > GST Reports.
Select GSTR-2B (or GSTR-2A/2B Reconciliation depending on your Tally Prime version).
Change the report period by pressing F2 to match the tax period of the downloaded file.
Step 3: Import GSTR-2B Data into Tally Prime
Inside the GSTR-2B report screen, press Alt + O (Import) or click on Import > GST Data.
Select the file path where your downloaded JSON or Excel file is saved.
Choose GSTR-2B as the Return Type.
Press Enter to import the data into Tally Prime.
Step 4: Analyze Reconciled and Unreconciled Statuses
Once imported, Tally Prime automatically compares your purchase vouchers against the portal data and categorizes entries under distinct reconciliation statuses:
| Status Category | Meaning / Action Required |
| Reconciled | Invoice values, tax amounts, and invoice numbers match perfectly. No action needed. |
| Unreconciled | Discrepancies exist in invoice date, taxable value, or tax amounts. Manual correction required. |
| Available Only in Books | Invoice exists in Tally Prime but supplier has not filed GSTR-1. Contact supplier. |
| Available Only in Portal | Invoice filed by supplier but missing in your accounting records. Enter missing purchase voucher. |
| Mismatch in Tax/Value | Taxable value or tax rates entered incorrectly in Tally Prime. Amend voucher details. |
Managing Common Discrepancies During Reconciliation
At AccountingSikho, we train professionals to handle real-world GST reconciliation challenges efficiently:
1. Invoices Missing on GST Portal (Available Only in Books)
If an invoice is recorded in Tally Prime but absent from GSTR-2B, your supplier hasn’t filed their GSTR-1 return or supplied an incorrect GSTIN. Filter these entries in Tally Prime, export the supplier list, and notify them to update their filings. Do not claim ITC on these items until they reflect in GSTR-2B.
2. Invoices Missing in Purchase Register (Available Only in Portal)
If an invoice appears in GSTR-2B but isn’t present in Tally Prime, check if physical goods/services were received. If valid, record the purchase voucher in Tally Prime immediately to claim eligible ITC.
3. Invoice Number Formatting Mismatches
Often, suppliers write invoice numbers with special characters (e.g., INV/2026/001 vs INV-001). Tally Prime’s flexible matching rules allow you to manually map or adjust tolerances to clear minor typographical differences without changing legal invoice numbers.
Best Practices for Seamless GST Reconciliation
To maintain smooth business operations and 100% tax compliance, AccountingSikho recommends implementing these standard accounting procedures:
Monthly Routine: Perform GSTR-2B reconciliation every month between the 14th and 20th, right before filing GSTR-3B.
Set Up a Vendor Communication Channel: Maintain a systematic track of non-compliant vendors who consistently delay GSTR-1 filings.
Maintain ITC Pending Ledgers: Track blocked or delayed ITC under separate ledgers in Tally Prime so that your books reflect clear balance sheet positions.
Keep Data Backups: Always take a data backup in Tally Prime before bulk importing or modifying GST reconciliation statuses.
Frequently Asked Questions (FAQs)
Q1. What is the difference between GSTR-2A and GSTR-2B reconciliation in Tally Prime?
GSTR-2A is a dynamic statement updated continuously as suppliers file returns. GSTR-2B is a static statement generated once a month (on the 14th). For legal ITC claims under current GST laws, you must reconcile GSTR 2B with Purchase Register in Tally Prime.
Q2. Can I claim ITC if an invoice appears in my Purchase Register but not in GSTR-2B?
No. Under Rule 36(4) of CGST Rules, you can only claim ITC for invoices that are reflected in GSTR-2B. Unmatched invoices must be deferred until the supplier files their GSTR-1 return.
Q3. How does AccountingSikho help in learning Tally Prime and GST filing?
AccountingSikho provides hands-on practical courses on Tally Prime, GST filing, TDS compliance, and advanced bookkeeping designed for beginners and experienced accounting professionals across India.
Q4. What file formats can be imported into Tally Prime for GSTR-2B matching?
Tally Prime supports both JSON and Excel formats directly downloaded from the GST Portal for automatic reconciliation.
Master Advanced GST Accounting with AccountingSikho
Reconciling purchase registers with tax portal statements is a core compliance requirement for businesses across major industrial hubs like Mumbai, Delhi NCR, Bengaluru, Ahmedabad, and Kolkata. By taking full advantage of automated features to reconcile GSTR 2B with Purchase Register in Tally Prime, you maintain error-free books and safeguard your organization against audits.
Want to upgrade your accounting career and learn step-by-step practical GST, Income Tax, and Tally Prime workflows? Visit Accounting Sikho today to access expert tutorials, courses, and resources designed to turn you into a certified accounting expert!