Convert Amazon FBA Settlement Report to Xero CSV
Upload your Amazon FBA Settlement Report and download a Xero CSV file ready to import into Xero.
How to download your Amazon settlement report
- Log in to Amazon Seller Central
- Go to Reports > Payments > Date Range Reports
- Click Generate Report for your desired settlement period
- Select Transaction report type
- Download the generated
.csvor.txtfile - Upload it here to convert
About the Xero CSV Format
Xero's manual journal CSV import format. Upload your settlement file and download a CSV that can be imported directly into Xero as a manual journal entry.
Other Export Formats for Amazon FBA Settlement Report
Frequently Asked Questions
After downloading your Xero CSV file from SettleBooks, open Xero and use the journal entry import feature. The file is pre-formatted to match Xero's expected layout.
Yes. SettleBooks categorizes every fee and charge from your Amazon FBA Settlement Report into separate journal entry lines. Each line maps to a specific account so your books stay detailed and accurate.
Absolutely. Every exported journal entry has total debits equal to total credits. If there's a discrepancy in your source data, we flag it with a warning before you export.
Yes. After signing in, go to Settings → Category Mappings to override the default account name and code for any fee category. Your custom mappings are saved and applied to all future conversions.