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

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.
mayank tolia
mayank tolia
5 out of 5 stars
3 weeks ago
software is very useful And also their support service is also very Good.
sampat kumar
sampat kumar
5 out of 5 stars
7 months ago
Excel-Tally is a powerful tool designed to simplify the process of data import into Tally, the popular accounting software. With its user-friendly interface and robust functionality, Excel-Tally makes importing data a breeze, saving users valuable time and effort.
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.
Write a review
×