How to import Amazon settlement in Tally

Amazon settlement report includes commission, shipping and other charges deducted by amazon. It also includes TDS, TCS deducted by amazon. This guide provides a step-by-step process for importing the Amazon settlement report in Tally.

Sign in and upload Amazon Settlement Report

1. Sign up at Tally Integration, existing users may login here.
2. Go to Upload Reports from the left side pane, choose company > Market Place > Year & month and upload your settlement report.
3. In the left side pane, go to Upload Reports. (See procedure to download reports)

Load TDL and Import Data in Tally

1. Load TDL in Tally.
2. On the “Gateway of Tally” screen, go to Tally Integration.
3. Under the login option, enter your login credentials for Tally Integration.
4. Go to View & Import, choose the relevant options, and proceed.
5. Once the data is displayed on the Tally screen, click on the import buttons in the following sequence:
   • Import new ledgers
   • Import vouchers

Reconcile Settlement Report in Tally

1. After importing the vouchers into Tally, you will see three voucher types:
   • Amazon Commission
   • Amazon Settlement
   • Amazon TDS-TCS

(Refer to Figure 1 for reference.)

(Figure one: Vouchers types from Amazon Settlement)

2. To verify the entry, match the total value of the Amazon settlement report (Excel) with the balance in the Amazon Settlement Ledger. In the Amazon settlement report (Excel), the data includes various types of transactions in which transaction type “Transfer” should be excluded, as the seller has already received this amount. Therefore, it is not recorded in the Amazon Settlement Ledger. 3. To review the total after filtering out the "Transfer" transactions, please refer to Figure 2. 

(Figure two: Amazon settlement report)

4. In Tally, open the Amazon Settlement Ledger to match the accuracy (refer figure 3). This value should match the total in your Excel report, confirming the accuracy of our solution. 

(Figure 3: Amazon settlement ledger in Tally)

5. Apart from the settlement voucher, TCS-TDS voucher can also be matched. Calculate the total of each column of TCS-CGST (-57.65), SGST (-57.65), IGST (6538.79) and TDS (16661.95) in the settlement report. 

(Figure 4: CGST, SGST, IGST and TDS column in settlement report)

6. Open the current assets in the balance sheet report of Tally and match the total. 

(Figure 5: Highlighted TCS section of balance sheet report in Tally)

7. For the TDS, consider Figure 6. 

(Figure 6: Highlighted TDS section of balance sheet report in Tally)