In the daily routines of Practicing chartered accountants and part-time accountants one of the duties is to post entries to the tally software which later prepares and files GST-returns
However, there are times where GSTR-1 is being filed first and posted entries into the tally software later due to time constraints or accountants want to take purchases only available in the GST portal for that purpose they download respective JSON from the site and enter into the tally software manually
To make this possible, I prepared an excel utility that imports GSTR JSON To tally directly. It even processes 1000’s entries in minutes named CARA JSON2TALLY
CARA JSON2TALLY is a utility where you can import GSTR JSON files into excel and later you may generate tally XML or post it into the tally software directly
This tool supports the following JSON
GSR JSON 1
GSR JSON 2A
GST JSON 2B
It is user-friendly software. Where you can process GSTR returns instantaneously
Limitations:
1. GSTR1 and GSTR 2A don’t contain trade names instead it only contains GSTIN
2. For the import process to work properly, ledger Heads in tally need to be named with GSTIN in the alias field
3. It may be limited to Windows PC only, as it has not been tested on Mac.
Prerequisites:
1-Tally-Erp 9/Tally-Prime
2-Windows PC with MS Office Installed
3 – GSTR 1 /2A /2B Json File(s) [Downloaded from Portal ]
4-GSTR to Tally Import Tool
5-Moderate Working Knowledge of Excel
Procedure
Step 1: Launch Tally and enable ODBC, then set the port number to 9000. Then select the company where you want to import GSTR purchases or sales.
Step: 2 Open the tool and enable macros. A user form will be opened, and click the JSON file button to import
Step: 3 Select the appropriate option and click the Import File button. A File Picking dialogue box will appear. Browse and select the JSON file downloaded from the GST-Portal.
Step: 4 All available GST Numbers will be retrieved from the Opened Company in Tally and replaced automatically. A list of GSTINS that don’t replace them will be displayed.
In that scenario, create a party master with unavailable gstins and try importing again also, In Excel, replace appropriate purchase/sales and GST ledgers in green-colored cells.
Step:5 Then press the Tally button to export to the tally directly using ODBC.
Step:6 The status of success or failure will be displayed on the form.
In the tally, you’ll find posted entries in the Purchases register for GSTR 2A/2B and the Sales register for GSTR-1.
Disclaimer:
* This tool is created by me and you can find the same post link enclosed
* It is very important to take a backup of your tally data before importing it to the software to avoid data loss.
* Multiple importing will create multiple entries, which means it does not ignore the duplicates.
(Republished with Amendments)