Yes, you can save the mapping template for All Companies in your TallyPrime. The same mapping template can be used by different companies provided the excel file and sheet names are the same.

Yes, you can share mapping templates across multiple systems. All the mapping templates saved under All Companies will be saved as. tsf (Tally Source File) files. 

1. Go to the application folder where you have installed TallyPrime. 
2. Select the userconfig folder and open excelmaps. 
   
3. Find and select the .tsf file of the mapping template that you want to share. You can then share this file with others, allowing them to import the mapping template into their TallyPrime systems and save time in data entry.

Yes, irrespective of whether you have a licensed or un-licensed version of MS Office you will be able to use this feature for importing data from Excel into TallyPrime.

Yes, LibreOffice is supported for importing data from Excel. CSV is also supported for importing. You will have to convert the CSV file into an Excel format by saving it as .xls or .xlsx file from MS Excel application. However, Google Sheet is not supported right now but the roundabout is you can download it is as an Excel Sheet and use it to import data.

Bank statements are used for reconciliation purpose. Therefore,

1. Open the Bank Reconciliation report in TallyPrime.
2. Go to Alt+O (Import)> Bank Statements.
   You can easily import data from Bank Statements into TallyPrime.

No, they will not be displayed in the Exceptions report. The value will be rounded off according to the decimal places set in the currency. If you require 4 decimal places, you must specify this before importing the data.

Yes, since language is supported for importing masters, your data will be successfully imported into TallyPrime.

Price list is supported as a part of stock item not as a separate master.

TallyPrime follows the most commonly followed data entry practices. Fox example, if the entire column is used for credit amount, then there is an option in mapping configuration to treat the column as Credit amount or vice-versa. So, if your data is available otherwise, it is recommended that you update it before importing the data.

After importing your data, open the Chart of Accounts for viewing the masters and Day Book for viewing the vouchers that have been successfully imported into TallyPrime.

During the import process, there is no way to abandon it. However, before you start importing, a pre-import summary will be displayed that includes the name of the Excel file you’ve selected. At this point, you have the option to either proceed with the import or go back and change the selected Excel file. This allows you to ensure that you have the correct file before importing, minimizing the impact of potential errors.
However, it is recommended that you take backup of your data before importing so that the same can be restored, in case of an unintended import.

Yes, the Preview Import Summary is auto-enabled in the feature. However, you can disable it in the Import Masters/ Import Transactions screen by setting the option Preview Import Summary as No. 

If these details are missing after importing, check if you have provided the Country and State details correctly in the Company Creation page.

All formats of values entered for forex amount in TallyPrime is supported for import. For instance:

To import Stock items under the default Primary group, you can leave the field Parent Group Name blank, and the system will automatically create the Stock items under the default Primary group. The same is applicable for importing Cost Centres, Stock Group, Stock Category, Godown/Location, Employee, Employee Group, Attendance/Production Type. 

Voucher numbers are imported based on the configuration set in the respective Voucher Type master. For example, if Method of voucher numbering in Voucher Type is set to Automatic then the voucher numbers will be created by system, as it happens during manual entry. To know more, click here. 

Yes, Price Lists can be imported as a part of Stock Item masters. However, updating a Price List is not supported currently.
To know more, click here.

No, you cannot import masters into multiple companies at once.

The fields that are not present in the first sheet of the Sample Excel File can be found in the Read Me worksheet. You can copy the field names from the Read Me worksheet and add the same to the Sample Excel File.

No, only one worksheet can be imported at one go.

To specify the Sales or Purchase ledgers in Order Vouchers and Delivery Notes,

• You can use the fields Accounting Allocations – Ledger and Accounting Allocations – Amount. 
• However, a Sales or Purchase Order can be imported without the accounting allocations, by setting the option Provide Accounting Allocations for Order/Delivery Note to No in the voucher entry configuration screen. Refer to the sample data for more information.

This error appears when the total of Debit and Credit amount is not equal in a voucher. Ensure that the total of the Debit and Credit amount is equal while making ledger entries.

In the Mapping screen, select the option Ledger Details from multiple rows to import the transactions with multiple Sales Ledgers or Tax Ledgers. Refer to the sample data for more information.

