From January 2021, (static, month-end statement) is more reliable for reconciliation. Follow the same Excel process using GSTR-2B instead of dynamic 2A.
| Return | Description | |--------|-------------| | | Purchase-related auto-populated statement based on supplier’s GSTR-1 and GSTR-5. Read-only. | | GSTR-3B | Monthly summary return filed by taxpayer declaring sales, purchases, ITC claimed, and tax payable. |
This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.
: A supplier files their GSTR-1 late, causing the invoice to appear in a later month's GSTR 2A than your internal purchase log. gstr 2a and 3b reconciliation in excel format download
: Auto-highlights unmatched items or value differences in red.
Reconciling GSTR 2A and 3B is vital for several reasons:
: Provides a structured layout for monthly inward supply reconciliation against the electronic credit ledger. ⚡ Key Features to Look For From January 2021, (static, month-end statement) is more
Spot vendors who collected GST from you but failed to file their returns or deposit the tax with the government.
For professionals managing data for multiple periods or GSTINs, this tool helps consolidate GSTR-2A Excel workbooks. It is designed to work with specific naming conventions ( GSTIN_MMYYYY_R2A.Xlsx ) and uses Microsoft Excel's Power Query to auto-compile data.
Reconciling GSTR 2A and 3B is a critical task for businesses to ensure accuracy, compliance, and correct ITC claims. By following the step-by-step guide and using the downloadable Excel template, businesses can simplify the reconciliation process. Regular reconciliation and verification of supplier invoices can help in identifying and rectifying errors, ensuring compliance with the GST law. Read-only
[Insert downloadable link]
: Paste the portal GSTR-2A data into the Portal Data tab.