Summary: The GSTR-2A/2B vs Books Reconciliation Tool is designed for Excel 2019, Excel 2021, and Office 365, facilitating the reconciliation between GST data and book records. To use this tool, ensure that column and sheet names remain unchanged. Begin by updating the Books and GSTR-2B/2A data in their respective sheets, making sure client names match in both. Proceed to the “Reco sheet” for reconciliation: enter the round-off value in cell Ap3, refresh the Reco table for first-level reconciliation, and update the Final Remark column based on the Reco sheet’s remarks. Optionally, update GSTIN and Invoice No as per 2A. Refresh the Pivot table for second-level reconciliation, and update the Final Remark column based on the Pivot remarks. Move to the Difference sheet for third and fourth-level reconciliation, and refresh PQ1 and PQ2 tables. Finally, review the reconciliation data manually to ensure accuracy. This methodical approach helps in accurate alignment of GST and book records, ensuring compliance and error-free reporting.
Important note
1. This tool will work only in Excel 2019, Excel 2021 and Office 365 Versions
2. Kindly don’t change column names and sheet names
3. You can consider 2A or 2B as same for this Reconciliation tool
Instructions
1. Update Books data {Books} and GSTR-2B or 2A data {PORTAL} on respective column wise
2. make sure that client name should be the same in both sheets{ Books & Portal}
3. After updating respective data in both sheets Go to” Reco sheet” for reconciliation
4. Go to Reco sheet and update Round off value located in Ap3
5. Refresh the Reco table [First Level Reconciliation]
{Right click then click on Refresh} or {press Ctrl+Alt+F5}
5. Update Final Remark Column(Compulsory) Based on Remark column in Reco sheet
6. Update GSTIN as per 2A and Invoice No as per 2A Columns (optional) in Reco sheet
7. Go to Pivot sheet and refresh that table [Second Level Reconciliation]
{Right click then click on Refresh} or {press Ctrl+Alt+F5}
8. Update Final Remark Column(Compulsory) Based on Pivot Remark column in Reco sheet
9. Copy and paste the un updated columns date in Reco sheet in Difference sheet[Third& Fourth Level Reco]
10.Refresh PQ1 Reco table and Pq2 Reco table
{Right click then click on Refresh} or {press Ctrl+Alt+F5}
11. Update Final Remark Column(Compulsory) Based on PQ Remark column in Reco sheet
12. Update GSTIN as per 2A and Invoice No as per 2A Columns (optional) in Reco sheet
13. After Completion of Four Level Reconciliation review the reconciliation data manually once
Author Bio
26AS AS text to excel tool is excellent . it saves a lot of time to reconcile data . Thanks once again .