skip to Main Content
+91-9551052100 info@tallymaster.in

Features in Import Purchase Order Vouchers

 

 

How to Import Purchase Order Vouchers from Excel to Tally

Step 1 – Prepare Excel

  • Prepare the excel file as per the prescribed Excel Formats.
    (Download sample excel from the link available at bottom of the page)
  • Ensure that excel files are properly filled with all the mandatory fields, which are green colored in sample excel.
  • Save the excel file as per the prescribed Excel file types, such as sheet name and file type.

Step 2 – Load Excel and Verify Masters

  1. Connect ‘Tally Master – Excel to Tally’ with Tally ODBC
  2. Go to the “Accounts Vouchers” menu, click the “Purchase Order” form.
  3. Then click the “Load Excel” button (at the bottom screen), then select the prepared excel file.
  4. Once the file is selected, excel data will be loaded on the data grid screen.
  5. If the excel files are not in the proper format, users may get an error, those lists of errors can be verified.
  6. Use the data grid features, such as filter, search & group to analyse the loaded data.
  7. Click verify master button (at the bottom of the screen), where the connected master of the vouchers such as ledgers, stock items, godown, unit & voucher type of the loaded vouchers can be verified and missing masters can be created to tally directly.
  8. Click the configuration button (top right on the grid), to select the default voucher type, the account name for the loaded data.

Steps 3 – Upload to Tally

  • Once the verify master and configuration are completed, users may proceed to upload data to tally.
  • Users can upload all or selected vouchers to tally, using the check box on the left side.
  • Now click the “Upload to Tally” button to upload entries to Tally directly.
  • Check the import process and log details of records imported.

Steps 4 – Verify Import Status

  • During the process of import, in the data grid, the last column, “xmllog” will get updated with upload status from Tally.
  • After completion of all or selected lines, users will get the count statistics of data uploaded.
  • Users may refer to import log details in tally.imp file in the Tally.ERP9 or TallyPrime application installed folder.
Back To Top