91-93584-44502 | support@quick2tally.com
Quick2Tally

Amazon (MTR) Sales

Import Amazon’s Merchant Tax Report (MTR), B2B and B2C, straight into Tally. Download the MTR from Seller Central – QuikAccount does the rest.

Need help? Call or WhatsApp 93584-44502. Free installation and demo support.

Step 1 – Download the MTR from Seller Central

  1. Log in to Amazon Seller Central.
  2. Go to Reports → Tax Document Library → Merchant Tax Report.
  3. Select the month, choose B2B or B2C and click Download Report.

Step 2 – Connect Tally

  1. Open your company in Tally.
  2. Open QuikAccount and go to the sheet you want to use.
  3. Click Connect Tally on the QuikAccount ribbon. The Tally Company box at the top right shows the company name, GSTIN, state and books start date. Check it is the right company.

Step 3 – Import the report into E-Com

  1. Open the E-Com sheet.
  2. Click Tools → Marketplace Import and choose Amazon - B2B (MTR) or Amazon - B2C (MTR).
  3. Confirm clearing the existing data, then select the downloaded file. Rows fill automatically.
  4. Enter the Amazon party ledger and the sales ledger when asked (both must exist in Tally), or leave them blank and fill later.
E-Com Tools menu with Marketplace Import options

Step 4 – Map ledgers and sort

  1. Click Ledger Mapping. Choose sales ledgers per GST rate (local and inter-state), CGST/SGST/IGST ledgers and the TCS ledgers. Click Save – the Purchase/Sales Ledger Name column fills automatically.
  2. Click Tools → Sort to sort by voucher number. This is required before export.
  3. Tick With Inventory on the ribbon if items should go into Tally.
E-Com sheet with marketplace sales and mapped ledgers

Step 5 – Validate and export

  1. Click Calculate & Validate (Alt+Shift+V). Errors are listed on the Error sheet.
  2. New items go to ItemCreation: enter their units there and Export to Tally. New parties go to LedgerCreation.
  3. Validate again, then click Export to Tally (Alt+Shift+E) and check the Report sheet.

▶ Watch the video: import Amazon MTR into Tally

Advantage

Invoice details

Invoice no., date and Amazon order no. and date, to match settlements.

No editing

The raw report is imported as it is; tax is calculated.

B2B buyer details

Posted to the Amazon ledger with buyer name and GSTIN for GSTR-1.

Custom voucher types

e.g. Amazon Sales and Amazon Credit Note in one run.

Shipping and TCS

Shipping charges and TCS ledgers handled.

Returns

Returns become credit notes automatically.

Global Network Of

Happy Clients

0

Transaction Processed

0

Partners

0

Trusted by 10,000+ Tally Users

For Utility, Support and Service

Trusted by Tally users

4.9 Star Google Rating Based on 300+ Reviews

Kamal Jain, FCA, CCA
Kamal Jain, FCA, CCA 1 review

Recently

Great software, User friendly & Superb support. All GST reports shows accurate results. Multiple formats for each voucher to suit our need. Whatever format of data you have, you can export that to tally. Good Job... QuikAccount Team!

Sanjay Jain
Sanjay Jain 1 review

Recently

Software is user-friendly. It provide lot of option to cater your need and give results in desired format. Also it ask for minimum data and most of the fields are either auto-calculated or imported from tally which makes working on this software very faster.

Prachi Shah, Senior Executive
Prachi Shah, Senior Executive 1 review

Recently

Superb tool to integrate excel data in Tally. We have imported complex e-commerce reports with this tool and it has imported large data accurately and very fast too. Company provided one click import option for multiple e-commerce platforms.

Get in touch

Share your details and we will get back to you.