Merging Amazon Order #s

eric.dalquist's Avatar


25 May, 2021 05:24 AM

Not a full extension yet but I just finished a python script to merge an Amazon Order Report with my credit card account. The end result is getting amazon order numbers into the memo fields of the matching transactions. Matching is done by transaction value and date adjacency.

Instructions are included at the top of the script but it should be pretty straight forward to use:

  1. Set AMAZON_ACCOUNT_NAME to the name of your MoneyDance account your Amazon charges end up in
  2. Go to export an order history report and put the full file path in AMAZON_REPORT_CSV.
  3. Optional: Ensure the AMAZON_DESC_PATTERNS regex patterns match the descriptions of your Amazon charges
  4. Open Moneydance Console, paste in the script and run it.
  1. 1 Posted by Dan P on 28 May, 2021 08:19 PM

    Dan P's Avatar

    Works great. Thanks!

  2. System closed this discussion on 27 Aug, 2021 08:20 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac