1. Home
  2. Accounting Solutions for eCommerce Sellers
  3. Flipkart to Tally.ERP9
  4. How do I Import Flipkart Commission & Settlement data to Tally?

How do I Import Flipkart Commission & Settlement data to Tally?

In this article you will learn how to Import Flipkart Commission & Settlement from Excel To Tally without technical skills.

You can import Order wise settlement in Tally.ERP9 and it helps you to identify order wise amount received and commission deducted in Tally.

Watch Demo Video

Follow Step by Step Process

1. Login in to your Excel2Tally.in account

 

2. Select Template “Flipkart Commission”and/Or “FlipkartSettlement”

3. Click “Process Data” 

4. Add Company & Select Template.

5. Download Sample file format

6. Once you are ready with your excel data then Choose file and Upload Excel

      STEP – 1 

7.Now Click Process Excel

         STEP – 2

8. Now Click Download XML

       STEP – 3

9. Now import the converted XML to Tally, using option import data > Vouchers

10. In case data is not imported in Tally than check Tally.imp file for data import log report.

Create following masters in Tally

Master Type Tally Name Additional info
Voucher Type Flipkart Commission Under – Credit Note

Voucher numbering – Manual – Prevent Duplicate = YES

Voucher Type Flipkart Settlement Under – Journal

Voucher numbering – Manual – Prevent Duplicate = YES

Ledger Flipkart Internet Pvt. Ltd. Under – Sundry Debtors

 

Create new ledger or set as Alias to existing ledger

Ledger Flipkart Settlement Account Under – Current Assets
Ledger Commission (Flipkart) Under – Indirect Expenses or as suggested by your CA
Ledger Commission Fee Waiver(Flipkart) Under – Indirect Expenses or as suggested by your CA
Ledger Collection Fee (Flipkart) Under – Indirect Expenses or as suggested by your CA
Ledger Collection Fee Waiver(Flipkart) Under – Indirect Expenses or as suggested by your CA
Ledger Fixed Fee  (Flipkart) Under – Indirect Expenses or as suggested by your CA
Ledger Fixed Fee Waiver(Flipkart) Under – Indirect Expenses or as suggested by your CA
Ledger No Cost Emi Fee Reimbursement(Flipkart) Under – Indirect Expenses or as suggested by your CA
Ledger Installation Fee (Flipkart) Under – Indirect Expenses or as suggested by your CA
Ledger Uninstallation Fee (Flipkart) Under – Indirect Expenses or as suggested by your CA
Ledger Tech Visit Fee (Flipkart) Under – Indirect Expenses or as suggested by your CA
Ledger Uninstallation & Packaging Fee (Flipkart) Under – Indirect Expenses or as suggested by your CA
Ledger Pick And Pack Fee Under – Indirect Expenses or as suggested by your CA
Ledger Pick And Pack Fee Waiver(Flipkart) Under – Indirect Expenses or as suggested by your CA
Ledger Customer Shipping Fee Under – Indirect Expenses or as suggested by your CA
Ledger Shipping Fee (Flipkart) Under – Indirect Expenses or as suggested by your CA
Ledger Reverse Shipping Fee (Flipkart) Under – Indirect Expenses or as suggested by your CA
Ledger Shipping Fee Waiver(Flipkart) Under – Indirect Expenses or as suggested by your CA
Ledger Franchise Fee (Flipkart) Under – Indirect Expenses or as suggested by your CA
Ledger Product Cancellation Fee (Flipkart) Under – Indirect Expenses or as suggested by your CA
Ledger Service Cancellation Fee(Flipkart) Under – Indirect Expenses or as suggested by your CA
Ledger Fee Discount (Flipkart) Under – Indirect Expenses or as suggested by your CA
Ledger Taxes (Flipkart) Under – Duties & Taxes or as suggested by your CA
Ledger Other charges 1 Under – Indirect Expenses or as suggested by your CA
Ledger Other Charges 2 Under – Indirect Expenses or as suggested by your CA

Important Note

– Please make sure that the ledger masters already exist in your tally data

– Option “Ignore errors during data import” should be YES. Find this option on Gateway of Tally > Press F12 > General

Updated on October 1, 2018

Article Attachments

Was this article helpful?

Related Articles

Add A Comment

Help-Desk