Once the Mapping Template is created, import the data in TallyPrime by using the respective mapping template.
You might have Opening Balance stored in multiple columns, with or without column headers in the Excel file. Similarly, you might want to compute values from different columns in the Excel worksheet. In such cases, you can use the Compute Value mapping options for importing such data.
Let’s say you maintain an Excel sheet for entering the opening balances of your party accounts. You have separate columns for entering the debit and credit amount for each party and you want to import this list into TallyPrime.
In the Mapping Template Creation screen,
- Under Field (TallyPrime), select Ledger – Opening Balance to map with the column in your Excel file.
- Under Column Header (Excel), select Compute Value from the List of Column Headers.
The Compute Value for: Ledger – Opening Balance screen appears.
- Map the Column Headers and specify if the value is Debit or Credit and proceed for import.
After importing the data, you can verify the change in credit and debit amounts from Alt+G (Go To) > Trial Balance.
Once the Mapping Template is created, import the data in TallyPrime by using the respective mapping template.
Let’s say that you have maintained stock item details in Excel sheet as follows:
In case you want to use the details from the Column Headers Model and Size as the stock item name, you can map using the Compute Value option in the Import process.
In the Mapping Template Creation screen,
- Under Field (TallyPrime), select Name.
- Under Column Header (Excel), select Compute Value.
- Under Column Header (Excel), select the field values that you want to combine, for example, Model and Size.
- Map other relevant fields for the stock items and save the mapping template.
- Import the data using the saved template.
The Model and Size of the stock items appear as Name in the Chart of Accounts in TallyPrime.
There are certain fields in TallyPrime that accept only Yes/No as the input, like Maintain Balances bill-by-bill, Cost centres are applicable and more. In you Excel file, you may have entered values other than Yes/No which you want to map with the fields in TallyPrime.
Let’s say your Excel file has data as follows and you want to map the value for Maintain balances bill-by-bill:
In the Compute Value for: screen,
- Under Column Header (Excel), select Maintain Balances bill-by-bill.
- From the List of Conditions, select containing.
- Select the Cell Value, for example, Billwise in this case.
- Map other relevant fields for the ledgers and save the mapping template.
By using this option, you can easily map your Excel data to TallyPrime fields that accept logical values like Yes or No. It simplifies the process of importing data and ensures that your data is correct and consistent within TallyPrime.
Let’s say you have entered details of multiple parties in an Excel file, without specifying their Group, as they all belong to the same group – Sundry Debtors.
However, as you know that Group Name is mandatory during ledger entry, while importing you will need to specify the Group for the ledgers. You can use the Specify Fixed Field Value option while mapping the data to import such masters easily.
In the Mapping Template for Masters,
- Map the fields in TallyPrime with the corresponding column headers in your Excel worksheet.
- Under Field (TallyPrime) select Group Name and under Column Header (Excel), select Specify Fixed Field Value.
A List of Groups is displayed on the screen to provide you a seamless experience for mapping.
- From the List of Groups, select the Group Name that you want to consider as the fixed value while mapping the ledgers with TallyPrime, say Sundry Debtors.
As a result, all the parties in your Excel file will be systematically assigned to the specified group in TallyPrime, simplifying the data import process and ensuring that your ledger details are accurately organized for the import process.
on the parameters you select for creating the uniqueness, the masters or transactions will be created. When you import masters from an Excel file, TallyPrime by default creates masters based on each unique master Name.
Similarly, when you import vouchers from an Excel file, TallyPrime by default creates vouchers based on each unique Voucher Type Name, Voucher Date and Voucher Number.
However, you can choose the unique values based on which the masters or transactions should be created when importing data. Once you have mapped the fields with the Excel file, select the required option under Unique values for creating masters > Additional Options.
In case you do not see this option in the mapping template, press F12 (Configure) > Show Additional Options for creating Masters > Yes.
You can specify the conditions based on which data from one or more rows should be excluded while importing the data. Let’s say you have entered transaction details with parties in an Excel worksheet in the following manner:
Now, let’s say you want to exclude rows that contain the entries for Sunday.
In the Mapping Template Creation screen,
- Set the option Exclude Rows in Excel to Yes.
In case you do not see this option, press F12 (Configure) > set the option Exclude rows in Excel while importing Data as Yes.
- Select the Column Header where the data in the row is to be excluded.
- Select the Condition from the List of Conditions.
- Enter the value based on which you want to exclude the row while importing.
The screen for setting the Conditions for Excluding Rows appears, as shown below:
- Accept the screen and proceed with the importing your transactions into TallyPrime.
You can select more than one Column Header or more conditions for the same Column Header for excluding rows in the Excel worksheet.
By using this option, you can easily set conditions to filter out unwanted data during the import process. Whether you need to exclude rows based on dates, specific values, or other criteria, TallyPrime empowers you to tailor your data for importing.
In your business, the employee attendance details maybe stored in Excel files by the Admin/HR department or in an Attendance Machine by Biometric. To process the salaries, you may often need to transfer this data to the Accounts department. With TallyPrime’s Import feature, you can seamlessly import attendance details from Excel files into TallyPrime.
For example, if your employee attendance data is recorded in the following format:
You can create a separate mapping template for each Attendance Type (Absent, Present and Leaves). The value of each Attendance Type will be recorded in separate vouchers.
Mapping Templates for Employees:
Absent
Present
Leaves
Set the option Unique values for creating vouchers as Every Blank Row. This will create single Voucher Type for each Attendance.
Once the Mapping Template is created, import the data in TallyPrime by using the respective mapping templates for the attendance data.