Yes, you can import a transaction without a Voucher Number. Delete the Voucher Number Column from the Excel sheet and then proceed with import.

•  In case of user defined formats, you can alter the range of import by changing the values ‘Import data from row and to ‘ and ‘Import data from column and to’ in the mapping configurations.
• In case of Sample Excel File, create different sheets for different periods if you are maintaining a single Excel file.

Multiple bill details can be entered one after the other in multiple rows in excel as shown below:

To know more, click here.

To map a Sales ledger or other Expense ledgers in case of ledgers in fixed columns, you have to select the option Bottom Ledgers (Tax, Discount, & so on) while creating a map for horizontal format.

If you are facing difficulties while saving the mapping template, ensure that all the mandatory fields have been mapped in the template.

• For instance, if you are creating a mapping template for Ledgers, the Name and Group Name of the ledgers are mandatory fields that need to be mapped.
• Similarly, if you are creating a mapping template for Vouchers, Voucher Type Name, Voucher Date, Ledger Name and Ledger Amount are mandatory fields that need to be mapped.

The address can be entered in multiple Excel rows under one Address column and imported. In case, you have addresses in multiple columns like Address1, Address2, Address3 then these can be mapped with Address field in Tally and imported.

In the Mapping Template Creation screen,

• Under Field (TallyPrime) select Address and map with the corresponding Address columns in your Excel file.

Yes, importing 2 Lakh+ transactions at one go using Import Data from Excel is feasible. However, for optimal efficiency in TallyPrime, it is recommended that you import 50,000 to 1 Lakh transactions at a time.

When the cell value is negative it is imported as debit and if it is positive, it is imported as credit. If there is a mismatch in these values while you are importing them, you can do either of the following:

1. If all values are in positive, mention Debit or Credit in the Excel column for the values, respectively.
2. Use the Compute Value option in the Mapping Template and proceed.

Check if the Cell is in a text or a number format. If it is in a number format, change the format to text by following the steps given below:

1. Add a new column in the Excel sheet.
2. In the first cell of the new column, enter the formula =CONCAT(“”,cell number) <here cell number is of the corresponding column you want to import>.
3. Apply the same formula in the remaining cells of the new column or simply drag your cursor till the cell you want to import.
4. Now map this new column with the corresponding field in TallyPrime and proceed with the import process.

While importing vouchers with Multicurrency, you will have to provide the Amount in Base Currency and proceed with importing the Cost Centre Allocation. 

While Importing Data from an Excel file, TallyPrime has the ability to detect duplicate entries only for the fields that must be unique, such as the name of Masters and Groups. However, TallyPrime does not consider duplicate GSTIN/UIN as exceptions, because it’s possible for multiple branches to have the same GSTIN while maintaining separate ledgers.

The Reset GSTN Data feature in TallyPrime can be used in the following situations, without affecting your books:

• The data you have imported or downloaded from the GST portal to TallyPrime is corrupted.
• You have accidentally imported GSTR-1 fetched into GSTR-2A (or vice-versa).

While you reset GSTN data in TallyPrime Release 3.0, the To date is prefilled with the date of last statutory voucher entry. You can select the From date, as needed, and reset the GSTN data.

Once you have completed resetting the GSTN data, you can open the GSTR-1 and GSTR-3B reports as applicable to you company, and verify if the data that you had imported earlier is completely erased as expected.

In TallyPrime, you can export and import the entire data to a newly created company. You have to export the masters first and then the transactions. Ensure that company features (F11) of the exporting and the importing company are the same.

Note: The price lists of the old company mentioned in F11 features can be imported and exported in a similar manner to the new company.

Export Masters

1. Press Alt+G (Go to) > type or select List of Accounts > select Ledgers and press Enter.
   Alternatively, Gateway of Tally > Chart of Accounts > Ledgers.
   
2. Press Alt+F12 (Range) to select the masters you want to export. Skip this step if you want to export all the masters.
   
3. Press Alt+E (Export) > press Enter on Current.
4. In the Export screen, press C (Configure) > select the File Format as XML (Data Interchange)
5. The Folder Path will be set to C:\Program Files\TallyPrime. You can change this, if needed.
6. The File Name will be set to Master.XML. You can change this, if needed.
7. Set the Type of Master to All Masters.
   
