Reconcile GSTR-1 Data | GSTR-1 Reconciliation Report
Reconciling your GSTR-1 ensures that the data on the GST portal matches your company books, helping you identify differences early and maintain accurate returns.
In TallyPrime, you can get GSTR-1 data into the reconciliation report in two ways – by downloading the data directly from the GST portal or by manually importing the GSTR-1 data. Once the data is available in the GSTR-1 Reconciliation report, you can compare it with your books and reconcile the transactions as needed.
The report highlights mismatches, missing transactions, and other exceptions, enabling you to take corrective action quickly. You can also track the download progress when data is being fetched from the GST portal.
If you are on a previous release of TallyPrime, click here to know more about GSTR-1 Reconciliation.
- Gateway of Tally > Display More Reports > Statutory Reports > GST Reports> GSTR-1.
Alternatively, press Alt+G (Go To) > type or select GSTR-1 > and press Enter. - Press Ctrl+H (Change View) > Status Reconciliation. The Status Reconciliation screen appears as shown below:
Voucher Count: Displays the total count of vouchers under the particular table for the reporting period.
Activity Status
- To Be Uploaded: Displays the number of vouchers yet to be exported. The count vouchers that are not yet exported to GSTR-1 return file are displayed in this column.
- Uploaded: Displays the number of vouchers exported. This column is automatically updated when a voucher is exported to GSTR-1 return file.
- Rejected by GST: Displays the count of vouchers marked as Rejected by GST. You can mark the voucher status as rejected when GST rejects the voucher for reasons such as, duplicate invoice, reference of original transaction is not found in case of debit/credit note, GSTIN of any user being suspended, and so on.
- Accepted: Displays the count of vouchers marked as Accepted. You can mark the status as accepted when input tax claim made by the buyer in the GSTR-1A.
- Rejected: Displays the count of vouchers marked as Rejected. You can mark the status as rejected when the buyer rejects the voucher details as displayed in the GSTR-1A.
Reconciliation Status
Not Reconciled: Displays the count of vouchers marked as Not Reconciled. You can mark the status as Not Reconciled when the details in the online portal do not match with your books.
Reconciled: Displays the count of vouchers marked as Reconciled. You can mark the status as Reconciled when the details in the online portal match with your books
Set Status
- Drill down from any table to view the voucher register with list of vouchers and change the status of the voucher.
- The voucher register displayed on drill down from a table in Status Reconciliation screen appears as shown below:
- Select a voucher or multiple vouchers using Spacebar.
- Press Alt+S (Set Status).
- Select the Activity status and Reconciliation status of the voucher based on the details in the GST portal and press Enter.
The status change based on the status set for each transaction, is displayed in the Voucher Register. Press Alt+F5 (Detailed) to view the reason provided for the status Rejected by GST.
- Press Esc to return to the Status Reconciliation screen. The voucher count in columns is changed based on the status updates.
Status-wise View
You can view the status reconciliation in the status-wise view.
- Press F8 (Status-wise View) in the Status Reconciliation screen.
F12 (Configure)
Show uncertain transactions: Enable this option to view the number vouchers that are not included in the returns due to incomplete information or mismatch. This voucher count is displayed at the bottom of the Status Reconciliation screen.
Directly Download GSTR-1 from TallyPrime
- Press Alt+Z (Exchange) > All GST Options > Download GST Returns.
If you are using TallyPrime 5.0 & lower versions,
Press Alt+Z (Exchange) > Download GST Returns.
The Download GST Returns screen appears, in which you can see that all the Return Types are selected, by default.
- Press C (Configure) to set the required Return Type, that is GSTR-1, and the Return Period.
You also have the option to set the default return types for download. - In the Download GST Returns screen, press D (Download).
- Log in to your GST profile, if you have not already done so.
- Enter your GST Username.
- Enter the OTP received on your registered mobile number, after which your summaries will be exported to the GST portal.
Once you have logged in, the session will be valid for six hours, which will ensure the safety and security of your activities.
- Enter your GST Username.
Once GSTR-1 download is initiated, you can easily track the progress.
Once the GSTR-1 data is downloaded from the GST portal, you will receive a confirmation.
Now you can view the downloaded details in the GSTR-1 Reconciliation report.
Manually Import GSTR-1 Data
Import the GSTR-1 file into the GSTR-1 Reconciliation report, after which all the relevant values from the portal will be captured in extensive detail and unparalleled flexibility.
- In the GSTR-1 Reconciliation report, press Alt+O (Import) > GST Returns.
The Import GST Returns screen appears. Provide the required details to import the GST details.- GST Registration: The GST Registration for the company is selected by default. If you have created multiple GST registration for the company, you can select the GST Registration, as needed.
- Type of Return: Select the return for which you need the GST details from the portal.
- File Path: Location of the return file.
- File to import: Select the JSON file that you will import into TallyPrime.
- Press Ctrl+A to accept.
You can see the Import Summary, which will provide you a clear picture of the number of transactions processed, imported, or failed to import.
- Press any key to continue.
You can see that the imported details will be captured seamlessly in the Total Vouchers section (under Unreconciled) as well as in the Return View section, where the respective values from the portal will be highlighted in blue.
Once you have imported the file, your returns will display a comparative view of the values.
Importing GST Returns helps you compare the same with the data in your returns and reconcile as needed to keep your data up-to-date and accurate.
For more information, refer to the GSTR-1 topic.
View GSTR-1 Reconciliation
The GSTR-1 Reconciliation report provides a comparison between the data in your Books and the data from the GST portal. Portal values are highlighted for easy identification, and you can drill down to view transaction-level details.
- Press Alt+G (Go To) > GSTR-1 Reconciliation.
By default, the report opens in the Return View. - Press Alt+F5 (Nature View) for a portal-like view of your GSTR-1 data.
It displays values from your books alongside the values downloaded from the GST portal, making comparison easy.- Portal values are highlighted for clear identification.
- When values are fully reconciled, the difference appears as zero
You can drill down from any section to view transaction-level details and analyse differences.
Header | View Company Information
The header section in GSTR-1 Reconciliation captures some of your key information up front, such as the Company name, GST Registration, Period, Status of returns (Signed/Not Signed), and so on. If required, you can change one or more of these necessary details, and the contents of the reports will be updated accordingly.
What’s more, if your business consists of multiple GST registrations/GSTINs, then the GSTR-1 Reconciliation report provides you with an amazing view of your combined GST details and activities across registrations. However, TallyPrime also provides you with the flexibility to view GSTR-1 Reconciliation for only one registration, from any of your companies.
View GSTR-1 Reconciliation for a specific GSTIN
Press F3 (Company/Tax Registration) and select the required company or registration from the list.
The GSTR-1 Reconciliation report will then open for the selected registration.
Based on your requirements, you can even set a particular registration as the default using the Save View feature, so that GSTR-1 Reconciliation will open the details of your desired registration every time.
Total Vouchers | View Statistics & Verify Details
The Total Vouchers section gives you a bird’s eye view of the key numbers and details across your GST transactions. You will get a clear picture of the number of reconciled, unreconciled, and uncertain transactions. You can drill down from each of these sub-sections to take a closer look at the transaction details.
The Total Vouchers section will display the following sections, based on your actions and transactions:
- Reconciled
- Unreconciled
- Mismatched
- Available Only in Books
- Available Only on Portal
- Available in Books and on Portal, but in Different Return periods
- Uncertain Transactions (Corrections needed)
Total Vouchers
This section gives a summary of reconciliation status. You can drill down from each section to view and act on transactions.
The following sections appear:
Reconciled
Displays transactions that match between your books and the portal. No action is required.
- If you want to verify the transactions, you can further drill down to see the full list of reconciled transactions in the selected period.
Unreconciled
This section provides a count of the transactions in GSTR-1 that are yet to be reconciled. After you import the GSTR-1 data, you can see that the Unreconciled transactions will be further categorised into Available Only in Books, Available Only on Portal, and Mismatch in Return periods.
- Drill down further to see the full list of unreconciled transactions in the selected period.
Mismatched
Displays transactions where GST details differ between your books and the portal (for example, Tax Amount or document details).
- Drill down, verify the differences, and update the values or status as needed.
- Press F12 (Configure) to enable additional fields, if needed.
- Press Alt+S (Set GST Status) to mark transactions as Reconciled, if differences are acceptable or update the values in your books to resolve the mismatch.
Available only in Books
Displays transactions present in your books but not on the portal.
- Review these and take necessary action, such as communicating with your party or uploading the transaction.
Available only on Portal
Displays transactions present on the portal but not in your books.
- Press Alt+R (GST Portal View) to view transaction details.
- Record the corresponding transaction in your books.
Once recorded and aligned, the transaction appears as Reconciled.
Available in Books and on Portal, but in Different Return Periods
Displays transactions recorded in different return periods in your books and on the portal.
- Update the GST Return Effective Date to align the periods, by pressing Alt+L (Set Effective Date).
Mismatch in Return periods
This section captures transactions that are present in both your books and on the portal, but in different periods, which leads to issues in reconciliation.
- Drill down to see the full list of transactions in the selected period.
- Press Alt+L (Set Effective Date) to align the return period.
Once updated, the transaction appears as Reconciled.
Excluded, but available on Portal
This section captures transactions that have been excluded from returns, but are present on the portal.
- Drill down to see the full list of transactions excluded from the current return period.
Uncertain Transactions (Corrections Needed)
Displays all the transactions with GST-related errors.
- Drill down further from the section to view all such uncertain details and correct them.
