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