Gstr 2a And 3b Reconciliation In Excel Format Download
Columns (one column per letter):
A. Supplier GSTIN
B. Invoice No.
C. Invoice Date
D. Taxable Value (GSTR-2A)
E. IGST (GSTR-2A)
F. CGST (GSTR-2A)
G. SGST/UTGST (GSTR-2A)
H. Total Tax (GSTR-2A) — formula: =E2+F2+G2
I. Taxable Value (GSTR-3B)
J. IGST (GSTR-3B)
K. CGST (GSTR-3B)
L. SGST/UTGST (GSTR-3B)
M. Total Tax (GSTR-3B) — formula: =J2+K2+L2
N. Match Status (Invoice-level) — formula examples below
O. Difference — Tax (GSTR-3B minus GSTR-2A) — =M2-H2
P. Reason / Notes (e.g., missing credit, timing, wrong invoice, blocked credit)
Q. Action Required (e.g., follow-up supplier, adjust next month, keep as exception)
R. Reconciliation Category (Auto/Partial/Not claimed/Excess claimed) gstr 2a and 3b reconciliation in excel format download
| Total ITC in GSTR-2A | 5% of that | ITC Claimed in GSTR-3B | Permissible Limit | Excess Claim (if any) | |----------------------|------------|------------------------|--------------------|------------------------| | 1,00,000 | 5,000 | 1,20,000 | 1,05,000 | 15,000 (Disallowed) | Columns (one column per letter): A
Ensure both sheets have consistent headers: | Total ITC in GSTR-2A | 5% of
As of now, the GST portal does not provide a direct Excel download of GSTR-3B. However, you can:
Alternatively, export your ERP or accounting software (Tally, Busy, Zoho, etc.) purchase register as Excel.
If you are looking to download a file, reliable sources typically include: