I dropped a new release to GitHub - daveinlosbarriles/TillerAmazonOrdersCSVImport · GitHub . A fair number of changes. Details are all in the readme, but in summary:
- It was too messy editing configuration values as constants in the appscript code, in particular dealing with multiple payment types. Now, when you first open the Import dialog, a new sheet is created called “AMZ Import”. Go to this sheet and enter in one row for each credit card you use with Amazon. And then enter in the appropriate account, account ID, and Institution ID values to use.
- There were other constants in the code that I also moved to the AMZ Import tab - but you normally won’t ever need to touch those. These are things like the actual name of all of the fields we need in the Amazon CSV, the name of the Transactions tab, Date column, Amount column, etc.
- One value that might be handy is that you can duplicate just your tiller Transactions tab, call it Test, and then on the AMZ Import tab you can set the transactions tab name to “Test”. Then you can play around with confirming for yourself that the amazon transactions are imported to your liking. Just don’t forget to change it back.
- I also took most of the remaining interesting Amazon transaction data and stuck it in the Metadata column, just like the old tool did. So number of items, price per item, taxes are there.
- Finally, after adding support for multiple payment types, I realized that the Offsetting entry to avoid double counting your amazon transactions should be broken out by credit card, instead of applied to just one credit card.
Go ahead and give it a try and let me know of any issues.