LIMITED TIME 90% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
User987654321
Level 3

Closing date changed?

QuickBooks closing date was set to 30-09-2022 (September 30, 2022). When I changed the system date format from DD-MMM-YYYY tp MM/DD/YYYY, then QuickBooks closing date was changed to 12-09-2022 (December 9, 2022). Nothing could be entered for today and no errors in October could be corrected. When I changed the Windows date format back to DD-MMM-YYYY, then the QuickBooks closing date again correctly showed as 30-09-2022 and October and November entries could be changed. What is going on?

Solved
Best answer November 07, 2022

Best Answers
BigRedConsulting
Community Champion

Closing date changed?

Yes, this is a security bug. Depending on the closing date entered, the date might advance to the 12th month, or might retreat all the way back to January of a given year, allowing wanton edits in the file during periods that are supposed to be closed.

 

It's actually amazing how lame this is, because dates in QuickBooks are usually stored internally as numbers, something like 44871 for today, but seems like the date here is stored as text and then - sometimes - adjusted if the resulting date is invalid.

 

For example, if you set the closing date to August 1 while the computer date format is DD/MM/YYYY, set it so to "01/08/2022", save it, and try to record a new transactions in July 2022, you'll get a message saying that the transaction date is before the closing date. So far, so good.

 

But then if you change the system date format to MM/DD/YYYY, reversing the month/day order, then even while QuickBooks is still running and the transaction form is still open (or restart QuickBooks. It doesn't matter), then you can record the transaction in July without getting any messaging!

 

This is because after making the system date format change, and then you open preferences and review the closing date, QuickBooks still displays "01/08/2022" as the date, only now it thinks that means January 8, not August 1! 

 

And so, now the user can add/edit/delete transactions all the way back to January 8.

 

Seems slightly wrong.

View solution in original post

2 Comments 2
ChristieAnn
QuickBooks Team

Closing date changed?

Hi there, User987654321.

 

I just wanted to let you know that I responded to your other post. In order to keep the conversation streamlined and provide you with the best resolution, I'll ask that you post any follow-ups there.

 

Just in case you haven't been notified of the new response, here's the link: https://quickbooks.intuit.com/learn-support/en-us/reports-and-accounting/possible-scurity-flaw-on-cl...

 

For now, you can open this article to view various details on how QuickBooks performs certain year-end adjustments based on your fiscal year start month: Close your books in QuickBooks Desktop.

 

Please let me know the further details of your concern. I'll be here every step of the way, User987654321.

BigRedConsulting
Community Champion

Closing date changed?

Yes, this is a security bug. Depending on the closing date entered, the date might advance to the 12th month, or might retreat all the way back to January of a given year, allowing wanton edits in the file during periods that are supposed to be closed.

 

It's actually amazing how lame this is, because dates in QuickBooks are usually stored internally as numbers, something like 44871 for today, but seems like the date here is stored as text and then - sometimes - adjusted if the resulting date is invalid.

 

For example, if you set the closing date to August 1 while the computer date format is DD/MM/YYYY, set it so to "01/08/2022", save it, and try to record a new transactions in July 2022, you'll get a message saying that the transaction date is before the closing date. So far, so good.

 

But then if you change the system date format to MM/DD/YYYY, reversing the month/day order, then even while QuickBooks is still running and the transaction form is still open (or restart QuickBooks. It doesn't matter), then you can record the transaction in July without getting any messaging!

 

This is because after making the system date format change, and then you open preferences and review the closing date, QuickBooks still displays "01/08/2022" as the date, only now it thinks that means January 8, not August 1! 

 

And so, now the user can add/edit/delete transactions all the way back to January 8.

 

Seems slightly wrong.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us