How do i Import Amazon MTR data to Tally.ERP9?

Sellers selling on Amazon.in can now simply import Amazon MTR (Sales & Sales Returns) data to Tally.ERP9

This is an ideal solution for the Amazon sellers to import Sales & Returns data at the end of the month using MTR format

It covers both B2B and B2C transaction Types

Watch Demo Video

Create Following Masters in Tally

Create following masters in Tally before you begin

Type Name Additional info
Voucher Type Amazon Sales Under Sales

Voucher Numbering – Manual – Prevent Duplicate – YES

Voucher Type Amazon Returns Under Credit Note

Voucher Numbering – Manual – Prevent Duplicate – YES

Ledger Amazon.in Under Sundry Debtors

You can set as ALIAS to your existing ledger

Ledger ship-promotion-discount Under Indirect Expense or Sales
Ledger Gift Wrap Under Indirect Expense or Sales
Ledger Gift Wrap Promo Discount Under Indirect Expense or Sales
Ledger Item Promo Discount Under Indirect Expense or Sales
Ledger Shipping Charges Under Indirect Expense or Sales
Ledger CGST @ XX% Under Duties & Taxes
Ledger SGST @ XX% Under Duties & Taxes
Ledger IGST @ XX% Under Duties & Taxes
Ledger Sales GST Local @ XX% Under Sales Accounts

Inventory Values effected = YES

Ledger Sales GST Interstate @ XX% Under Sales Accounts

Inventory Values effected = YES

Stock Items As per SKU column You can create as per SKU name or set as ALIAS
UOM As per Tally

Follow step by step process

1. Login in to your Excel2Tally.in account

2. Select Template “Amazon MTR (Sales & Purchase)”

 

3. Click “Process Data”

 

4. Add Company & Select Template

 

5. Download Sample file format

6.Follow the below steps to download the data from AMAZON SELLER CENTRAL website

 

6. Before uploading the data, you are required to manually add column UOM, this is the unit of measurements as per your Tally stock items

7. Once you are ready with your excel data then Choose file and Upload Excel

         STEP – 1

 

8.Now Click Process Excel

STEP – 2

 

9. Now Click Download XML

     STEP – 3

 

 

10. Now import the converted XML to Tally, using option import data > Vouchers

 11. Your imported data will look like this as shown in the below SnapShots.

 

12. In case data is not imported in Tally than check Tally.imp file for data import log report.

GSTR1 Helper

  1. Error – “UoM not mapped with Unit Quantity Code (UQC)
    • Drill down to the error message and click on Map to UQC button and set the appropriate UQC from the list as per GST requirements, refer below snapshots
  2. Error – Getting Difference of Rs. 0.01 or similar in many transactions
    • This error occurs when tax values in excel data is coming in more than 2 decimals but Tally supports values in 2 decimals only
    • Considering the real life business scenarios to accept the mismatch forcefully, Tally has provided button ALT+A Accept as is to resolve and consider the given tax value in reports
  3. Error – Tax rate/tax type not specified
    • The possible reason for this issue is GST configuration has been not done in the Sales ledgers and Tax ledgers, please select appropriate GST tax type in Sales & GST ledgers to resolve this issue.

Important Note

  • Add Units of Measurement ( UOM ) column to MTR data first and save the file as Excel
  • Option “Ignore errors during data import” should be YES. Find this option on Gateway of Tally > Press F12 > General

Updated on October 3, 2018

Article Attachments

Was this article helpful?

Related Articles

Add A Comment

Help-Desk