This post has been closed and is not open for comments or answers.
Quicken Community Home Page

Quicken 2014: Possible bug - Wrong downloaded posting dates

I am on QW 2014 and I have observed what I believe to be a problem and I am wondering if others have noticed the same behavior.  

Background:  I have the "downloaded posting date" column enabled on my checking account through Suntrust Bank.  I have been using it for the past few versions of Quicken and never noticed any problems.  I manually enter ALL transactions by hand, ALWAYS, and then download transactions from my bank and the match them.  In QW 2014, the posting dates sometime appear on a transaction in the register(often the wrong posting date) and the transaction is marked cleared as soon as the transaction is downloaded from the bank.  Even though I have "automatically accept downloaded transaction" turned off.  The funny thing is that the downloaded transaction is listed in the "downloaded transactions" window at the bottom of the screen with the correct posting date.  As soon as I click "accept" on the downloaded transaction it will change the "downloaded posting date" column (although it is confusingly listed as just "posting date") to the correct posting date listed on my banks website.  I found this behavior rather peculiar, but nothing major to worry about....  Until today when I discovered other discrepancies with downloaded posting dates.

Actual Problem:  I received an ACH deposit of $11184 as a pending transaction on Saturday, Oct 19th.  The transaction didn't actually clear my account until Monday, the 21st of Oct.  I downloaded my transactions from Suntrust through direct connect on the 22nd of Oct.  All of the previous listed behavior in the "background" section above was observed and the correct posting date was placed on my $11184 deposit.....  No big deal, until today I was looking at that transaction to add an attachment and noticed the "Downloaded posting date" was now Oct 18th, a full day before the transaction actually hit my account.  I immediately checked the "posting date" by right clicking the transaction, holding control, then left clicking "copy transaction".  The posting date was listed as Oct 21st, as it should have been.  I then clicked on "help"- "log files" - "ofx log" and then saved a copy of that as a txt file.  I then did a search for the $11184 transaction and verified the following "<DTPOSTED>20131021120000".  Which to me means,  <date posted> Oct, 21st, 2013.  I then started looking at other random transactions and found many of them to have the downloaded posting date to be off by two-three days.  I have verified the date/time on all my computers and ran a validate on the file.  Everything else seems to be operating in what I have grown to accept as a normal state.  I have ran both a validate and a super validate on a backup copy of my file with zero errors detected.

