If at the time of generating GSTR1 in Excel B2B Total Bill Count Mismatch with the Software then it can be easily resolve in Marg Software.

Fig.1 View of GSTR1 (B2B) Bill Count in Software i.e '4'.

Fig.2 View of GSTR1 (B2B) Bill Count in 'Excel' i.e '3'.

1. Firstly Verify the Party GSTIN.

2. If Party GSTIN is Cancelled, the user needs to Cancel Party GSTIN and Resave Bills.

If still the issue is not resolved, the user needs to follow the below steps:

• Go to GST > GSTR1. 

• A 'Marg GST Summary' window will appear.

• Select the Period i.e. from which month till which month the user needs to view GSTR 1.

• Then click on ‘Show’.

• Click on 'GSTR1 Returns'.

• Now, Click on 'GSTN Excel Template'.

• The user will untick the 'B2B/B2C/CDN Nill entries in Exemp' option.

• The user will untick the 'B2C/CDN Nil entries in Exempt' option.

• Then click on 'Start' button.

• Thereafter, an 'Errors found in GST Returns' window will appear In this window if the user has found any errors in GSTR1 report then those errors will be shown here.

• Click on 'Close'.

• An alert window of 'Are you sure to prepare eReturn file ?' will appear.

• Click on 'Yes'.

• Now, the user can view that an excel sheet has been generated.

• Click on 'Ok'.

After following the above steps, the user can view that the Count of the B2B Excel will be match with Software.

Cause:

Gstr1 B2B invoice count show different in excel & software because user has created 2 bill with the same bill number because of which excel sheet bill number count show only one bill.

Solution:

The user have to find out the duplicate invoice number & change the bill number of duplicate bill.

For eg:- invoice number 1:- 000010

               Invoice number 2:-00010

Then in excel sheet invoice count show 1 not 2.