: While 2A is dynamic, GSTR 2B is static and dictates your actual legal eligibility for a specific filing month. Use both for absolute compliance.
Manually amend your internal books to reflect the portal invoice. Rounding errors or incorrect GST rate application.
| 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") | gstr 2a and 3b reconciliation in excel format download
“Input tax credit to be availed by a registered person in respect of invoices or debit notes, the details of which have not been furnished by the supplier under section 37(1), shall not exceed 5% of the eligible credit available in GSTR-2A/2B.”
If you are looking for a , you can build a robust template using these columns: Sheet 1: Data from Books Vendor Name Invoice No Taxable Value Sheet 2: Data from GSTR-2A Supplier Name Invoice No Taxable Value Sheet 3: Reconciliation Summary : While 2A is dynamic, GSTR 2B is
I can tailor the exact formulas or macros to fit your daily accounting workflow perfectly. AI responses may include mistakes. Learn more Share public link
While building custom spreadsheets gives you deep visibility into tax records, manual reconciliation can become overwhelming if your business processes hundreds of B2B invoices monthly. Rounding errors or incorrect GST rate application
You missed recording the invoice in your accounting system, or the supplier entered your GSTIN by mistake.