# Balance History sheet not updating **URL:** \ **Category:** Ask Anything\ **Tags:** bank-feed-issue\ **Created:** [December 22, 2019, 12:49pm UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751 "2019-12-22T12:49:22Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![john.warren3](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/john.warren3/32/983_2.png) [@john.warren3](https://community.tiller.com/u/john.warren3)\ **Post date:** [December 22, 2019, 12:49pm UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751/1 "2019-12-22T12:49:22Z")
I’ve been using the Tiller Feed, which runs 8+ hours, and still no update to Balance History sheet. I created a new budget in a new file, same result. Any suggestions? Transactions are coming in, though, regularly, albeit a day late (I see transactions from the 18th on the 20th, not the 19th). However, the daily summary always has the right transactions and balances on it. ---
**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:** [December 31, 2019, 1:10am UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751/2 "2019-12-31T01:10:02Z")
Hi @john.warren3, For large data sets the feed can take a while. 8+ hours is unusual. I’d recommend reaching out directly to [support@tillerhq.com](mailto:support@tillerhq.com). The day late is likely just normal with the way the feeds/updates/refreshes work with the add-on and may be slightly different than what you’re used to. Heather ---
**Author:** ![adekunledauda](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/adekunledauda/32/749_2.png) [@adekunledauda](https://community.tiller.com/u/adekunledauda)\ **Post date:** [December 31, 2019, 1:53am UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751/3 "2019-12-31T01:53:09Z")
Hi John. The issue was never resolved. In fact, I never received a reply until your post. My Accounts balances haven’t update properly for over a month. I have given up on Balance history and account balances. ---
**Author:** ![Blake](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/blake/32/7052_2.png) [@Blake](https://community.tiller.com/u/Blake)\ **Post date:** [January 4, 2020, 11:14am UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751/4 "2020-01-04T11:14:16Z")
@adekunledauda I recommend contacting support directly. I recently started having similar issues. Getting transactions but not balances. Only affecting certain accounts. This likely has something to do with my specific sheet. I contacted support and they are working on it now. It might be something with your specific sheet too. If this issue was affecting everybody, it would shut Tiller down. Will you reach out to support, for me? Thanks, Blake ---
**Author:** ![adekunledauda](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/adekunledauda/32/749_2.png) [@adekunledauda](https://community.tiller.com/u/adekunledauda)\ **Post date:** [January 6, 2020, 12:03am UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751/5 "2020-01-06T00:03:49Z")
Thanks, Blake. I have contacted support and waiting to hear from them. My observation was Tiller is having issues with a large sheet. If you have a foundation template with two or four linked accounts, you won’t have a problem with balance history and account balance update daily. But, If you have several accounts linked and large transactions download from several accounts, the tiller will have difficulty updating the balance history and account balance in real-time. As I am writing, the last balance history and account update I had was 22 days ago. The issue needs to be look into by Tiller engineers. ---
**Author:** ![Blake](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/blake/32/7052_2.png) [@Blake](https://community.tiller.com/u/Blake)\ **Post date:** [January 6, 2020, 1:11am UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751/6 "2020-01-06T01:11:04Z")
@adekunledauda@heather Thanks for hanging in there and contacting support. I suspect you might have an issue with your specific sheet. I assume support did something to my sheet as my issues have now been fixed. Tiller is able to handle a large sheet as I think I fall into that category with 17 current linked accounts, 340 categories, 7,000 rows in my Transactions tab, and 4,000 rows (was 25,000 rows before my recent clean up) in my Balance History tab. Refer to the top of your Insights tab for some interesting data about your sheet. Don’t under estimate Tiller, it is amazing and has lots of housepower. Blake ---
**Author:** ![adekunledauda](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/adekunledauda/32/749_2.png) [@adekunledauda](https://community.tiller.com/u/adekunledauda)\ **Post date:** [January 6, 2020, 1:25am UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751/7 "2020-01-06T01:25:48Z")
Thanks Blake. Let Hope they will fix mine. ---
**Author:** ![Blake](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/blake/32/7052_2.png) [@Blake](https://community.tiller.com/u/Blake)\ **Post date:** [January 6, 2020, 1:33am UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751/8 "2020-01-06T01:33:47Z")
@adekunledauda@heather Don’t worry, they will but remember to reply if they have any questions or requests from you and continue to follow up with them to make sure things keep moving. Please let us know how it goes. Blake ---
**Author:** ![john.warren3](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/john.warren3/32/983_2.png) [@john.warren3](https://community.tiller.com/u/john.warren3)\ **Post date:** [January 9, 2020, 2:42pm UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751/9 "2020-01-09T14:42:05Z")
I did get the balance history to update. I first went into my balance history sheet and deleted everything from 2017 to June 2019. I have some accounts that appear to update multiple times/day. This created a HUGE worksheet - \>38k lines. I have other issues now, but this is updating. ---
**Author:** ![Blake](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/blake/32/7052_2.png) [@Blake](https://community.tiller.com/u/Blake)\ **Post date:** [January 10, 2020, 4:47am UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751/10 "2020-01-10T04:47:54Z")
@john.warren3 Glad to hear about the good news but sorry to hear about the bad news. This may be what you are looking for. Please let me know if I can help. I have been where you are at now. Good luck. Blake [https://community.tiller.com/t/tiller-labs-utilities-add-on-comprehensive-guide/80](https://community.tiller.com/t/tiller-labs-utilities-add-on-comprehensive-guide/80) ---
**Author:** ![john.warren3](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/john.warren3/32/983_2.png) [@john.warren3](https://community.tiller.com/u/john.warren3)\ **Post date:** [January 10, 2020, 4:51pm UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751/11 "2020-01-10T16:51:52Z")
Now isn’t this interesting - thank you for pointing me to the utility. It looks like it may be useful. However, it requires the column “Index” to work, and my sheets do not have that column. How’d that happen?!? ---
**Author:** ![Blake](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/blake/32/7052_2.png) [@Blake](https://community.tiller.com/u/Blake)\ **Post date:** [January 11, 2020, 4:01am UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751/12 "2020-01-11T04:01:51Z")
@john.warren3 Please see below for what Randy says. You should be in Tiller Labs, not Tiller. You do not have an index column and that is good. You should be able to use Tiller Labs Utility. Thanks, Blake [7d](https://community.tiller.com/t/tiller-labs-utilities-add-on-comprehensive-guide/80/8) Hey, @pindy. I just migrated the Trim Balance History scripts from Tiller Utilities to the [Tiller Labs add-on](https://community.tiller.com/t/how-to-use-the-tiller-labs-add-on/67). I haven’t tested it extensively, but it seems to work with my test cases. You can find the workflow under the `Tools / Utilities` sidebar menu. One note… older Tiller sheets used an `Index` column to uniquely identify accounts. Newer Tiller sheets (since ~July 2019) use the `Account ID` column instead. The new version in Tiller Labs only works with `Account ID` and will not run on sheets that only have the `Index` column. Hope you fall into the former category. Let me know if it works for you. Randy ---
**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:** [January 11, 2020, 4:50am UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751/13 "2020-01-11T04:50:34Z")
Hey @john.warren3, As @blake noted, I just migrated the Balance History Trimmer into Tiller Labs. The version in the separate Tiller Utilities add-on will soon be deprecated and relies on the obsolete `Index` column to uniquely identify columns. We now use `Account ID` as the unique index. Give the version in [Tiller Labs](https://community.tiller.com/t/how-to-use-the-tiller-labs-add-on/67) a try and let me know if it works for you. Thanks for your patience. Randy P.S. Thanks as always for helping out John, @blake. ---
**Author:** ![Blake](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/blake/32/7052_2.png) [@Blake](https://community.tiller.com/u/Blake)\ **Post date:** [January 11, 2020, 6:14am UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751/14 "2020-01-11T06:14:43Z")
@adekunledauda Any resolution yet? ---
**Author:** ![Nakeva](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/nakeva/32/213_2.png) [@Nakeva](https://community.tiller.com/u/Nakeva)\ **Post date:** [January 11, 2020, 6:15am UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751/15 "2020-01-11T06:15:28Z")
Just FYI, I too, have been having problems with Balance history updating but appearing to get transaction updates. Last Balance history update was 5 days ago. I will try some of the things mentioned here before contacting support. ---
**Author:** ![adekunledauda](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/adekunledauda/32/749_2.png) [@adekunledauda](https://community.tiller.com/u/adekunledauda)\ **Post date:** [January 11, 2020, 8:38am UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751/16 "2020-01-11T08:38:30Z")
Not yet. It seems things are getting worse. I now get duplicates transaction on every update. I have used the new tool, **Trim Balance History** to reduce the balance history but it went on for 24 hrs on my PC but trim nothing. I have given up on the account balances as I have not had a balance update in 25 days. With duplicates transactions, I can’t trust the report anymore. I am still talking to the support to fix the issue. ---
**Author:** ![Blake](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/blake/32/7052_2.png) [@Blake](https://community.tiller.com/u/Blake)\ **Post date:** [January 11, 2020, 10:22am UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751/17 "2020-01-11T10:22:03Z")
@adekunledauda Good, please keep talking with support. Anything you can do @heather to help if you are not already involved. It sounds like this user may be near the end of his rope. Thanks, Blake ---
**Author:** ![arvind.govindarajan](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/arvind.govindarajan/32/2022_2.png) [@arvind.govindarajan](https://community.tiller.com/u/arvind.govindarajan)\ **Post date:** [January 11, 2020, 4:55pm UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751/18 "2020-01-11T16:55:12Z")
I have the same problem - I have to keep closing and restarting the Money Feeds add on to get it to fully populate my balances. where each run takes many hours before I kill and restart. Going to each of the accounts on my phone and entering the balances manually takes 15min I tried the Trimmer. It immediately told me how many rows would get trimmed but after 1hr of run time did no trimming My workaround now is that I have two Tiller sheets. One is the “actual” one with the analyses and is the feed for the app i built. The other one has no analyses - instead it’s only purpose is to allow MoneyFeeds to run. I delete all the balance history rows on this 2nd sheet, restart the Tiller Money Feeds addon and allow it to populate (takes ~2min). Then copy the rows from the 2nd sheet onto the “actual” sheet by adding rows to Balance History and then copy pasting. Since the Account ID field is unique (at least it appears to be), it works ---
**Author:** ![Blake](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/blake/32/7052_2.png) [@Blake](https://community.tiller.com/u/Blake)\ **Post date:** [January 11, 2020, 7:22pm UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751/19 "2020-01-11T19:22:34Z")
@arvind.govindarajan That is crazy. I am glad you found a workaround but you should not have to do that. I recommend you reach out to support to get your situation fixed. You will contact them? Blake ---
**Author:** ![arvind.govindarajan](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/arvind.govindarajan/32/2022_2.png) [@arvind.govindarajan](https://community.tiller.com/u/arvind.govindarajan)\ **Post date:** [January 11, 2020, 7:30pm UTC](https://community.tiller.com/t/balance-history-sheet-not-updating/1751/20 "2020-01-11T19:30:03Z")
Already reached out, but this method was faster than waiting to hear back 🙂 [Next page](https://community.tiller.com/t/balance-history-sheet-not-updating/1751.md?page=2)