Excel to tally prime

Call Us demo / Support : 🤙 + 91 9322956608 / 🤙+ 91 9604339316 / 🤙+ 91 9373335929 / 📨: email@tallyconnects.com

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/

Get Free Demo

Sundar A
Sundar A
5 out of 5 stars
2 months ago
It is very nice application. It saves lot of time. We no need to spend more time to enter data in tally. The main thing is... customer support...immediately they help us to solve any issued.
Aryan Jain
Aryan Jain
5 out of 5 stars
2 months ago
It is a nicely built software with very low chances of errors. The team has very cleverly made use of excel to design such a software for business owners to ease the task of accounting entries. The support team is also quick in responding and resolving the issues. I highly recommend using their services if they are in-line with your needs and specifications. A special mention to one of their customer support executive named Vishakha for guiding me with utter patience.
GST ADDA
GST ADDA
5 out of 5 stars
2 months ago
offers a comprehensive set of features that streamline our workflow. From task management to data entry, it covers all our book-keeping needs efficiently. The ability to customize workflows and integrate with other tools is a huge plus. Its intuitive design makes it easy for new users to get started without much training. Moreover, the customer support team is top-notch. They're always quick to respond to our queries and provide helpful solutions. Their dedication to customer satisfaction is truly commendable.
Kadavakollu Associates
Kadavakollu Associates
5 out of 5 stars
3 weeks ago
If we really need to focus on business development, and then it is always advisable to cut down the time and cost on same type of recurring tasks and one such amazing software that helps accountants achieve this is excel to tally. I have got the software designed in 2018 for a specific task and after which there has been no looking back.. I have access to all updates and we are really happy with excel to tally and their team. Definitely worth trying.
srisurya consultants
srisurya consultants
5 out of 5 stars
6 months ago
It is a Very Good Software and Very user friendly. Customer Care Staff is very friendly and they give their assistance immediately and once again they learnt and explain the Software. I recommend to any body it is a good Software. Thank You.
Write a review
×