Country & TaxFree worksheetPDF, Excel, Word exportTally PrimeIndia

GST ITC Reconciliation Worksheet: Books vs GSTR-2B

Input tax credit can only be claimed on invoices that show up in the buyer's GSTR-2B. A monthly comparison of the purchase register with GSTR-2B protects you from notices and a surprise reversal. This worksheet gives you a clean format to do it and export the result.

Download:

Supplier	Supplier GSTIN	Invoice no.	Invoice date	ITC in books	ITC in GSTR-2B	Difference	Status
						Rs 0
						Rs 18,360
						Rs 2,700
						-Rs 5,400
						Rs 0

Total ITC in books

Rs 103,860

Total ITC in GSTR-2B

Rs 88,200

Net difference

Rs 15,660

Net books ITC not supported by 2B

15.1%

ITC safe to claim (lower of books and 2B in total)

Rs 88,200

The GSTINs shown are dummy samples. Section 16(2)(aa) allows ITC only when the invoice appears in GSTR-2B, so claim the lower figure invoice by invoice. Rows with a negative difference mean 2B is higher than books and may need booking.

Automated ITC reconciliation

Want this comparison produced automatically each month from your books? Ask for an optional expert review.

Optional. The tool and every export work without this. No spam.

How to use it

Download GSTR-2B from the portal and export the purchase register from Tally Prime, Busy, Marg or Zoho Books. Enter one line per invoice with the ITC amount from both sources. The difference column calculates itself. Choose a status for each line, then work through the open items by supplier. At the top of your totals you see the net share of ITC in your books that is not supported by 2B, which gives you a quick view of the risk for the month.

Method

ITC is available for a period only to the extent the invoice appears in the GSTR-2B for that period, and the tax must be paid by the supplier. A positive difference means you booked more credit than 2B supports, so hold it back or reverse it. A negative difference means 2B shows more than you booked, which may be a missing purchase entry. Cumulative totals can hide offsetting errors, so always review differences invoice by invoice.

Match on GSTIN, invoice number and date, not supplier name.
Watch for invoice number format differences such as leading zeros.
Blocked credits under section 17(5) need to be excluded from both sides.

Improving the process

Reconciliation takes less time when vendor master GSTINs are validated, purchase invoices are booked by invoice date and supplier follow-ups are logged with a date. Send suppliers a monthly request for missing invoices before the GSTR-1 deadline. Keep the worksheet export with the return working papers, because it is the evidence you give an auditor or the GST officer when a notice arrives.

Frequently Asked Questions

Do I need GSTR-2B or GSTR-2A?

GSTR-2B is the static statement used for ITC eligibility in a period, so it is the one to reconcile. GSTR-2A changes dynamically and is useful only as an additional check for later filings.

What do I do with a Not in 2B invoice?

Follow up with the supplier to file their GSTR-1 or IFF. Do not claim the credit until it appears in 2B. When it appears in a later month, you can claim it then, within the time limit under section 16(4).

Can I paste many rows?

You can add rows in the worksheet and edit values directly. For hundreds of invoices it is faster to keep your Excel master and use this layout as the column structure.

Why show percent at risk?

It is a quick indicator. A rising percentage over months usually means a process issue, such as late supplier filing or booking errors, not just a single invoice problem.

Netray can build a read-only reconciliation job that compares your purchase register with GSTR-2B data and outputs the same columns automatically.

Talk to an Expert Explore More Free Tools

Related Tools

Country & Tax

More Country & Tax tools

See all

Back to All Tools