Download Mapping Templates for Data Entries Applicable in E-commerce Businesses
You also have the option to download Excel worksheet with prefilled column headers and templates already mapped to the worksheet.
The following table lists the sample files that can be used for recording data, especially if you are into e-commerce or online retail industries.
| Sl No. | E-commerce/ Other Software | Zip Files |
| 1. | Amazon | Amazon B2B |
| 2. | Busy | Busy |
| 3. | Marg | Marg |
| 4. | Odoo | Odoo |
| 5. | QuickBooks Desktop | QuickBooks Desktop |
| 6. | QuickBooks Online | QuickBooks Online |
| 7. | Sage | Sage |
| 8. | Shopify | Shopify |
Step 1: Click the required sample file to download.
- You can download more than one zip files, if needed.
- You can also reach this table by selecting the Other Templates/Sample Files option available from the Import Masters or Import Transactions screen.
Step 2: Unzip the file in the downloaded folder.
Step 3: Move the mapping template (.tsf file) to the excelmaps folder under the TallyPrime application folder.
This is needed to list the mapping templates under the List of Mapping Templates, while you select the template for importing data from Excel. It is also recommended that you keep a backup of these templates in a separate folder.
Just fill in the worksheet with relevant data based on your day-to-day transactions or master details, and import using the mapped templates. Moreover, you can use the Excel files as is or make any necessary modifications to record data and alter the corresponding mapping files as needed.
If you are downloading the TSF files for Other Templates/Sample Excel Files for the first time, you must manually create the config > excelmaps folder under the TallyPrime installation folder.
Ensure that you check the Templates and Sample Excel Files and alter them according to the data that you want to import into TallyPrime.
