How to Match Your Books ITC With GSTR 2B ITC



Quick Summary
Reconciling your business's Input Tax Credit (ITC) with GSTR 2B can be challenging, especially when suppliers file returns late. This article introduces a straightforward method to match your book ITC with GSTR 2B ITC. It involves an invoice-wise reconciliation process, which can be simplified using a dedicated Excel utility. The reconciliation helps identify matching and non-matching ITC, with unmatched amounts potentially carried forward to the next month.

It is getting difficult for GST taxpayers to match their Book's ITC with GSTR 2B ITC because GSTR-2B contains ITC which is not only related to the current month ITC. It may be related to earlier month's ITC due to the suppliers filing their GST Returns after the due date. 

Here is a Simple Equation for Matching your Book ITC with GSTR 2B ITC. First of all, we need to Reconcile our ITC Data (Invoice wise) with GSTR 2B Data (its mandatory). If you don’t have any Reconciliation utility means, please click the link below to download the GSTR 2B Matching Excel Utility. This Utility will help you to Match Your Book's ITC with GSTR 2B within minutes.

GSTR 2B Matching Excel Utility Download Link: Click Here

Match Book ITC with GSTR 2B ITC Easily

Please check the Illustrate image 0.1 for GSTR 2B Matching Concept how it will work. 

Illustrative Image 1

After the Reconciliation, we will get the Results of the following.,

1. Matching ITC (ITCis Available in GSTR 2B)
2. Not Matched ITC(ITC not Available in GSTR 2B) 

For Instance, we are going to Match ITC for the month of July 2021. Please check the Illustrate image 0.2.

Illustrative Image 2

As per Above Illustrate Image Total Matching ITC is Rs. 75,000/- only. So unmatched ITC Rs. 25000/- Will be carried forward to Next Month. 

Note: GSTR 2B There is Excess ITC Found Rs. 75000/-. This Excess ITC May be related to Earlier months (Those ITC may be utilized by you in earlier months). If you have not Utilized those ITC means We can take This ITC in Current Month.

 

Let's see we going to Match ITC for the month of Aug 2021. Please check the Illustrate image 0.3 

Illustrative Image 3

As per the above Illustrate image, ITC for the month of Aug 21 & LastMonth Not Matched ITC is Now Reconciled with GSTR 2B for the month of Aug 21. So, If your suppliers are filed their GST Returns for the month of July 21means, Your Not matched ITC Will be matched Here. If still your supplier is not Filed their GST Returns it will continue as ITC Not matched. 

 

Then Your ITC Reconciliation for the month of Sept 21 is like.,

ITC for the month of Sept 21           XXXX 
(+) ITC Not matched for July 21      XXXX  (If ITC is not Received) 
(+) ITC Not matched for Aug 21      XXXX (If ITC is Not Received) 
Total ITC is                                      XXXX 

Now the Total ITC Reconciled with GSTR 2B for the month of Sept 2021.


20384 Views Comment   Share GST   Report


About the Author

accountant

Comments :

Related Articles


Loading


Popular Articles





CCI Pro

CCI Articles

submit article


Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details
Company
19 November 2026
Accounts & Taxation Executive

MCSR and Associates LLP

Hyderabad

CA Inter

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
ARTICLESHIP 23 October 2026
Articled Trainee

J Y & CO

Hyderabad

CA Inter

View Details