About this webinar
Every other week @randy and @heather will be hosting a community webinar to demo one Tiller Money Labs tool, solution, or workflow and offer “office hours” where you can ask your questions about other Labs features and solutions.
If you need help with basic set up join our Weekly Foundations Webinar.
Details on future webinars below.
Register even if you can’t attend and we’ll send you a link to the recording and Q&A.
The demos will be quick so we’ll have plenty of time for Q&A. Please keep in mind that we will likely defer more complex questions or demos for future webinar sessions.
We’ll see you in 2021!
Let us know what you’d like to see us demo by completing this quick survey.
Transaction Splitter from Tiller Labs
May 7 at 10AM PST
Learn how to split transactions among multiple categories.
Category & Budget Rollup Reports
May 21 at 10AM PST
Drill down to better understand where your money is going in specific categories and which transactions caused overages in your budget.
Envelope & Zero Sum Budgeting Tools
June 4, 2020 at 10AM PST
In this webinar we explored the Envelope budgeting tool via the Tiller add-on for Google Sheets. Learn how to install the template, get started for basic budgeting, and turn on the rollover features for zero sum or envelope budgeting.
The guide for the template featured in this webinar is here. This template is supported by our team in the Tiller Money Community. Our customer success team reached via email or chat does is not able to resolve issues or answer questions about this template. Of course, they’re always happy to help with data feed issues or other core product questions. Read more about our support on the Help Center here.
We also discuss the differences between the different add-ons we offer.
Manually adding & reconciling transactions
June 25 @ 10AM PT / 1PM ET
Learn how to use the Tiller Money Labs add-on to add manual transactions and flag them for reconcile. Great for cash flow and budget projections.
How to track cash
July 9 @ 10AM PT / 1PM ET
Learn best practices for tracking cash transactions in your Tiller Money Powered spreadsheets.
July 23 @ 10AM PT / 1PM ET
Learn how to use the Migration Helper in the Tiller Money Labs add-on to transition customized data from one Tiller Money-powered Google Sheet to another.
What is the Migration Helper? The Migration Helper (in Tiller Money Labs) will help you migrate enriched personal-finance data—(e.g. categories, splits, manual balances, etc.) from an old “source” Tiller Money spreadsheet to a new “destination” Tiller Money spreadsheet.
When Do I Need Migration Helper?
- Move from a Feedbot to a Tiller Money Feeds spreadsheet
- Start over in a new clean spreadsheet without losing history
- Merged enriched account data into another spreadsheet
What Does Migration Helper Migrate?
- Transaction categories
- Transactions-sheet columns
- Transactions splits
- Manual transactions
- Non-feeds transactions (e.g. Import CSV)
- Manual balances entries
- AutoCat rules
- New Categories
August 6 @ 10AM PT / 1PM ET
Learn how to use the Tiller Money Labs Debt Progress sheet to build your customized Debt Freedom plan.
August 20 @ 10AM PT / 1PM ET
The Spending Money sheet will help you understand how much discretionary spending you have to spend on a daily, weekly, or monthly interval. It’s a minimalists budgeting option.
Using Tags with Transactions and Categories
September 3 @ 10AM PT / 1PM ET
Learn how to use tags for more granular control over transaction reporting in your Tiller Money powered Google Sheet with the help of the Tags report and Category Rollup report from Labs.
- Webinar recording
- How to Guide for Tags Report
- Add A Column via Tiller Money Labs
- How to use the Category Rollup Report
Savings Budget (Prototype)
September 17 @ 10AM PT / 1PM ET
Learn more about our new Savings Budget that includes workflows for having your unspent or overspent category budgets carry over into the next month. Great for envelope budgeting!
Oct 1 @ 10AM PT / 1PM PT
Learn how to set and track savings goals with the Savings Tracker from Tiller Money Labs.
October 15 @ 10AM PT / 1PM ET
Distinct from the Debt Progress sheet, the Debt Tracker is on the same sheet as the Savings Goal tracker. Use it to get a quick overview of your outstanding debt and how much you need to budget for each one to pay it off by a certain date.
Monthly Analysis sheet
October 29 @ 10AM PT / 1PM ET
Use the Monthly Analysis sheet in your Foundation template to get detailed analysis of your actuals, budgets, and available with month over month comparisons and helpful visualizations of budget vs actual changes over time.
Rename & merge categories
Nov 12 @ 10AM PT / 1PM ET
A handy workflow if you decide you want to rename or remove a category after you’ve already been using it for a while or if you want to merge one category with another.
Holiday Gift Planner sheet
Dec 3 @ 10AM PT / 1PM ET
Use this Holiday Gift Planner sheet to track your gift spending. Organize your gift ideas, set budgets, and get a holiday shopping plan.
Transaction Splitter Demo - May 7, 2020
Do you intend to make the envelope budget sheet compatible with the main sheets?
We don’t currently have a roadmap to make the envelope budgeting features compatible with the Foundation template.
Love the tool. I’ve noticed it uses same transaction ID for each new split - will that cause any problems later (multiple transaction rows with the same transaction ID)
There are no known issues with the splits using the same transaction ID.
Do I need to click on the Description column for the row I want to split or can I click on any column in the row?
You can select any cell in the row for the transaction you want to split.
Heather and Randy, What are your favorite solutions?
Randy: The Weekly Analysis sheet from Tiller Labs.
Heather: The Monthly Analysis sheet from Tiller Labs.
can you use the splitter for investments?
Yes, you can use it for any type of transaction, but the workflow might be a bit different.
Automatic way to split/enter paycheck deductions like 401k, health insurance, etc?
There isn’t an automated way to do this with the splitter or other add-on/tool. You could use the manual transaction add tool in Tiller Labs to add them one by one or you could stage them in a separate sheet and add multiple rows each month. More in the community on that here
Category & Budget Rollup Reports - May 21, 2020
Please go ahead and show us some of the customization you mentioned.
The Category and Budget rollup reports both have a hidden report template tab that you can customize in certain spots to add a custom name, logo, or other formatting. Watch the recording here for a demo.
Sorry. A basic question- My budget screen does not show TILLER LABS. Does this mean that I haven’t added the add-ons?
You will need to install the Tiller Labs add-on via the Gsuite Marketplace. It’s a separate add-on from the one that feeds data to your sheet. More on that here.
when doing manual additions to the transactions worksheets, which of the columns are optional versus required; i.e. Categorized Date/ Date added & Month/Week…do you need to calculate these and add?
The answer to this question really depends on the report or dashboard you’re looking at after you add the Transaction, but in general only the date, description, category, and amount columns are required. Categorized Date is automatically updated by AutoCat as a way to indicate when AutoCat did it’s job. Month and Week are helpful for your own custom reports although there is a bug with the Monthly Budget sheet in the Foundation template right now where if you add a transaction to row 2 and do not include the Month data, the transaction won’t be calculated into the Monthly Budget dashboard. We’ll get this fixed soon.
In the example, you have a column called Notes. Where was that column added ? In the Transactions tab. My Transactions sheet does not have the notes column. I’m I okay to add it without breaking anything?
You can add it to your Transactions sheet (click the column header and insert 1 right or left and title it Note - singular - and it will work in the reports demoed in this session.
Can you create graphs to show % by category of spending per month
We recommended that this question be posted in the Tiller Money Community to get some information there more quickly or we may choose to do a demo of how to create this for yourself in a future session.
I remember a comment about implementing automated credit score data in the past. Are there current plans to add score monitoring to tiller? Thank you
We don’t have anything on our short term road map for included automated credit score data.
i want to see how my spending this month compares to all the previous months on a running basis - by category. any way to do this already or is it something i need to create
Check out the Monthly Analysis sheet.
Hi, I know this is a basic question, but I’m having difficulty getting one of my accounts to sync. What options are there for getting sync issues resolved with lesser-known banks?
Reach out to our support team via the chat tool on our help center or the Console at https://sheets.tillerhq.com/auth/google and go through the bot flow to give them the right information to get started with the troubleshooting.
Can you clarify the best way to account for contributions to saving accounts (529s, ROTH IRAs)? I have my accounts connected to tiller and also budget for them. However, the problem is I categorize them as a “Transfer” which means it doesn’t count as an actual.
Recommend searching the community for the answer on that. Here’s a little bit that’s already out there on this question.
Is it okay to manually change the description column on a transaction from the automatic feed?
It’s totally okay to clean up and edit descriptions for transactions and this won’t affect the feed. The edit is only being made in the current sheet you’re using and won’t appear in future sheets.
Envelope Budget - June 4, 2020
The guide for the template featured in this webinar is here. This template is supported by our team in the Tiller Money Community. Our support team via email or chat does is not able to resolve issues or answer questions about this template. Of course, they’re always happy to help with data feed issues or other core product questions. Read more about our support on the Help Center here.
Hi! I have been using Tiller since Nov. I used the Auto Cat but not it doesn’t work. I am a financial planner and been introducing Tiller to clients. I want to learn more!
We recommend onboarding clients to the Foundation template vs this envelope budget. We have a special section in the community for financial professionals with resources on how best to use Tiller Money with clients. Please complete this form for next steps on gaining access to these resources.
As far as AutoCat not working, please reach out to our support team via the chat tool in the lower right corner of the Console at https://sheets.tillerhq.com/auth/google
Can you say again (if you already did) where the list of shortcut commands is hosted?
You can learn more about the envelope budget shortcut commands here.
How would I break up charges on a credit card to itemize into categories?
Generally credit card transactions come through and are associated with the actual spending so when you use your credit card at the gas station so you’d just categorize it as “gas.” If you’re needing to split transactions for purchases that span multiple categories, you can use the Splitter workflow in Labs add-on.
is there a way to tie recurring bills or expenses to this budget starter sheet or the foundation template sheet?
One recommendation is to have these transactions staged in a separate sheet, for things like paycheck deductions. You can also use the Labs add-on to manually add transactions and then reconcile them when we bring them in automatically.
I’m wondering if, since the Envelope Budgeting Starter Sheet and the Foundation Template sheets are separate, is there to be any connection between the two data-wise. Are they meant to stay independent from each other?
They aren’t really MEANT to be independent, but at this point they are not compatible because the functionality and implementation are pretty different. The Migration Helper in the Labs add-on can help migrate data to a new sheet if you’d like to move from a Foundation template budget to try envelope budgeting.
"I am using the foundation template. How can I remove that
budget tool and use this one? Also, if I setup a monthly budget for one month, will that be copied over to future months?"
Recommend just starting in a fresh sheet and then using the Migration Helper in the Labs add-on can help migrate data to a new sheet if you’d like to move from a Foundation template budget to try envelope budgeting.
What additional information does the Manual Transaction download for Amazon give you beside what already populates daily into Transactions?
The CSV Line Item Importer tool allows you to get line item detail for Amazon purchases to help you clarify how money was spent on an Amazon order, since these often span multiple categories.
Manually adding & reconciling transactions - June 25, 2020
If each month you have a standard set of manual transactions with the same description, vendor, etc… is there anyway to streamline the entry so you don’t have to input each one individually each month?
Yes, the best way is to create a Recurring Transactions sheet and stage them there then just paste into the Transactions sheet so you don’t have to do each one over and over. Here is the example sheet we demoed. Feel free to make a copy of this to use in your own sheet. Just remember to use Paste Special > Values only when copying from the Recurring Transactions sheet to the Transactions sheet.
I use “split transaction” for my monthly paychecks, where I include tax withholdings, HSA deposits, etc. If I enter this manually, would it be able to reconcile with the single deposit transaction that shows up from the bank?
You could use the same “Recurring Transactions sheet” above.
If you wanted to load in a number of repetitive monthly manual expenses (that you are not going to need to reconcile against anything)…can you do so for the rest of the year now and be done with it. Will that cause any reporting issues?
It wouldn’t cause any issues with the feed or in the sheet.
Transactions are for actual deposits or withdrawals. When credit card statement arrives, it shows a date 3 or 4 weeks in the future when a withdrawal will occur. I’m wondering if manual transaction would show that future liability?
Yes, you could add the statement balance transaction to be paid manually to the sheet to show that future liability.
Tracking cash - July 9, 2020
Can you start with say under the mattress cash (an initial cash balance) , that may have occurred before an ATM transaction has been posted to Tiller transaction sheet?
Yes, if you’re tracking the balance in the Balances sheet using the Tiller Money Feeds add-on manual balance option you add the balance of the cash there with whatever date you like. If you’re using the automated balance for cash based on Transactions you may also want to enter a transaction for the starting balance.
I have transactions in two currencies - USD and Mexican pesos. My Mexican transactions are all in cash or from accounts not supported by Tiller. I’m fine tracking balances etc. in USD; I’ve been manually inputting USD values based on either the transaction-date exchange rates or (when possible) the exchange rate from whenever I turned dollars into pesos. Wondering if you have ideas for how to make that process a little less manual?
We’re primarily focused on USD right now so we don’t have great specifics on how to handle multiple currencies. The best thread going right now is here: Currency conversion while adding Indian bank accounts and loan accounts
Migration Helper - July 23, 2020
If I added a manual transaction without using the Manual Transaction tool, will it include that in the migration?
The simple answer is yes. It’s worth noting that a transaction added by hand will come into your destination spreadsheet through a slightly different pathway. Manual Transactions created by the Tiller Money Labs add-on are assigned a unique
Transaction ID with a format like
manual:0acd149b-8e24-4a3b-b1a7-01c3600fc574. Such transactions are recognized by the Migration Helper and migrated when the
Manually Created option is set to
Migrate All. If you added a transaction “by hand”, you probably wouldn’t have populated the
Transaction ID column, so that would migrate based on your
No Transaction ID setting (i.e. a similar pathway to Import CSV Line Items transactions).
Is this process only for Feedbot or other earlier Tiller Sheet? Or, could it be used to migrate exported data from another financial tool?
The Migration Helper is designed to work with all Tiller Money spreadsheets. It works great with Feedbot-to-Tiller-Money-Feeds migrations as well as Tiller-Money-Feeds-to-Tiller-Money-Feeds migrations. It may work with data from other finance tools but only if the column headers match up to Tiller’s standards. Your best bet for data from other finance tools is using the Import CSV Line Items workflow if import rules are available for your source data.
Is there a rollback feature if you make a mistake with the migration?
You can use the version-history/restore functionality built into all Google Sheets to rollback your spreadsheet if you are not satisfied. Only the destination spreadsheet is affected; no changes are made to the source spreadsheet.
Will there be a Financial Coaches portal in the future?
We hope so! Working with financial professionals and their clients is a new frontier for us at Tiller Money so we don’t currently have an estimate on when that might be available. If you’re a financial professional interested in using Tiller Money with your clients, join the invite-only Financial Pros group in the Tiller Money Community. Just complete this form for next steps: https://forms.gle/bP9nrydwJjHLEWM67
Debt Progress - August 6, 2020
Great Sheet! Thank you!..However on my sheet when either “Avalanche” or “Lowest Ranked First” is selected in the Payoff Method, the “Remaining Interest”, “Estimated Paid Off” & “Monthly Payment” columns are not populating with data. What might be the cause? Thank you.
You can try restoring the sheet using Tiller Money Labs or if that doesn’t work, reach out in the Community here
I’ve been using the debt progress sheet for a while. it seems to work even without having the debt category. so, how does that workflow affect the sheet? I ask because I don’t really see useful changes in the chart on the right.
Using the recommended category workflows for budgeting are not required to use the Debt Progress sheet. You can simply use this as a way to track debt and build a payoff plan.
something new you showed me today is a category for Interest. even though it comes through as a separate transaction, isn’t it already counted in the minimum payment or any extra money you pay towards that debt?
Interest charges that come through from the credit card are separate expenses and even though a portion of your minimum payment is going toward interest this is just a category to use for those transactions. You could have this as a hidden expense category so it doesn’t get counted in your budget or double counted against what you’ve paid toward debt, but gives you something to use for those transactions when you see them come through as these charges are for new interest accrued and not the amount of interest you actually paid with your last payment.
I am using the zero based budget sheet and wondering how to capture savings goals…would I just add it as a category?
I’d recommend checking out the savings goal section in the guide for that template.
Can you show how the rollovers work in the envelope budget?
I’d recommend checking out the webinar we ran on that template here.
Spending Money - August 20, 2020
If I change or modify the name of the category the transactions all show an error because the category name is different after the change. How do I update the category name for all the transactions to the new category name?
You can easily filter the Transactions sheet on the Category column and just review the transactions where you need to update the Category. Then use the quick fill square to quickly drag down the new entry to all the rows.
Typically how many days of lag are there between spending and Tiller transactions appearing? I’m wondering how far behind the “available spending money” would normally be. Thanks!
For a debit card usually there is no more than a 36 hour delay. Credit cards can take longer to clear transactions.
Where does the estimated cash flow come from again?
The estimated cash flow is the amount left over after subtracting the target amount for expense categories included at the bottom of the Spending Money sheet from the target amount for any income categories also listed there.
Using Tags - Sept 3, 2020
I’m using the original version of Tiller - created my Tiller Sheet #2 in 2018. Can I use Labs and Tags, or do I have to first convert to Foundations?
You should be fine to use it, yes. Any incompatible sheets will appear at the bottom of the Add a Solution list. You’ll also probably be prompted to “Adopt” a few sheets when you set up Tiller Money Labs.
On that note, if I manually add columns to my or client’s Transactions or Categories sheets, will that likely break anything?
Nope, most worksheets are built so that you can move columns around.
If I want to use Tags as “Sub-Categories,” can I fill in just the Tags in the Transactions Sheet and automatically have the Category filled in based on the Tag?
It’s best to just pick one way or the other. You’d need to use a formula to have the category populate based on the tag and if you want to also manually assign categories (not based on tags) it would get very confusing.
I imagine tags could be really useful for couples to tag “Partner #1 and Partner #2” expenses within various categories?
Yes, this is a great application of tags. Tags are great because they can span multiple categories.
When importing transactions to my transaction sheet, what is the best way to format the data to match existing data? (alignments/date formats)
You can manually do this or you can use the Basic CSV format from the Tiller Money Labs CSV importer tool.
Is Foundation template for Excel on the horizon? I’m an Excel guy.
We don’t have a roadmap for feature parity between Google Sheets and Excel at this time, but we do offer a great Excel starter template that’s very similar to the Foundation for Google Sheets.
Is there a way to automatically update the balances tab/sheet for a manual account (e.g. an outstanding loan) based on the transactions (e.g. payments to a loan)?
Yes, after adding an account manually via the Tiller Money Feeds add-on you can then add transactions via the Tiller Money Labs add-on and have the balance for manual accounts updated at the same time. This only works for manual accounts.
Savings Budget (Prototype) - Sept 17, 2020
Is there a way to not overwrite at each version update? Is there a way to not modify the set budget amount for each successive month?
The Savings Budget dashboard is just a visualization so there is no harm in overwriting it unless you’ve added customizations to it. To prevent the successive months from updating when you update the budget in one period, just remove the formula that’s referencing the previous cell by overwriting it or copy the cells and then paste special > values only.
A few questions came up about formatting
We’ve got these and recommend folks add more to a new topic tagged labs-savings-budget.
Can you confirm that if you track savings as an expense, the savings budget sheet won’t work correctly? Any alternatives to keep as an expense?
We’ll have better workflows documented for how to handle transfer transactions soon.
Can you add a column that sums the savings and budget columns to get total value of available spend for each category? Can you have negative values for each category?
You can certainly add a column and customize the dashboard to your liking, but keep in mind if you do a restore or update at some point in the future using Tiller Money Labs you’d want to archive your dashboard so you don’t overwrite your changes.
If you want to give this a try, insert a column into the spreadsheet between columns
E and enter a formula like this into cell
Hi I using for my business and looking how do I accrue for expenses that are paid annually? I want to know what it works out to montrose and create a way to save for that
You’d want to just set those categories as “savings” in the “Track” column on the Categories sheet after installing this budget dashboard and from there as long as you’re not spending in that category it will accrue the budgeted amount as savings.
Savings Tracker - October 1, 2020
What would be the appropriate way to handle and/or at least think about a year end bump in salary(bonus)(additional savings)? Just add the additional income to December budget and then continue with my savings goals?
Adding the additional income to the Dec budget definitely makes sense.
How do you make the money go to those funds. do you have to tell the bank to transfer it
The savings tracker assumes that whatever money you budget toward a goal is being saved. You can use the Savings Account check at the top of the sheet to confirm you have enough money in the account to cover all the assigned goals.
My savings budget sheet is showing all of my categories, not just the ones I selected savings from in the track column on categories. How do I make it only show the categories I want to save for/within?
The Savings Budget is intended to be a fully featured budget, not just a budget only for savings categories.
Debt Tracker - October 15, 2020
Does this work with the envelope budget template?
We haven’t tested this with the envelope budget tool via the Envelope Budget add-on (formerly called the Tiller add-on). It might work, but if it doesn’t let us know here in the community and we’ll see if we can get it working.
What if I already have my college loan account connected to Tiller? Do I still need to add a separate entry for it to the Categories sheet?
You would still want to create categories for each debt account you want to track in this solution.
Monthly Analysis - October 29, 2020
How do you get your Labs sheets update? how often do you need to do it?
Whenever we release an update to a Tiller Money Labs solution the Labs add-on will alert you that a sheet has a newer version available and will offer details about the change so you can decide if you want to update to the latest version. This is under Manage Solutions in the Labs add-on.
Rename Category - November 12, 2020
Holiday Gift Planner - December 3, 2020
Guess the way its built it can be used for tracking Annual charity
Sure you could use it for that, but a simpler option would just be to use the Foundation template’s budgeting features.
how can you do averaging. to tend to put in one month and spread it
You’d probably want to use this in combination with the Savings Budget
Are the transactions entered manually or can they be pulled in from the transactions sheet on the foundation template?
This leverages the automated transaction feeds from Tiller Money. You tag the transactions with the recipient name on the Transactions sheet.
Just had a question, allocating the gifting budget can be done based on income % or savings % … that would be a good approach? and query to check how much of gifting % of the income
You’d need to add some customizations to help you work out the % of your income for budgeting for your holiday giving. We cover a few options in the webinar and you can watch the replay to explore those.