093584-44502, 080038-49093    support@quick2tally.com

How to Import Flipkart Sales in Tally

QuikAccount provides you one click Import functionality for flipkart sales report. It gives you option to import both B2B and B2C reports. All the necessary calculations and formatting will be done by software itself. User only need to download Flipkart Sales excel file from https://seller.flipkart.com/sell-online/?login=true. Sales can be imported with all the necessary informations like inv no., reference no., order no. etc.

Steps showing How to Import Flipkart Sales Report in Tally

Step 1. Download Flipkart Sales report

1.    Login at https://seller.flipkart.com/sell-online/?login=true with your Email Id and Password.

2.    After login take your curson to Reports tab and choose Reports Centre option.

3.    Click on Create New Report.

4.    In report type choose Tax Report & in report sub-type choose Sales Report.

5.    Select the period and click on Generate button.

6.    Wait for few minutes, report will be generated and you can download then.

Step 2. Open QuikAccount & Connect Tally

(Click here to see How to Install & Activate software)

1.    Go to Help sheet and match Tally Port in Cell 'D4' with the port set in Tally.

     (Port in tally can be set by pressing F12 on Gateway of Tally --> Advanced Configuration)

2.   Now click "Connect Tally" button available on Help sheet.

Step 3. Import Sales Report in E-Com Sheet of QuikAccount

1.     Go to E-Com sheet and click on ‘Flipkart Sales’ button.

2.     Click yes when prompted to clear existing data.

3.     Select the relevant Flipkart Sales file downloaded from Flipkart Portal. Software will automatically import all data in E-Com sheet.

5.     Enter Flipkart Ledger Name (which exist in Tally) when prompted.

6.     Enter Sales Ledger Name (which exist in Tally) when prompted.

You can leave Flipkart and sales ledger name as blank and can fill later also.

Step 4. Sales/GST Ledger Mapping & Data Sorting

1.   Click on Ledger Mapping button, a mapping window will open.

2.   In mapping window, various drop downs are available wherein tally ledgers have been preloaded. Select the appropriate sales ledgers in relevant drop-down.

3.   Sales ledgers can be mapped on the basis of GST % and Nature of Transaction (Local or Inter-State)

4.   Similarly select the CGST, SGST, IGST ledgers for different GST rates.

5.   Also select TCS CGST, TCS SGST and TCS IGST ledger in relevant drop down.     

6.   Once Mapping is complete, click on Save Button.

7.   When youn click on save button, you will see that Column I of E-Com sheet is automatically filled up on the basis of mapping.

8.   Now click on 'Sort by Vch No.' button to sort data on the basis of voucher no. (Compulsory)

Step 5. Miscellaneous Data feeding

1.   In Column ‘G’ select Flipkart Ledger from the drop-down if not entered at the time of data import.

2.   In Cell ‘K4’ select shipping ledger from the dropdown.

3.   Select the financial year in Cell ‘D3’.

4.    Make sure that ‘WithInventory’ button in checked.

Step 6. Calculate & Validate Sheet

1.    Just go through the data filled in complete sheet and check it for any correction.

2.    Click on Calculate & Validate button to identify the possible error in your data and see the report on Error Sheet.

3.    Resolve the errors by clicking on the hyperlink.

Step 7. Resolve Item Name error

1.    Upon validation, all new stock items will be transferred to ‘ItemImports’ sheet.

2.    Go to ItemImports sheet and fill units for all those items.

3.    Click on ‘Export to Tally’ button to create them in Tally.

Step 8. Validate again and Export

Validate the ‘E-Com’ sheet again and see if all errors have been removed. If Validation is success, click on Export to Tally Button. All data will be exported to tally instantly.

Go to tally and verify your data.

Advantage

Invoice Details

Data can be imported with Invoice No, Inv Date, Ref No., Ref Date, Bill Reference etc.

Order Details

Import sales voucher with flipkart generated order no. and date. So that invoices and credit note can be matched with flipkart settlement.

Auto Calculation

QuikAccount automatically calculates all the values from Raw Sales Report of Flipkart. User dont need to make any changes in raw file.

Capture B2B Buyer Details

Import data with B2B buyer details. All entries are posted in Flipkart ledger but Buyer Name and GSTIN is captured for GSTR-1 Reporting.

Custom Voucher Type

Use custom vouchers created in Tally (Ex. Flipkart Sales/ Flipkart Credit Note) Further multiple voucher type can be used in one go.

Shipping & TCS

Import data with Shipping Charges and TCS amount shown in Flipkart Sales Report.

Global Network Of

Happy Clients

0

Transaction Processed

0

Partners

0

What our client says