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.
Sign in and upload Amazon MTR Report
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. (See procedure to download reports)
Load TDL and Import data in Tally
Download TDL from here.
Open Tally/ERP Prime and load TDL.
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.
Reconcile figures in tally with MTR Report and TCS Report
Open profit & loss a/c in tally and note the total amount of sales (ex. Rs. 12,80,039.26 in figure-1).
Open Amazon sales report (both B2B and B2C report) and apply sum formula in column AC (refer figure 2).
