Ideas/Help Reconciling a Checking Account after BOA EWC+ update

I reconcile my BoA accounts on Quicken, and I've never had a problem, not even with this September's statement..

Sort account by reconcile (R C) then look for items without either R or C.

My most recent BofA reconcile had a problem: it turned out to be duplicate transactions were downloaded (because a different "Downloaded ID" was assigned to a transaction that had been previously downloaded. I suspect this type of problem may last for a bit following the change to the EWC+ "connection method".

I used the register Date filter to exclude register transactions that I believed would not be involved in the problem. Then I sorted the register on Amount (I may have employed a second sort at some point - I've forgotten now), to help me find the duplicate transactions. In my case, I think all the original transactions were already reconciled, so it was easy to spot the duplicates: two transactions in succession with one "reconciled", the other only "cleared". I think just deleting the duplicates was all I had to do. [Just to be safe, I checked the account opening balance - some users have reported opening balance records being changed by a OSU. My opening balance transaction had not been modified (one good reason for that: I do not Sync my Quicken data).]

If you have the same problem I had, you shouldn't need to un-reconcile.

But if you feel that would help, you can do it. Select all the register transactions you want to un-reconcile (as you would select multiple files in Windows Explorer). Right-click a selected transaction and select "Edit transaction(s)". In the resulting "Find and Replace" dialog: select "Cleared status" in the "Replace" dropdown; key the letter "c" in the "With" box (or select "Cleared" in the "With" dropdown). Make sure all (or the appropriate) transactions in the "Find and Replace" dialog have a check mark in their "Select" box. Click "Replace All".

John, Thanks for this. Sorry for the delayed response. I'll have to dwell upon the register manipulations. I have a backup from Dec, 2021 even. I'll take a look at its Opening Balance - was thinking about that already. I may or may not do the August Recon just to see what happens. I'm presuming (I hope!) I'll eventually get it straightened out. Geo.

John Pollard and others - thanks. Problem quote solved.

The December, 1992 Opening Balance Trx had its Amount [grossly] altered from $45 and change to $1,400+!

Fortunately being the highly AR type with gobs of SSD and HHD free-space, I was able to look at the Opening Balance in a Dec, 2021 Backup and an August, 2022 Backup a few days after the August Reconciliation. Both showed the Dec, 1992 Opening Balance as $45.98. Following the EWC+ update the Opening Balance became $1,441.05!!! Jeez! Correcting for that then allowed September to reconcile to zero and October to zero after that. Phew!

I'm good to go. Geo.

There is one Quicken option that is frequently involved in screwing up Quicken transaction data - transaction data which may include Quicken account opening balances. That option is the "Sync" Preference for "Quicken Mobile & Web". Unless that option is essential, users should consider not using it.

One trick that might save you needing to look in backups to verify account opening balances: In your Quicken account opening balance transactions, put the correct opening balance amount in the Memo field.

I, for one, definitely don't have sync 'on' (just double-checked to make sure<g>). Frankly, I don't want anything to do with "The Cloud". I have my own on a local NAS and I don't do any kind of phone access to anything.

Good idea - I updated my Qkn Acct.