Downloaded Transactions Posted With Later Date

My Quicken account reconciliation with Wells Fargo Bank for months 12/31/2021 and 11/30/2021 uncovered an issue with the dates that are posted during my daily transaction download. For example, Wells Fargo Bank posts their interest at the end of the month. However the 11/30/21 Interest payment downloaded to Quicken with the date of 12/1/21, even though the Wells Fargo website and bank statement, shows it was posted on 11/30/21. This was true for the 12/31/21 interest payment as well. Note that it was not only the interest payments downloaded with this issue, but other transactions as well.

This caused a problem with reconciliation via Quicken. Using the 11/30/21 reconciliation as an example, when I put in the reconciliation end date as 11/30/21, there was a discrepancy because the 11/30/21 transactions were downloaded to Quicken as 12/1/21. When I put in the reconciliation end date as 12/1/21, everything reconciles just fine. As an experiment, I went into the transactions posted with 12/1/21 and changed the date in Quicken to 11/30/21. This made no difference and the only way I could get the reconciliation to come out successfully, I had to changed the reconciliation end date to 12/1/21.

Please note that this same thing was true for the 12/31/21 reconciliation and I had to put in a reconciliation end date of 1/1/22 in order to get it to reconcile.

Please note that I have been a Quicken User since 1994 and I am OCD about reconciliation every month and I always balance to the penny. I have never had an issue until now. This issue appears to be a Quicken bug in the download process.

Please help.

Answers

  • jacobs
    jacobs SuperUser, Mac Beta Beta
    There's an easy way to see if Quicken is doing this or if your bank is doing this. Click on one of those interest transactions, and select View > Show Inspector. At the top is Quicken's date, and near the bottom is the Posted Date. If the Posted Date shows 12/31/21 but Quicken's date is 1/1/22, that would be odd. But if the Posted Date shows as 1/1/22, then that date is what your bank is sending to Quicken. Please report back what you find. (A screenshot of one of the Transaction Inspector window could be helpful.) 

    You could pursue this with Wells Fargo if they are sending the wrong posted date. Or you could just live with it, and always enter a date a day or two after the month-end in your Quicken reconciliation. There is really no downside to using a later statement ending date in Quicken. If any other transactions show up in your reconcile window which didn't clear in the prior month, just ignore then=m and don't check them, and they'll show up in your next reconciliation. 
    Quicken Mac Subscription • Quicken user since 1993
  • mgrant1152
    mgrant1152 Member
    Thank you for your response! I never knew about the Show Inspector. I checked it for three transactions that were posted on the Wells Fargo website as 12/31/21 but came through to Quicken as 1/1/22. When I did a Show Inspector in Quicken for each of these transactions, the Posted Date shows as 1/1/22.

    I will consider contacting Wells Fargo to report the issue. It just doesn't make sense download to Quicken, a different date than is posted by Wells Fargo. It just serves to make things confusing. However, if I get nowhere with Wells Fargo, I will just live with it.

    Thanks again!
  • jmad
    jmad Member
    Mgant, I have the same issue. For me, it wasn't a simple matter of changing the dates, I have to delete and re-enter each mis-dated transaction.
    Thanks Jacobsf the tip
  • jacobs
    jacobs SuperUser, Mac Beta Beta
    @jmad Can’t you simply add a day or two to the statement ending date when you reconcile? That’s a lot easier than deleting and re-entering transactions.
    Quicken Mac Subscription • Quicken user since 1993