Still having issues with EWC accounts being deleted

Charlie@

Roughly a week ago I began having issues with all of my EWC accounts - not all at the same time but every one has had the problem, some multiple times. There are NO problems with any of my Direct Connect accounts. Sometimes the account simply stops downloading transactions with no errors of any sort. More recently Q has begun telling me that the account may have been deleted and places a little stop sign on the accounts in the account bar. Then I have to deactivate the download for the account and then re-enable it. But this takes a lot of time. This morning Q flagged 10 accounts across 4 different institutions that it said may have been deleted. All 10 of these were fine yesterday.

AND seemingly randomly when this issue happens, Q adds an "Opening Balance" transaction of a random amount one day before the first transaction in the account. Why? And then this bogus Transaction skews the balance and the account will not reconcile.

What is going on???

CaliQkn

@Charlie@ - you don't indicate if and what error code, but I suspect you are getting CC-800 errors with multiple financial institutions.

I have found the following steps are pretty successful in permanently fixing the reoccurring CC-800 errors -

1. Make a backup of your data file.
2. Validate your data file. Click on File→Validate and Repair File, then select "Validate". Click "OK". Review the "Validate & Repair log" for any messages that need to be acted upon.
3. Super Validate your data file. Same as step #2, except hold Ctrl-Shift when clicking on "Validate and Repair File".
4. Do a "Copy File" to create a copy of your data file. This process forces a rewrite of code and fix some file corruption issues. It will also clear out online connection "remnants" for all accounts. Click on File→Copy or Backup File, and select "Create a copy or template", and then click Next.
5. On the next screen, leave the defaults as is. You can change the new file name and location, if you wish. Click on "Save Copy".
6. During the copy process, you will be asked to provide a password for the new file. If you don't want a password, hit ESC.
7. When the process completes, switch over to the new file. You will need to re-setup online services for all accounts in the new data file.

This is the only way I have found to permanently fix the reoccurring CC-800 errors and CC-800 errors that affect multiple financial institutions.

CaliQkn

@Charlie@ - as for the opening balance issue, do you already have an opening balance transaction, and another one is being added?

Charlie@

Thanks CQ, I have already performed most of the things you recommend.

About a month before this started I did make a copy of my data file and began using it successfully for about 2 weeks. After that we were on a 3+ week holiday, and about 3 days after returning home this issue started. A coincidence ?

There is never any error code that I can see, just [sometimes] the message that the account may have been deleted.

I have validated and super validated my file. It came back clean. Again.

No 2nd opening balance transactions, just the one - which I have deleted and it got re-added - with a different amount! Note that it doesn't add this Txn all the time or to the same account, seemingly random.

I have also tried removing the 3rd party agreements at my FI's (after disabling Txn download), then starting over, but it happened again after that. Also, sometimes resetting the account accomplishes the same thing.

This morning there were no errors, but also no actual transactions were downloaded - just some pendings and these were duplicated - i.e. 2 pendings for the same Txn. Just bizarre. And while I am on the subject, I am going to turn off the pending transaction feature as it seems pretty useless. I frequently get duplicates and sometimes there are stuck pending Txns that have already cleared. Useless!

CaliQkn

@Charlie@ it looks like you've had some challenges with your Quicken data file, but it seems like you know how to resolve your issues (until it happens again).

As for the Opening Balance issue, the only thing I can recommend is to create a new category "Opening Balance" and replace the Quicken generated "self-transfer" category that seems to be causing the issue.

Charlie@

Latest Update and probable solution (time will tell):

Yesterday it seemed like the transaction downloads stopped again. No errors of any kind.

Again this morning no transactions downloaded even though I checked and there were over a dozen new ones available. However I did notice that there were a bunch of duplicate transactions in the pending bucket. So I disabled pending transactions and then performed an update. Boom! Everything downloaded.

Intuit - you need to take a look at how enabling pendings can foil the regular transaction download.