1. Home
  2. Accounting Solutions for eCommerce Sellers
  3. Amazon to Tally.ERP9
  4. How do I Import Amazon Fulfilled Shipment Sales Data to Tally

How do I Import Amazon Fulfilled Shipment Sales Data to Tally

This is an ideal solution for the Amazon sellers who wants to daily import the sales data fulfilled by Amazon shipments to Tally.

This includes only Sales Data fulfilled by Amazon shipment.

Watch Demo Video

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.

Create Following Masters in Tally

Create following masters in Tally before you begin

Type Name Additional info
Voucher Type Amazon Sales Under Sales

Voucher Numbering – Manual – Prevent Duplicate – YES

Ledger Amazon.in Under Sundry Debtors

You 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 Accounts

Inventory Values effected = YES

Ledger Sales GST Interstate @ XX% Under Sales Accounts

Inventory Values effected = YES

Stock Items As per SKU column You can create as per SKU name or set as ALIAS
UOM As per Tally

Follow Step by Step Process

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

 

 

 

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.

Colum Wise Explanation

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

Important Note
– Please make sure that the ledger masters are already existing in your tally data
– If possible create separate amazon sales voucher types with voucher numbering method manual & prevent duplicate = YES
– Option “Ignore errors during data import” should be YES. Find this option on Gateway of Tally > Press F12 > General

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

Updated on October 1, 2018

Article Attachments

Was this article helpful?

Related Articles

Add A Comment

Help-Desk