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

Import all type of accounting transactions in single excel formats using Daybook features in Tally Master.

  • All vouchers can be imported
  • Invoice mode or Accounts mode can be selected
  • Auto indexing of ledger with respective voucher type

How to Import Daybook Vouchers from Excel to Tally

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 columns.

2. Load Excel and Analyse Data

3. Verify Masters and Configuration

  • Click Verify Masters button (at the bottom of the screen), to check the existence of connected masters of the voucher.
    (Example: ledgers, cost centre, stock items, godown, units, voucher type & etc. can be verified and missing masters can be created automatically.)
  • Click the Configuration button (top right on the grid), to select the default voucher type and additional details.

4. Upload to Tally

  • Now Upload all or Selected Vouchers to tally.
    (Use check box on the left side in the data grid)
  • Now click the “Upload to Tally” button to upload entries in to Tally directly.

5. Verify Import Status

  • Check the Import Process, Log and Report for details of records imported.
  • After upload is completed, users shall check the Tally and verity the same.
Back To Top
Select your currency
INR Indian rupee