Below is the explanation of how GSTR1 Reports in accu360 is use to validate data.
Let us assume for Company A , the sales transactions data has been entered in accu360 for the period 01-01-2023 till 11-01-2023 .
According to the GST Rules set in India, the formula to validate the GSTR1 reports is as :
HSN Summary = B2B + B2C - CDNR
Now let us first look into the B2B Report that falls under GSTR1.
The B2B Report includes all GST registered sales transactions. In the above image you can see the Taxable Value equals to Rs 1921507.50.
Next we look into the B2C Report.
The B2C Report includes all GST non-registered sales transactions. In the above image the Taxable Value equals to Rs 2725052.86.
Now let us check the CDNR Report.
The CDNR Report includes all the credit and debit notes for gst registered as well as gst non-registered transactions. In the above image the Taxable Value equals to Rs 105696.66.
The HSN Summary Report list all the items included in sales transactions for registered as well as non-registered customers.
The Taxable Value equals to Rs 4540863.70.
As stated above, HSN Summary = B2B + B2C - CDNR
4540863.70 = 1921507.50 + 2725052.86 - 105696.66