I recently handed management of my retirement funds to a professional team at Fidelity, and because I’m not actively trading securities there, is there a way I can get Tiller to just update the account balance but not give me all the transactions? I always simply mark these trades as “transfers” so my budget reports don’t include them, and I know I could create an autocat to mark them as transfers so I don’t have to categorize them, but how about just keeping them out of my transaction ledger for simplicity? Not sure this works when I do want to regularly see the balance in my balances tab. Any ideas?
You could add them as manual accounts and update the balances periodically. If you have a several investment accounts, I shared a template that updates balances from Tiller Money Feeds and helps you copy/paste the balances into your Tiller file without all of the transactions.
2 Likes
Thanks, Brett. That certainly sounds workable, but after reviewing the instructions, it seems like I’m gonna need to set aside a bit of time to implement that. I was hoping there’s a setting that I just missed, but it sounds like a workaround is necessary. Thanks for answering!
It does look like a lot of setup steps, mainly with having to set up a separate Tiller Spreadsheet, though today I thought of a way to simplify that step.
That said, you should look at the other methods people are sharing in this discussion. You could set up Autocat rules for each investment account to categorize them as “Transfer” or another category that you “hide” on the Categories sheet.
1 Like
You could use a completely separate Investments worksheet, and ignore the ‘Transactions’ sheet inside of it.
Generally budgeting is done from checking/savings on the Budgeting worksheet, and investing/retirement-planning are done with the Investments worksheet.
Right. I get that. The only reason I want my investments in my main tiller worksheet is so my balances and net worth tab is accurate. I’m not using it for budgeting. By autocat labeling all transactions from those accounts as transfers, I can exclude them from budget and expense tracking reports, which is fine. I’m doing that. But I do use my transactions sheet a lot, and I was just hoping to reduce the clutter in there.
2 Likes
Thanks, Brett. I appreciate the linked discussion. I read that and decided I’ll just keep autocategorizing them as transfers. I also voted for the feature request. But the request has been there for a long time, so I hope someone does some work on it!
1 Like
Same! This issue is brought up quite often. I think there’s an open feature request and I hope Tiller is noticing how common this need is.
1 Like
I made something that solves for this. It is automated, so just a one-time setup needed.
2 Likes
Thank you! I have bookmarked that post so I can come back to it and try when I have some time.
That one got removed and replaced with a Show & Tell version, so I updated my link above.
1 Like