In this article you will learn how to Import Flipkart 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 NoteVoucher numbering – Manual – Prevent Duplicate = YES |
| Voucher Type | Flipkart Settlement | Under – JournalVoucher 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