Import Amazon (MTR) Sales into Tally

1. Log in to Amazon Seller Central.
2. Go to Reports > Tax Document Library and download the monthly MTR B2B and MTR B2C reports.
3. Unzip the download and keep the files ready.

1. Open Tally with your company and click Connect Tally.
2. Open the E-Com sheet.
3. Click Ecom Import ▾ and choose Amazon - B2B (MTR) or Amazon - B2C (MTR).
4. A message asks you to make sure the computer date format is DD/MM/YYYY. Click Yes to continue.
5. Select the MTR file.
6. For B2C the sales are summarised by GSTIN, state, HSN and GST rate, so QuikAccount asks for one voucher date – enter it as DD/MM/YYYY (for example the last day of the month).
7. The data is filled in the E-Com sheet. With Inventory is switched on automatically, returns come as Credit Note, and the party is set to Amazon Seller A/c (create this ledger in Tally if it does not exist).

1. Click Ledger Mapping and select the sales and GST ledgers for each rate (local and interstate).
2. Click Calculate & Validate. Fix the cells marked red (for example items or ledgers not in Tally), then validate again.
3. If needed, use Tools > Sort to sort the rows.
4. Click Export to Tally.

▶ Watch the video: import Amazon MTR into Tally