Upload the Report on tally-integration.in

  1. Sign up at Tally Integration; existing users may log in here.
  2. After login, click on Company List and add your company (if already added, skip this step).
  3. New users need to activate the trial from the left-side menu.
  4. Go to Import Settings, choose Company > E-Commerce Platform, then map the necessary ledgers and voucher types.

Note: Default voucher types and ledgers will be auto-populated; you can modify them if needed.

  1. Go to Upload Reports from the left side pane, choose Company > Marketplace > Year & Month and upload your sales report.

Flipkart Sales Report Upload Screen

Load TDL and Import Data in Tally

  1. Download TDL from here. Open Tally and load the TDL file.
  2. Update PAN and GSTIN in Tally. To learn the procedure, click here.
  3. On Gateway of Tally, click Tally Integration > Login (enter your credentials).

  4. Go to View & Import, choose the relevant options and proceed.

    Flipkart View and Import Data Screen

  5. The entire data will be displayed on the Tally screen. Click the import buttons in the following sequence:

    • Import new stock items
    • Import new ledgers
    • Import vouchers

    Flipkart Data Vouchers Import Screen

  6. Once you follow this procedure, your entire data will be imported into Tally. Press Ctrl + N to see the calculator pane of Tally for any errors.

Reconciliation Between Tally and the Flipkart Sales Report

To verify the data imported into Tally:

  1. Open P&L A/c in Tally and note the Left-hand side total (e.g. Rs. 36,495.27 in the example below).
  2. Open the Flipkart Sales Report and check the total of the column Final Invoice (Taxable Value) (e.g. Rs. 36,495.27).
  3. Confirm that the taxable value total in the Flipkart report exactly matches the total of sales and shipping in the Profit & Loss A/c.

Flipkart Total Taxable Value Reconciliation

Reconciliation with GSTR-1 Report

  1. Reconcile the GSTR-1 Taxable Value and Tax Amount with the totals of the Tax Amount, IGST, CGST, and SGST columns in the Flipkart Sales Excel file.

    Flipkart GSTR-1 Reconciliation

Reconciliation with Flipkart Seller Ledger

  1. 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 in the Flipkart Sales Report.

    Flipkart Seller Ledger Total

Note: Tally data should not contain any entries other than those imported during this process.