• Prepare the excel file as per the prescribed Excel Formats for E-Commerce.
  (Download sample excel from the link available at bottom of the page)
• Save the excel file as per the prescribed Excel file types, such as sheet name and file type.

2. Load Excel File

• Connect ‘Tally Master – Excel to Tally’ with Tally ODBC.
• Go to E-Commerce menu and select Settlement or Sales Return in Amazon tab.
• Click the “Load Excel” button (at the bottom of the screen) and select your prepared excel file.
• Set the value in preload configuration for e-commerce for the required output in Tally and click Ok
• Next, follow Verify, Analyse and Configure procedures with loaded excel file, before import.

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

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