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

Avant kumar
Avant kumar
5 out of 5 stars
in the last week
Excel-tally software is very useful to all CA's and accountant. I have been using it since 1 and half year . support team solve each and every query .training and sales team is also good .highly recommended !
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
Ramesh Kaushik
Ramesh Kaushik
5 out of 5 stars
in the last week
Always available to answer any questions. Very knowledgeable about the services they provide. Would recommend to anyone, 100% must buy software.
Y.Jayaram Bhat
Y.Jayaram Bhat
5 out of 5 stars
in the last week
It is an excellent software. It is making my work very easy and fast. The team provides best support. It saves my time. It is the most recommended software.
Write a review
×