Excel Template for Amazon Sales Reports - UK, USA, India, UEA, Canada, Eurozone

Dec. 2022: Attention. Amazon has changed now the format of the exported data, so this template might now not work for you. If that's the case, simply request a refund. 

May 2021 update: I have now added more countries, including USA, UEA, India and Canada, as well as an experimental Black Mode.

February 2019 update: I have now added conditional formating for transaction types, number of sold items and country codes. If you don't like it, just use the first template and clear the formating, or simply change the conditional formating to suit your preferences. 

March 2019 update: Now zero values in sales are highlighted with yellow, so you that you will be alerted to them if you want to delete them (they usually correspond to Promo Rebates, which are usually not neccesary or even misleading). I always delete them as they mess up with my sold numbers calculations. 

-------------

This is my template that I have been using for importing Amazon sales reports into MS Excel. It has a pleasent formating and filtering. I appreciate your support. You can see the template in action in this video: https://youtu.be/RNpqsPfebqE

As a bonus I have added my Summary Template, which is helpful when you need to calculate your cost of purchase minus refunds. It still requires manual input from the sales report (the first template), but it's very useful, especially if you sell more than 10 items a month, but fewer than 1000 (roughly). 

Thank you for your custom. 

Have an awesome day and beyond!

Kamil