How do I import older Amazon transactions?
Like with other online sales channels, Seller Ledger is able to automatically import the last 90 days of transaction history from Amazon when you first sign up. And if you upgrade to an annual plan, we can go back and automatically import much of your transaction history for the full tax year.
However, Amazon starts to archive some of the reports we access after 90 days. To ensure that Seller Ledger is able to pull in all of your Amazon data for a prior tax year, you will need to request some additional reports. Fortunately, the steps are very easy.
What older data is automatically imported?
Once you sign up for an annual plan, we'll go back to January 1 of the most recent tax year and automatically import the following data:
- Sales and order history
- Returns/refunds for merchant-fulfilled transactions
What older data is not automatically imported?
However, we do not have automatic access to the following data beyond 90 days:
- FBA returns/refunds
- Amazon account fees
The good news
To help with this one time issue (because we import all data going forward,) all you have to do is request older Amazon Settlement reports from Seller Central. Simply follow these step:
- Log into Seller Central, click on Reports, then Payments, and the All Statements tab
- As you scroll down, you'll start to see a change from settlement reports that have a button that says "Download Flat file" to "Request Report." It's those "Request Report" ones we're looking for.
- Click the "Request Report" button for each of the reports from January up until the most recent one that says "Download Flat file".
- After a little while, each of those Settlement reports will become available for Seller Ledger to access.
That's it. Seller Ledger's system is smart enough to recognize that new, older reports are available, and will grab that data automatically.