How to enter different tax rate in single invoice (GSTR-1 > B2B Invoice) through excel sheet?

How to enter different tax rate in single invoice (GSTR-1 > B2B Invoice) through excel sheet?

Solution:

Step 1:
Login on GST Software Application.

Step 2:
Select Company, Financial Year, Filing Type as GSTR-1 and Tax Period and then Go to Proceed.

            

Step 3:
Here Click on - Download Sample Template.

            

Step 4:
Once the excel template is downloaded fill proper data in this excel sheet.
  1. Invoice Value should be same on Particular Invoice number
            

Step 5:
Import the excel sheet through -Upload Button.

            

Step 6:
Browse excel sheet and then Upload the excel sheet.

            

Step 7:
If some issue occur it is shown as Warning message as shown below.

            

Click on the Warning button and correct the data.

Step 8:
Once you have corrected the data, Status is showing as Ready for Upload

            


Hope this helps.





    • Related Articles

    • Invoice & other data upload for creation of GSTR 2 in Express GST | GST Filing

      The table below provides the name, full form and detailed description for each field of the worksheets followed by a detailed instruction for filling the applicable worksheets. The fields marked with asterisk or star are mandatory. b2b B2B Supplies - ...
    • Excel import - Tax Rate should be numeric

      Excel import  - Tax Rate should be numeric Solution  This error comes when TDS details (24q,26q,27q,27eq) are imported from Excel Template and the tax rate is not entered in the numeric format Open excel template > "deductee detail" sheet Select a ...
    • GSTR-2A Reconciliation

      GST reconciliation primarily involves matching the data uploaded by the suppliers with those of the recipient's purchase data. This basically includes comparing the GSTR-2A auto-populated from suppliers data and the purchase data recorded by the ...
    • Invoice & other data upload for creation of GSTR 1

      The table below provides the name, full form and detailed description for each field of the worksheets followed by a detailed instruction for filling the applicable worksheets. The fields marked with asterisk or star are mandatory. B2B B2B Supplies ...
    • In Income Tax Software how to Import Trial Balance from BUSY Software?

      Solution: Regarding this please export the excel sheet through BUSY Software. For Export Busy Excel file please follow the steps below:               Once all the data is exported successfully, Import the same in Trial Balance. For this Go to ...