Here is the comprehensive list of TallyPrime Data Import Errors and it’s solutions
Below is a practical, field-tested list of common errors faced during data import in TallyPrime, along with clear reasons and step-by-step solutions.
This is especially useful for Excel / CSV / XML imports and tools like Import2Books.
1. Ledger Does Not Exist
Error Message
Ledger does not exist
Party Ledger not found
Why it Happens
- Ledger name in Excel does not exactly match Tally ledger
- Extra spaces, spelling differences, or case mismatch
- Ledger not created in Tally
How to Solve
- Ensure exact ledger name matching (including spaces)
- Pre-create ledgers in Tally before import
- Use ledger auto-creation option (if your import tool supports it)
2. Voucher Type Does Not Exist
Error Message
Voucher Type not found
Invalid Voucher Type
Why it Happens
- Voucher type in Excel is different from Tally (e.g., “Sales Invoice” vs “Sales”)
- Custom voucher types not created in Tally
How to Solve
- Use standard Tally voucher names (Sales, Purchase, Receipt, Payment, Journal)
- Create custom voucher types in Tally before importing
3. Duplicate Voucher Number
Error Message
Duplicate voucher number
Voucher number already exists
Why it Happens
- Same voucher number already exists in Tally
- Manual numbering conflicts
How to Solve
- Enable Auto Voucher Numbering in Tally
- Ensure unique voucher numbers in Excel
- Import vouchers date-wise sequentially
4. Invalid Date Format
Error Message
Invalid Date
Date is not valid
Why it Happens
- Excel date format not supported by Tally
- Text-formatted dates instead of actual date values
How to Solve
- Use DD-MM-YYYY or YYYYMMDD format
- Ensure Excel column is set as Date, not Text
- Avoid mixed date formats in one column
5. Item / Stock Item Does Not Exist
Error Message
Stock Item does not exist
Why it Happens
- Item name mismatch
- Stock item not created in Tally
How to Solve
- Pre-create Stock Items and Units in Tally
- Ensure exact matching of Item Name & Unit
- Enable auto stock creation (if supported)
6. Unit of Measure Does Not Exist
Error Message
Unit does not exist
Invalid Unit
Why it Happens
- Unit mentioned in Excel is missing in Tally
- Different naming (Nos vs Pcs)
How to Solve
- Create Units in Tally (Nos, Pcs, Kg, Box, etc.)
- Keep unit names consistent across Excel & Tally
7. GST / Tax Ledger Not Found
Error Message
GST Ledger not found
Invalid Tax Ledger
Why it Happens
- GST ledgers not created
- Wrong tax rate ledger mapping
How to Solve
- Create GST ledgers (CGST, SGST, IGST) in Tally
- Ensure correct tax percentage mapping
- Verify GST nature of ledger
8. Amount Does Not Match / Debit Credit Mismatch
Error Message
Debit and Credit not equal
Amount mismatch
Why it Happens
- Journal vouchers not balanced
- Incorrect sign (+ / -) in Excel
How to Solve
- Ensure Total Debit = Total Credit
- Remove negative values unless required
- Validate totals before import
9. Company Not Loaded / Company Not Found
Error Message
Company not loaded
Invalid Company
Why it Happens
- Wrong company selected
- Company not opened in Tally
How to Solve
- Open the correct company in TallyPrime
- Ensure import tool is connected to the active company
10. Security / User Permission Error
Error Message
Permission denied
Access not allowed
Why it Happens
- Import attempted with restricted user
- Security control enabled
How to Solve
- Login as Admin / Owner
- Grant Import permissions to user
- Disable security temporarily during import
11. XML Structure Error
Error Message
Invalid XML
Parsing failed
Why it Happens
- Incorrect XML tags
- Broken structure or encoding issues
How to Solve
- Validate XML structure before import
- Use trusted import tools instead of manual XML
- Avoid special characters (&, <, >) without encoding
12. Duplicate Ledger Creation Error
Error Message
Ledger already exists
Why it Happens
- Ledger auto-creation enabled
- Same ledger already present
How to Solve
- Disable auto-creation for ledgers
- Use mapping instead of creation
13. Opening Balance Mismatch
Error Message
Opening balance difference
Why it Happens
- Incorrect debit/credit flag
- Wrong opening balance date
How to Solve
- Verify Dr/Cr flags
- Import opening balances on financial year start date
- Cross-check trial balance totals
14. GSTIN / Compliance Validation Error
Error Message
Invalid GSTIN
Compliance error
Why it Happens
- Wrong GSTIN format
- Extra spaces or missing characters
How to Solve
- Validate GSTIN (15 characters)
- Remove spaces & special characters
- Verify State code correctness
Best Practices to TallyPrime Data Import Errors
- Standardize Excel templates
- Pre-create Masters (Ledgers, Stock, Units, Taxes)
- Use professional import tools (like Import2Books.com)
- Test import with 5–10 records first
- Always take Tally backup before bulk import
- Use Auto Master creation option
For further assistance, call our support desk on +91 7710010372 or email us on support@import2books.com