Sales & Support   093584-44502

Leaders in eCommerce to Tally Data Integration

Amazon to Tally

How to Import and match Amazon MTR in Tally

With https://tally-integration.in, you can effortlessly upload your Amazon sales and returns data into Tally. Our platform supports both Amazon MTR B2B and B2C files, making the process smooth and efficient. See the detailed procedure and start streamlining your accounting tasks today.
Download Amazon MTR Report (B2B / B2C)
  1. Log in at Amazon Seller Central
  2. Go to Reports > Manage Taxes > GST Monthly Reports.
  3. Choose “Merchant Tax Report (MTR)”.
  4. Select the year and month and download the report.
Upload Report on tally-integration.in
  1. Sign up at Tally integration, existing users may login here.
  2. After login, click on Company List and add your company (if added, not required).
  3. New users need to activate trial from the left side menu.
  4. Go to import setting, choose Company > E-Commerce Platform> map necessary ledgers and voucher types.
        Note: Default voucher types and ledgers will be auto-populated, you can modify, if needed.
  1. Go to Upload Reports from the left side pane, choose company> Market Place> Year & month and upload your MTR report.
Load TDL and Import data in Tally
  1. Download TDL from here.
  2. Open Tally/ERP Prime and load TDL.
  3. Open an existing company or create a new company.
  4. Update PAN and GSTIN in Tally. To learn the procedure, click here.
  5. On “Gateway of Tally,” go to Tally Integration.
  6. Under the login option, please enter login credentials of https://tally-integration.in/.
  7. Go to “View & Import” and choose relevant options and proceed.
  8. Entire data will be displayed on the tally screen, now click on import buttons in the following sequence:
    i) Import new stock items
    ii) Import new ledgers
    iii) Import vouchers
  9. Once you follow this procedure your entire data will be imported in tally. Press Ctrl + N to see the calculator pane of tally for errors if any. 
  10. Open profit & loss a/c in tally and note the total amount of sales (Rs. 1280039.26 in figure-1).
  11. Open Amazon sales report (both B2B and B2C report) and apply sum formula in column AC (refer figure 2).
Abhi Agarwal
Oct 19,2024

Please fill out the form below to receive a quote

categories

RECENT POSTS

How to Import and match Amazon MTR in Tally
Read More
How to import Flipkart Sales report data to Tally
Read More
How to import Amazon settlement Report in Tally
Read More
How far tally-integration can support E-commerce sellers?
Read More