Reconciliation of the Sales Register with GSTR-1 and e-Invoice data ensures accuracy in GST reporting and prevents mismatches or filing errors. Using GSTZen, businesses can easily compare sales data from their books with data reported on the GST portal, identify discrepancies, and make corrections before filing.
Through GSTZen, you can reconcile GSTR-1 in 4 simple steps:
- Download GSTR-1 Einvoice data from the government portal
- Upload Sales Invoice through Excel (OR) Tally
- Run GSTZen Intelligent matcher
- Download the report
Step 1: Download GSTR-1 Einvoice data from the government portal into GSTZen
1.1 Log in to your GSTZen account.
1.2 Choose the GST number in the dashboard for which you want to perform the reconciliation.
1.3 Click on Reconcile Books vs Govt. Portal Data, then select “Sales Register vs GSTR-1 Einvoice” and the relevant period.
1.4 Log in to the GST Portal through OTP.
1.5 Click on the check boxes for the data you want to download, and click on “Download data from the Government 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 and Credit/Debit Notes
2.1 To upload your Sales data into GSTZen, please click on Upload Sales Invoices XLS
- You may either choose GSTZen’s Excel sample to upload the invoices or use your Excel file with invoice and credit/debit note data.
2.2 Once you upload the Excel file, choose the appropriate XLS data format and click on Upload Sales Invoice XLS File.
- 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.
2.3 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.
2.4 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.
3.1 Click on Run Sales Details Matcher and choose the Maximum Days Difference and Maximum Tax Amount Difference according to your business. Click on Run Intelligent Matcher.
3.2 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
4.1 You may now scroll down to the Step 4 section and download the Excel report. You get to choose the reconciliation report based on the Invoice Date, Record Date, and Filing Period.
Review the Excel Report (Sheet Available)
The Excel file contains single sheet:
- GSTR-1 EInvoice Reconciliation: Transaction-level reconciliation report of all the parameters of an Invoice.