2. Load Excel and Analyse Data

• Connect ‘Tally Master – Excel to Tally’ with Tally ODBC
• Go to the “Accounts Vouchers” menu, click the “Bank Statement” form.
• Click the “Load Excel” button (at the bottom screen) and select the prepared excel file.
• If the excel file is not loaded and any error pop-ups, check the Lists of Common Errors for rectification.
• Use the Data Grid Features, such as filter, search & group to analyse the loaded data.

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