In this article you will learn how to import Flipkart Sales & Sales Return data to Tally.ERP9 using Flipkart Tax Report file.
Watch Demo Video
Follow Step by Step Process
1. Login in to your Excel2Tally.in account
2. Select Template “Flipkart Tax Report”
3. Click “Process Data”
4. Add Company & Select Template.
5. Download Sample file format
Let me explain to you, How to download above format from Flipkart Seller Central
6.Login into your Flipkart seller account
7.Go to REPORTS and click on Report Centre
8. Click on Types of Reports & Select TAX REPORTS
9. Select SALES REPORT
10.Select the date & Click on GENERATE.
11. File downloaded from the flipkart will be having 3 sheets as below
1)Help
2)Sales Report
3) Cash Back Report
You are required to copy & use the data only from SALES REPORT
12.You are required to Add a column UOM
Remove Extra Space from the Column Name Order Approval Date & Seller Share
13. Once you are ready with your excel data then Choose file and Upload Excel
STEP – 1
14.Now Click Process Excel
STEP – 2
15. Now Click Download XML
STEP – 3
16. Now import the converted XML to Tally, using option import data > Vouchers
17. 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 | Name in Tally | Additional info |
Voucher Type | Flipkart Sales | Under SalesVoucher Numbering – Manual – Prevent Duplicate – YES |
Voucher Type | Flipkart Returns | Under Credit NoteVoucher Numbering – Manual – Prevent Duplicate – YES |
Ledger | Flipkart.com | Under Sundry DebtorsYou can set as ALIAS to your existing ledger |
Ledger | Flipkart Seller Share | Under Indirect Expense or Sales |
Ledger | Flipkart Bank Offer Share | Under Indirect Expense or Sales |
Ledger | Shipping Charges | Under Indirect Expense or Sales |
Ledger | CGST @ XX% | Under Duties & Taxes |
Ledger | SGST @ XX% | Under Duties & Taxes |
Ledger | IGST @ XX% | Under Duties & Taxes |
Ledger | Sales GST Local @ XX% | Under Sales AccountsInventory Values effected = YES |
Ledger | Sales GST Interstate @ XX% | Under Sales AccountsInventory Values effected = YES |
Stock Items | As per SKU column | You can create as per SKU name or set as ALIAS |
UOM | As per Tally |
Important Note
- Please make sure that ledger masters & item masters are already exist in your tally data
- If possible create separate Flipkart Tax Report voucher type with voucher numbering method manual & prevent duplicate = YES
- Option “Ignore errors during data import” should be YES. Find this option on Gateway of Tally > Press F12 > General