Tool to convert Amazon Retail Order History to YNAB import format to give a transaction for each item in an order. This was created to mimic what Tiller is doing here.
This tool creates a list of transactions that can be uploaded into YNAB. It creates 1 inflow entry with the sum of the order to offset your credit card charge. It then creates a transaction for each item in an order with item details in the memo. You can then categorize these individually.
NOTE: Dates might not line up with your credit card transaction due to how Amazon bills.
- Download order history from Amazon: https://www.amazon.com/gp/privacycentral/dsar/preview.html
- Python 3.11 or higher
ynab_amazon_importer.py -i <inputfile> -o <outputfile> [-s YYYY-MM-DD] [-e YYYY-MM-DD]
- -i = input file from amazon
- -o = output transactions to load into ynab
- -s = [optional] start date in YYYY-MM-DD format (ie 2023-11-28)
- -e = [optional] end date in YYYY-MM-DD format (ie 2023-11-28)
To import the transactions, upload the output file using the instructions found here. It is import to create an account named something like "Amazon" as a cash account and $0 balance. This script should always create transactions with a $0 balance here.
- You should categorize all credit card transactions for Amazon under a category called "Amazon"
- All Amazon Orders should be categorized under the same "Amazon" category as above
- Individual items should be categorized under the category that makes sense for the item.
Please feel free to reach out to ynab_importer@chalupabatman.com if you have any requests, feature requests, or want to throw me an Amazon gift card :)