Gstr 2a And 3b Reconciliation In Excel Format - Download ((free))

Based on this analysis, you can create a summary table to report your findings, which can be used to communicate with your team or clients.

| Issue | Description | How to Resolve in Excel | | :--- | :--- | :--- | | | An invoice in your purchase register is not found in GSTR-2A/2B. | This is a systemic issue. Follow up with your supplier to ensure they have filed their GSTR-1. Until then, you cannot claim ITC on that invoice. | | Value Mismatch | The tax or value of an invoice differs between your books and the portal. | Use the MATCH function to identify the exact invoice. Contact the supplier to correct their filing if they made an error, or correct your books if you have an error. | | GSTIN Errors | The supplier GSTIN in your books is incorrect or not matching the portal's records. | Use conditional formatting to highlight all entries for a specific GSTIN. Verify the correct GSTIN from the portal and correct your master data. | | Ineligible ITC | You have claimed credit for blocked items (e.g., motor vehicles, works contract services). | Section 17(5) of the CGST Act lists ineligible credits. You need to identify these invoices and reverse the credit claimed. | | Date Discrepancies | The invoice date in your books doesn't match the date on the portal. | Compare the records. The date on the portal should be correct as per the supplier's filing. Correct your books if needed. | | Duplicate Entries | The same invoice appears multiple times in your purchase register. | Use Excel's "Remove Duplicates" feature, based on the unique combination of Supplier GSTIN and Invoice Number. |

The invoice is in your books, but the supplier hasn't uploaded it. Action: Hold this ITC or follow up with the vendor immediately. gstr 2a and 3b reconciliation in excel format download

Do you prefer a or one with advanced macro/VBA automation ? Share public link

Doing this regularly ensures you do not lose out on tax credits or face severe penalties from the GST department due to mismatches. Why GSTR-2A and GSTR-3B Reconciliation Matters Based on this analysis, you can create a

Create a pivot table or use =SUMIF() formulas referencing Tab 1 and Tab 2 to populate this quick overview:

| Particulars | Excel Formula | |-------------|----------------| | Total ITC as per 2A (eligible) | =SUM(Reconciliation_Report!E:E) | | Total ITC claimed in 3B | =Sheet2!B5 (assuming cell B5 has total ITC) | | | =B1-B2 | | Action | =IF(B3>0,"You claimed more than 2A – risk","You can claim more ITC") | Follow up with your supplier to ensure they

If excess ITC has been claimed, it must be reversed with interest. If ITC is short‑claimed, it can be claimed in a subsequent valid month.

A good Excel template automates the matching process to highlight:

Note: The link above leads to the official GST portal, which provides tools, but the specific template described below is a structured approach to matching data. Structure of the Excel Template

Download your filed data or pull your internal Purchase Register (Books of Accounts) for that period. Step 2: Prepare the Excel Sheet