How to Import Myntra Sales report in Tally

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 added, not required).

3. New users need to activate the trial from the left-side menu.

4. Go to import settings, choose Company > E-Commerce Platform, and map necessary ledgers and voucher types.

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

5. Go to Upload Reports from the left side pane, choose Company > Marketplace > Year & Month and upload your Myntra Sales B2C Data report.

   

Load TDL and Import data in Tally

1. Download TDL from here. Open Tally and load the TDL.

2. Update PAN and GSTIN in Tally. To learn the procedure, click here.

3. On “Gateway of Tally”, click Tally Integration > Login (enter credentials).

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

   

5. 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

   

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 errors, if any.

Reconciliation between the data in Tally and the Myntra Sales Report 

To verify the data imported into Tally, 

1. Open P&L a/c in Tally and check the Left-hand side total (Rs. 422,092.41 in the below example)

2. Open the Myntra Sales Report and check the total of the column with the heading ‘Taxable Amount’ (Rs. 422,092.41 in the below example)

3. You can see that the total of taxable value in the Myntra report exactly matches the total of sales and shipping in the Profit & loss a/c

Reconciliation with GSTR-1 Report

1. Now reconcile the GSTR-1 Taxable value and Tax amount with the total of the ‘tax amount’, and ‘IGST’, ‘CGST’, and ‘SGST’ column in Myntra Sales Excel file.

   

Reconciliation with Myntra Seller Ledger

1. Open Myntra 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 ‘Total_invoice_amount’ column of the Flipkart Sales Report.

   

Note: Please note that tally data should not contain any entries other than those imported during this process.