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

gothal & co. chartered accountnat
gothal & co. chartered accountnat
5 out of 5 stars
a month ago
This software is incredible! Importing data from Excel to Tally has never been this easy. The process is fast and error-free, saving me hours of manual work. It’s a must-have for any business using Tally and the support team also very talented and cooperative
Rikka Varshini
Rikka Varshini
5 out of 5 stars
a month ago
"An absolute game-changer for our accounting team! The software makes importing Excel data into Tally so easy and accurate. We used to spend hours manually entering data, but now it’s done in minutes. It’s a huge time-saver and has improved the accuracy of our financial records. Purva from the support team was incredibly helpful in guiding us through the process. Highly recommend it to any business using Tally
Rajashri pula
Rajashri pula
5 out of 5 stars
a month ago
Good and fast support. I am very happy with the software Support Thank You falgunee mam for helping me.
GAURAV R PATEL
GAURAV R PATEL
5 out of 5 stars
a month ago
I am used bank templates only for last two years. I am self-employed and many banks so 150 entries(year) not bigger but hesitate to account in Tally. It is old school but easy to use and understand well. Just recommendation update your template wise video in high resolution for creating interest to watch.
vidyasagar kola
vidyasagar kola
5 out of 5 stars
in the last week
Good and fast support. I am very happy with the software Support, Sales persons are great. They solved my issues as their. Very helping team.
Write a review
×