Hello there, grishsavla.
We can fix the incorrect report by enabling Marcos. Here's how:
If your customer gets a notification about Macros when exporting, accept the Macros. You can also check this article to learn on what to do when there are missing details when opening the report in Excel. Then, here are some articles that will guide you through modifying and memorizing reports within your QBO account.
Please don't hesitate to post again if you have other questions. I'm here to help. Take care always.
I did what you explained but still it is not working. When I export to excel the dates are not in dates format, I try to change but it doesn't work. Of course, when I try to short by date that column it doesn't do either. Could you help please?
Thank you for trying the steps shared by Sarah.
It would be best to contact our Chat Support team. That way, they can start a screen-sharing to gather more details and investigate this further. They have more tools on their end.
If you have other questions, feel free to go back to this thread.
Hi there, @Gulraiz
I understand how important to manage your report in doing business.
To further assist you, I'll ensure you'll be routed to the right support. In that way, they can check why you're experiencing this kind of error.
Here's how to contact them:
You can check our support hours to ensure we can address your concern immediately.
Feel free to visit our QuickBooks India Community. This page contains a lot of questions about handling your business transactions, reports, and other topics.
Don't hesitate to click the Reply button to post a comment or to let me know how the chat goes. I'm always here, willing to assist you. Keep safe.
Hi @AbegailS_ and the rest of QuickBooks team
I am having the same issue with my QB.
As suggested, I have contacted the QuickBooks team and they do not have a solution for this problem.
If anyone found out how to fix the issue, please let me know. I am also open to a phone call from anyone from QuickBooks team to show me a solution.
As off right now- QuickBooks team's Suggestion is to "retype each date" which is laughable.
I'm creating a new column next to date column in Excel. I use function =Datevalue and click the column where the dates are from the QBO export. This converts General/Text type into date format. At least this worked for me and I was able to group dates again in pivots etc..