Instructions

This tool utilizes the Amazon purchase reports found at https://www.amazon.com/b2b/reports

You will need to create two reports for whatever time period you would like to categorize.

Create an "Items" report, and a "Orders and shipments" report and save them after they generate as csv files.

You will also want to create a csv file with categories. To get a sample one click Here. Please edit this with your appropriate categories

Once you have all three csv files (items, orders, categories) upload them with the appropriate buttons.

You can then categorize them appropriately. The fields will do full text search of the categories

When finished categorizing, click the bottom button and it will show a report that you can use to help reconcile with your bank

Yellow indicates an item that is NOT part of a combined order but had a discount of some sort applied

Blue indicates an item that is part of a split transaction, note if the order had a discount applied, the amounts will not add correctly