How to Easily Migrate Your Data to TallyPrime

A lot of companies maintain their books of accounts using Excel spreadsheets. For small Businesses, this configuration might be sufficient, but when the business is growing, Excel spreadsheets are difficulty to manage so to overcome this problems accounting software is essential. Adopting a new software has its challenges. Entering all of your spreadsheet data into the new system is the first thing you will need to do when you begin using the new software for your accounting processes.

This is a manual process for a large number of software items available on the market. Transferring your Excel data to TallyPrime is a simple process. There is an integrated Excel import feature in the most recent version of TallyPrime 5.1. This tool, as its name implies, will assist you in automatically transfer all of your data from your Excel files to the software.

Steps to Migrate Data to TallyPrime from an Excel Worksheet

The procedures for moving data from an Excel spreadsheet to TallyPrime are listed below.

• Click on Alt+O, then choose the Configurations from the Import Screen.
• You will see the List of Configurations on the screen now. Click on the Show More option to view the entire list.
• This list has two sections—General and Banking. Here are the options you will see under the Banking section:

Location of the Import/Export Files—Choose where to save the file after successful Import or export.

• The behaviour of Import when exceptions exist—When the original file has some exceptions (like missing data or invalid data), how do you want to import it to TallyPrime? Choose if you will ignore the exceptions, import with exceptions, or stop the Import when you notice the first exception.

Overwrite vouchers—Set the option to “Yes”. This way, duplicate vouchers will be overwritten if the export and import files are of the same company.

• Remove invalid characters—Set the option to “Yes”. This way, invalid characters like additional spaces, tabs, and other noise characters will be removed from the Excel file before being imported.
• Import batch size—How many files do you want to import at a time? You can set the batch size accordingly here.
• Enable detailed log—Do you want to see a detailed log of errors during data import? Set the option as per your preferences.