/lunchable-primelunch

LunchMoney Amazon Transaction Updater

Primary LanguagePythonMIT LicenseMIT

lunchable-primelunch

lunchable lunchable

LunchMoney Amazon Transaction Updater

PyPI PyPI - Python Version docs Hatch project Ruff pre-commit semantic-release Gitmoji

PrimeLunch is a command line tool that supports updating Amazon transaction notes with the items from Amazon itself. This tool uses CSVs generated by the Amazon Order History Reporter plugin on Chrome. Once you've gathered your transactions, export them as a CSV and scan them with the tool. You'll be asked which transactions you'd like to update.

The plugin uses the dollar amounts on the CSV export to match Amazon transactions in LunchMoney. When a matching dollar amount is found, PrimeLunch compares the date window between the transactions to determine if they're really a match.

We're using the Amazon Order History Reporter plugin because it gives us some functionality that Amazon doesn't: exporting Amazon transactions as they're grouped on actual credit card transactions.

Run via the Lunchable CLI

You can install lunchable with pip or pipx. Make sure to use the lunchable[primelunch] extra to install the PrimeLunch plugin. You can also use the lunchable[plugins] extra to install all the known plugins.

pipx install "lunchable[primelunch]"
pip install "lunchable[primelunch]"

The below command runs the PrimeLunch update tool:

lunchable plugins primelunch -f ~/Downloads/amazon_order_history.csv

The below command runs the PrimeLunch update tool using a date window of fourteen days instead of the default seven days (these larger windows are especially useful for finding refunds and recurring purchases):

lunchable plugins primelunch \
   --file ~/Downloads/amazon_order_history.csv \
   --window 14

Update all transactions without going through the confirmation prompt for each one:

lunchable plugins primelunch \
   --file ~/Downloads/amazon_order_history.csv \
   --all

Provide a LunchMoney API access token manually (PrimeLunch defaults to inheriting from the LUNCHMONEY_ACCESS_TOKEN environment variable):

lunchable plugins primelunch \
   --file ~/Downloads/amazon_order_history.csv \
   --token ABCDEFGHIJKLMNOP

References

This lunchable plugin was inspired by the original Lunchable Amazon importer at samwelnella/amazon-transactions-to-lunchmoney.