Question: Soooo....  anyone else seeing discrepancies in the "downloaded posting date"  column?   Is there a possible way to have my posting dates go back to the correct date? Again, the correct dates are listed by right clicking the transaction, holding control, then left clicking "copy transaction".
  • Well I almost never pay any attention to the posting date, so I would never noticed this kind of problem.

    When looking at transactions where they are not manually entered/matched, all the dates are the same.

    For the manually matched some are different dates and of the dates I found this was typical (this is from USAA, Direct Connect)
    <DTPOSTED>20131025120000<TRNAMT>322.93

    And in the register (Note transaction was manually entered and then matched)
    Date 10/26/2013
    Posting Date 10/25/2013
    Ctrl+Copy Date: 10/26/2013

    So for my case the Posting date is what is in the OFX data, and the Ctrl+Copy Date is probably the download date.

    I'm not sure why your posting date would before the actual transaction date.
    I can tell you though it is a read-only date, you can not change it.
  • Why would those dates be different? And which one is used for the reconcile period?
  • I don't know why they would be different MsHiggins.  If I remember correctly the Posting Date and the Ctrl+Copy date use to be the same.  As far as I know the posting date is the one used in the manual reconcile, and if it doesn't exist because the transaction isn't downloaded, it then used the main one in the register.
  • I find the change disconcerting.
  • Personally I hate the whole business of the "hidden" Ctrl+Copy, and the read-only nature of the posting date.
    I think they should make all of these columns that the user can turn on, and they should make it so they can edit them.
  • QPW,
        I agree completely!  I use Quicken to command better control over my finances and I don't like things in Quicken that limit my control.

    Daaknes
  • Hoping you are only referring to the "hidden" posting date (read-only?) and not the "Downloaded Posting Date": I agree.
     [I believe that the "hidden" posting date is not the same field as the "Downloaded Posting Date". I think when Downloaded Posting Date is first populated from a download, the hidden posting date is given the same value - but after that, I don't see any connection between the two.]

    I have long wished the hidden posting date would be as visible as any other register field ... including being available in reports - for display, selecting, sorting and subtotaling.

    [Edit: I believe the hidden posting date is used for reconciles.]
  • Given that we can change the hidden date, I decided to test which is used for reconcile (in Quicken 2014).
    It is the hidden date that is used.  I could change it and make a payment appear or not appear in the reconcile.

    So at least the user still retains the ability to change it.

    How it now relates the the posting date, I have no idea.
  • "How it now relates the the posting date, I have no idea".

    My interpretation: hidden date is blank until/unless transaction is downloaded - or user manually modifies. If transaction is downloaded, "Downloaded Posted Date" is moved to hidden date (overlaying whatever was there). After transaction is downloaded and Accepted, user can modify hidden date, and it will keep user entered value.
  • So back to Daaknes' original question, why are the dates changing between the "hidden" posting date (read-only?) and the "Downloaded Posting Date" if Daaknes is not changing either date?
I keep my Quicken file in Dropbox so I have hundreds of backups going back 30 days.  So I decided try and track down exactly what happened and when the dates changed.  It took a while but I have discovered more problems than I originally thought.  

Oct 22nd, 2013 @12:31am
All transactions are normal, they have the manual dates that I put in, and the transactions in question have no downloaded posting dates and no hidden posting date because I have not done a one step update.  Older transactions have some recently discovered downloaded posting date issues, but for this investigation I am going to stick to the deposit discussed above.

Oct 22nd, 2013 @12:41pm 
Opened my file and executed a one step update and the transaction in question was updated with the correct downloaded posting date and the  correct hidden posting date of OCT 21st, 2013.  The transaction was manually entered with a date of Oct 19th, 2013.

Oct 22nd, 2013 @12:54pm
Had closed my file and revisited it, and the downloaded posting date had changed from the 21st to the 20th.  The hidden posting date stayed with the correct date of the 21st.

Oct 22nd, 2013 @17:24pm
 No change, all is the same as last time.

Oct 23rd, 2013 @9:44am
The next five backed up files were all unchanged from the previous status.  Did a one step update for today with nothing worthy of reporting

Oct  23rd, 2013 @10:45am
The transaction changed from a downloaded posting date of the 20th, down to the 19th with no discernible reason as to why.  I also noticed several other transactions that had their downloaded posting date decrease by one day.

Fast forward to today Oct 29th, 2013 @10:00pm
The $11184 transaction(the one I have been tracking this whole time) now has a downloaded posting date of Oct 17th.  Again, no discernable reason why it would change.


Summary:
I can't find any reason why this happening...  it's not tied to any one transaction nor a single financial institution or account type.  The downloaded posting date seems to decrease by one every day.  I can't seem to force it to happen, it just shows up that one.  All files pass validation and super validation without error.

Hope this helps,
Daaknes
  • Is it decreasing each time you OSU and there are more transactions for an impacted account?
  • It is not tied to every OSU.  Can't seem catch it exactly as it is happening.  And yes, it affects more than one account.

My transactions have the correct date in the Date and Posting Date columns until I Reconcile the account.  After Reconcile the Posting Date is now in the Date field and the transaction date that I entered has been moved to the Posting Date field.  I've tried to convince Quicken support that the Reconcile function has a bug but that chat was a waste of time.

  • What Quicken year version and operating system?
  • 2014 and Windows 7 Professional.
  • Additional information.  The problem starts at 11/1/2012 in my files.  Before that point, the dates are correct.  I had Mobile and Cloud turned on for a while so that I could access data using the Kindle app.  I found this process buggy so I stopped using and deleted my Cloud data. I upgraded to 2014 in November of 2013 and started using the Cloud.  I believe the Cloud uploaded a years worth of transactions.  I wonder if the Cloud data was corrupt and a Sync changed the dates in my Registers to match the Cloud data?  I'm not sure when I cut from the Cloud.  I don't think I've done any Reconciliations since that time.  My next account to Reconcile will be on 2/4 so I'll watch my data to see if the dates swap after the Reconciliation is Done.
  • I reconciled a credit card account today and the Downloaded Posting Date stayed in its column and the Date stayed in its column.  I believe the dates were getting transposed between my Kindle, the Quicken Cloud, and my PC.  Now that I've quit using the Kindle and Cloud the dates are staying put.

Similar questions other people found helpful: