skip to Main Content


There two variety of excel templates structured for import journal vouchers

  1. Columnar format
  2. Multi line format

Step to Import from Excel

  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 “Journal”
  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