GSTR1 Report Exception in Tally Prime 3.0:
1. Identify the Exception:
Open Tally Prime 3.0.
Navigate to the GST Reports section.
Select the GSTR1 report.
Look for any exceptions or discrepancies highlighted in the report.
2. Common Exceptions:
Mismatch in Tax Amounts: This could be due to incorrect tax rates applied to transactions or manual modifications.
Missing Invoice Details: Sometimes, certain invoices might not reflect in the GSTR1 report due to various reasons.
HSN/SAC Code Missing: For certain items, the HSN/SAC code might be missing, which is mandatory for GST reporting.
3. Resolving Mismatch in Tax Amounts:
Navigate to the particular invoice where the mismatch has occurred.
Verify the tax rate applied and ensure it matches the GST rate for that particular product or service.
If there’s an error, correct the tax rate and save the invoice.
4. Addressing Missing Invoice Details:
Check if the invoice date falls within the reporting period.
Ensure that the invoice is marked as a GST transaction.
If the invoice is missing, re-enter the invoice details and ensure all mandatory fields are filled.
5. Adding HSN/SAC Code:
Go to the item master where the HSN/SAC code is missing.
Update the HSN/SAC code for that particular item.
Save the changes.
6. Revalidate the GSTR1 Report:
After making all the necessary corrections, navigate back to the GSTR1 report.
Refresh the report to see if the exceptions have been cleared.
If there are no more exceptions, you can proceed to generate the GSTR1 report for filing.
7. Backup and File:
Before filing any report, it’s always a good practice to take a backup of your Tally data.
Once backed up, you can proceed to file the GSTR1 report through the GST portal or any other preferred method.
Note: Always ensure that you’re working with the latest version of Tally Prime, as updates might contain important fixes related to GST reporting.
While this is a general guide, the specific solution might vary based on the exact nature of the exception. If you have a specific error message or issue, please provide that for more tailored assistance.
How to import data from Excel to Tally Prime Software
Tally Connect Software imports various types of vouchers like Sales Vouchers, Purchases Vouchers, Bank statements, Receipt Vouchers, Payment Vouchers, Journal Vouchers, E-Commerce, and Payroll Vouchers, and masters like Ledgers, Items, and Stock Journal from Excel to Tally Prime or Tally ERP9.
1- Prepare your data in a template by copying & pasting or by smart mapping
2-Validate Ledger, Items, Vouchers & Auto Create using TallyConnect software
3- Select template & start importing. After successful import, check data in Tally
Excel to Tally Prime / Excel to tally Prime3.0 import Software
“No Monthly Cost Pay Once Use Lifetime 100% Accuracy and Guaranteed Support”
Tally Connect Software imports various types of vouchers like Sales Vouchers, Purchases Vouchers, Bank statements, Receipt Vouchers, Payment Vouchers, Journal Vouchers, E-Commerce, and Payroll Vouchers, and masters like Ledgers, Items, and Stock Journal into Tally Prime /Prime3.0 or Tally ERP9.
# Import Multi GSTN data from 1 Template
# Import data in Multi GSTN Companies
# No XML import-export, direct Excel to Tally import
# Verify details of Ledger & Item master before import.
# Smart merging of the same invoices Number
# Import 25+ ledgers in 1 invoice
# Import e-commerce data with templates for Amazon, Flipkart, Meesho & more.
# Import Credit Note & Debit Note data with or without Inventory
# Import Stock Journal data
# Smart Data mapping feature to import data in Template file
# Auto Create GST ledger one-click by GSTN, place of supply, tax rate
# Multi Bill references & Multi cost centers as many as you can
# Import data of Employee Masters, Attendance Vouchers & Payroll Vouchers
# Import Multi-Currency data with Multi-currency Conversion
# Import Share Market data
# Import E-Invoicing data of Sale Credit note Vouchers
Sounds exciting then hurry up & contact us for Free Demonstration
watch our Software demo :https://www.youtube.com/@tallyconnects
Call us for free demo : 9322956608 / 9604339316
email : excelotallyprime@gmail.com
GET Free online Demo :https://www.exceltotallyprime.com/
