# "Balances" tab is borked - how do I restore functionality?

**URL:** <https://community.tiller.com/t/balances-tab-is-borked-how-do-i-restore-functionality/3437>\
**Category:** Google Sheets\
**Tags:** foundation, troubleshooting\
**Created:** [April 6, 2020, 5:01pm UTC](https://community.tiller.com/t/balances-tab-is-borked-how-do-i-restore-functionality/3437 "2020-04-06T17:01:18Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![TomWIN](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/tomwin/32/606_2.png) [@TomWIN](https://community.tiller.com/u/TomWIN)\
**Post date:** [April 6, 2020, 5:01pm UTC](https://community.tiller.com/t/balances-tab-is-borked-how-do-i-restore-functionality/3437/1 "2020-04-06T17:01:19Z")

</div>

Hi All,

I’ve made some “improvements” to this tab over the past few months (mainly summarizing categories), but now it isn’t pulling all the data it should from the Accounts tab. I’d love to just restore it to where it was before - is that possible?

Thanks!  
Tom

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\
**Post date:** [April 6, 2020, 5:17pm UTC](https://community.tiller.com/t/balances-tab-is-borked-how-do-i-restore-functionality/3437/2 "2020-04-06T17:17:12Z")

</div>

Try installing the [Tiller Labs add-on](https://community.tiller.com/t/how-to-use-the-tiller-labs-add-on/67) and using using the `Manage Solutions` workflow to restore the version in your sheet.

---

<div class="post-metadata">

**Author:** ![TomWIN](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/tomwin/32/606_2.png) [@TomWIN](https://community.tiller.com/u/TomWIN)\
**Post date:** [April 6, 2020, 5:35pm UTC](https://community.tiller.com/t/balances-tab-is-borked-how-do-i-restore-functionality/3437/3 "2020-04-06T17:35:15Z")

</div>

Thanks - I have the add-on, but that tab doesn’t seem to be part of the Manage Solutions tool.

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\
**Post date:** [April 6, 2020, 5:53pm UTC](https://community.tiller.com/t/balances-tab-is-borked-how-do-i-restore-functionality/3437/4 "2020-04-06T17:53:25Z")

</div>

Maybe you have an old version, @TomWIN. I’d rename your `Balances` sheet to `Balances Backup` and see if you can find the Balances sheet in the Add Solution pane.

---

<div class="post-metadata">

**Author:** ![TomWIN](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/tomwin/32/606_2.png) [@TomWIN](https://community.tiller.com/u/TomWIN)\
**Post date:** [April 6, 2020, 5:56pm UTC](https://community.tiller.com/t/balances-tab-is-borked-how-do-i-restore-functionality/3437/5 "2020-04-06T17:56:39Z")

</div>

It says that “Accounts” will conflict with “Balances”. Should I rename that one too?

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\
**Post date:** [April 6, 2020, 6:00pm UTC](https://community.tiller.com/t/balances-tab-is-borked-how-do-i-restore-functionality/3437/6 "2020-04-06T18:00:42Z")

</div>

I’d try that. Maybe you have old versions of both. Sounds like you may have a pretty old spreadsheet.

---

<div class="post-metadata">

**Author:** ![TomWIN](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/tomwin/32/606_2.png) [@TomWIN](https://community.tiller.com/u/TomWIN)\
**Post date:** [April 6, 2020, 6:25pm UTC](https://community.tiller.com/t/balances-tab-is-borked-how-do-i-restore-functionality/3437/7 "2020-04-06T18:25:34Z")

</div>

I think we’re making progress, but not quite there yet. The new “Accounts” tab, which was installed along with Net Worth Tracker (the only way to get it in there) is blank. The dropdowns are empty as well. Any thoughts on how to get the accounts I’ve selected in TillerHQ central into this sheet?

Thanks again, Tom

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\
**Post date:** [April 6, 2020, 9:56pm UTC](https://community.tiller.com/t/balances-tab-is-borked-how-do-i-restore-functionality/3437/8 "2020-04-06T21:56:19Z")

</div>

Unhide the right side of the Accounts sheet. Do you see a list of accounts? If they are in the hidden area, they are being found properly in your Balance History. The left/unhidden side is purely optional. Accounts only need to be manually listed there if you want to override anything about them (or assign a group).

Randy

---

<div class="post-metadata">

**Author:** ![TomWIN](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/tomwin/32/606_2.png) [@TomWIN](https://community.tiller.com/u/TomWIN)\
**Post date:** [April 6, 2020, 10:08pm UTC](https://community.tiller.com/t/balances-tab-is-borked-how-do-i-restore-functionality/3437/9 "2020-04-06T22:08:40Z")

</div>

Thanks Randy - everything on that tab is completely blank.

Best, Tom

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\
**Post date:** [April 7, 2020, 6:27pm UTC](https://community.tiller.com/t/balances-tab-is-borked-how-do-i-restore-functionality/3437/10 "2020-04-07T18:27:40Z")

</div>

Everything in the hidden area? Can you scroll way over to the right and send me a screen shot of what you see in S1:T11? Should looks something like:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/tillermoney/original/2X/9/977bb7d1fea2ac092510efb1ccc6cda2d6fafb44.png)

---

<div class="post-metadata">

**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\
**Post date:** [April 8, 2020, 12:40pm UTC](https://community.tiller.com/t/balances-tab-is-borked-how-do-i-restore-functionality/3437/11 "2020-04-08T12:40:52Z")

</div>

Hi @TomWIN if you’re still using a Feed Bot sheet you’ll want to make sure that the Account ID column is present in the Balance History sheet.

You can follow the steps in this guide to make sure it’s there and populated.

> **[Updating your Balance History sheet to use Account ID](https://help.tillerhq.com/en/articles/3696252-updating-your-balance-history-sheet-to-use-account-id)**
>
> Learn how to update and backfill Account ID data in Balance History

Also, if you’re unfamiliar with what a Feed Bot sheet is, here’s a quick guide.

> **[What's the Difference between Feed Bot and Tiller Money Feeds?](https://help.tillerhq.com/en/articles/3278745-what-s-the-difference-between-feed-bot-and-tiller-money-feeds)**
>
> Considerations for switching to the Tiller Money Feeds add-on.

Let me know if that doesn’t help.

---

<div class="post-metadata">

**Author:** ![TomWIN](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/tomwin/32/606_2.png) [@TomWIN](https://community.tiller.com/u/TomWIN)\
**Post date:** [April 9, 2020, 8:23pm UTC](https://community.tiller.com/t/balances-tab-is-borked-how-do-i-restore-functionality/3437/12 "2020-04-09T20:23:34Z")

</div>

That’s fantastic, Heather, everything from the feed is now showing in accounts.

Last question, I promise - how do I now enter manually-configured accounts such that they show up in my net worth, etc?

Best Regards, Tom

---

<div class="post-metadata">

**Author:** ![warren](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/warren/32/1191_2.png) [@warren](https://community.tiller.com/u/warren)\
**Post date:** [April 10, 2020, 1:23am UTC](https://community.tiller.com/t/balances-tab-is-borked-how-do-i-restore-functionality/3437/13 "2020-04-10T01:23:48Z")

</div>

Can you see if the general steps in this article help. [https://help.tillerhq.com/en/articles/3251091-adding-balances-for-manual-accounts](https://help.tillerhq.com/en/articles/3251091-adding-balances-for-manual-accounts), After following these steps the Net Worth may have an ungrouped account so you will have to do an extra step of reselecting the new manual account in the Accounts tab and updating the information on this tab. I hope this helps.

---

<div class="post-metadata">

**Author:** ![TomWIN](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/tomwin/32/606_2.png) [@TomWIN](https://community.tiller.com/u/TomWIN)\
**Post date:** [April 10, 2020, 1:13pm UTC](https://community.tiller.com/t/balances-tab-is-borked-how-do-i-restore-functionality/3437/14 "2020-04-10T13:13:00Z")

</div>

Thanks so much, Warren. It appears that I’m not using Tiller Money Feeds, so those steps don’t sync up with what I’m able to do on my end. Is converting from Feedbot worthwhile?

Best, Tom

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\
**Post date:** [April 10, 2020, 9:41pm UTC](https://community.tiller.com/t/balances-tab-is-borked-how-do-i-restore-functionality/3437/15 "2020-04-10T21:41:53Z")

</div>

I think it is worthwhile, @TomWIN. The future of our platform is Tiller Money Feeds. We still support long-time users (thanks for sticking with us!) with feedbot sheets, but eventually we will want everyone to migrate so they can take advantage of many platform improvements.

The [basic steps](https://community.tiller.com/t/how-to-use-the-migration-helper-from-tiller-labs/802#how-to-use-the-migration-helper) are to create a new Tiller Money Feeds spreadsheet in the Console then use the very recently-updated [Migration Helper](https://community.tiller.com/t/how-to-use-the-migration-helper-from-tiller-labs/802) (in Tiller Labs) to port your data (e.g. categorization) from your old (feedbot) spreadsheet.

Heather has written some [support content](https://help.tillerhq.com/en/articles/828060-migrating-an-existing-data-set-to-a-new-sheet) on this.

Let me know if you have any question,  
Randy

---

<div class="post-metadata">

**Author:** ![heather](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/heather/32/177_2.png) [@heather](https://community.tiller.com/u/heather)\
**Post date:** [April 21, 2020, 3:06pm UTC](https://community.tiller.com/t/balances-tab-is-borked-how-do-i-restore-functionality/3437/16 "2020-04-21T15:06:33Z")

</div>

@TomWIN, I also put together this guide:

[https://help.tillerhq.com/en/articles/3864414-guide-to-transitioning-from-a-feed-bot-sheet-to-a-tiller-money-feeds-sheet](https://help.tillerhq.com/en/articles/3864414-guide-to-transitioning-from-a-feed-bot-sheet-to-a-tiller-money-feeds-sheet)

Let me know if you prefer not to transition at this time and want more info on adding manual balances to your existing Feed Bot sheet.

Heather
