Gstr 2a And 3b Reconciliation In Excel Format Download Updated < ORIGINAL >

| 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 |

If you download a standard reconciliation utility, the workflow generally looks like this:

: You can download GSTR 2A data directly in Excel format by navigating to the Returns Dashboard , selecting the period, and clicking "Generate Excel File to Download" in the GSTR 2A tile.

=SUM(Sheet1!E2:G2) (CGST+SGST+IGST)

| 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 |

If you download a standard reconciliation utility, the workflow generally looks like this: gstr 2a and 3b reconciliation in excel format download

: You can download GSTR 2A data directly in Excel format by navigating to the Returns Dashboard , selecting the period, and clicking "Generate Excel File to Download" in the GSTR 2A tile. | Issue | Solution | |-------|----------| | Supplier

=SUM(Sheet1!E2:G2) (CGST+SGST+IGST)