How do I change the post date for a transaction?

Gary Lee Ashford

In order to reconcile some accounts, I need to change the post date.

Used to be able (earlier in 2024) to "right click on the transaction, press and hold the ctrl key and choose "copy transaction" This "hidden" data shows the "posting" date which you can change.". This no longer works. When I do the above, no data is displayed that I can change.

I am on Quicken classic deluxe, version r56.9 build 27.1.56.9 on Windows 11 home.

NotACPA

By "post date" do you mean the date that the transaction posted at your FI, which is downloaded from that FI?

And since to reconcile is to compare, your Q records to the bank's statement … I don't understand how the downloaded Posting Date can differ from what's on your statement, thus I don't understand how changing this date assists with reconciliation.

Please elaborate.

Gary Lee Ashford

I have a statement from the financial institute that has a statement period of "March 1 - March 29, 2024". On the website, I have an interest income entry of $180.53 on 04/01/2024, which is included in the statement period of "March 30 - April 30, 2024". When I do "one step update" the $180.53 is correctly downloaded to quicken with a date of 04/01/2024. When I reconcile the account and enter a "ending date" of 03/29/2024" the transacions of 04/01/2024 are included.

04/01/24 is clearly after 03/29/2024, so why are the 04/01/2024 dates included in the reconciliation? Quicken must be using some date other than 04/01/2024 for this reconciliation.

Other people have had this problem and have documented it. This is where I got the solution in my original post, "right click on the transaction, press and hold the ctrl key and choose "copy transaction" This "hidden" data shows the "posting" date which you can change.". This solution no longer works.

Can this problem be fixed?

Thanks for any help.

NotACPA

What you're showing is NOT the downloaded Posting Date. It's the As-of Date. Just as if you write a check today (As-of Date) but it doesn't clear your bank until next Wednesday (Posting Date).

To see the Posting Date, click the Gear icon in the upper right of the register, click Register Columns and Check "Downloaded Posting Date".

I suspect that the posting date for your transaction actually falls within the Statement range.

q_lurker

@Gary Lee Ashford I believe the Ctrl-Copy technique only works in a spending account, not an investment account. Not sure about a spending account linked to an investment account which is really a pseudo-account.

I am not sure how (in what fashion) Quicken maintains any downloaded posting date for investment account transactions.

NotACPA

https://community.quicken.com/discussion/comment/20433735#Comment_20433735

AAHHH, Good point. I overlooked that this was an investment account.

But, to get that Reconciliation screen, doesn't that require that this be a Linked Cash Account?

And my LCA certainly has the Downloaded Posting Date

Gary Lee Ashford

Thanks to both of you for the info. You are right that the ctrl-copy does not work for investment accounts but does work for checking accounts. I am curious as to where you get your info as both of you are very knowledgeable. Is the ctrl-copy and posted date documented anywhere?

To fix the reconcile problem, I will just either (1) have to use a statement ending date that is not the real statement date or (2) delete the downloaded transactions that don't work and enter manually.

I dont understand why Quicken would use a date other than the as of date "that is downloaded and visible" when reconciling an account. I assume that Quicken is using the posted date (assume, because I can't see it) for reconciling.

Thanks again.

NotACPA

Q uses the Post date for reconciliation, and not the As-of date because As-of can EASILY cross statement periods. Such as when you write a check on the last day of the month.

Also, in preparing the statement, your FI's computers don't know the As-of date. YES, it's hand-written on that check but since it's not on the MICR line, there computers don't know it. The computer only know the Post Date.

My step-son just sat on his birthday check for over a month. How could the FI POSSIBLY prepare a statement, of activity in the account, based upon the As-of date of that check?

Remember, to Reconcile is to Compare … the bank's records (represented by the statement) to your Q records.