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

A good Excel template automates the matching process to highlight:

=VLOOKUP(A2, 'GSTR-2A'!A:H, 5, 0) – To pull taxable value from 2A. gstr 2a and 3b reconciliation in excel format download

| Issue | Solution | |-------|----------| | Supplier hasn't filed GSTR-1 | Follow up with supplier | | Wrong invoice number/date in books | Correct purchase entry | | ITC claimed on ineligible supplies | Reverse in next month’s 3B | | Time lag in reporting | Adjust in subsequent month | A good Excel template automates the matching process

Prevents notices from the GST department regarding excess ITC. gstr 2a and 3b reconciliation in excel format download