8. Press Esc to return to the Export screen.
   
9. Press E (Send) to export.

Export Transactions

1. Press Alt+G (Go to) > type or select Day Book.
   Alternatively, Gateway of Tally > Day Book.
2. Press Alt+F2 (Period) and provide the required From and To dates.
   
3. Press Alt+F12 (Range) to select the masters you want to export. Skip this step if you want to export all the transactions.
   
4. Press Alt+E (Export) > press Enter on Current.
5. In the Export screen, press C (Configure).
6. Select Narration and press Enter to set it to Yes. Similarly, set the required options to Yes.
7. Set the Type of Vouchers to All Vouchers.
8. Select the File Format as XML (Data Interchange).
9. The Folder Path will be set to C:\Program Files\TallyPrime. You can change this, if needed.
10. The File Name will be set to DayBook.xml. You can change this, if needed.
    
11. Press Esc to return to the Export screen.
    
12. Press E (Send) to export.

Import Masters

1. Select the required company.
2. Press Alt+O (Import) > Masters.
3. In File to import (XML) select the filename containing the exported masters.
4. In Behaviour of import if masters already exists, select Modify with new data.
   
5. Press Enter to import the masters.
   • Once the import process is complete, compare the statistics of both importing and exporting company.
   • To view these details, press Alt+G (Go To) > type or select Statistics > and press Enter.
     Alternatively, go to Gateway of Tally > Display More Reports > Statements of Accounts > Statistics.

Import Vouchers

1. Select the required company.
2. Press Alt+O (Import) > Transactions.
3. In File to import (XML) select the filename containing the exported transactions.
   
4. Press Enter to import the transactions.
   • Once the import process is complete, compare the statistics of both importing and exporting company.
   • To view these details, press Alt+G (Go To) > type or select Statistics > and press Enter.
     Alternatively, go to Gateway of Tally > Display More Reports > Statements of Accounts > Statistics.

1. Press Alt+O (Import) > select Configuration and press Enter.
2. Set the option Ignore errors during import to Yes.
   

This will avoid programming conflicts that may occur while the data is being imported. Setting this option to ‘No’ will ignore the error message and continue with the import of data.

Note: However, errors while importing data will be logged into the Tally.Imp file that is generated in the TallyPrime folder.

Scenario 1: While merging multiple company data, transactions are getting overwritten or deleted on importing data of another company.

Scenario 2: While importing third party xml data to Tally, transactions available in Tally database are getting deleted or overwritten.

Reason

1. If multiple copies of a single company are copied in different locations rather than creating from Tally application, then vouchers will hold same Voucher ID at all the locations.
2. Consolidation of all the company vouchers using export and import feature will lead to overwriting or deletion of the vouchers as Voucher ID is same in all the companies.
3. If third party application is generating same Voucher ID for all vouchers, then the above-mentioned problem will occur while importing the xml files.

Solutions

Scenario 1: Create the company from Tally application and import the data by removing the voucher ID with the help of Notepad++.

Scenario 2: For third party software’s, you need to generate unique Voucher ID for each and every voucher.

Below is the XML TAG LINE which should be altered:

<VOUCHER REMOTEID=”Unique id has to be provided” VCHKEY=”01ae33cc-833c-479e-913c-c5079b964709-0000a46e:00000008″ VCHTYPE=”Purchase” ACTION=”Create” OBJVIEW=”Invoice Voucher View”>

Additional information

To merge all the current data and to overcome the overwriting or deletion problem, Voucher ID must be removed from daybook.xml files. This can be done using XML editors. Below is the procedure followed for “NOTEPAD++” software.

Note: There are multiple XML editor software, but procedure might vary from one software to another.

Following is the procedure for replacing Voucher remote ID using Notepad++ software.

Step 1

1. Download the Notepad++ software.
2. Load the XML file using NOTEPAD++ software.
   
   
3. Press Ctrl+F button -> in Find what field, mention Remoteid=*.*vchtype and in Replace field, mention VCHTYPE. In Search Mode box, enable the option Regular expression and click on Replace All.
   
