is there an instruction on how to use this? thank you
Yes, after you install the tool there is a link to the documentation in the sidebar. This is the documentation: GitHub - daveinlosbarriles/TillerTools: Provides Amazon import and QuickSearch functions to Tiller financial worksheets ¡ GitHub. While the documentation is quite detailed, the tool itself is simple and takes just a few minutes to use.
I finally got around to trying this. Impressive! Seems I might have to break down my 22MB zip file that goes back to 2001 though as my first attempt to import everything timed out. I tried again just doing this year and it worked perfectly. Iâll try expanding the date to pull in prior years (I donât actually need to import all the way back to 2001 of course).
1 suggestion so far: If the âOrder Statusâ is âCancelledâ, donât create the $0 transaction (perhaps provide a user setting to select this behavior?). I have some scheduled deliveries, and if I âskipâ a delivery, it puts it in the transactions as âCancelledâ with a $0 amount. This can be confusing since I never actually purchased/recieved the item, but having the transaction there suggests I did and didnât have to pay anything for it.
Another suggestion: If the Merchant column exists, fill in Amazon (or have an option for what to fill in).
Tip: On the âAMZ Importâ sheet, in the âPayment Typeâ section, I had 30 different payment types from over the last 20+ years. Many of them I didnât recognize. I found that if you request the âPayment Optionsâ data from the same page you requested the âYour Ordersâ data from, and then open the âYour Payment Methods/Saved Cards.csvâ file youâll get more information about each payment type, including Bank Name, Card Issuer, Co Brand, Credit Card Product Name, Debit or Credit, Expiration Date, Card or BankAccount, etc. I found many of mine were PrePaid cards. Many I still donât know for sure, but at least I know the Institution and type of card.
Thanks for doing this @daveahlers ! I remember your post from when this first broke. Canât believe how much you popped off! It works really well!
Do I need to modify the column headers on my transactions sheet before I run this? Iâm following the instructions and I keep getting an error. Iâm sorry if Iâm missing something obviousâIâm not a coder and this is the first time Iâve tried using any special extensions on my sheet.
no, you should not need to modify any column headers. What error are you getting?
I am traveling abroad right now so responses may be delayed.
thanks, Iâve never heard of that column. Is that part of a newer template? Iâll add this to the feature request list.
makes sense to me. Iâll add it to the future list. Can you paste in a sample of two or three records from your CSV file?
I donât think itâs part of the Foundation template, but one Iâve started using (I have AutoCat populate most of the merchants). Perhaps if you can make the feature somewhat generic, like enter any column name you want, and then enter what youâd like automatically filled in.
Sure, hereâs a couple with minor redactions:
B0D3FG3XXX,âname and address",âNot Available",USD,"Not Available","Not Available","Not Available","Not Available",2025-10-23T13:04:28.469Z,113-1998223-2717811,Cancelled,0,"Visa - XXXXâ,New,"Salmon Oil for Dogs and Cats, 32 oz - Omega-Rich Supplement for Healthy Skin & Coat, Joint & Immune Support - All-Natural Fish Oil Liquid - Premium Pet Care, Made in USA","Not Applicable","Not Available","Not Available","Not Available","Not Availableâ,âname and addressâ,0,std-sns-us,0,0,26.98,0,Amazon.com
B09S5TZXXX âname and address",âNot Available",USD,"Not Available","Not Available","Not Available","Not Available",2025-10-08T20:46:08.263Z,111-1393656-4523458,Cancelled,0,"Gift Certificate/Card and Visa - XXXX",New,"DONAMA Cervical Pillow for Neck and Shoulder,Contour Memory Foam Pillow,Ergonomic Neck Support Pillow for Side Back Stomach Sleepers with Pillowcase","Not Applicable","Not Available","Not Available","Not Available","Not Availableâ,âname and addressâ,0,next-1dc,0,0,32.29,0,Amazon.com
just seeing your message now. I thought the default tiller template included the account ID column, but apparently not. I think this column exists so that if you ever have two accounts with the same name from different banks or within the same bank, they will be tracked separately. Iâm not sure why your template doesnât have it. You will need to add the Account ID column in two places: the transactions tab, and the Accounts tab.
@jpfieber any more insight on the account ID column versus the unique account identifier column?
My template as account ID in both accounts tab and transactions tab. It is also on the balance history tab. It also has those columns on a fresh install of the sheet, so I am unsure why yours might not.
If you modify the account name, the âUnique Account Identifierâ is going to change for that account, but presumably the âAccount Idâ will not.
I donât know. Iâve had it since 2019 but those columns werenât in there.
Well, that was an easy fix. Thank you so much!
Glad that worked for you, but it is interesting that your sheet was missing the columns,
@daveahlers Thanks for taking the time to create this and share it with the community!! Worked perfectly right out of the gate! 