Word of warning, CapOne is now including pending transactions in credit card downloads
I noticed yesterday that CapOne is including pending transactions in their Web Connect (.QFX) file downloads for their credit cards. This has now happened with two different accounts.
Luckily, both of these transactions were from businesses were not bills like at restaurants where there is an initial hit and then a final which includes a tip, so they will not change when they change from pending to final.
There is no obvious way to keep this from happening.
-splasher using Q continuously since 1996
- Subscription Quicken - Win11 and QW2013 - Win11
-Questions? Check out the Quicken Windows FAQ list
Comments
-
Are they identified in the register as pending transactions?
Disabling pending transactions for your CapOne credit card account(s) does not prevent them?
Quicken Classic Premier (US) Subscription: R61.20 on Windows 11 Home
0 -
As I stated in the OP, these are Web Connect (.QFX) downloads. The controls on pending downloads is for EWC/EWC+ download connections.
There is no indication in Quicken that the .QFX downloaded transactions are pending. The only way to know that they are pending is what is shown on the CapOne website.
-splasher using Q continuously since 1996
- Subscription Quicken - Win11 and QW2013 - Win11
-Questions? Check out the Quicken Windows FAQ list0 -
As I stated in the OP, these are Web Connect (.QFX) downloads. The controls on pending downloads is for EWC/EWC+ download connections.
I download so very little with WC that I wasn't sure if the pending controls are applicable to it. Thanks for clarifying.
There is no indication in Quicken that the .QFX downloaded transactions are pending. The only way to know that they are pending is what is shown on the CapOne website.
When the pending transactions are downloaded, what do they show for the Clr status? C or blank?
I have 2 CapOne credit cards but one hasn't been used in months and the other has no pending transactions. Looks like I might have to make 1-2 purchases and then use WC to see what I get downloaded.
Quicken Classic Premier (US) Subscription: R61.20 on Windows 11 Home
0 -
a QFX file is the response that would’ve been sent as if direct connect had requested transactions. So basically everything that connect as far as how deal with transactions that have been downloaded the same. So those are as cleared. Not because they’re such a status in the OFX data, but because that’s what quicken does with downloaded transactions.
Signature:
This is my website: http://www.quicknperlwiz.com/1 -
When the pending transactions are downloaded, what do they show for the Clr status? C or blank?
What Chris_QPW said, stated a lot better than I would have.
-splasher using Q continuously since 1996
- Subscription Quicken - Win11 and QW2013 - Win11
-Questions? Check out the Quicken Windows FAQ list0 -
What is it about pending transactions in EWC/EWC+ downloads that causes them to be identified in Quicken as pending instead of simply being added as C transactions like what is being done with the CapOne WC downloads? There must be something different about the pending transactions data between the different connection methods and that makes me wonder why that difference couldn't also be included in the WC downloads.
Quicken Classic Premier (US) Subscription: R61.20 on Windows 11 Home
0 -
That is secret information that if Quicken Inc was to tell you, they would have to kill you. 😂
But here is a hint. Direct Connect, Web Connect don't flow through Quicken Inc or Intuit servers.
Signature:
This is my website: http://www.quicknperlwiz.com/2 -
Yeah, I understand that but I would certainly like to understand it better. There must be something in that EWC/EWC+ data that identifies what is pending vs what is posted. It would be nice to know what that is and why that can't or hasn't also been factored into DC and WC downloads, as well, so the pending transactions included in CapOne's WC can be either flagged as pending or can be filtered out.
I suppose this CapOne WC issue should probably be reported to Quicken so they can review it and determine what perhaps can and will be done to resolve it. The status quo, IMO, is not acceptable. Maybe @splasher will do that if it hasn't been done already?
Quicken Classic Premier (US) Subscription: R61.20 on Windows 11 Home
0 -
It would be nice to know what that is and why that can't or hasn't also been factored into DC and WC downloads
There might be something in the Quicken Cloud log that identifies the transactions, but I haven't looked.
Let me backup and state something that might not be obvious.
When @splasher says that his Web Connect import is including pending transactions, he means that he knows that they are pending, not that Quicken knows that they are pending. There isn't anything in the QFX file that is telling Quicken that a given set of transactions or "pending".
The same would be true of Direct Connect.
When we talk about the new Quicken pending feature, Quicken separates those transactions out from regular transactions because it knows that they are pending. These two aren't the same thing. Even though it has been pretty rare, it isn't unknown for a financial institution to include pending transactions in the downloads even though the "rules" say to only include the posted transactions.
Now as to how Express Web Connect and Express Web Connect + are identifying the pending transactions. Well, first off, Express Web Connect + is using a different protocol and it certainly could have the pending transactions identified. And in the case of Express Web Connect they might be able to pick up that information from whatever format a given financial institution is giving them for the download.
I do believe though, that most of this is determined on the Quicken server, not in Quicken (the program) itself.
But like I said, Quicken Inc almost never tells us any of the details of how anything works.
Signature:
This is my website: http://www.quicknperlwiz.com/0 -
Yes, I understand all that. That's why I suggested that this WC issue be reported to Quicken. They need to work with Intuit and/or CapOne to determine why the WC file is including pending transactions and what can and should be done to either keep the pending transactions out of the WC file or to somehow flag those pending transactions as pending. Whether that is a QFX file management process on CapOne's server or on Intuit's server or on Quicken's server or in the Quicken software or some combination thereof is something only they can determine.
Quicken Classic Premier (US) Subscription: R61.20 on Windows 11 Home
0 -
I quickly read the comments, so pardon me if this happens to be mentioned. There is a selection within Quicken that allows or disallows pending transactions. I tried using pending, but did not like it during reconciliation, so I turned off pending transactions. You can find the option within Preferences. (from the top menu, Edit / Preferences)
0 -
Those settings do not have any bearing on the contents of the Web Connect (.QFX) file that is manually downloaded from the financial institution's website.
This has happened before with Capital One, it went away and has now returned.
I made the OP just to warn other users that CapOne is up to it again. The biggest downside to this issue is that the online balance (which doesn't include pending) then doesn't agree with what you see in the Quicken register.
-splasher using Q continuously since 1996
- Subscription Quicken - Win11 and QW2013 - Win11
-Questions? Check out the Quicken Windows FAQ list0 -
Splasher - regarding your last sentence, that is exactly why I turned pending transactions off within Quicken preferences.
Suggestion, I’d make sure that is turned off in your Quicken preferences.
Also, is your Quicken set to allow you to review / match / delete transactions before accepting them into your register?
FYI - My CapOne Credit Card is set the Express Web Connect+. Any reason why you are manually using the QFX, vs Auto Download?
Quicken user continuously since 1988.
0 -
I use Quicken Deluxe on Windows, so not sure why near my name it says Quicken Mac Subscription. Although, I am typing this on an iMac.
0 -
You should be able to edit that here in your profile. This link should take you to it:
Signature:
This is my website: http://www.quicknperlwiz.com/0 -
Thanks, but for now I’d rather not install anything to be able to change that minor item.
0 -
Any reason why you are manually using the QFX, vs Auto Download?
I have no desire to have my financial information on the aggregation provider's (Intuit) or Quicken's servers, so I only use Direct Connect or Web Connect download methods. I also will never use desktop Quicken companion online apps (QMobile & QWeb).
A side benefit is that I also run QW2013 in parallel to subscription Quicken and the .QFX files can be converted to .QIF files (using ImportQIF) for import into QW2013. The DC download is from my brokerage and I don't track it in QW2013.
-splasher using Q continuously since 1996
- Subscription Quicken - Win11 and QW2013 - Win11
-Questions? Check out the Quicken Windows FAQ list0 -
I don’t quite understand a portion of what you said. Isn't Direct Connect the other method, separate from using a QFX file. Whether we like it or not, our information is likely on the Financial Institutions Back-Office Quicken Servers, based on the connection method. I’ve worked quite a bit with the Back-Office IT personnel at UBS. I too, will not use the Quicken companion apps, as I don’t like/need that and don’t want my information there. Thanks for including the side benefit; although, I have opened old Quicken Data Files with newer versions of Quicken. Just curious, what is your reasoning for running QW2013 in parallel to subscription Quicken?
0 -
Hello @splasher,
Thank you for letting us know this is happening. I don't usually update my Capital One account using Web Connect, but since I pay my card off in full every week on Tuesday, I should have a pending transaction to attempt to replicate this in a couple days.
Thank you!
Quicken Kristina
Make sure to sign up for the email digest to see a round up of your top posts.
0 -
There are three types of downloads.
- Web Connect (WC) where you manually download from the website (no data on a Quicken server)
- Direct Connect (DC) where Quicken makes a direct connection to the financial institution to download the transactions and your data is never on an aggregator or Quicken server
- EWC/EWC+ where the aggregator collects your information during overnight connections to aggregate your data on the aggregator's server for later collection by the Quicken program. EWC & EWC+ are variations of the same concept just using different connection methods.
2 & 3 use One Step Update to get the data into Quicken.
Whether or not the FI prepares the information for WC or DC separately from the rest of their data, it is still on THEIR server, not an aggregator/Quicken server and is behind their firewalls and secured by their cyber defenses. I either trust them or I don't, but the data isn't all over the place.
Why QW2013? It is the last version of Quicken that does not require a Quicken Id to install, register and use. If Quicken goes belly up and does not release a last version that removes the ID requirement, you are stuck with Quicken on that computer with probably never being able to move it to a new computer since you can't install/register it. I can run QW2013 as long as I have a version of Windows that it will run on and a VM running an old version Windows is not an issue since it would not need an internet connection or pose a security risk.
-splasher using Q continuously since 1996
- Subscription Quicken - Win11 and QW2013 - Win11
-Questions? Check out the Quicken Windows FAQ list1 -
Thank you, I will be sure to read this again.0 -
Sorry for the slow follow-up,
The transaction on Tuesday posted too quickly, but I was finally able to replicate the issue today. While this is most likely something happening on Capital One's end, I reported this to the proper channels for further investigation and resolution. If you would like to participate in the investigation, please navigate to Help>Report a Problem and send a problem report with log files attached.
While you will not receive a response through this submission, these reports will help our teams in further investigating the issue. The more problem reports we receive, the better.
We apologize for any inconvenience!
Thank you.
(CBT-618)
Quicken Kristina
Make sure to sign up for the email digest to see a round up of your top posts.
0
