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

Are you struggling more with or identifying the reasons for mismatches? I can help refine your reconciliation strategy.

: Log into the GST Portal. Go to the Returns Dashboard, select the financial year and month, and download the GSTR 2A Excel file.

Use the monthly – within the 30th of the next month – to stay compliant under Rule 36(4).

=VLOOKUP(A2, 'GSTR-2A'!A:H, 5, 0) – To pull taxable value from 2A.

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 gstr 2a and 3b reconciliation in excel format download

Go to the Official GST Portal and log in with your credentials. Navigate to > Returns > Returns Dashboard .

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

This is a ready-to-use spreadsheet that simplifies the process. It allows you to import GSTR-2A/2B JSON files directly, auto-matches them with your purchase register, and generates a mismatch report. It also provides a summarized view of eligible and ineligible ITC.

=IF(B2=C2, "Matched", "Difference") – To flag discrepancies. Are you struggling more with or identifying the

Suppliers often add prefixes (e.g., "INV/001" vs "001"). Use the RIGHT or MID function in Excel to extract numeric values for better matching.

Helps identify suppliers who haven't uploaded invoices or filed returns.

Beyond Excel formulas, a systematic approach to reconciliation will ensure completeness and accuracy.

— Maintain a separate Excel file for each financial year containing all monthly reconciliation sheets. This documentation is crucial during departmental audits and assessments. Go to the Returns Dashboard, select the financial

=SUMIFS(...) – To create a monthly summary of ITC available vs. claimed. Common Challenges and Solutions

Supplier reported the invoice with a wrong GSTIN.

: Send automated or manual reminders to defaulting vendors as soon as a mismatch appears.