What is the goal of your workflow? What problem does it solve, or how does it help you?
This is an Excel-Only Zero Based Budgeting worksheet that integrates with Tiller Money data feeds and includes:
- Transaction Splits
- Monthly and Annual spend plan management
- Data quality validation
- Full-year cashflow forecasting and management.
- Auto file-lock with personal password for data security
How did you come up with the idea for your workflow?
I used Quicken for over 20 years and was never satisfied with the budgeting capabilities so I ended up building my own Excel tool, importing data from Quicken into it. I gave it to some close friends to use, and one of them asked me if there was a way they could import bank data directly into it. I did some research and found Tiller Money. Actually I found Money in Excel and Tiller Money. However, it was quickly obvious that there is no comparison and Tiller Money has by far the best user-value proposition. Even though the Tiller Money Excel template is in Beta all I really needed was the data feed. It was really easy to integrate Tiller Money in the Excel workbook.
This was done as a hobby for me on weekends. Meanwhile, I have seen over the past few months a number of Excel users asking for more features within the Tiller Ecosystem. I figured it would be good to make this available as a free option that “natively” supports Tiller imports for those individuals until the Tiller Team incorporates more features into the Excel offering. It is not part of the Tiller Excel Template, so needs to be linked separately from the template. I hope there are a couple of people who find this userful.
Please describe your workflow. What are the sheets? Does it use any custom scripts or formulas?
This is built with scripts and is (mostly) locked for customization (except for a few free sheets where you can add any custom pivots, graphs, reports, etc). It is built to provide a comprehensive budgeting solution in Excel for individuals who do not have a lot of deep Excel knowledge and want something feature-full without requiring a lot of their own customization work. That may not fit the desire for a lot of spreadsheet power-users on this forum, but I am sure there are those who are in this zone! Happy to provide something of value if someone has the need.
Anything else you’d like people to know?
I am interested in feedback and suggestions for improvement. It is not intended for a large audience, as it is just my hobby, but I will be improving the tool for my own use and would be glad to entertain suggestions for improvement or to answer questions that are not covered in the built-in documentation or the videos (please use those first!).
Is it ok for others to copy, use, and modify your workflow?
The tool is completely free to use (outside of course the Tiller Money subscription), but requires an activation code when you download and first start to use it. As mentioned above it is built with scripts and is (mostly) locked for customization (except for a few free sheets where you can add any custom pivots, graphs, reports, etc).
This post is my invitation for the TillerMoney audience to download and use the template/tool. The activation code is given below. The workbook only runs on Excel, and only on a local version of Excel (Office365). All data remains local. It also only runs on the Windows 10 operating system (does not yet support Apple/Mac computers).
If you said yes above, please make a copy of your workflow and share the copy’s URL:
Download Link: MMM_ToolDownload - Google Drive
Activation Code: TillerMoneyRocks!
It has built-in instructions on every sheet. However, I have generated a series of YouTube videos (links below) to walk through in detail in case there are questions. The watch time is long; 20-30 minutes each for most of the videos. However you can skip through to find what you need.
I suggest to look at video#1 which gives an overview, then #4 which discusses the Transaction tools (auto-categorization, splits, reconcile, suggestions, etc), followed by videos #7/#8/#9 which explain the monthly and annual expense management screens, along with cashflow, data quality checking and and forecasting capability. If you are an Excel user and decide that this is for you, then you can download the worksheet and go through the other videos for guidance.
1: PLANNING - Overview ( https://youtu.be/GlNVJJa7O8o )
2: PLANNING - Zero Based Budget Creation ( https://youtu.be/rE1Bw2mOVXA )
3: PLANNING - Annual Expense Planning ( https://youtu.be/ALOsQjelDE8 )
4: TRACKING - Transaction Entry and Categorization ( https://youtu.be/IRnbuCWP-w4 )
5: TRACKING - Bank Data Import with Tiller ( https://youtu.be/53jvVz5BM_4 )
6: TRACKING - Bank Data Import with Quicken ( https://youtu.be/MW5irowtLRM )
7: CONTROL - Monthly Expense Management ( https://youtu.be/b0c4gUECqQE )
8: CONTROL - Annual Expense Management ( https://youtu.be/ayvnBUBu0aA )
9: CONTROL - Forecasting and Cashflow Management ( https://youtu.be/1o5a0W1HCaU )