| Supplier GSTIN | Invoice No. | Books Value | Portal Value | Value Difference | ITC Books | ITC Portal | ITC Difference | Status | Action Required | |---|---|---|---|---|---|---|---|---|---|
: A monthly self-declared summary return where you report your total output liability, claim your Input Tax Credit (ITC), and pay the net tax due.
When analyzing your reconciliation summary, variances typically fall into these buckets: Variance Category Action Required Supplier has not filed their GSTR-1 yet. Follow up with the supplier to file immediately. In 2A, Missing in Books gstr 2a and 3b reconciliation in excel format download
For a robust match, use a helper column that concatenates Supplier GSTIN and Invoice Number:
Filing GST returns accurately requires a systematic comparison of your data against government records. This process is called GSTR 2A and GSTR 3B reconciliation. It ensures you only claim the Input Tax Credit (ITC) you are legally entitled to. What is GSTR 2A and GSTR 3B Reconciliation? | Supplier GSTIN | Invoice No
🔗 (Note: This is a simulated link – create your own by saving the structure above as an Excel file)
If payment to the supplier is not made within 180 days of the invoice date, the input tax credit must be reversed with interest. It can be reclaimed after payment is made. Follow up with the supplier to file immediately
While many businesses use paid software, you can effectively perform this task using a well-structured . Why Reconcile GSTR-2A and 3B?
The core of the reconciliation is matching your books with the portal data. On a new sheet, use the VLOOKUP or XLOOKUP function to match invoices based on Supplier GSTIN + Invoice Number .
Contact the supplier to change the status from B2C to B2B in their next return filing. Free GSTR 2A and 3B Reconciliation Excel Template Structure
| Supplier GSTIN | Invoice No. | Books Value | Portal Value | Value Difference | ITC Books | ITC Portal | ITC Difference | Status | Action Required | |---|---|---|---|---|---|---|---|---|---|
: A monthly self-declared summary return where you report your total output liability, claim your Input Tax Credit (ITC), and pay the net tax due.
When analyzing your reconciliation summary, variances typically fall into these buckets: Variance Category Action Required Supplier has not filed their GSTR-1 yet. Follow up with the supplier to file immediately. In 2A, Missing in Books
For a robust match, use a helper column that concatenates Supplier GSTIN and Invoice Number:
Filing GST returns accurately requires a systematic comparison of your data against government records. This process is called GSTR 2A and GSTR 3B reconciliation. It ensures you only claim the Input Tax Credit (ITC) you are legally entitled to. What is GSTR 2A and GSTR 3B Reconciliation?
🔗 (Note: This is a simulated link – create your own by saving the structure above as an Excel file)
If payment to the supplier is not made within 180 days of the invoice date, the input tax credit must be reversed with interest. It can be reclaimed after payment is made.
While many businesses use paid software, you can effectively perform this task using a well-structured . Why Reconcile GSTR-2A and 3B?
The core of the reconciliation is matching your books with the portal data. On a new sheet, use the VLOOKUP or XLOOKUP function to match invoices based on Supplier GSTIN + Invoice Number .
Contact the supplier to change the status from B2C to B2B in their next return filing. Free GSTR 2A and 3B Reconciliation Excel Template Structure