How do I Import Flipkart Tax Report to Tally

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 Sales

Voucher Numbering – Manual – Prevent Duplicate – YES

Voucher Type Flipkart Returns Under Credit Note

Voucher Numbering – Manual – Prevent Duplicate – YES

Ledger Flipkart.com Under Sundry Debtors

You 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 Accounts

Inventory Values effected = YES

Ledger Sales GST Interstate @ XX% Under Sales Accounts

Inventory Values effected = YES

Stock Items As per SKU column You can create as per SKU name or set as ALIAS
UOM As per Tally

GSTR1 Helper

  1. Error – “UoM not mapped with Unit Quantity Code (UQC)
    • Drill down to the error message and click on Map to UQC button and set the appropriate UQC from the list as per GST requirements, refer below snapshots
  2. Error – Getting Difference of Rs. 0.01 or similar in many transactions
    • This error occurs when tax values in excel data is coming in more than 2 decimals but Tally supports values in 2 decimals only
    • Considering the real life business scenarios to accept the mismatch forcefully, Tally has provided button ALT+A Accept as is to resolve and consider the given tax value in reports
  3. Error – Tax rate/tax type not specified
    • The possible reason for this issue is GST configuration has been not done in the Sales ledgers and Tax ledgers, please select appropriate GST tax type in Sales & GST ledgers to resolve this issue.

Important Note
  • 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
Updated on October 3, 2018

Article Attachments

Was this article helpful?

Related Articles

Comments

  1. i am trying to pay 270rs u have changed it to 540 plus gst.why pricing so much.

Add A Comment

Help-Desk