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

Features in import Flipkart MTR (Sales & Return) Vouchers

Both Sales and Sales Return can be imported from Flipkart MTR reports.
Both B2C and B2B transactions for sales and sales returns can be imported.
See advanced Smart Features for Import E-commerce Vouchers.

Prerequisites in Tally before import

Sales ledger to be exist. Example: Sales Flipkart or Sales GST
Flipkart ledger to be exist. Example: Flipkart or Flipkart Internet Services Pvt Ltd
Sales and Credit Note voucher type should exist. Example: Sales Flipkart , Credit Note Flipkart
Read the Suggested Accounting Methods in Tally for E-Commerce.

Smart Features for E-Commerce

How to Import Flipkart Sales Vouchers from Excel to Tally

1. Prepare Excel File

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

Download Sample Excel

Import E-Commerce Vouchers

How to import from Excel to Tally

Related Help Topics