Back

Free Excel template

GSTR-2B reconciliation Excel template

Paste your purchase register and the GSTR-2B download into two sheets. Every invoice is marked Matched, Amount differs or Missing, and a summary shows the credit at risk.

Download the Excel file

.xlsx · 319 KB · Works in Excel, LibreOffice and Google Sheets · No sign-up

What is in it

  • A "Books" sheet and a "GSTR-2B" sheet with the same columns: GSTIN, invoice number, date, taxable value, IGST, CGST, SGST
  • Matching on supplier GSTIN and invoice number, with tax differences above ₹1 flagged
  • A summary: count and tax for each status, and the credit at risk
  • Room for 2,000 invoices on each side

How to use it

  1. Download GSTR-2B in Excel from the GST portal and copy the B2B rows into the "GSTR-2B" sheet.
  2. Export the month’s purchase register from your accounting software into the "Books" sheet.
  3. Make invoice numbers look the same on both sides (no spaces, same leading zeros) so they match.
  4. Follow up every "Not in GSTR-2B" invoice with the supplier before claiming the credit.

Blue cells are for your figures; everything else is a formula. The first rows hold an example: replace them with your own. This is a general format, not professional advice for your case.

Want us to do this for you every month? Talk to us.