Special Offer for Chartered Accountant

Tally Automation
Sep 18, 2022

Import Data from Excel to Tally In 3 Easy Steps

Ankit Virani



Pushing data into a Tally can be tedious because of the hours of manual entries made from Excel. As an accountant, this process eats into your time. 

On top of that, Tally is not the most user-friendly software that can facilitate seamless data import. 

Automated accounting solves this problem for all tax experts. With the right automation tool for excel to tally data import, 100% error-free entries and process optimization is possible. 

The process can be completed in  3 steps, taking only a few clicks and saving up to 80% of the time you would normally take in data entering. 

Before you begin

Download Suvit and begin your 7-Day Free Trial, 

Make sure that Suvit is connected to **Tally and the Internet.



Step 1: Upload Excel into Suvit

Upload your excel sheets according to the modules available of Banking, Sales or **Purchase


Final Step: Push the Data into Tally

Click on Send Transactions to Tally. 


You will be notified once your entries are pushed into Tally. 


Watch this: Every tally user must know this | PDF/Excel to Tally Automation in Tally 

**But, to complete Step 1 successfully, you will need the well formatted Excel. So, let’s see how to import data smoothly from Excel. Here are 6 tips for smooth data import from Excel to tally.**‍

Also read: Tally on Mobile: Accounting for the Mobile Age

Importing data from Excel to tally can be challenging. So, here are the six down-to-earth tips to make your tally data migration a cakewalk. 

Tip 1: Deciphering Tally's Language

Let's start with the basics. Tally isn't just a tool; it's your trusty companion in the accounting world. Before starting with data import from Excel to tally, take a moment to understand Tally's language. Think of it as decoding a friend's favorite book—it makes the conversation (or in this case, data transfer) much smoother.

Tip 2: Accuracy Is the North Star

In the world of Tally, accuracy is unbeatable. Imagine Tally as a GPS; it needs precise coordinates to guide you through the financial landscape. Data formatting can be the madness of a multiverse, but navigating it with accuracy ensures you won't end up in the wrong financial galaxy.

Tip 3: Ledger Accounts - Your Financial Map

Ledger accounts are the signboard of your Excel to tally data import journey. Organize them —like pinning destinations on a road trip. Accuracy in ledger data is like having a reliable map. It ensures you reach your financial destinations without detours.

Tip 4: Excel Ready, Set, Go!

Preparing your Excel sheet is like prepping for a race. Clear and concise headings are your milestones, leading the way. Each column plays a specific role, much like training for race-ready. A clutter-free Excel sheet sets the stage for a smooth data import from tally highway.

Tip 5: Cleaning Data Clutter

Now, let's roll up our sleeves for some data clean up. Ditch those duplicates—they're like unwanted hitchhikers on your financial journey. Empty cells are potholes; fill or fix them to avoid a bumpy ride. Consistent formatting for excel to tally is your vehicle maintenance, ensuring a smooth ride without unexpected breakdowns.

Tip 6: Format Right, Import Light

Formatting your data for Tally is like choosing the right vehicle for a specific terrain. Text fields need to be concise—like packing light for a trip. Round off numerical values for a smoother ride, and keep date formats consistent. To make the excel to tally data importing process a stress-free journey, align your data with Tally's preferences.

Bonus Tip: Utilize Appropriate Data Import Tools

Right tools ease the data journey just like a pro rider relies on quality gears. You can use Excel or other software to help you smoothly transfer your data from excel to Tally.

Employing Data Formatting Functions

  • CONCATENATE Function: Combine data from different columns into a single cell.
  • TRIM Function: Remove extra spaces from cells, especially in text fields.
  • TEXT Function: Ensure consistent formatting, like dates in DD/MM/YYYY format.

Trial Error Checking: Spotting Errors Before the Actual Journey

Think of it as a test drive. You can find and fix mistakes without affecting your real finances.

Verifying Accuracy

  • Review Ledgers and Transactions: verify if ledger names align with your expectations and cross-reference transaction entries with your original data.
  • Verify Totals and Balances: Make sure that your ultimate totals match your expectations and cross-verify balances for precision
  • Taxation Tally: Validate that tax calculations, such as GST, correspond with your Excel data, and review tax codes and rates.

 Troubleshooting Common Errors

  • Mismatched Ledger Titles: If ledger names differ in Tally, review and adjust them before the final import.
  • Wrong Transaction Entries: Verify each transaction's values and details for precision.
  • Incorrectly aligned Dates: Rectify any inconsistencies in date formatting.
  • Taxing Issues: Ensure GST and other tax-related data match.

And That's Not It!

With this, you now know the art of smooth data transfer—from structuring your Excel data to formatting, cleaning, and utilizing specialized tools. You've delved into GST considerations, understood the importance of trial imports, and even experienced the magic of Suvit automation. 

But apart from smooth data import from excel to Tally, Suvit provides numerous additional advantages. Such as:

- You can directly upload PDFs, scanned PDFs, and Excel sheets to the Suvit platform instead of using other platforms for sharing.

- Suvit serves as a centralized platform for efficient data management, providing insights into collected data.

- It enables remote access to data and allows controlled sharing of access with team members.

- The integration of machine learning and AI ensures continual optimization, eliminating the need for repetitive data entry in Suvit.

Open a new account on Suvit by signing up here.

Recent Blogs