Issues with Foundations Sheet

Hi all, I’m using Google sheets and lately I have been having issues with my Foundations Template sheet; it’s duplicating, sometimes even triplicating, transactions that are brought in.

I also have to reset the Data Validation range to include my category list options for my new transactions.

Additionally, I have recently noticed that when I open my sheet, it already has some new transactions there, even though I haven’t manually chosen to “Fill sheets”, which was the never the case before. I believe this is where I run into the transaction duplication issue (when I run the “Fill sheets” option in an effort to make sure my account transactions are all up to date)

Have there been changes to how the Foundation Templates are loaded with transactions? Any suggestions for fixing those other issues?

Hi @dtour001 some accounts can refresh automatically and there’s also Auto Fill for Google Sheets. Learn more here. Please also review the troubleshooting guide here which details a few common sources of duplicates and how to resolve them. If you’re still having trouble with those please write in to support detailing any recent troubleshooting you’ve already attempted and the impacted accounts and/or institutions and we can take a closer look.

1 Like