Obtaining the Settlement Report Flat File V2
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. These will be entered into the nominated Sage bank account as either Bank Payments (BP) or Bank Receipts (BR).
Tradebox is only compatible with the Settlement Report Flat File V2 and will not be able to read other type of Amazon fees files.
How to get the Settlement Report Flat File V2?
Before Tradebox can import the Settlement Report Flat File V2 the user needs to manually download the file from Amazon by going to Reports > Payments > All Statements, clicking on the Download button next to the V2 report and saving it into the correct Amazon IN folder on their PC or Network.
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:
|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.|
* Tradebox will not import any Reserve Amounts included in the 'other-transaction' type section.
To import the settlement report into Tradebox, your Amazon channel must first of all be set up to download Amazon Fees. To do this, open the Amazon channel and select Selling Fees from the options on the left.
This will bring you to the settings screen for Amazon fees. Download Fees must first be selected, and a Sage nominal account, bank account and tax code selected. You can opt to post the fees as individual transactions, to post summary transactions which are summarised by type, or as one single lump sum.
Once that has been set, save the settlement report into the Amazon input folder and use the Download option under Operations to process the settlement report.
Fees will not be posted to Sage automatically. To post the fees, select the Fees option under the Information heading on the left hand side of the main Tradebox screen, and select the appropriate channel. This will display all downloaded fees for that channel, which you can then select and use the Post to Sage button to send across to Sage. These will then appear as bank payments within Sage.