Sellers selling on Amazon.in can now simply import Amazon MTR (Sales & Sales Returns) data to Tally.ERP9
This is an ideal solution for the Amazon sellers to import Sales & Returns data at the end of the month using MTR format
Watch Demo Video
Create Following Masters in Tally
Create following masters in Tally before you begin
Type | Name | Additional info |
Voucher Type | Amazon Sales | Under SalesVoucher Numbering – Manual – Prevent Duplicate – YES |
Voucher Type | Amazon Returns | Under Credit NoteVoucher Numbering – Manual – Prevent Duplicate – YES |
Ledger | Amazon.in | Under Sundry DebtorsYou can set as ALIAS to your existing ledger |
Ledger | ship-promotion-discount | Under Indirect Expense or Sales |
Ledger | Gift Wrap | Under Indirect Expense or Sales |
Ledger | Gift Wrap Promo Discount | Under Indirect Expense or Sales |
Ledger | Item Promo Discount | Under Indirect Expense or Sales |
Ledger | Shipping Charges | Under Indirect Expense or Sales |
Ledger | CGST @ XX% | Under Duties & Taxes |
Ledger | SGST @ XX% | Under Duties & Taxes |
Ledger | IGST @ XX% | Under Duties & Taxes |
Ledger | Sales GST Local @ XX% | Under Sales AccountsInventory Values effected = YES |
Ledger | Sales GST Interstate @ XX% | Under Sales AccountsInventory Values effected = YES |
Stock Items | As per SKU column | You can create as per SKU name or set as ALIAS |
UOM | As per Tally |
1. Login in to your Excel2Tally.in account
2. Select Template “Amazon MTR (Sales & Purchase)”
3. Click “Process Data”
4. Add Company & Select Template
5. Download Sample file format
6.Follow the below steps to download the data from AMAZON SELLER CENTRAL website
6. Before uploading the data, you are required to manually add column UOM, this is the unit of measurements as per your Tally stock items
7. Once you are ready with your excel data then Choose file and Upload Excel
STEP – 1
8.Now Click Process Excel
STEP – 2
9. Now Click Download XML
STEP – 3
10. Now import the converted XML to Tally, using option import data > Vouchers
11. Your imported data will look like this as shown in the below SnapShots.
12. In case data is not imported in Tally than check Tally.imp file for data import log report.
Important Note
- Add Units of Measurement ( UOM ) column to MTR data first and save the file as Excel
- Please make sure that masters are already exist in your tally data
- Option “Ignore errors during data import” should be YES. Find this option on Gateway of Tally > Press F12 > General