How to import Amazon Sales & Returns (MTR) data to Tally?

Use eCom2Tally.in to import Amazon MTR data accurately in Tally. It will import all the Accounting, Inventory & GST data accurately, so you can generate GSTR1 & GSTR 3B timely and accurately. To import Amazon MTR data to Tally follow the below steps;   Login to your seller central account Go to Reports > Tax Document Library > Merchant Tax Report Click on B2B or B2B as per your requirements to begin download, you can also download the previous period data from here Open downloaded...

Continue reading

How to import Amazon Settlement & Commission data to Tally?

Use eCom2Tally.in to import Amazon Settlement and Commission data to Tally.ERP9 accurately. Settlement & commission data will be knocked off against each sales invoices using Amazon order ID, so you will be able to get the list of cleared and pending orders payments within Tally under Amazon ledger summary. To import Amazon MTR data to Tally follow the below steps;   Login to your seller central account Go to Reports > Payment Click on Electronic Transactions or COD Transactions at a time > Date Range Report >...

Continue reading

How to import Flipkart Sales & Returns data to Tally?

Use eCom2Tally.in to import Flipkart Tax Report data accurately in Tally. It will import all the Accounting, Inventory & GST related data accurately to help you to generate GSTR1 & GSTR 3B from Tally timely and accurately. To import Flipkart Tax Report data to Tally follow the below steps;   Login to your Flipkart seller account Go to Reports > Report Center > Types of Reports > Tax Reports Click on Sales Report > Specify Period > Generate Your Flipkart Sales & returns data will be downloaded in excel file Now...

Continue reading

How to import Flipkart Settlement & Commission data to Tally?

Use eCom2Tally.in to import Flipkart Settlement and Commission data to Tally.ERP9 accurately. Settlement & commission data will be knocked off against the sales invoices using Flipkart Order ID, so you will be able to get the list of cleared and pending orders within Tally under Flipkart ledger summary. To import Flipkart Settlement & Commission data to Tally follow the below steps;   Login to your flipkart seller central account Go to Payment > Previous Payment > Select Period Click on the list of NEFT ID displayed to begin the data...

Continue reading

Myntra to Tally

How to Import Data from Myntra to Tally?

Are you looking to import your Myntra Sales data to Tally? Sellers selling on Myntra marketplace and having many orders to record in Tally for accounting, they can use our utility eCom2Tally.in to import Myntra data to Tally. For importing Myntra data to Tally, you can use our excel templates eCommerce Sales for importing your order-wise sales data, eCommerce Return for importing order-wise returns and eCommerce Settlement for importing TCS. Follow the steps given below to import Myntra data to Tally; Log in on Myntra Seller Portal with your registered ID and password Download sales...

Continue reading

Udaan to Tally

How to Import Data from Udaan to Tally?

Are you looking to import your Udaan Sales data to Tally? Sellers selling on Udaan marketplace and having many orders to record in Tally for accounting, they can use our utility eCom2Tally.in to import Udaan data to Tally. For importing Udaan data to Tally, you can use our excel templates eCommerce Sales for importing your order-wise sales data, eCommerce Return for importing order-wise returns and eCommerce Settlement for importing TCS. Follow the steps given below to import Udaan data to Tally; Log in on Udaan Seller Portal with your registered ID and password Download sales...

Continue reading

TataCliq to Tally

How to Import Data from TataCliq to Tally?

Are you looking to import your TataCliq Sales data to Tally? Sellers selling on TataCliq marketplace and having many orders to record in Tally for accounting, they can use our utility eCom2Tally.in to import TataCliq data to Tally. For importing TataCliq data to Tally, you can use our excel templates eCommerce Sales for importing your order-wise sales data, eCommerce Return for importing order-wise returns and eCommerce Settlement for importing TCS. Follow the steps given below to import TataCliq data to Tally; Log in on TataCliq Seller Portal with your registered ID and password ...

Continue reading

Meesho to Tally

How to Import Data from Meesho to Tally?

Are you looking to import your meesho sales data to Tally? Sellers selling on meesho marketplace and having many orders to record in Tally for accounting, they can use our utility eCom2Tally.in to import meesho data to Tally. For importing meesho data to Tally, you can use our excel templates eCommerce Sales for importing your order-wise sales data, eCommerce Return for importing order-wise returns and eCommerce Settlement for importing TCS. Follow the steps given below to import meesho data to Tally; Log in on Meesho Seller Central with your registered ID and password ...

Continue reading

Unable to Import the Data in Tally

When you are trying to import the data in Tally using XML file, make sure that option “Ignore errors during data import” is set to Yes.  This setting will allow Tally to import the matching data and generate the log/imp file with the summary of Imported data and not imported data with complete error description. On gateway of Tally, Press F12 > General See the below snapshot 

Continue reading

How to Control Duplicate Voucher Import in Tally

  Voucher number is the only check point for the Tally when you are importing any data from XML to Tally. In case your voucher numbering method is automatic than there is a high possibility that your data gets duplicated when the same XML or voucher has been imported in Tally. Solution To prevent duplication of vouchers keep your voucher numbering method as “Manual” with Prevent duplicate option as “Yes” Important Note In case if you are trying to modify the numbering method of your existing voucher type than their is a possibility that your old numbers...

Continue reading

Date Format Issue In Excel File

Refer below steps to resolve date formatting issue while processing data. Step 1:- First of all select the Columns containing the “dates”     Step 2: Select Text To Columns. You’ll find this on the DATA tab/menu, depending on which version of Excel you are using.     Step 3: Ensure that the original data type is set to Delimited and click Next     Step 4: Ensure that all the check boxes are clear and click Next     Step 5: Set the Column Data Format to DMY and Click Finish button this format is DD/MM/YYYY is format is correct date format.  

Continue reading

Introduction of IRN Columns in Amazon MTR

  With effect from 1st January 2021 and with the applicability of e-Invoicing system, Amazon has introduced 4 new columns in Amazon MTR file as below. IRN Number IRN Filing Status IRN Date IRN Error Code Let's discuss more in detail about IRN in this article:   What is IRN? IRN called “Invoice Reference Number” it is a unique invoice number created by the Invoice Register Portal (IRP) on uploading the invoices electronically. Under the e-invoicing system in GST, documents like invoice, Credit Note, Debit Note or any such document as needed by the law should...

Continue reading

How to record TDS Deducted by Flipkart in Tally?

In the Finance Act 2020, the Government has introduced new rules in Section 194-O which provides a withholding of TDS by e-commerce companies for facilitating sale of goods and services of e-commerce participants through its marketplace. These rules are effective October 1, 2020. Many sellers like you have came across the query of how to account the same in Tally? Please refer the steps below to learn how to record TDS deducted by Flipkart in Tally. Recording TDS Receivable Entry Check for the TDS values in the settlement file you received as shown...

Continue reading

How to record TDS Deducted by Amazon in Tally?

In the Finance Act 2020, the Government has introduced new rules in Section 194-O which provides a withholding of TDS by e-commerce companies for facilitating sale of goods and services of e-commerce participants through its marketplace. These rules are effective October 1, 2020. Many sellers like you have came across the query of how to account the same in Tally? Please refer the steps below to learn how to record TDS deducted by Amazon in Tally. Recording TDS Receivable Entry Check for the TDS values in the settlement you received as shown in...

Continue reading