Amazon Settlement Reports
The Amazon Settlement Report Flat File V2 contains details of orders, promotions, refunds, fees and other transactions for your Amazon account for a given 2 week period, including the amount of money (or settlement) they owe the seller after deductions. Tradebox can read this file and extract from it fees associated with each order and ‘other-transaction’ fees and credits associated with your Amazon account.
Understanding the Settlement Report Flat File V2
The Settlement Report Flat File V2 is a text delimited file which can be read in Notepad. However, its easier to read this in Excel. To get the V2 file into Excel save a copy on your desktop and ensure that it is closed. Open Excel and from the Data menu choose ‘From Text‘ under the Get External Data section and point at the Settlement Report Flat File V2. After importing the file you will see that all data is held in discrete columns. The transaction-type and amount-type columns describe the type of data in the row. The following table explains the data types Tradebox will import:
transaction-type |
amount-type |
Imported |
Details |
| Order | ItemPrice | No | Income from Amazon orders already accounted for through order import |
| Order | Promotion | No | Discounts on Amazon orders already accounted for through order import |
| Refund | ItemFees/ItemPrice | No | Refunds are not handled by Tradebox and should be accounted for manually. |
| Order | ItemFees | Yes | Transaction fees for each order |
| other-transaction | Multiple | Yes* | Includes credits and debits for monthly costs, reimbursements, FBA fees. |