hi
any simple method of reconciliation between books vs 2A .
how to track previous month not uploaded GST cr in current month etc ...
Menu
Reconciliation between books vs 2A
Replies (1)
You can easily reconcile by using Excel
download GSTR 2A of all the month in Excel format and consolidate all into one sheet.
make pivot table w.r.t. each GSTN then use vlookup to find out the total purchase in your books w.r.t. each GSTN for particular year
if total of particular GSTN matched - reconciliation
if not - then check invoice wise
for this you to use concatenate formula on GSTN column and Invoice column in both(GSTR2A & Books purchase ) excel file now use vlookup to find out invoice wise purchase in GSTR2A sheet.
if matched - reconcile
not - report
download GSTR 2A of all the month in Excel format and consolidate all into one sheet.
make pivot table w.r.t. each GSTN then use vlookup to find out the total purchase in your books w.r.t. each GSTN for particular year
if total of particular GSTN matched - reconciliation
if not - then check invoice wise
for this you to use concatenate formula on GSTN column and Invoice column in both(GSTR2A & Books purchase ) excel file now use vlookup to find out invoice wise purchase in GSTR2A sheet.
if matched - reconcile
not - report
Recent Topics :
- Taxation of Gift - Father to Daughter
- TDS on Property Purchased above 50lakh
- Accounting Treatment in Tally for Restaurant Sales
- Form 146 required
- Rule 86(B) Applicability
- ROC FILINGS FY2025-26
- Mismatch in 26AS
- How Can a Trader Utilise Approximately ₹1.20
- How Can Law Students Present Papers at Conferences
- On which amount 200% penalty under section 270A is
Related Topics :
CAclubindia
