Tiller - Too much work

The Amazon card does not give more details in the transaction itself. In Chase (the provider for the Amazon card) you can log in and there’s a link to see what the specific item is. But you can’t download it to Tiller automatically.

Plus there’s a bigger problem, in that Amazon transactions are tied to the entire purchase (e.g. you buy 3 items at once). If you want to separate these out, you’ll need to split transactions. Frankly this was too complicated/cumbersome for my needs, so Amazon is just a black bucket which I categorize as “Home Goods” (as Amazon is typically stuff for the house anyway).

1 Like

Man, that does stink. Ill have to think through my budgeting process.

I started using Tiller in Dec of 23 and I absolutely love it. I was a Mint user for 20+ years and I was always downloading my transactions into Excel and doing analysis there anyway. Tiller uses Excel as my core and I’ve found my comfort zone. Also, the Amazon transaction coding is not a Tiller issue. I wish either Amazon would allow you to code the transaction upon purchase or that my wife would stop buying things. :slight_smile:

4 Likes

The Amazon Prime VISA does not show extra detail.

The Amazon Prime STORE CARD (uses Synchrony Bank) does show purchase detail.

1 Like

If your Amazon Prime Visa is carried by Chase, there is a way to identify source of what the charge is. Open your Chase account > select Prime Visa > select transactions > select the one which aligns to your spend amount > Look for the Description section > click on the “see order details” (actually a hyperlink and you will be directed to Amazon and the specific order.
We use Amazon quite a lot and I will do this methodically every Tiller workbook update, add a note into the Description field and then provide the correct category and group. If your Prime Visa is not Chase, maybe the other carriers provide the same or similar path/detail availability.

1 Like

Right. I think the lament is that at times there have been ways of automatically downloading transaction information from Amazon, so we wouldn’t have to do all of that. But it seems to be getting harder rather than easier to get it automatically.

1 Like

I don’t think Tiller is for everyone. The assumption is that you want to track your spending, like in a paper budget vs. actual expenses. If all you want to do is see balances, you can open your online banking account. I have set up an account for my dad who at this point in life has less than 30 transactions a month. But since those transactions can widely vary in the health care category, I am using Tiller to watch future cash flow. (I created a google sheet that looks at ending balances and expected upcoming transactions to compare and decide how much to transfer in) For me, I use it for two sole purposes over any other software. (1.) To track our spending - i.e. when we track spending, we are going to stay within budget and not overspend; I categorize un-automatic transactions about 3x/month and it takes me about 15 minutes, even with manually entering categories for different Amazon transactions. (2.) Watch our cashflow in different accounts - i.e. I have customized a google sheet to import data, compare upcoming, save for longer term upcoming expenses and manage the overall cash flow of accounts. If you’re not needing these functions - you don’t need Tiller! :grinning:

1 Like

Oops, somehow I replied to the wrong person. My bad.

Replying to original post:

I don’t view/categorize my transactions as frequently as i used to. (yes I have some set to auto), and this is something that really needs to be kept up on.

Any budgeting app that imports transactions must be accessed and updated from time to time so that categorization stays current. This holds true with Tiller, as it did with Mint, YNAB, Every Dollar, etc.

Amazon purchases require too much manual process to get entered and categorize. I was using the somewhat painful download and import method until Amazon broke it about a year or so ago.

Amazon purchases do require more work to label, especially when there are multiple items to an order, however, I spend much less time in Tiller categorizing Amazon transactions as I did in Mint. If you use the Amazon Store Card, you can automatically have your items appear in the Full Description field on the Transactions sheet. This is so much easier than Mint ever was, which required more steps to access that information on my credit card company website via the order number. Also, Tiller’s split tool is better than most I’ve used as it allows you to add Note and Tag fields directly to the split, saving a lot of time. This is something Mint never did. So ya, it takes time, but Tiller makes it a lot easier than what I’ve tried.

When I do decide to examine my tiller sheets (which might be monthly) almost always, more than one source has stopped syncing which requires quite a bit of troubleshooting and logging in to get working again.

This has more to do with aggregators and bank sites than it does Tiller. I experienced this occasionally as well with Mint, Personal Capital, etc. No noticeable difference with Tiller doing this more.

Launching Tiller requires too many clicks to get things syncing and transactions downloaded. In ye ol’ day of Tiller it was Tiller hosted and auto updated.

I always have my Tiller sheet open. I simply go to Extensions - Tiller Money Feeds - Fill Sheets in Google Sheets. Easier than having to login to Mint every single time and then forcing a refresh, which also takes time. Tiller also has the automatic refresh ability which I have not personally used yet, but I imagine would make things even easier in this regard. I’m good with how I do it now though, easy.

I don’t really do budgeting, so the real benefit to me was transaction searching and adhoc reports. But Tiller occasionally changes functionality which requires a new spreadsheet and new data (happened twice). So historical data is spread amongst different sheets.

You just need to get used to a workflow. The more I use it, the more I remember where to go for what information I’m looking for. Mint, other budgeting sites also added features over time that required you to make changes, learn new things, etc.

I’m glad tiller opened a community and has various community templates…but almost all are based on the need for folks to budget, rather than investigate.

Perhaps it’s because this original post is almost 2 years old, but I see tons of community sheets and Tiller stock sheets which allow you to dig deep down into the data. Budgeting goes hand in hand with tracking your personal finances. You budget for business, you budget personally. Without budgeting, tagging transactions, doing some work, I don’t see how one would effectively be able to obtain any meaningful information from their data.

Maybe I’m just getting older and want a less maintenance required approach.

Once you get this setup (which I admit, takes the longest amongst the competition I’ve used), it runs with minimal maintenance. The only maintenance I do now is adjusting Grouping, Categorizing, Budgets, Tags, etc, i.e. tweaking the way I track my own data. I do little troubleshooting because once the sheets work, assuming your data is aggregating, it just works. Mint on the other hand gave me massive headaches. I would get logged out all the time even though I was actively working. Transactions would show as updated, then I would refresh the page and they weren’t actually updated. I could go on and on. And that was from one of the most popular personal finance tools. Tiller is a piece of cake compared to the competition. Once you have it working, it just works. This is literally my dream personal finance/budgeting solution. Aside from the initial learning curve and setup, and the lack of pretty graphics that you seen on competitor sites, it’s leaps and bounds better due to the ability to customize and create literally anything you can think of with the spreadsheet framework. And let’s not forget - there are no ads here. Mint was terrible with ads and there was no way to get rid of it on Desktop. Not having ads of any kind when doing your own personal finance is great.

1 Like

I used to use the Amazon Prime Visa in Mint this exact way. However, the Amazon Store Card allows you to automatically display the contents of the order in the “Full Description” column on the Transactions sheet. I can categorize right there in Tiller or, if it’s multiple items across various categories, I can copy and paste the Full Description content into Amazon and pull up the order and break things apart with the Split tool. I’ve found this to be the superior way to deal with Amazon transactions.

1 Like

Will you explain this a little further?

Sure. This is what a transaction looks like from the Amazon Store Card in Tiller.

Notice how the far right field (full description) shows the actual item that was purchased. This is done automatically and makes it easier to categorize. If you order multiple items in a single order that have different categories, then you can just copy and paste one of the items in the Full Description field into the Amazon orders search field, and it will take you to that order where you can break it apart with the Split tool in Tiller accordingly.

The Amazon Store Card is the only card that shows the order data in the transaction field, as far as I know. The Amazon Prime Visa card does not do this.

1 Like