Sales Register VS Eway bill Reconcilation with GSTZen

Managing GST compliance becomes easier when your sales data matches the e-Way Bills generated for the movement of goods. The Sales Register vs E-Way Bill Reconciliation feature helps businesses compare their sales register with e-Way Bill data to identify missing, mismatched, duplicate, or unreported transactions.

Through GSTZen, you can reconcile Sales Register with Eway bill in 4 simple steps:

1. Download GSTR-1 Einvoice data from the government portal
2. Upload Sales Invoice through Excel
3. Run GSTZen Intelligent matcher
4. Download the report
   

Login to GSTZen account and select the GSTIN in the Dashboard for which you want to perform the reconciliation.

•  Click on Reconcile Books vs Govt. Portal Data, then select “Sales register VS Eway bill” and the relevant period.
  

Login to the E-Way Bill Portal Using API Credentials

If you have not yet created your E-Way Bill API credentials, follow the step-by-step guide below:
Create E-Way Bill API Credentials:– https://www.gstzen.in/a/gstzen-enable-api-access-in-e-way-bill-portal.html

After successfully logging in, click Request to initiate the data download from the E-Way Bill Portal.

Here is how you may determine the download status. Once you see that all data points have a Green Tick mark, you may proceed to the next step.

Step 2: Upload your Sales Invoices.

Note:

1. You may either choose GSTZen’s Excel sample to upload the invoices or use your Excel file with invoice.
2. Once you upload the Excel file, choose the appropriate XLS data format and click on Upload sales Invoice XLS File.
3. If the Excel file has multiple sheets, you will be prompted to choose the sheet with the data. Click on Use this Sheet against the sheet with invoice data.
4. You will now be required to map columns in your Excel sheet into GSTZen. All mandatory fields are marked with a red asterisk. Click on Process file upload once the column mapping is complete.
5. GSTZen will process the invoices and provide a summary. Click on Confirm and Save entries once you verify the summary. Once the invoices are uploaded, you will be able to view them in your GSTZen sales Register.

Step 3: Run GSTZen Reconciliation Matcher

GSTZen Reconciliation Matcher will match fields such as Invoice Number, Invoice Date, GST Number, Invoice Amount, etc, to make the best possible match. GSTZen gives you results relevant to each field or basis of matching.

Click on Run Purchase Details Matcher and choose the Maximum Days Difference and Maximum Tax Amount Difference according to your Working. Click on Run Intelligent Matcher.

Once the software gives you a notification that the matcher has run, you will see an option to download the reports. Click on Download Reports.

Step 4: Download the Reconciliation report and review the reconcilation status