4. After selecting Replace All option, the Voucher ID will be removed from all the Vouchers & message will be displayed as shown below:
   
5. Once replacement is completed, you will find the difference in below mentioned tag line:
   • Before replacement:
   • After replacement:

Step 2: Import this daybook.xml to Consolidation Company, so that complete data will get imported.

Note: Ensure to import this xml file only once. If import is done again and again, transactions will get duplicated.

You can export or import a stock item to another new company.

1. Load both the importing and exporting companies in TallyPrime.
2. Select the Company from which the Stock Item has to be exported.
3. Go to Gateway of Tally > Alter > Stock Item.
   Alternatively, press Alt+G (Go To) > Alter Master > type or select Stock Item > and press Enter.
4. Select the required stock item.
5. In the Stock Item Alteration screen, press F3 (Company).
6. In the Change Company screen, select the company in which the stock item has to be imported.
7. The Stock Item Alteration screen for the selected company appears, press Ctrl+A to save the stock item.

You can export the closing balances of the ledger or item or both on any given date and import the same as opening balances to newly created companies. This facility is provided in TallyPrime.

Export closing balance in old company

1. Gateway of Tally > Chart of Accounts > Ledgers.
   Alternatively, press Alt+G (Go To) > type or select List of Accounts > select Ledgers and press Enter.
2. Press Alt+E (Export) > Current.
3. In Chart of Accounts screen, press C (Configure).
4. Select the required Type of master or select All Masters to export all the masters to the respective company.
5. Set the option Export closing balances as opening balance to Yes, to export the closing balances.
6. Select the File Format as XML (Data Interchange) or SDF (SDF format appears only when TDL is loaded).
7. In the Export to field, select the path to which the file needs to be exported.
8. In the File Name field enter the required output file name or accept the default file name.
9. Press Enter on Show More displayed at the top of the list > set the option Open Folder after export to Yes.
10. In the Closing balance as on field, press Enter and change the date, as needed.
    
11. Press Esc to return to the export screen.
    
12. Press E (Send) to export the file.

Import as Opening Balance in New Company

Open new company to import the exported closing balances as opening balance.

1. Press Alt+O (Import) > Masters.
2. In File to import (XML) select the filename containing the exported masters.
3. In Behaviour of import if masters already exists, select Modify with new data.
   
4. Press Enter to import the masters.

On successfully importing the data you can view the balances for ledgers and stock items.

Use ODBC feature to export customer’s/supplier’s details to Excel.

1. Start TallyPrime.
2. Press F1 (Help) and ensure ODBC Services and port number are displayed.

   Note: Ensure that TallyPrime is open till you complete the process of exporting ledgers details to Excel.

3. Open Microsoft Excel on your computer.
4. Click Data > Get External Data > From Other Sources > From Microsoft Query, as shown below:
   
5. Click Browse > select TallyODBC64_9000, as ODBC is enabled on the server 9000.
6. Click OK. The Query Wizard – Choose Columns screen appears as shown below:
   
7. Click Ledger and expand the list to select the required fields.
8. Click Next. The Query Wizard – Filter Data screen with the column names appears as shown below:
   
9. Click Next. The Query Wizard – Sort Order screen appears as shown below:
   
10. Select Ascending or Descending for each drop down list under Sort by, as required.
11. Click Next. The Query Wizard – Finish screen appears as shown below:
    
12. Select the option Return Data to Microsoft Office Excel.
13. Click Finish. The Import Data screen appears as shown below:
    
14. Click OK. The Microsoft Excel sheet with the imported data appears as shown below:
    

You can export the Sundry Debtor and Sundry Creditor ledgers to a newly created company.

1. Gateway of Tally > Chart of Accounts > Ledgers.
2. Press Alt+H (Multi-Masters) > Multi Alter > select Sundry Debtor/Sundry Creditor from the List of Groups.
3. Press F3 (Company).
4. Select the new company.
5. In the Multi Ledger Alteration screen, press Ctrl+A to save the creditor/debtors ledgers in the new company.

With Open Database Connectivity (ODBC), you can exchange data between TallyPrime and any other application.

The bitness of the following three important elements determines Export of data via ODBC.

1. TallyPrime
2. Operating System
3. Microsoft Office

