27
Aug
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...
27
Aug
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 >...
27
Aug
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...
27
Aug
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...
11
Mar
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...
11
Mar
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...
11
Mar
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
...
10
Mar
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
...
19
Jan
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
19
Jan
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...
19
Jan
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.
19
Jan
Error – No Entries In Voucher
You might have noticed error message “No entries in Voucher!” while importing XML data to Tally.ERP9
To resolve this error, set option “Enable zero-valued transaction to Yes”
The possible reason for this error is one of your vouchers in XML is having no accounting values.
Refer below snapshot
19
Jan
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
09
Jan
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...
20
Nov
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...
20
Nov
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...