How to Easily Shift/Migrate Your Data to TallyPrime

Most companies and organisations are in the habit of keeping their books of accounts through Microsoft Excel. Though this may be considered adequate for a small organisation, due to increased operations, such businesses get to a point when they find it necessary to adopt accounting software. Change is never easy but that is especially the case when adopting a new software into the workplace.

When you begin to replace one or some of the above mentioned aspects by a new software for your accounting operations, the very initial procedure to complete is to upload all your data from the spreadsheet. For many SW products in the market this is a manual job.

In TallyPrime it is not at all difficult to import your excel data into the software. The new release is TallyPrime 4. 0 also has a convenient Excel Import feature. As suggested from its name, this feature will import all your data from your Excel files into the software without the need of involving you.

Steps to migrate data to TallyPrime from an Excel worksheet
  • When you are at the Import Screen, press Alt+O and then go for the Configurations. 
  • You should now get the List of Configurations on the screen now. If you wish to expand your list, click on the Show More icon. 
  • In this list, there are two divisions—General and Banking.
  • Import/Export Files Location—Decide the location of the file after the import/export process is complete. 
  • The general action of Import if there are exceptions—It is possible, the original file has some exceptions for instance missing data or invalid data, what do you want to do to import it into TallyPrime?Select one of the options which include Discard, Import ignoring exceptions, or Import only while throwing exception on first one if any. 
  • Overwrite vouchers—Select the option as “Yes”. This way, if the export and import files of the company are of the same company, then the duplication of vouchers will be overwritten. 
  • The choice should be set to “Yes”. This way, the unwanted characters such as double space, tab space and other nuisance characters will be excluded from the Excel file before import. 
  • Import batch size—What number of files would you like to import simultaneously?At this place, the batch size can be set as per the requirement.
  • Enable detailed log—Do you wish to include a detailed log of errors from the data import operation?In this option, set the option for the result as per your choice.

As per these steps, your data is integrated into TallyPrime and you can carry on your business activities without any problem as stated below.

Advantages of migrating data to TallyPrime

  • In just a few clicks you can transfer all the data from vouchers, customer orders and other external software to TallyPrime. This means it saves you a lot of time and energy while at the same time greatly reducing human input errors. 
  • Due to this feature, the user can import any data in the new software called TallyPrime at his/her own wish. Regardless of the data in the original file may be incorrect data, missing data or disarrayed data, they can be directly imported to the respective fields on TallyPrime. 
  • Once you have imported your data in TallyPrime, then you can always use this template for the same kind of data. It also provides several samples which you can use to import your data for which you get the correct data in the proper fields within minutes. You could even select a template based on your requirements and preferences. 


When you import data into TallyPrime, you also have an option where you can view detailed error messages. This allows you to avoid log errors to check for, and fix them on your own. These logs can assist you in preventing such mistakes in the next batches of imports.

Bottom Line

  • Thus, depending on the results of the work, it became possible to introduce a new version of TallyPrime 4. 0, you’re able to fairly and ease import your files already created in Excel or any other external software to TallyPrime. There are no manual interferences, which makes the whole process absolutely seamless and very efficient.

 

  • The best which can be said in regards to this import process is the selection of templates that are good for your business. The new Tally software has all the robust features for importing data irrespective of the type and format of data of the source file and thus you can be sure that the data will be imported successfully.

Efisiensi

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

efisiensi.themes