How to Import Masters and Transactions from Excel in TallyPrime
Entering hundreds of ledgers, stock items or transactions manually can take a lot of time. TallyPrime allows you to import masters and transactions from Excel using predefined sample files or mapping templates.
Version note: This guide is for TallyPrime Release 7.0+. Menu names and options may vary slightly in other releases.
What can you import from Excel?
- Ledger masters
- Stock items
- Groups and units
- Customers and suppliers
- Sales, purchase and other transactions
Before importing transactions, make sure the required masters, such as ledgers, groups, stock items and units, are already available in the company.
Before you begin
- Take a verified backup of the company.
- Test the import in a backup or test company first.
- Check the Excel file for duplicate names, blank mandatory fields and incorrect formats.
- Confirm that the company features match the data being imported.
- Enable bill-wise details if you are importing outstanding transactions.
Sample Excel file vs mapping template
Sample Excel file
A sample Excel file already contains columns arranged for TallyPrime. Use it when you want a faster and simpler import process.
Mapping template
A mapping template is useful when your existing Excel file has a different column structure. You can map Excel columns to the corresponding TallyPrime fields.
Step 1: Prepare the Excel file
- Download the required sample Excel file or prepare your own workbook.
- Enter the data in the correct worksheet.
- Do not rename or remove mandatory column headers from a sample file.
- Check dates, quantities, rates, GST details and ledger names.
- Remove unnecessary blank rows and duplicate records.
- Save the workbook in Excel format.
Mandatory fields are usually identified in the sample file. Read the ReadMe worksheet before entering data.
Step 2: Open the Import screen
- Open the required company in TallyPrime.
- Press Alt+O to open Import.
- Select Masters or Transactions.
- Specify the Excel file path.
Import masters before transactions when the transactions depend on new ledgers, stock items or other masters.
Step 3: Configure the import
Review the import settings before proceeding. Depending on the selected data type, configure the file path, worksheet, mapping template, behaviour when a master already exists, exception handling, backup and import batch size.
For existing masters, choose the appropriate behaviour instead of blindly creating duplicates.
Step 4: Preview the import
Use the preview or import summary to check the number of records that will be imported. Look for missing fields, duplicate names, invalid GST details and unmatched ledgers.
Step 5: Import the data
- Confirm the file and import configuration.
- Enable backup if the option is available.
- Press I or select Import.
- Wait until TallyPrime completes the process.
- Review the import summary and exceptions report.
How to resolve import exceptions
- Missing master: Create or import the required group, ledger, item or unit first.
- Duplicate master: Correct the name or select the required existing-master behaviour.
- Invalid date: Use the date format expected by the Excel template.
- GST error: Check GSTIN, state, HSN/SAC and tax-rate details.
- Incorrect amount: Verify quantity, rate, discount and tax columns.
- Wrong worksheet: Confirm that the selected worksheet contains the data-entry rows.
Verify the imported data
- Open Chart of Accounts and verify ledgers.
- Open Stock Summary and verify stock items and quantities.
- Open Day Book or Sales Register and check imported transactions.
- Review Trial Balance and outstanding balances.
- Check GST reports if GST data was imported.
- Compare the import summary with the number of rows in Excel.
Important safety tips
- Never import unverified data directly into the live company.
- Keep the original Excel file unchanged.
- Do not share files containing customer, bank or GST information publicly.
- Take a backup before importing large batches.
- After import, compare totals with the source file.
- Keep a copy of the mapping template for future imports.
Related TallyPrime guides
- How to Export TallyPrime Reports to Excel
- How to Backup and Restore Company Data in TallyPrime
- TallyPrime Troubleshooting
Conclusion
Excel import can save significant data-entry time when the workbook is prepared correctly. Import masters first, use a backup company for testing, review the preview and exceptions report, and verify the accounting and GST reports after import.
Always test the process with a small file before importing large volumes of business data.
No comments:
Post a Comment