GSTR-1, GSTR-2, and GSTR-3B Reports in Tally Prime
Goods and Services Tax (GST) compliance requires businesses to file various returns with the government. In India, the three major GST returns that businesses need to file are GSTR-1, GSTR-2, and GSTR-3B. Tally Prime provides features to generate these returns based on the data entered in the system. In this article, we will guide you step-by-step through the process of generating and understanding GSTR-1, GSTR-2, and GSTR-3B reports in Tally Prime with real examples.
1. GSTR-1 Report in Tally Prime
GSTR-1 is a monthly return that contains details of all outward supplies (sales) made by a registered taxpayer. It includes information such as sales invoices, GST rates, and the total taxable value of supplies made to customers.
Step 1: Enable GST and Configure Company for GSTR-1
Go to Gateway of Tally → F11: Features → Statutory & Taxation → Enable GST.
Set Enable GST to "Yes".
In the same section, set GST Details and GST Registration Type as per your business needs.
Press Ctrl + A to save the settings.
Step 2: Create GST Tax Ledgers
Ensure that GST tax ledgers such as CGST, SGST, and IGST are created under Duties and Taxes in Tally Prime. For example, create CGST, SGST, and IGST ledgers with appropriate tax rates.
Step 3: Record Sales Transactions
When making sales, use the Sales Voucher to record the transaction and apply the correct GST rate (CGST/SGST or IGST) based on the type of supply (intra-state or inter-state).
Step 4: Viewing GSTR-1 Report
Go to Gateway of Tally → Display → Statutory Reports → GST Reports → GSTR-1.
Select the required period (monthly or quarterly) for which you want to view the GSTR-1 report.
The GSTR-1 report will display details of all outward supplies (sales), including the tax amounts for each transaction.
Step 5: Export GSTR-1 to JSON
Once you are satisfied with the details in GSTR-1, you can export the report by selecting Export → JSON.
This JSON file can then be uploaded to the GST portal for filing.
2. GSTR-2 Report in Tally Prime
GSTR-2 is a return that contains details of inward supplies (purchases) made by a registered taxpayer. It is auto-populated from the GSTR-1 returns filed by your suppliers. However, in Tally Prime, you will need to record purchase transactions properly to generate the GSTR-2 report.
Step 1: Record Purchase Transactions
Use the Purchase Voucher in Tally Prime to record purchases and select the appropriate GST tax ledgers (CGST, SGST, IGST) for each purchase.
Step 2: Viewing GSTR-2 Report
Go to Gateway of Tally → Display → Statutory Reports → GST Reports → GSTR-2.
GSTR-2 will show details of all inward supplies (purchases) made, including the tax amounts for each transaction.
You can verify the data and make sure the details match with your suppliers' returns.
Step 3: Export GSTR-2 to JSON
If you wish to file GSTR-2, export the report in JSON format using the Export → JSON option.
Upload the JSON file to the GST portal for filing.
3. GSTR-3B Report in Tally Prime
GSTR-3B is a simplified summary return that taxpayers need to file every month. It includes details such as the total sales, total purchases, GST liability, and input tax credit (ITC).
Step 1: Recording Sales and Purchase Transactions
Ensure that all sales and purchase transactions are recorded properly in Tally Prime using the Sales and Purchase vouchers. The GST calculations will be automatically handled by Tally Prime based on the GST tax ledgers used in the entries.
Step 2: Viewing GSTR-3B Report
Go to Gateway of Tally → Display → Statutory Reports → GST Reports → GSTR-3B.
The GSTR-3B report will display a summary of outward supplies (sales) and inward supplies (purchases), along with the applicable GST for each type of transaction.
Check the summary for sales, purchases, tax liabilities (CGST, SGST, IGST), and eligible input tax credits.
Step 3: Export GSTR-3B to JSON
Once you have verified the data in GSTR-3B, you can export the report by selecting Export → JSON.
Upload the JSON file to the GST portal to file GSTR-3B.
4. Key Differences Between GSTR-1, GSTR-2, and GSTR-3B
GSTR-1: A monthly return for outward supplies (sales) made by the taxpayer.
GSTR-2: A return for inward supplies (purchases) made by the taxpayer, auto-populated from GSTR-1 filed by suppliers.
GSTR-3B: A summary return for both outward and inward supplies, used for calculating GST liability and filing for payment of taxes.
5. Conclusion
GSTR-1, GSTR-2, and GSTR-3B are essential reports for GST compliance in India. Tally Prime makes it easy to generate and file these returns by automating tax calculations and generating detailed reports. By following the steps outlined in this article, you can accurately record your transactions and file your GST returns on time.