I can see how you want the automatic update to work, homebrewed.
We can refresh your bank's connection by manually downloading your latest transactions. But before we proceed, may I know what's the name of your bank? This is to make sure that this isn't an issue on the bank's side. Furthermore, you can follow these steps to fix the connection.
- Go to the Banking menu or Transactions menu.
- Select Update.
You'll also want to manually upload transactions in QuickBooks to get the older transactions from your bank. Please check this article: Manually Upload Transactions Into QuickBooks Online.
I have these banking help articles in case you have any questions about QuickBooks.
Feel free to let me know if there's anything you need. I'll always make sure to get back.
