This guide provides a step-by-step process for importing the Amazon settlement report in Tally.
1. Amazon settlement report can be segregated majorly in following 3 categories
Amazon selling fees, shipping fees, commission etc.
TDS-TCS deducted by amazon
Settlement made by amazon towards orders
2. Follow these steps to easily and quickly upload your Amazon report:
Log in to Your Account: If you’re a new user, sign up at Tally Integration. Existing users can log in directly.
Upload Settlement Report
In the left side pane, go to Upload Reports.
Select your company, then Market Place, choose the year & month, and upload your settlement report.
Download the TDL file and load in Tally.
On the Gateway of Tally, go to https://tally-integration.in/ and enter your login credentials in Login.
Go to View & Import and choose the relevant options and entire data will be displayed on the Tally screen.
Click on import buttons in the following order:
Import New Ledgers
Import Vouchers
3. After importing the vouchers into Tally, you will find three voucher types: Amazon Commission, Amazon Settlement, and Amazon TDS-TCS (Refer to Figure 1).
(Figure one: Vouchers types from Amazon Settlement)
4. 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.
5. To review the total after filtering out the "Transfer" transactions, please refer to Figure 2.
(Figure two: Amazon settlement report)
7. 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
8. 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
9. Open the current assets in the balance sheet report of tally and match the total.
