Is anyone seeing a lot of duplicate transactions recently? I used to not see any and over the past 1-2 weeks, have seen many with Chase and US Bank.
I have credit cards with both and no issues for me. I’ve only been using auto-fill lately, no manual fills.
Is the Transaction ID value the same or different?
If the same, Tiller issue.
If different, institution issue.
I have also noticed this, have been trying to pinpoint a particular cause but have not had any luck, citi was my main offender lately. And yes mine have duplicate transaction ids. All auto fill no manual fills.
@Mark.S - Thanks for responding quickly. This is happening everyday on multiple transactions, many where I had already downloaded and categorized.
Same Transaction and Account ID. Now seeing quadruplets…
Thanks for the support. Hopefully, this can get fixed very soon.
-Scott
The transaction ID being the same indicates that the fill might be crashing. Are you running many complex templates or scripts in that sheet?
No scripts other than what Tiller provides.
As for complex Templates, not sure what would be considered “complex”. Also, why/how would this affect filling in the Transactions and how would I I know if this is the cause and fix it?
Thanks.
@Cowboy13 are there many many transactions duplicates like it’s re-importing your entire history for some accounts, or did they just start coming in after a specific point in time and it’s only a few?
If the fill crashes partway through the process, which can happen if the process times out due to a combination of a ton of data + dashboards/templates that immediately start recalculating against the entire transactions sheet or balance history sheet, this can cause duplicates.
It’s an issue we’ve been trying to address for probably about a year now and we are just bumping into limits with what’s possible with Google with the add-on environment.
@heather - Thanks for the insight.
This started happening a few weeks ago and has been consistent since. I am regularly tweaking (trying to optimize) templates. I recently added some new ones that looked intriguing to check out, but probably won’t use them regularly.
Sounds like I should try deleting some of the recent ones and see if this mitigates the issue?
Would a slower or intermittent internet connection affect this? I travel a lot for work and run “;ess than ideal” internet quite a bit. However, I hadn’t previously seen duplicates when I travel and my travel has been pretty consistent since I started using Tiller.
Thanks.
Slower internet could definitely be exacerbating the issue.
There is a remove duplicates tool in the settings area of the Tiller Money Feeds sidebar that you can use to help you clean up those duplicates.
Otherwise, yes, clearing out any templates you’re not using is a good first start to see if it addresses the problem. Then after that the next mitigation step would be trying to trim the balance history (you can remove duplicated balance history entries by balance ID column and Google’s built in deduplication workflows under the Data menu in your sheet).
Last would be to clear out some historical transaction data and archive it into a separate spreadsheet.
Thanks for the ideas Heather. So is it the size of the Google worksheet that’s causing issues or the number of formulas it’s trying to calculate? I realize those are related, but my spreadsheet has not grown significantly before I saw these issues.
If trying to recalculate all the formulas while it’s trying to fill is causing time out issues, is it possible for the Tiller script to turn off recalculation while it fills? Seems like this would greatly improve the success rate of the fill.
For a data point, how many Transactions and Balance History rows do you have?
And what are the names of the templates you added recently?
13,660 Transactions
14,427 Balances
I regularly trim Balance History.
As for templates, I just deleted 6-7 that I hardly ever used or were “duplicates”. However, some of the more recent ones I had installed were- Travel Planner and Transaction Tracker. I just deleted both of these as I won’t use them much.
I also regularly make mods to existing templates (mine or others) to add features or try to optimize. When I do this, I make a copy of the existing and make the mods to the copy. Some of the recent ones have been- Retirement Planner (haven’t shared yet my tweaks yet), Yearly Budget (here), Near Term Account Forecast (here), and a few others. I hadn’t deleted the originals of these, but just did.
After my clean-up, I’ll monitor it and let you know if the duplicates stop.
Thanks.
1 Like
@Cowboy13 it’s likely both
If you have a lot of data (based on the numbers you shared you do have quite a bit, but not excessive necessarily) combined with complex dashboards that are calculating against the entire datasets that is what can cause the timeout.
Google Sheets does not offer this type of setting the way Excel does.
Heather and Mark,
Thanks for the feedback.
After the cleanup I did, it is now downloading transactions again without duplicates.
Also, I too looked up “turn off recalc” for Google sheets and I was surprised that is not an option. I have always taken it for granted.
Thank you.
2 Likes
I just noticed tons of duplicated transactions. Looks like it dates back to September. I’m seeing this on multiple accounts - checking and credit card from different banks. Some of the duplication includes the categorizing that I already did, some of which was manual, so not specifically related to autocat. Some of them are uncategorized duplicates of transactions that had been categorized. I don’t think it’s about my spreadsheet being complicated, and it’s definitely not institution specific.
Mine have also increased in duplication recently, I did use the Tiller Size my sheet tool and found that two of my sheets had duplicated my entire transaction history at some point and then when changed to not display them they left remaining cells in their place, I’m hoping that cleaning up these two sheets along with a small balance history cleanup will alleviate my issue.
Here’s my data point currently:
17,283 transactions
44,893 balance history entries
I ran into a similar issue previously with my large dataset, but with hitting it again, I’m thinking I may start to maybe do a rolling reduction in years of info with some new sheets with the upcoming new year around the corner
2 Likes
I started seeing this when reconciling and came to this forum for a solution. Mine are specifically Chase but yes lots of new duplicates.
I’d recommend reaching out to our support team via the chat window in the lower right corner of the Console at https://my.tiller.com/ they are the best equipped to help triage the issue to determine the cause. Sometimes the aggregator introduces duplicates. There’s more on duplicates generally in this help guide: What Should I Do if I See Duplicate Transactions in my Sheet? | Tiller Help Center
@bentyre1 sorry that this has persisted for you. We’ve tried a few times this year to correct the issues that cause complex spreadsheets with large datasets that can result in duplicates, but your case as well as a few others has prompted us to invest in a different strategy to try and mitigate this. I am hoping to have that available for beta testing later this month, but it won’t be ready to work in your existing spreadsheet powered by Tiller Money Feeds at that time so it’d just be validating that the overall technology will work better long term.
@madkins1868 if you’re just seeing duplicates for a single institution it could also be an aggregator issue and I recommend reviewing the help doc linked above and reaching out to the support team directly.
3 Likes
@heather - I just went through all of my duplicates and realized they were all downloaded (date added) on 11/3/2025. It went back two months, to early September. Something about the download of data on that day duplicated two months of transactions from multiple banks. I’ve deleted the dupes now, and I hope it was just a one-off glitch.