Highlights of import of Flipkart settlement reportOrder ID wise settlement of Amazon ledgerAccounting of complete details of settlement entriesTracking of Commission, TCS & GST break up in settlementsHow to Import Flipkart Settlement Vouchers from Excel to Tally1. Prepare Excel FilePrepare 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 FileConnect ‘Tally Master – Excel to Tally’ with Tally ODBC.Go to E-Commerce menu and select Settlement or Sales Return in Flipkart 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 OkNext, follow Verify, Analyse and Configure procedures with loaded excel file, before import.3. Upload to TallyNow 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 StatusCheck 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 ExcelImport E-Commerce VouchersHow to import from Excel to Tally