Merging Amazon Order #s
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.
https://gist.github.com/edalquist/f7cafb07bb94a8efbf9e912c0c1a5268
Instructions are included at the top of the script but it should be pretty straight forward to use:
- Set
AMAZON_ACCOUNT_NAMEto the name of your MoneyDance account your Amazon charges end up in - Go to https://www.amazon.com/gp/b2b/reports export an order history report and put the full file path in
AMAZON_REPORT_CSV. - Optional: Ensure the
AMAZON_DESC_PATTERNSregex patterns match the descriptions of your Amazon charges - Open Moneydance Console, paste in the script and run it.
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
| ? | 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
1 Posted by Dan P on 28 May, 2021 08:19 PM
Works great. Thanks!
System closed this discussion on 27 Aug, 2021 08:20 PM.