Excel to tally prime

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

It is important to resolve all uncertain transactions before filing your GSTR1 return. If you do not, you may face penalties from the GST authorities.

  1. Go to Reports > GST > GSTR-1.

    %excel to tally%

     
  2. In the Filters section, select the Uncertain Transactions (Corrections needed) option.

  3. Click Preview.

    %excel to tally%

     
     
  4. The report will show all the transactions that have been marked as uncertain.

     
     
  5. For each uncertain transaction, you will need to identify the error and resolve it. The following are some common errors and their resolutions:

    • Invalid HSN/SAC code: The HSN/SAC code for the item is invalid. You can correct this by entering the correct HSN/SAC code in the item master.
    • %excel to tally%
    • Missing GSTIN: The GSTIN of the supplier or customer is missing. You can correct this by entering the GSTIN in the party master.
      %excel to tally%
    • Wrong tax rate: The tax rate for the transaction is wrong. You can correct this by entering the correct tax rate in the voucher.
      %excel to tally%
    • Mismatch in quantity and amount: The quantity and amount for the transaction do not match. You can correct this by entering the correct quantity and amount in the voucher.
       
  6. Once you have resolved all the errors, click Save to save the report.

    %excel to tally%
  7. The uncertain transactions will now be removed from the report.

 

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

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.
Team S&Y
Team S&Y
5 out of 5 stars
4 months ago
Excel-tally software is very useful for me to import excel sheet data into tally. Must buy the software its very easy to use. And software's support team is very co-operative
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.
Yerukola Kesavarao
Yerukola Kesavarao
5 out of 5 stars
a week ago
it's been 2 years i am using software . it is good to import any kind of data into tally. i will recomend it to tally user. i got best support from excel-tally team in this 2 year. never felt regret about software.
Damera Medifes Pvt Ltd
Damera Medifes Pvt Ltd
5 out of 5 stars
in the last week
The Software is extremely useful in reducing our workload from hours to just couple of seconds, there is no need for any service, even if it is there, they immediately sort it out very soon. very happy with the software and the service team
Write a review
×