skip to Main Content

Procedure for Import Sales Vouchers

Excel Template Model

  • There are different variety of excel templates are structured to upload various types of data formats from excel.
  • Excel templates are enabled with columnar and multi line ledgers, stock items and vouchers methods.
  • Refer invoice templates for more details.

Validation Rules for Excel file

  1. Check here for Common Procedure for Vouchers Import.
  2. Verify Master, connected master of the sales vouchers, such as; ledgers and stock items of the loaded excel can be verified and created to tally directly and automatically.

Steps to Upload to Tally

  1. Ensure that Tally Master App is connected to Tally thru ODBC
  2. Go to Accounts Voucher menu, click “Sales”
  3. In the bottom, click “Load Excel”, select your sales vouchers updated excel file and it would be loaded on the screen.
  4. Use Verify Master button for verifying the availability of ledgers between Excel sheet with company connected in Tally.
  5. Configuration (top right on the grid), to select the default voucher type, if multiple vouchers are created and used in Tally.
  6. Now click “Upload to Tally” button to import entries to Tally directly.
Back To Top