For seamless functioning of this ODBC feature, it is essential that these three elements are of the same bitness.

Consider the scenario where the Operating System is 64-bit, TallyPrime is 64-bit and MS Office is 32-bit. Then, by default, Microsoft Excel will not be able to communicate to TallyPrime as it is of a different bitness. To enable data export, installation of the required drivers is needed.

To install the required drivers to enable export of data via ODBC,

1. Open the TallyPrime application folder.
2. This folder will contain the files – regodbc32.exe and tallywin32.dat.
3. Right click the regodbc32.exe and select the option Run as Administrator to install 32-bit ODBC drivers.

Yes, it is possible to store the file on the desktop or any other location by specifying the required path or folder in the Folder Path field of Export screen.

Exporting the Masters and Vouchers separately, and then import them into another company individually is slow and time consuming. Hence, you can export both Masters and Vouchers together. This option is available while exporting the Day Book or all registers. To export the dependent masters and vouchers:

1. Gateway of Tally > Day Book.
   Alternatively, press Alt+G (Go To) > type of select Day Book > and press Enter.
2. Press Alt+E (Export) > Current.
3. Press C (Configure) > type or select Include dependent masters and press Enter to set it to Yes.
   
4. Press Esc to return to the Export screen.
5. Press E (Send) to export.

It is advisable that you do not alter the predefined masters in TallyPrime. If you require groups to be displayed in various reports, create new groups instead of altering the predefined masters.

It is possible to update Excel with the changes made to TallyPrime in real-time. This is possible only when ODBC connectivity is available.

The online update can be done automatically by setting the duration of auto-refresh rate in Excel by following the steps shown:

1. Click Data.
2. Click Refresh All.
3. Select Connection Properties.
4. By default, Refresh every is checked.
5. Enter the duration in minutes in Refresh every field. TallyPrime will automatically send the data to excel at the specified duration.
   
6. Click OK.

Yes, there is an option to automatically open the exported file in TallyPrime.

1. From any report, press Alt+E (Export) > Current. The Export screen appears.
2. Press C (Configure) > select Show More and press Enter.
3. Set the option Open folder after Export to Yes to automatically open the folder or file immediately after export.
   
   Files exported to Excel, JPEG (single page), HTML and PDF formats open automatically. Whereas for ASCII, JPEG (multi-page), XML and SDF formats, only the folders open.

To enable SDF format for export/import:

1. Open the Tally.ini file and set the option User TDL to Yes.
2. In the next line, remove the semicolons (;;) in TDL and enter the name of the TCP file (i.e., tdl = SDFExportImport.tcp)
3. Save Tally.ini and start TallyPrime. You can now view the SDF format while performing an Export/Import.

You can know the GUID by exporting any voucher from Daybook in XML format.

Open the exported file in notepad, find the word GUID using Ctrl+F function. You will find a 36 character length alpha numeric string enclosed within (hexadecimal value).

For example, f64a4e48-950f-46f0-90f6-6c054a22fa68-00000002

In the above example, GUID of the company is “f64a4e48-950f-46f0-90f6-6c054a22fa68” and the last part “00000002” identifies the voucher.

To view this option, press Alt+O (Import) > Configuration.

You can set the option Overwrite voucher when a voucher with same GUID exists to Yes/No, while importing vouchers into TallyPrime.

Impact of this option is given below:

No. The option Export closing balance as opening balance is supported only in XML and SDF formats.

Reports exported in HTML, PDF, and JPG formats support company logo.

You can export the data in SDF format.

1. Press F1 (Help) > TDL & Add-On > press F4 (Manage Local TDLs).
2. In the TDL Configuration screen, set Load selected TDL files on startup to Yes.
3. Select the TDL File Name from the path or the folder where the TDL file is stored.
4. Set Load TDL to Yes.
5. Start TallyPrime.

In the export configuration screens and you will have the option SDF format along with other available formats.

While exporting the data/report/invoice, specify the export location. TallyPrime creates the folder and exports data to the specified location.

The major difference in Restricted (ASCII) and Default (All Languages) is enumerated in the below table.

Yes, it is possible to perform a one-way snapshot based on the type of sync mentioned in the client rule.