Journal sync date error

WeststarAdmin2 · ‎January 28, 2025

We have found that if we use the spreadsheet sync to upload journal entries we get an error saying that the date is invalid. The date is not invalid, it is formatted correctly and appears completely normal when looked at as text. Calling the support phone reveals that this is a known issue and they have been working on it since 1/21/25. I thought I would mention it here because I have not been able to find this information anywhere else. The status page says that everything is fine.

A new twist that I learned today is that, for mysterious reasons, typing in the date (over the date that had been pasted into the template spreadsheet) prevents the error. This would be a very time consuming workaround for our process, but may help for small numbers of entries.

WeststarAdmin2 · ‎January 29, 2025

I have discovered that our problem was self inflicted. The spreadsheet that was the original source for our journal entries was building a string of text in the Entry Date column. Excel did not convert it to a date when it was pasted into the Journal Entry Template spreadsheet. When I wrapped the text building function with the DATEVALUE() function I got a date that I could paste into the Template and the sync worked correctly. The hint in my original post was " appears completely normal when looked at as text". It should not have, it should have looked like a number.

View solution in original post

Sherrie_F · ‎January 28, 2025

I highly appreciate your efforts in sharing your experience and in finding a solution to the journal sync date error within QuickBooks Online (QBO). Let me guide you further on the next steps to take for you to handle this situation, @WeststarAdmin2.

Since you've been added to our list of affected users, you will receive emails from us with detailed updates and any new fixes as soon as they become available. Our team will communicate any progress or solutions promptly. Please know that we're dedicated to keeping you informed every step of the way as we work towards a permanent solution.

I'd also encourage you to reach out to our Support Team whenever necessary, as they are available to assist you with any further questions and provide additional guidance while our engineering team continues to address the problem.

Your patience and cooperation in this matter are immensely appreciated. Rest assured that we are doing everything possible to resolve this issue promptly.

In addition, I'll drop these articles which can be handy for you moving forward:

Thank you for your continued patience and understanding, @WeststarAdmin2. Should you need any immediate assistance within QBO or have further insights to share, feel free to leave a comment below. Wishing you nothing but continued success in your business endeavors.

WeststarAdmin2 · ‎January 29, 2025

I have discovered that our problem was self inflicted. The spreadsheet that was the original source for our journal entries was building a string of text in the Entry Date column. Excel did not convert it to a date when it was pasted into the Journal Entry Template spreadsheet. When I wrapped the text building function with the DATEVALUE() function I got a date that I could paste into the Template and the sync worked correctly. The hint in my original post was " appears completely normal when looked at as text". It should not have, it should have looked like a number.

Topics

Training

Community

Resources

Journal sync date error