How to Reconcile GSTR-2B with Purchase Register in Tally Prime

What Is GSTR-2B and Why Does It Matter?

GSTR-2B is a static, auto-drafted Input Tax Credit (ITC) statement generated by the GST portal every month. Unlike GSTR-2A, which updates in real time, GSTR-2B is locked for a specific return period and acts as the legal basis for ITC claims under Rule 36(4) of the CGST Rules.

Your Purchase Register in Tally Prime records every purchase invoice entered locally. The two rarely match on day one — suppliers file late, invoice values differ, or entries are missed. Reconciliation bridges that gap so you claim only what is legally permissible and avoid ITC reversals during audits.

Why Reconcile Every Month?

The GST department cross-verifies your ITC claims with GSTR-2B data. If you claim ITC that does not appear in GSTR-2B, it can be disallowed under Section 16(2)(aa) of the CGST Act. Regular reconciliation protects you from demand notices, interest, and penalties. It also helps you follow up with vendors who have not filed their returns, since their non-filing directly blocks your credit.

Step-by-Step Reconciliation in Tally Prime

Step 1 — Download GSTR-2B from the GST Portal

Log in to gstin.gov.in with your credentials. Go to Services → Returns → Return Dashboard. Select the financial year and return period. Download GSTR-2B in JSON format. This JSON file will be imported directly into Tally Prime.

Step 2 — Import GSTR-2B into Tally Prime

Open Tally Prime and go to Gateway of Tally → Display More Reports → GST Reports → GSTR-2. Select the relevant period and choose the option to Import GSTR-2B. Browse and load the JSON file downloaded from the portal. Tally Prime will parse and map the data automatically against your existing purchase ledgers.

Step 3 — Open the Reconciliation Report

Once imported, navigate to Gateway of Tally → Display More Reports → GST Reports → GSTR-2 → Reconcile with GSTR-2B. This report displays a side-by-side comparison of invoices in your Purchase Register against those appearing in GSTR-2B.

Step 4 — Understand the Reconciliation Statuses

Tally Prime classifies each invoice into one of the following reconciliation statuses so you can take the right action.

Status	What It Means	Action Required
Matched	Invoice exists in both Purchase Register and GSTR-2B with matching values	No action needed
Not in GSTR-2B	Invoice is in your register but supplier has not filed	Follow up with supplier
Not in Purchase Register	Invoice appears in GSTR-2B but not entered in Tally	Record the missing purchase invoice
Mismatch in Values	Invoice exists on both sides but GSTIN, taxable value, or tax amount differs	Verify with supplier and correct the entry
Pending for Reconciliation	Invoices yet to be matched or reviewed	Review manually

 

Step 5 — Resolve Mismatches

For invoices marked as “Not in Purchase Register,” enter the purchase voucher in Tally Prime against the correct supplier ledger. For “Mismatch in Values,” cross-check the physical invoice with what the supplier reported and raise a debit note or correction if required. For “Not in GSTR-2B,” communicate with the supplier and track the credit in subsequent months once they file.

Step 6 — Accept Matched Records

After reviewing each discrepancy, use the Accept Reconciliation option in Tally Prime to mark resolved invoices as reconciled. This locks the matched records so they do not reappear in future reconciliation cycles.

Step 7 — File GSTR-3B Based on Reconciled ITC

Once reconciliation is complete, your eligible ITC figure is confirmed. Navigate to GSTR-3B in Tally Prime, verify the auto-populated ITC amounts, and file accordingly. Never claim ITC on invoices that remain in “Not in GSTR-2B” status — wait until they appear in a future GSTR-2B.

Common Reconciliation Mistakes to Avoid

Booking purchase invoices with incorrect GSTINs is one of the most frequent errors. Tally Prime matches records using GSTIN and invoice number together — even a single digit wrong will result in a mismatch. Similarly, entering the invoice date in the wrong return period pushes the record out of the reconciliation window. Always ensure the supplier’s invoice date and your ledger entry date fall within the same return period unless you are dealing with an amendment.

Another common mistake is claiming ITC on the basis of GSTR-2A rather than GSTR-2B. The law is clear — only GSTR-2B is the valid document for ITC eligibility from FY 2022-23 onwards.

Quick Reconciliation Checklist

Before submitting GSTR-3B each month, run through the following checks inside Tally Prime.

Verify the GSTR-2B JSON is imported for the correct return period. Confirm all purchase invoices for the month are entered with the correct GSTIN, invoice number, date, and tax values. Review all “Mismatch” and “Not in Purchase Register” entries and resolve them. Identify vendors who have not filed and send them a reminder. Check that ITC on ineligible expenses such as personal or blocked credits under Section 17(5) is reversed. Accept all matched records before generating GSTR-3B.

FAQs

Q1. Can I reconcile GSTR-2B with my Purchase Register without the JSON file?

No. Tally Prime’s GSTR-2B reconciliation feature requires the JSON file downloaded from the GST portal. Without it, the system has no external data to match against. Always download the JSON from the Returns Dashboard on gstin.gov.in before starting reconciliation.

Q2. What if my supplier files GSTR-1 after I have already filed GSTR-3B?

If a supplier files after you have filed, the invoice will appear in the next month’s GSTR-2B. You can claim that ITC in the subsequent return period. There is no need to revise your already-filed GSTR-3B for this reason alone.

Q3. How does Tally Prime match invoices between GSTR-2B and the Purchase Register?

Tally Prime uses the supplier’s GSTIN, invoice number, and invoice date as the primary keys for matching. If any of these three fields differ between the portal data and your local entry, the invoice will show up as a mismatch or remain unreconciled.

Q4. Is it mandatory to reconcile GSTR-2B before filing GSTR-3B?

While the law does not prescribe a specific reconciliation tool, Section 16(2)(aa) makes it mandatory to claim ITC only on invoices reflected in GSTR-2B. Reconciling before filing is the safest way to ensure compliance and avoid notices.

Q5. What happens to ITC on invoices that never appear in GSTR-2B?

If an invoice does not appear in GSTR-2B even after following up with the supplier, you cannot legally claim ITC on it under current law. You may need to reverse the ITC in GSTR-3B for that period. Persistent non-filers should be flagged for future procurement decisions.

Q6. Can I reconcile multiple months at once in Tally Prime?

Tally Prime performs reconciliation on a period-by-period basis. However, you can import multiple months’ JSON files sequentially and reconcile each period separately within the same company data. This is useful for businesses catching up on delayed reconciliation.

Q7. Does Tally Prime handle GSTR-2B amendments automatically?

Yes. When a supplier files an amendment (GSTR-1A), the revised data flows into the next GSTR-2B. Tally Prime will reflect the updated values when you import the new JSON, and the reconciliation status will update accordingly.

Conclusion

Reconciling GSTR-2B with your Purchase Register in Tally Prime is not just a compliance task — it is a cash flow decision. Every unreconciled mismatch is potential ITC that either gets blocked or becomes a liability. With Tally Prime’s built-in reconciliation reports and a disciplined monthly workflow, you can keep your ITC claims clean, your vendors accountable, and your business audit-ready at all times.

For more GST walkthroughs and Tally Prime guides, stay connected with BizWithTech.