How do you sort amazon orders and payments for your accountancy system

Hey Everyone,
I wonder if someone can give me and others advice.
I am not sure how you are sorting the amazon orders and payments from amazon, but the way I do, I find it very time consuming and frustrating, so I wonder if there is another way to do it.

Currently I am downloading the transaction report and then sorting manually the spreadsheet that it would fit my FreeAgent accountancy software which takes ages and then import them to the system. It works well (takes very long time) but I manage to import every order and then withdrawals link to the bank statement and specify amazon fees and etc.
But not I have a problem with the international marketplaces like DE ES and etc. All the transactions are made in euros, but the actual money are converted before they are coming to my account.
Can I ask you how do you sort them out? I got hundreds transactions to sort, but not sure how to do? Is there any quick way to do so?

I hope it make sense, and you guys can give me and others advice. I think it will be very useful to know especially when the tax year is ending.

If you need any info, please let me know.

Thank you in advance

Thank your for your answer. Sorry it took so long to reply. Thats the way I thought I will do as I am using FreeAgent software to handle all our accountancy. But may I ask you how you find out at what rate was the euros exhanged? I thought I knew but it seems I cannot find the info.
If you be so kind and let me know it would be superb! Thank you for you time to asnwer!
Because we got over 500 transaction which are overdue to import :frowning: