skip to Main Content

Excel Template Model

There two variety of excel templates structured for import receipt vouchers

  1. Multi Ledger Columnar
  2. Single Ledger Multi line

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. Check here for Common Procedure for Vouchers Import
  3. Ensure that excel file prepared with proper validation
  4. Go to Accounts Voucher menu, click “Receipt”
  5. In the bottom, click “Load Excel”, select your sales vouchers updated excel file and it would be loaded on the screen.
  6. Use Verify Master button for verifying the availability of ledgers between Excel sheet with company connected in Tally.
  7. Configuration (top right on the grid), to select the default voucher type, if multiple vouchers are created and used in Tally.
  8. Now click “Upload to Tally” button to import entries to Tally directly.
Back To Top