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)
Log in at Amazon Seller Central
Go to Reports > Manage Taxes > GST Monthly Reports.
Choose “Merchant Tax Report (MTR)”.
Select the year and month and download the report.
Upload Report on tally-integration.in
Sign up at Tally integration, existing users may login here.
After login, click on Company List and add your company (if added, not required).
New users need to activate trial from the left side menu.
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.
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
Download TDL from here.
Open Tally/ERP Prime and load TDL.
Open an existing company or create a new company.
Update PAN and GSTIN in Tally. To learn the procedure, click here
On “Gateway of Tally,” go to Tally Integration.
Under the login option, please enter login credentials of https://tally-integration.in/
Go to “View & Import” and choose relevant options and proceed.
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
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.
Open profit & loss a/c in tally and note the total amount of sales (Rs. 1280039.26 in figure-1).
Open Amazon sales report (both B2B and B2C report) and apply sum formula in column AC (refer figure 2).
