Envelope Budgeting In Excel with Tiller and Visual Basic

@tophermiller, thanks for putting this together. It’s impressive in its scope and you’ve done a great job documenting the functionality in the workbook’s first worksheet (even going so far as to help with “year-end procedures”).

You alerted users to script authorization. I imagine the script warnings/protections vary somewhat by platform. On my Mac, I did not see the yellow “security warning”… I’m not sure how the scripts were approved. I never saw a warning but they ran just the same.

You did a nice job integrating with the Tiller bank feeds in the Transactions and Balance History worksheets.

It looks like you built a lot of extra functionality into your Budget sheet which seems to serve a similar function to Tiller’s Categories sheet. I’d prefer to see your solution leverage the Categories-sheet convention that many users are familiar with… but I know that isn’t always possible when fleshing out complex, new workflows.

I think it is great to share solutions in this forum that break new ground beyond the conventions of our templates. Please continue to share new concepts like this.

For clarity though, for consideration for Builder Rewards Program prizes, solutions need to be “fully compatible with Tiller’s worksheet & column conventions” and also “should not use scripts”.

Again, I’m not discouraging sharing ambitious solutions like this that break new ground. I add this just to provide clarity on how our Rewards program functions.

Keep the good stuff coming!

1 Like