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

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

Error – No Accounting Allocation For!

You might have noticed error message “No Accounting Allocations For !” while importing XML data to Tally.ERP9   To resolve this error, set option “Enable Inventory Values are affected to Yes” The possible reason for this error is one of your vouchers in XML is having no accounting values. Refer below snapshot  

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

How to Record TCS deducted by the Flipkart in Tally?

Tax Collected at Source (TCS) under GST means the tax collected by an e-commerce operator from the consideration received by it on behalf of the supplier of goods, or services who makes supplies through operator’s online platform. TCS will be charged as a percentage on the net taxable supplies. Flipkart Tax Report contains the Invoice wise breakup of TCS deducted on each orders. In order to account the same in Tally, you will have to Debit the TCS Ledger and Credit the Flipkart Ledger. To account TCS entries in bulk on all...

Continue reading

How to Record TCS deducted by the Amazon in Tally?

Tax Collected at Source (TCS) under GST means the tax collected by an e-commerce operator from the consideration received by it on behalf of the supplier of goods, or services who makes supplies through operator’s online platform. TCS will be charged as a percentage on the net taxable supplies. Amazon Merchant Tax Report (MTR) contains the Invoice wise breakup of TCS deducted on the sale. In order to account the same in Tally, you will have to Debit the TCS Ledger and Credit the Amazon ledger. To account TCS entries in bulk...

Continue reading

Can’t Import Check Tally.IMP for details

Often you might have encountered this error message while importing data to Tally.ERP9. In this article I'll try to explain you the possible reason of getting this error message, how to identify and it's solution; What are the Possible Reason for this error? Following masters exists in your XML but missing in Tally data Item Master Ledger Master Unit of Measurement Godown Voucher Type Same Voucher number already exists (if prevent duplicate is set as Yes) Currency What is Tally.Imp file? Tally.Imp file is a nothing but a complete log file of...

Continue reading

Free TDL for XML to Tally Data Verify & Import

Use our intelligently developed TDL to simplify your Data import to Tally. This TDL will verify your XML file with existing Tally Data to check, detect & display the missing masters and already exits vouchers first and allow you to create the missing maters for error free data import. Additionally you will get complete data import log and analyses.  

Continue reading