Recurring bill and income reminders

Hello, long time Quicken user here trying to get up-to-speed with Tiller and so far I really like it. Based on my limited knowledge of Tiller it seems to be more a current snapshot of your accounts. In Quicken there was a function to create bill and income reminders and those items could automatically be entered into the transactions so I not only see the current state, but what is upcoming, and eventually these would be reconciled with the transactions when they occurred.

Is the a similar workflow/functionality available in Tiller?

Is this something that is possible with Tiller?

2 Likes

Please try this - https://help.tillerhq.com/en/articles/1876993-can-tiller-send-me-bill-due-date-reminders
and let me know if it works for you as I never had much luck with it even after consulting with the help desk but I have not revisited it in awhile and not since recently migrating to the Foundations sheet. I recall it being only a pure reminder tool.

Thanks, Blake

1 Like

Hi @wmedernach and @Blake,
The solution that Blake refers to would send an email reminder to you for upcoming recurring bills. But it would not add those bills to the Transactions sheet.

At the moment, Tiller doesn’t have that functionality. [ UPDATE: Tiller’s Business add-on has this feature. See Heather’s comment below. ]

The transaction sheet only contains automatic actual transactions, plus user, manually entered transactions.

You could manually add future transactions. When the actual transactions were recorded in Tiller, you would need to delete the manually added transactions so it wasn’t counted twice.

I think it would be possible to build such a feature if many customers want it.

You could submit a Feature Request for this workflow.

Hi @wmedernach,

We actually do have this functionality in the “Business” features of the Tiller add-on (cc @jonorlin). If you run “Start” from the Tiller add-on’s Business menu it will install a few sheets (a dashboard, and a statements sheet) and will make the manually add transaction menu option available via add-ons > Tiller > Business. From here you can manually add future transactions and flag them for reconciliation (similar to your Quicken workflow).

No extra cost to use these features, and definitely great for non-business workflows.

Read more here:

Thanks for letting me know about that cool feature @heather !

Thanks @heather I will check this out!

I’m also transitioning from Quicken and decided to try out Tiller. The scheduled/recurring transaction feature was something I used heavily in Quicken. I scheduled all my income and bills to automatically be entered 45 days in advance which would give me a great idea of my cash flow for that period. The feature mentioned above only works for manually adding one transaction at a time with no way to make it recurring. It would be too time consuming to manually add all my data that way. I did find an add-on named Projected Balances that fit my needs. It requires a bit of hacking to get it to show the same information as Quicken. Here’s what I did once I added the sheet:

  • Changed the start date to the today() formula
  • Period Interval set to Days, Future periods to 45
  • Starting Balance cell I linked to the Balances sheet, in my case I linked my Primary Checking balance

The monthly recurring transactions are straightforward but you can’t use that section for anything that is not monthly, like my biweekly paycheck. For that I used the yearly section and entered in my next 4 paychecks (and various scheduled transfers) so that I’m covered for a little over the 45 days. I set it up using formulas so that going forward all I have to do is change the date in the first entry and the next 4 dates will fill in automatically. If I have any one-off scheduled transactions I can enter it into this section as well but I will need to clear it out once it gets downloaded to the Transactions sheet.

I’m OK with it working like this but I’m hoping Tiller implements a much better solution.

1 Like

Hi @Betty
That’s a very clever use of the Projected Balances sheet. Thanks for sharing your workflow.

Hi Betty,

I really like the way you structured that so much so that I’ve done basically the same thing. But you’re right. It would be nice if there was a way to factor in other transactions that occur at regular intervals but not necessarily monthly. @heather, maybe this is something the team could work on for a future release? In my head I envision another section with 4 columns instead of 3. The first and last columns would be “Description” and “Amount,” respectively while column 2 would be “Every” (i.e., some integer) and 3 would be the “Interval” (i.e., days, weeks, months).

One concern I have with the starting balance being linked to the current balance is that once the transaction hits, wouldn’t the balance drop by that amount and thus the projection would factor in 2 instances of the same transaction, at least temporarily? Maybe I’m not thinking it through all the way but that seems like what would happen.

1 Like

Yes, that’s exactly what happens. Not much you can do since there’s no single transaction entry to match and clear like in Quicken. You’ll have to manually move around dates as transactions come in depending on the timing. It shouldn’t be too bad if you keep your dates accurate. My car payment comes out on the 18th, the transaction shows up in Tiller on the 19th so by then the start date in the sheet is the 19th as well so the duplication doesn’t happen. But when the 18th falls on a weekend the transaction will be early and there will be duplication.