Discovering Patterns with Tiller + Pivot Tables (Dividends & Subscriptions)

Hey everyone,

Just wanted to share a couple of ‘aha!’ moments I had recently using Tiller, especially now that I’m settling into retirement. Sometimes the obvious stuff escapes me, maybe others can relate.

Since retiring late last year, I’ve been getting a handle on my new routine. Looking at my brokerage statements, I always just assumed dividend activity was an end-of-month thing. But this month, Tiller showed dividend/reinvestment transactions popping up mid-month.

Instead of digging through old statements, I fired up a pivot table in my Tiller Google Sheet using my transaction data. Bingo. It clearly laid out the pattern I hadn’t noticed before: my U.S. bond fund pays out monthly but my stock funds pay out quarterly. Never realized that specific schedule before. Now I have a much better handle on when that income actually arrives, and it gives me some ideas for other things to look into.

Another thing that jumped out thanks to Tiller and pivot tables was classic subscription creep. Those little $1/month price hikes on things like Kindle Unlimited, Amazon Music, Netflix, etc., really snuck up on me. Individually, they don’t seem like much, but seeing them all laid out in the data, I realized those small bumps add up to a pretty significant chunk over the course of a year.

I’m also in the process of transitioning from another popular budget system which uses the envelope system. That system is great for the month-to-month view, especially making sure budgeted money carries over, setting and meeting targets, and handling credit card float really smoothly. Tiller, on the other hand, has been fantastic for easily spotting these longer-term patterns (like the dividends and subscription creep) that the strict monthly envelope view sometimes hides. I’m still working on replicating or working around some of those envelope features I rely on in my Tiller sheets (not a feature request – just part of my learning curve).

Looking ahead, I’m also pretty excited about what AI might bring to the table. Imagine AI automatically spotting unusual spending trends or offering personalized insights based on our detailed Tiller data or even automatically performing routine tasks like reconcilliation. I’m not quite ready to connect my raw financial data directly to an AI yet, but I’m getting closer. The potential for AI to help manage budgets and uncover even more hidden insights feels like a real game-changer down the road.

Anyway, just wanted to share my experience in case it resonates with anyone else.

5 Likes

Nice write-up, discoveries and insight Kevin!

I can definitely relate. Seeing the individual transactions in a pivot table, report or dashboard catches ones attention!

I started up on Tiller once I retired and was on a fixed income. Drilling into my bills, recurring expenses and discretionary expenses in Tiller was extremely insightful. Imagine my surprise to realize we had two separate Amazon Prime accounts. Something changed along the way and my authorized user profile became a separate account.

4 Likes

@kkinderen, you had me at pivot table. :heart:

-Alice
Tiller Evangelist

Bluesky, Instagram, Facebook, LinkedIn

Thanks for the ideas @kkinderen! Do you mind sharing a couple of your Pivot Table topics? I use them so much for other Google Sheets, but have never thought to bring them into my Tiller sheet!

I am a big fan of the Category Rollup Report and Category Report, but they are static and have to be manually created each time you want to use them. I can see how a Pivot table could take over some of their use cases!

Not as beautiful as the Category Rollup report, but I love that the Pivot Table is dynamic!


Hi RachelB:

This is exactly right. To me, the big benefits of the pivot table is ease of use and ability to look at data maybe differently or in isolation.

I use three pivot tables. They may duplicate other Tiller or Community features but they are simple and easily adjustable by me.

#1 Rewards & Interest: This helps me keep track of my credit card rewards and bank interest which I kind of lump together.

#2 Dividends & Reinvestments: I use Fidelity. I have to normalize the descriptions but the pivot table takes care of month-to-month and year-to-year comparisons along with making sure the dividents and reinvestments match.

#3 Playground: I just fool around with different rows, columns, values and filters to look back on how subscriptions have increased over time for example.

That’s as far as I got so far.

Kev