Steps to Use the Excel to Tally Voucher Import App

Step 1: Download the Template

  • Obtain the Template:
    • Visit the tool and find the section where you can download the template.
    • Download the provided Excel template, which contains the required format and necessary columns for your vouchers.

Step 2: Fill in the Template

  • Enter Voucher Details:
    • Open the downloaded Excel template.
    • Carefully enter the voucher details in the respective columns. Ensure all required fields are filled out. The necessary columns typically include DATE, VOUCHER TYPE, STANDARD NARRATION, VOUCHER NUMBER, REFERENCE NUMBER, LEDGER NAME, DR/CR, EFFECT, and AMOUNT.
    • Save the completed template on your computer.

Step 3: Upload the Template

  • Open the Voucher Import Tool:
    • Go to the tool in your browser.
    • Locate the file uploader section.
  • Upload the Completed Template:
    • Click on the upload button and select the completed Excel template from your computer.
    • Ensure the file size is within the allowed limit (usually less than 1MB).
    • The tool will automatically start processing the file after the upload.

Step 4: Validate and Preview Data

  • Data Preview:
    • After the upload, the tool will display a preview of the data from your Excel file.
    • Carefully review the preview to ensure all details are correct.
  • Check for Errors:
    • The tool will automatically validate the data.
    • If any errors are found, they will be listed in detail.
    • Correct the errors in your Excel file, save it, and re-upload the corrected file.
    • Repeat this process until there are no errors.

Step 5: Generate and Download XML

  • Process the Data:
    • Once the data is validated and there are no errors, you will see an option to process the data.
    • Click the “Process and Generate XML” button.
  • Download the XML:
    • The tool will generate the XML file required for importing into Tally.
    • Download the generated XML file to your computer.

Step 6: Import the XML into Tally

  • Open Tally Software:
    • Open your Tally software and navigate to the import section.
  • Import Data:
    • Choose the option to import data and select the downloaded XML file.
    • Follow the prompts in Tally to complete the import process.
    • Verify that the vouchers have been imported correctly.