Training By Himanshu

Tag: tally xml structure

  • Common Errors in Tally ERP 9 and Tally Prime and How to Fix Them: Step-by-Step Troubleshooting Guide with Practical Examples, Tables, and Complete Solutions

    Tally ERP 9 and Tally Prime are among the most widely used accounting and ERP software by small and medium-sized businesses across India. More than 2 million users depend on Tally for financial accounting, GST compliance, payroll management, inventory management, and reporting. While Tally is highly stable, fast, and reliable, users often encounter common errors due to incorrect settings, wrong configurations, corrupted data files, network problems, or improper voucher entries.

    Understanding these common issues and knowing how to fix them ensures smooth accounting operations, accurate financial reporting, and uninterrupted workflow. This article provides a detailed list of frequent Tally errors along with step-by-step solutions. It also includes examples, explanations, a two-column table for clarity, and best practices to prevent errors.

    Why Do Errors Happen in Tally?

    Errors in Tally usually occur due to:

    1. Incorrect data entry
    2. Damaged or corrupted company data
    3. Improper shutdown or power failure
    4. Incorrect voucher type selection
    5. Mismatch in GST settings
    6. Network and multi-user configuration issues
    7. Ledger misclassification
    8. Version incompatibility
    9. Security control misconfiguration
    10. Use of outdated Tally version

    With more than 500 different error combinations identified over years, the majority fall into predictable patterns that can be easily fixed.

    Table: Common Errors in Tally and Their Basic Causes

    ErrorBasic Cause
    Tally Data CorruptedSystem crash, improper shutdown, virus, bad sectors
    Voucher Type Not AllowedIncorrect voucher configuration
    Incorrect GST CalculationWrong ledger settings or missing GST rate
    Unable to Locate CompanyWrong data path or deleted folder
    Error Code 407: File DamagedData corruption
    Error “Voucher Number Already Exists”Duplicate voucher number entries
    TDL ErrorWrong customization code or missing TDL file

    Detailed List of Common Tally Errors and How to Fix Them

    1. Tally Data Corruption Error

    This is one of the most common issues users face, especially when systems are not shut down properly.

    Symptoms:

    • Error code 407
    • Company fails to load
    • Sudden shutdown of Tally

    How to Fix:

    1. Open Tally → Select Company Info.
    2. Choose “Repair” (in Tally Prime) or “Rewrite Data” (in Tally ERP 9).
    3. Select the data path and company folder.
    4. Follow on-screen repair process.

    In more than 80 percent of cases, data repair restores the company successfully.

    2. Incorrect GST Calculation

    GST-related issues happen when ledgers or items are not configured properly.

    Symptoms:

    • Tax not calculated
    • Wrong GST amounts
    • GSTR-1 mismatch
    • ITC mismatch

    How to Fix:

    1. Enable GST from F11 → Statutory Features.
    2. Check ledger:
      • Set “Is GST Applicable: Yes”
      • Correct GST rate
      • Correct Taxability (Taxable, Nil Rated, Exempt)
    3. For items:
      • Enable GST for stock items
      • Enter HSN
      • Enter applicable GST rate
    4. Re-enter voucher to auto-calculate GST.

    More than 60 percent GST issues are caused by wrong ledger tax classification.

    3. Voucher Number Already Exists

    This happens when Tally tries to save two vouchers with the same number.

    How to Fix:

    1. Go to F11 → Voucher Configuration → Set “Use Automatic Numbering: Yes”.
    2. Or manually change voucher numbers.
    3. Remove duplicate entries by checking Day Book (Display → Day Book).

    Around 25 percent of sales and purchase mismatches occur due to duplicate voucher numbering.

    4. Error “Company Not Found” or Missing Company

    This occurs when the company folder is not in the correct Tally data path.

    How to Fix:

    1. Press F1 (Select Company).
    2. Check the data path displayed at top-right.
    3. Verify company folder exists in that path.
    4. If not, browse to the correct data location manually.
    5. Recreate the data path if necessary.

    Many businesses store Tally data on external disks, which frequently causes this error.

    5. Tally Crashes While Opening

    A crash usually points to version issues or system conflicts.

    How to Fix:

    1. Update Tally to the latest release.
    2. Restart system.
    3. Disable background applications that may conflict.
    4. If crash persists, delete the Tally configuration file (Tally.ini) and reconfigure.

    Updating Tally resolves more than 70 percent crash issues.

    6. Error in File Access or Permission Denied

    This happens when Tally cannot access the data folder due to security restrictions.

    How to Fix:

    1. Go to folder properties.
    2. Give full permission to all users.
    3. Remove “Read Only” option.
    4. Disable antivirus restrictions temporarily.

    Multi-user environments are most prone to permission errors.

    7. Error Code 214 or 288 Related to Network Issues

    These errors generally occur in tally.net or multi-user setups.

    How to Fix:

    1. Check internet connectivity.
    2. Restart Tally Gateway Server (for multi-user).
    3. Check firewall settings.
    4. Ping the server system IP to ensure connectivity.

    In many offices, IP conflict is the root cause of Tally network errors.

    8. Incorrect Ledger Grouping

    Wrong classification leads to wrong reports and mismatches in Balance Sheet or P&L.

    How to Fix:

    1. Open the ledger.
    2. Check the “Group” field.
    3. Correct the group to appropriate classification.
    4. Recheck Balance Sheet and Trial Balance.

    Incorrect grouping leads to more than 30 percent reconciliation issues in businesses.

    9. Error “Voucher Type Not Allowed”

    This occurs when voucher type settings disable certain entries.

    How to Fix:

    1. Go to Accounts Info → Voucher Types.
    2. Check “Use in voucher entry”.
    3. Enable numbering and configurations.
    4. Save settings.

    10. TDL Errors

    These occur due to wrong external TDL files.

    How to Fix:

    1. Go to F1 → Settings → TDL Configuration.
    2. Remove invalid TDL path.
    3. Reload Tally.
    4. Add correct custom TDL file if necessary.

    More than 40 percent TDL errors occur due to outdated customization code.

    How to Prevent Errors in Tally: Best Practices

    1. Always close Tally properly.
    2. Take regular data backup.
    3. Enable Tally Audit.
    4. Use licensed version only.
    5. Keep Tally updated.
    6. Train staff to avoid common data entry mistakes.
    7. Keep antivirus updated to avoid corruption.
    8. Use UPS to prevent power failure issues.
    9. Maintain version history folder for safety.

    More than 90 percent Tally issues are preventable with simple precautions.

    Conclusion

    Errors in Tally ERP 9 and Tally Prime can disrupt accounting operations, affect GST filing, and delay reporting. However, with the right understanding, most of these errors can be fixed easily without external help. Whether it is data corruption, GST mismatch, voucher duplication, or network trouble, each issue has a structured solution within Tally. A disciplined approach, proper configurations, regular backups, and updated software can ensure seamless accounting experience for businesses.

    Disclaimer

    This article is provided for educational and informational purposes only. Tally software versions, error codes, and solutions may vary based on updates, business configurations, and system environments. Users must verify steps according to their Tally version and business requirements.

  • How to Import Excel Data into Tally Prime Step-by-Step: Complete Guide with Formats, XML Mapping, Ledger Import, and Troubleshooting

    Tally Prime is one of the most widely used accounting software tools in India for managing business transactions, inventory, ledgers, GST, and financial reports. Many businesses maintain their transactional data initially in Excel because it is flexible, fast, and easy to use. However, manually entering every entry into Tally Prime can consume a lot of time and increase the chances of errors.
    To solve this, Tally Prime offers powerful import features that allow users to bring Excel data directly into Tally using XML formats.

    In this article, we will explain the complete process of importing Excel data into Tally Prime, including ledger import, voucher import, stock item import, mapping fields, and common errors with their solutions.

    This detailed guide is designed for accountants, business owners, Tally users, data entry operators, and MIS professionals.

    Why Import Data into Tally Prime from Excel

    Before learning the import process, it is important to understand why businesses rely so much on Excel-to-Tally automation.

    Benefits

    1. Saves 60 percent time in data entry
    2. Reduces manual errors
    3. Ensures accurate accounting
    4. Helps businesses migrate old records
    5. Useful for bulk entries
    6. Perfect for GST sales-purchase upload
    7. Allows importing ledgers, stock, and vouchers

    According to industry data, nearly 72 percent of SMEs prefer maintaining draft entries in Excel before importing into Tally.

    Types of Data You Can Import into Tally Prime from Excel

    Tally Prime allows importing almost all major accounting components.

    Data TypeImport Possible
    Ledger MastersYes
    Stock ItemsYes
    Cost CentresYes
    Employee MastersYes
    Sales VouchersYes
    Purchase VouchersYes
    Receipt/Payment VouchersYes
    Journal VouchersYes
    Inventory VouchersYes
    Opening BalancesYes

    This makes Tally Prime extremely powerful for businesses moving from Excel-based systems to digital accounting.

    Understanding Tally XML Format

    Tally does not import Excel files directly. It first converts Excel data into an XML format that Tally can understand.

    Excel File → XML Format → Import into Tally Prime

    XML stands for Extensible Markup Language, and Tally uses this structure to read voucher entries, ledger names, inventory details, and opening balances.

    Basic XML Example Structure: <ENVELOPE> <HEADER> … </HEADER> <BODY> <IMPORTDATA> <TALLYMESSAGE> <LEDGER> … </LEDGER> </TALLYMESSAGE> </IMPORTDATA> </BODY> </ENVELOPE>

    Each data type follows its own XML structure, which must be correctly mapped.

    Step-by-Step Process: How to Import Excel Data into Tally Prime

    Below is the complete method, including preparation, XML conversion, and importing into Tally.

    Step 1: Prepare Excel File Correctly

    Your Excel must be clean, structured, and consistent. These three rules must be followed:

    Rule 1: Avoid Blank Rows

    Tally will not read inconsistent data.

    Rule 2: Use Correct Headings

    For example, Ledger Import should have:

    FieldExample
    Ledger NameRam Traders
    Group NameSundry Debtors
    Opening Balance45000

    Rule 3: Keep Formats Consistent

    For example:
    Date should be in DD-MM-YYYY or DD/MM/YYYY only.
    Amount should be numeric only.

    Step 2: Convert Excel Data into XML

    Tally Prime only imports XML files.
    To convert Excel to XML, you need a structured XML template.

    Example XML structure for ledger import: <TALLYMESSAGE> <LEDGER NAME=”Ram Traders”> <PARENT>Sundry Debtors</PARENT> <OPENINGBALANCE>45000</OPENINGBALANCE> </LEDGER> </TALLYMESSAGE>

    For voucher import, use voucher tags: <VOUCHER VCHTYPE=”Sales” ACTION=”Create”> <DATE>20240115</DATE> <NARRATION>Sale to Ram Traders</NARRATION> <LEDGERNAME>Ram Traders</LEDGERNAME> <AMOUNT>15000</AMOUNT> </VOUCHER>

    Your XML file must follow Tally’s structure.

    Step 3: Enable Import Options in Tally Prime

    In Tally Prime:

    Go to:
    Gateway of Tally → Import Data → Masters / Vouchers

    You will see two main options:

    1. Import Masters
    2. Import Vouchers

    Select the option based on what you are importing.

    Step 4: Choose XML File Location

    Tally will ask for:

    Name of XML file:
    Enter full file name along with .xml extension.

    For example:
    ledgerimport.xml
    voucher_sales.xml
    stockitems.xml

    Step 5: Select Import Behaviour

    You must choose one of the following:

    1. Modify All
    2. Combine Duplicates
    3. Ignore Duplicates

    Most businesses use Combine Duplicates.

    Step 6: Complete Import

    After import:

    Tally displays a message:
    Data Imported Successfully

    If any errors occur, Tally will generate an error file.
    You can open it to see which line caused the issue.

    Importing Ledger Masters from Excel

    Ledger imports are the most common.
    Excel structure should be like:

    FieldExample
    Ledger NameA1 Suppliers
    GroupSundry Creditors
    Opening Balance85000

    XML Structure for Ledger Import

    <TALLYMESSAGE> <LEDGER NAME=”A1 Suppliers”> <PARENT>Sundry Creditors</PARENT> <OPENINGBALANCE>85000</OPENINGBALANCE> </LEDGER> </TALLYMESSAGE>

    After generating XML, import via:
    Gateway of Tally → Import Data → Masters

    Importing Stock Items from Excel

    Excel structure:

    FieldExample
    Stock NameUSB Cable
    GroupElectronics
    Opening Qty120

    XML Structure: <STOCKITEM NAME=”USB Cable”> <PARENT>Electronics</PARENT> <OPENINGBALANCE>120</OPENINGBALANCE> </STOCKITEM>

    Importing Sales Vouchers from Excel

    Excel Structure:

    FieldExample
    Date15-01-2024
    LedgerRam Traders
    ItemUSB Cable
    Quantity5
    Rate300

    XML Voucher Structure: <VOUCHER VCHTYPE=”Sales” ACTION=”Create”> <DATE>20240115</DATE> <NARRATION>Sales Entry</NARRATION> <LEDGERNAME>Ram Traders</LEDGERNAME> <AMOUNT>1500</AMOUNT> <INVENTORYENTRIES.LIST> <STOCKITEMNAME>USB Cable</STOCKITEMNAME> <ACTUALQTY>5</ACTUALQTY> <RATE>300</RATE> <AMOUNT>1500</AMOUNT> </INVENTORYENTRIES.LIST> </VOUCHER>

    Common Errors During Import and How to Fix Them

    Problem: Ledger not found
    Solution: Ledger must be present in Masters or included in same XML file.

    Problem: Date format not accepted
    Solution: Use YYYYMMDD for vouchers.

    Problem: Group does not exist
    Solution: Ensure parent group is already created.

    Problem: Incorrect decimal or symbol
    Solution: Remove commas, spaces, or currency symbols.

    Problem: Item missing in voucher
    Solution: Create item in Masters before importing voucher.

    More than 60 percent import issues come from formatting errors in Excel.

    Tips for High-Accuracy Import

    1. Avoid merged cells in Excel
    2. Do not keep extra spaces in names
    3. Use clean data validation
    4. Test with 5 records before full import
    5. Keep backup of Tally company before importing
    6. Keep XML tags clean and properly closed
    7. Write date as text to avoid format issues

    These practices help prevent rejections during import.

    Advanced Import: Using TDL for Excel Upload

    Some companies customize their Tally using TDL (Tally Definition Language) to create direct Excel import options.
    This allows:

    Direct XLS import
    Item-wise mapping
    GST invoice import
    Excel-to-voucher automation

    But custom TDL depends on business requirements.

    Conclusion

    Importing Excel data into Tally Prime is one of the most effective ways to automate accounting processes. Through proper formatting, XML conversion, and accurate mapping, businesses can save hours of manual entry and ensure error-free accounting. Whether you need to import ledgers, stock items, or bulk sales vouchers, Tally Prime provides a powerful import engine that supports large datasets and streamlines the workflow.

    Once you master the XML structure and Excel formatting, importing data becomes a smooth and time-saving process.

    Disclaimer

    This article is for educational purposes only. All examples, XML structures, values, and formats are illustrative and created solely to explain the process of importing Excel data into Tally Prime.