A Flipkart sales report includes comprehensive data on sales, returns, and cashback for sellers. Integrate this data effortlessly with Tally using our website’s one-click solution. Enjoy instant reconciliation of orders and seamless GST report generation. Follow the steps below to get started!
Upload the report on tally-integration.in
Sign up at Tally integration; existing users may log in here.
After login, click on Company List and add your company (if added, not required).
New users need to activate the trial from the left-side menu.
Go to import settings, choose Company > E-Commerce Platform> map necessary ledgers and voucher types.
Note: Default voucher types and ledgers will be auto-populated; you can modify them if needed.
Go to Upload Reports from the left side pane, choose Company > Marketplace > Year & Month and upload your sales report.
Load TDL and Import data in Tally
Download TDL from here. Open Tally and load the TDL.
Update PAN and GSTIN in Tally. To learn the procedure, click here
On “Gateway of Tally”, click Tally Integration > Login (enter credentials).
Go to “View & Import”, choose relevant options, and proceed.
The entire data will be displayed on the tally screen; now, click on the import buttons in the following sequence:
i) Import new stock items
ii) Import new ledgers
iii) Import vouchers
Once you follow this procedure, your entire data will be imported into Tally. Press Ctrl + N to see the calculator pane of tally for errors, if any.
Reconciliation between the data in Tally and the Flipkart Sales Report
To verify the data imported into Tally,
Open P&L a/c in Tally and check the Left-hand side total (Rs. 36,495.27 in the below example)
Open Flipkart Sales Report and check the total of the column with heading ‘Final Invoice (Taxable Value)’ (Rs. 36,495.27 in the below example)
You can see that the total of taxable value in the Flipkart report exactly matches the total of sales and shipping in the Profit & loss a/c
Reconciliation with GSTR-1 Report
Now reconcile the GSTR-1 Taxable value and Tax amount with the total of the ‘tax amount’, and ‘IGST’, ‘CGST’, and ‘SGST’ column in Flipkart Sales Excel file.
Reconciliation with Flipkart Seller Ledger
Open Flipkart Seller Ledger in Tally. Calculate the total of Total Debit and Total Credit as shown in the image below.
Verify the same with the total of the ‘Final_invoice_amount’ column of the Flipkart Sales Report.
