AmEx Savings transactions dated one day after the actual transaction, prevent reconciliation

seadan

This seems to be a relatively new phenomenon, but I can't pinpoint exactly when it started. Perhaps when Amex Savings accounts switched to the new connection method?

In any case, I'm noticing that downloaded transactions are showing in Quicken as being 1 day after the actual date of the transaction in Amex. Most likely it's a timezone conversion issue? Anyone else seeing similar behavior?

As an example, my statement closes on the 12th of the month, and interest for that period posts on the 12th. Since this issue started, when Quicken downloads the interest charges, it has a date of the 13th on it. And thus, when I go to reconcile my statement, it doesn't work properly because the interest posts after the statement closing date. Even if I manually adjust the transaction date to the 12th, when I attempt to reconcile it says there are no uncleared transactions to reconcile, which is false.

Any ideas? Anyone else having issues?

I am using Quicken Classic for Windows R61.17.

Quicken Kristina

Hello @seadan,

Thank you for coming to the Community to let us know you're encountering this problem. Changing the Date of the transaction won't impact whether the transaction shows up in the Reconcile window because Quicken is looking at the Downloaded Posting Date (which is harder to edit), rather than the Date field you see in your register by default. See this article on reconciling spending accounts for more details.

To see the Downloaded Posting Date column, click the action gear near the upper right of the register and select Register columns…

Near the bottom of the list of columns, select Downloaded Posting Date, then click Done.

You should now see that date field in your register. The column will be labeled Posting Date. To edit that Posting Date, right click on the transaction. Hold the control (ctrl) key and click Copy transaction(s).

This will bring up a View Posting Date window.

Edit the posting date as needed, then click OK. That should force Quicken to see those transactions as falling within the statement period.

Based on your description, it sounds like this change in behavior is due to the information being sent to Quicken by the financial institution. Have you contacted American Express about this issue? If you have more than one account with them, does this impact all your accounts?

I hope this helps!

seadan

Hey Kristina,

Wow, learned something new today, thanks! I didn't know about the downloaded posting date nor how to edit it, so that's good to file away for the future.

The issue seems to only affect my Amex Savings accounts — other credit card accounts seem to be OK. I did end up calling support today as well and showed the rep the issue, which we replicated in a new clean file. The dates on the Amex website/statement are correct, but the downloaded ones are all off by one day. It seems that it's most likely a time zone translation issue with the dates Amex is sending and how Quicken is interpreting them. I recall there was a similar issue recently with Schwab that was posted in the forums (and impacted me). I believe this was escalated internally so hopefully it can be investigated and resolved quickly.

Quicken Kristina

Thank you for your reply,

I'm happy to help!

Thank you for sharing the troubleshooting you did with American Express. If this is happening in a brand new file, then it's unlikely to be a file specific problem. I have forwarded this issue to the proper channels for further investigation and resolution. Thank you for sending a problem report with log files attached; it will help with the investigation. Please also provide a screenshot of the transactions as they appear on the financial institution website (please redact any personal information). If you are not comfortable posting it to this discussion, then please send it using a Problem Report.

Thank you!

(CBT-582)

seadan

Hi Kristina,

Awesome, thanks for following up on this. To clarify, I also worked with Quicken support so they have the problem report linked already I think. The ticket number I was given is 1625072 if that helps.

Quicken Kristina

Thank you for the follow-up,

I was able to get the screenshot I requested in my earlier post from the ticket you referenced.

I can see that when you contacted Support yesterday, they referred you to American Express and did not escalate the ticket.

The ticket I created will escalate this issue for further investigation.

Thank you!

seadan

Much appreciated, Kristina! Looking forward to hopefully hearing updates on this soon.