+91-9551052100 info@tallymaster.in Download Pay Help

Features in Import Payment Vouchers

Multiple Excel Formats for Receipt & Payment are available to import
Smart voucher features available for auto grouping, indexing, voucher type selection and etc.
Advanced accounting features for vouchers, such as multi-currency, bill details, cost centre and etc.

How to Import Payment 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

Connect ‘Tally Master – Excel to Tally’ with Tally ODBC
Go to the “Accounts Vouchers” menu, click the “Payment” 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.

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.

Download Sample Excel

Related Topic for Import Vouchers

Related Topic for Import Masters

Smart Features for Import

Import Vouchers How to import from Excel to Tally