Introduction
Managing GST reconciliation manually can be time-consuming, especially when handling multiple purchase invoices, tax differences, and Input Tax Credit (ITC) adjustments.
To simplify this process, Shivansh Infosys introduces an updated GSTR Reconciliation TDL for TallyPrime, designed to make GST reconciliation faster, easier, and more accurate.
With the latest update, users can now import GSTR-2B data with tax breakup details by combining GSTR-2A and GSTR-2B data. This enhancement helps businesses manage multiple tax rates, automate voucher entries, track ITC, and identify mismatches between GST portal data and TallyPrime records.
What's New in the GSTR Reconciliation TDL?
1. GSTR-2B Import with Tax Breakup-Wise Details
One of the major updates is the ability to import GSTR-2B transactions with detailed tax breakup information.
Previously, importing GSTR-2B data with separate tax breakup details was a limitation.
With the updated TDL, users can combine GSTR-2A and GSTR-2B JSON data to identify the applicable tax breakup and import transactions into TallyPrime.
Key Benefits:
Import GSTR-2B data with tax breakup details.
Handle invoices containing multiple GST rates.
Support CGST, SGST, IGST, and applicable cess.
Reduce manual tax ledger mapping work.
Improve accuracy during purchase voucher creation.
2. Bulk Purchase, Debit Note & Credit Note Import
The updated tool allows users to import multiple transactions together instead of processing each voucher individually.
Users can import Purchase Vouchers, Debit Notes, Credit Notes, and supported RCM entries through the bulk import process.
This helps reduce repetitive data entry and saves valuable accounting time.
3. Support for 40% GST Rate
The latest update also introduces support for the 40% GST rate, allowing users to map transactions that fall under this tax category.
This enhances the tool's ability to handle different applicable GST rates.
Key Features of the GSTR Reconciliation Tool
1. GSTR-2A & GSTR-2B Reconciliation
Compare GST portal data with TallyPrime records and identify differences in purchase transactions.
The tool helps users identify:
Matched transactions
Transactions not available in TallyPrime
Transactions not available on the GST portal
Partially matched transactions
Invoice number and date differences
GST amount and tax ledger mismatches
2. Automatic Party Ledger Creation
When importing GSTR-2A transactions, the tool can create missing party ledgers using the available GST details.
This reduces the need to manually create supplier ledgers before importing transactions.
3. Invoice Matching & Merge Bill Facility
Sometimes, invoice numbers recorded in TallyPrime differ from the invoice numbers reported on the GST portal.
The Merge Bill feature helps users reconcile selected transactions and update invoice references based on portal records.
This simplifies the reconciliation of transactions that otherwise appear unmatched.
4. Automated ITC Reversal & Reclaim
Managing Input Tax Credit becomes easier with the automated ITC reversal and reclaim functionality.
Users can:
Identify invoices requiring ITC reversal.
Set the reversal month.
Generate reversal accounting entries.
Reclaim eligible ITC in the appropriate month.
View the corresponding impact in the Balance Sheet and GSTR-3B reports.
Track reversal and reclaim details for future reference.
This reduces the manual accounting effort involved in ITC adjustments.
5. ITC Availment Month Tracking
The tool provides an option to record the month in which ITC is availed.
This is particularly useful when the purchase invoice date and ITC claim month are different.
Users can filter ITC transactions month-wise, making GST reporting, financial reconciliation, and year-end reviews more convenient.
6. Reverse Charge Mechanism (RCM) Entries
The GSTR Reconciliation TDL also supports RCM-related accounting entries.
Users can select applicable transactions and generate RCM entries using the provided functionality, reducing manual journal entry work.
7. Ineligible ITC Management
Not every purchase transaction qualifies for Input Tax Credit.
The tool provides functionality to identify and process ineligible ITC transactions, helping businesses maintain appropriate accounting records and reflect relevant adjustments in GST reports.
8. Optional Voucher Entries for Non-Claimable Transactions
Some transactions may appear in GST portal data but may not be relevant for ITC claims.
The tool allows users to maintain such transactions using optional vouchers and suitable reason classifications, including:
Book Entry Without GST
Not in Portal
Not Related to Us
This helps preserve transaction records without including them in regular ITC claims.
9. GSTR-1 Reconciliation
Along with GSTR-2A and GSTR-2B, the tool supports GSTR-1 B2B reconciliation.
Businesses can compare sales transactions recorded in TallyPrime with GST portal data to identify missing entries, differences, or other discrepancies.
10. Detailed GST Reports & Filters
The tool provides multiple reports and filtering options for better GST management.
Available reporting features include:
GSTR-2A vs Tally Report
GSTR-2B vs Tally Report
ITC Reversal Register
Ready Bills for ITC
Pending Bills for ITC
Party-wise and bill-wise transaction details
Return filing date tracking
Document type and reconciliation status filters
These reports help accountants and business owners review GST transactions more efficiently.
How Does the GSTR Reconciliation TDL Work?
Step 1: Load the GST Reconciliation TDL in TallyPrime.
Step 2: Configure the required settings and specify the folder paths for GSTR-2A and GSTR-2B JSON files.
Step 3: Open the GST Reconciliation report and select the required month.
Step 4: Import the GST portal data and compare it with transactions available in TallyPrime.
Step 5: Review matched, unmatched, and partially matched transactions.
Step 6: Map the required tax ledgers and import missing vouchers individually or in bulk.
Step 7: Approve reconciled transactions and process applicable ITC reversals or reclaims.
Step 8: Set the ITC availment month and generate the required reconciliation reports.
Note: Tax breakup-wise GSTR-2B import requires the corresponding GSTR-2A JSON data. ITC eligibility, reversal, and reclaim treatment should be verified against applicable GST requirements.
Who Can Benefit from This Tool?
The GSTR Reconciliation TDL is useful for:
Chartered Accountants and Tax Consultants
Accountants and Finance Teams
GST Practitioners
Small and Medium Businesses
Businesses handling large volumes of purchase invoices
Organizations requiring regular GST reconciliation
Why Choose Shivansh Infosys GSTR Reconciliation TDL?
Shivansh Infosys provides practical TallyPrime customization solutions designed to simplify accounting operations.
Our updated GSTR Reconciliation TDL helps businesses:
Save time on repetitive GST reconciliation tasks.
Reduce manual voucher entry work.
Identify mismatched and missing transactions.
Manage ITC reversal and reclaim efficiently.
Maintain organized GST accounting records.
Improve GST reporting and month-wise tracking.
Existing customers can contact our team to receive the latest update at no additional cost, as described in our update policy.
Conclusion
Accurate GST reconciliation is essential for maintaining reliable accounting records and managing Input Tax Credit effectively.
With the latest GSTR Reconciliation TDL update from Shivansh Infosys, businesses can import GSTR-2A and GSTR-2B data, manage tax breakup-wise transactions, process bulk vouchers, track ITC adjustments, and generate useful GST reports directly in TallyPrime.
Make GST reconciliation smarter, faster, and easier with Shivansh Infosys!
Get a Demo Today!
Simplify your GST reconciliation process with our advanced TallyPrime customization.
Shivansh Infosys – Quick Response, Quick Support
Website: www.shivanshinfosys.in
Contact our team today to learn more about the GSTR Reconciliation TDL or request a product demonstration.