Posts by Dhaval Goradia
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...
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...
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...
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...
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...
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...
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 MTR.csv file and save it as .xlsx
Now login to eCom2Tally.in or...
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 > Transaction > Give Period
Settlement data is broadly...
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 login to your eCom2Tally.in account...
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 download
You can merge the multiple...
