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 for Data Import.

We have also attached predefined required masters in XML format, this you can import in your Tally to Auto create the required masters with GST enabled parameters.

Download Sample XML from here – Download Amazon Masters in XML Format

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

  • Error – “UoM not mapped with Unit Quantity Code (UQC)
  • Solution
    • 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
  • 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
  • Solution
    • 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
  • 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.
  • Solution
      • Please select appropriate GST tax type in Sales & GST ledgers to resolve this issue, as shown in below screen shots.
  • State names are duplicating in GSTR1 B2C Report

    If you observe, state names are coming differently in the data received from the Amazon.

  • Solution
  • Please correct the same and make it as per the Tally’s state name before uploading data to avoid mismatches in GSTR1 > B2C (Small Invoices – 7) section.Differences are highlighted in below snapshotWe have attached list of state names as per Tally in excel sheet, please get it from the article attachments below.
  •  Sales Return – Supplier/Original Invoice Number & Date Issue

You might have noticed below error in GSTR 1 when Sales return is imported to Tally.

This happens because currently Amazon MTR does not provides Original Invoice Number & Date against the sales return record, so we are currently capturing order number in this field.

  • Solution

You are required to search the original invoice number from the seller portal for the selected order number and enter the same in Tally manually to resolve this error.

  • Error – Shipping Charges, Item Promotion, Discounts, Other charges are not getting considered for tax GST calculation

You might have noticed that other charges like Shipping, Item Promotion, etc are not getting considered for GST calculation and thus giving mismatch errors in GSTR-1.

  • Solution

Please follow below steps to resolve this issue.

You are require to Include these ledger in assessable value for calculation under GST.

  • Set GST Applicable = Not Applicable
  • Set Include in assessable value calculation = GST > Apportioned to Goods > Based on value

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 November 23, 2018

Article Attachments

Was this article helpful?

Related Articles

Add A Comment

error: Content is protected !!
Help-Desk