10 Apr How to Map GSTR 1 vs GSTR 3B

GSTR-1, filed by the supplier, contains invoice-wise and category-wise details of all outward supplies made in a year

GSTR-3B is the summary return based on which tax is deposited by the supplier. It contains the category-wise summary of both inward and outward supplies and tax payment details.

Now, the reconciliation of GSTR-3B and GSTR-1 is of utmost importance since GSTR-3B is a manual return, i.e. it is not auto-populated on the basis of GSTR-1 and GSTR-2A. There might be instances where the supplier has shown an invoice in GSTR-1 but has not paid tax on that invoice in GSTR-3B. GST department uses data analytics to reconcile GSTR-1 and GSTR-3B filed by a supplier. That means it automatically reconciles GSTR-1 with GSTR-3B and issues a GST Notice for Mismatches

One of the main reason of the difference is, wrong calculation of revenue & tax liability at the time of filling GSTR-3B For a large business organization, it is very common to have a difference in Actual Turnover & the Turnover Recorded in Books. This may result in GST Liability if turnover, as recorded in books of accounts, is less than the actual turnover. Again this may result in late payment of GST, which may lead to the applicability of interest. Nominal difference in is still accepted, but large data gaps are a matter of concern because this can result in heavy interest liability

Problems in mapping

1. Downloading All Files – All files for each branch and each month need to be downloaded from GST Portal.
2. Conversion to Excel – For starting any kind of mapping firstly all the files need to be converted into excel in a format that it can be manipulated.
3. Identifying Data Points to be Matched – There are multiple data points in the forms which can be mapped. As GSTR 1 is a detailed return and mapping it with 3B required submission of a number of columns in GSTR 1 for mapping with the column of 3B.
4. Huge Data and Complex Sheets – When preparing these sheet for multiple clients and years the data can become too large to handle. The formulas become complex and chances of manual errors cannot be ignored.
5. Data Visualization – Data Visualization can be tough as making sense of data in such huge sheets can be challenging.

We provide these reconciliations in understandable formats with zero errors. Reach us at care@gsthelpline.org.in for more details.