1. Home
  2. How to Import Online Market Place Data to Tally?
  3. How do I Import Amazon Sales Data to Tally

How do I Import Amazon Sales Data to Tally

This document will guide you how to import Amazon FBA sales data to Tally.ERP9.

We have tried to make the data conversion process simpler so that anyone can use it without technical skills.

To get started, Login to your Excel2Tally.in account

1. Select Template Amazon FBA Sales as shown below and click process data

2. Add / Select company in which you want to import the data

 

3. Before you upload the data, we recommend you to download the sample file as shown below and go through the entire format.

Download sample format as shown in below screen

 

We recommend users to go through the following structure before you begin your 1st time data processing.

We have added 4 new column for successful data import in Tally as highlighted in green color below.

Columns highlighted in GREEN are not available in Amazon FBA downloaded report. User are required to fill the same as per the below explanation.
Column Column name Explanation
A amazon-order-id No change, keep it as downloaded from Amazon Seller Central, keep it as downloaded from Amazon Seller Central, keep it as downloaded from Amazon Seller Central
B Invoice Number You can keep Amazon Order Number as Voucher Number in Tally as the current GST for B2C filing structure doesn’t required invoice numbers to be submitted.
OR
You can download the report from Tax Document Library > Merchant Tax Report and get the Invoice number by applying Vlookup with Order ID
C merchant-order-id No change, keep it as downloaded from Amazon Seller Central
D shipment-id No change, keep it as downloaded from Amazon Seller Central
E shipment-item-id No change, keep it as downloaded from Amazon Seller Central
F amazon-order-item-id No change, keep it as downloaded from Amazon Seller Central
G merchant-order-item-id No change, keep it as downloaded from Amazon Seller Central
H purchase-date No change, keep it as downloaded from Amazon Seller Central
I payments-date No change, keep it as downloaded from Amazon Seller Central
J shipment-date No change, keep it as downloaded from Amazon Seller Central
K reporting-date No change, keep it as downloaded from Amazon Seller Central
L buyer-email No change, keep it as downloaded from Amazon Seller Central
M buyer-name No change, keep it as downloaded from Amazon Seller Central
N buyer-phone-number No change, keep it as downloaded from Amazon Seller Central
O sku No change, keep it as downloaded from Amazon Seller Central
P UOM In this column put Unit of Measurement for each stock item as per Tally.ERP9 like Pcs, Nos, Ltrs, etc.
Q product-name No change, keep it as downloaded from Amazon Seller Central
R Tax Rate In this column put the GST Tax rate as applicable to your each stock items.
S quantity-shipped No change, keep it as downloaded from Amazon Seller Central
T currency No change, keep it as downloaded from Amazon Seller Central
U item-price No change, keep it as downloaded from Amazon Seller Central
V item-tax No change, keep it as downloaded from Amazon Seller Central
W shipping-price No change, keep it as downloaded from Amazon Seller Central
X shipping-tax No change, keep it as downloaded from Amazon Seller Central
Y gift-wrap-price No change, keep it as downloaded from Amazon Seller Central
Z gift-wrap-tax No change, keep it as downloaded from Amazon Seller Central
AA ship-service-level No change, keep it as downloaded from Amazon Seller Central
AB recipient-name No change, keep it as downloaded from Amazon Seller Central
AC ship-address-1 No change, keep it as downloaded from Amazon Seller Central
AD ship-address-2 No change, keep it as downloaded from Amazon Seller Central
AE ship-address-3 No change, keep it as downloaded from Amazon Seller Central
AF ship-city No change, keep it as downloaded from Amazon Seller Central
AG ship-state No change, keep it as downloaded from Amazon Seller Central
AH Seller State In this column specify YOUR State from where material is dispatched
AI ship-postal-code No change, keep it as downloaded from Amazon Seller Central
AJ ship-country No change, keep it as downloaded from Amazon Seller Central
AK ship-phone-number No change, keep it as downloaded from Amazon Seller Central
AL bill-address-1 No change, keep it as downloaded from Amazon Seller Central
AM bill-address-2 No change, keep it as downloaded from Amazon Seller Central
AN bill-address-3 No change, keep it as downloaded from Amazon Seller Central
AO bill-city No change, keep it as downloaded from Amazon Seller Central
AP bill-state No change, keep it as downloaded from Amazon Seller Central
AQ bill-postal-code No change, keep it as downloaded from Amazon Seller Central
AR bill-country No change, keep it as downloaded from Amazon Seller Central
AS item-promotion-discount No change, keep it as downloaded from Amazon Seller Central
AT ship-promotion-discount No change, keep it as downloaded from Amazon Seller Central
AU carrier No change, keep it as downloaded from Amazon Seller Central
AV tracking-number No change, keep it as downloaded from Amazon Seller Central
AW estimated-arrival-date No change, keep it as downloaded from Amazon Seller Central
AX fulfillment-center-id No change, keep it as downloaded from Amazon Seller Central
AY fulfillment-channel No change, keep it as downloaded from Amazon Seller Central
AZ sales-channel No change, keep it as downloaded from Amazon Seller Central

Important Note: We strongly recommend user to create Separate Voucher Type “Amazon Sales” under Sales & Keep voucher numbering Manual > Prevent Duplicate = YES

Let me explain you, How to download above format from Amazon Seller Central?

  1. Go to REPORTS Tab Select “Fulfilment by Amazon”
  2. Click on Amazon Fulfilled Shipments
  3. Go to Download tab and set from date – to date range report and click request Download. Once report is ready, download button is visible, click on Download
  4. The data will be downloaded in Text format. Copy entire data and paste it in Excel file as it is and add 4 new columns as highlighted in green color in above explanation table.

Now let’s begin with data conversion steps 

  1. Once you are ready with your excel data then Choose file and Upload the Excel
  2. Now Click on Process Data
  3. Now Download Converted XML
  4. Now import the converted XML to Tally as shown in below snap shots, using option import data > Voucher

Before importing the XML in Tally.ERP9 make sure that all required masters like Amazon ledger, Sales ledgers, Tax ledgers, item masters, Godown, etc are exist in your Tally data.

Note : If the data is not imported successfully then check error message in calculator panel or check Tally.imp log file available under Tally’s folder.

in case of any query, kindly write us on support@excel2Tally.in

Updated on April 10, 2018

Article Attachments

Was this article helpful?

Related Articles

Add A Comment

Help-Desk