posted
Hi @Danijor,
Thank you for posting here in the Community about the unusual result when exporting the report in QuickBooks. I'm here to help you fix the issue for the data to reflect in the correct order.
Ideally, your data should follow the same order for the items when exporting to Excel. Since you're not getting the desired output, I recommend performing some troubleshooting steps.
Before you begin, please update QuickBooks Desktop to the latest release. Aside from improving the performance of the software, this process also instantly fixes common issues.
Here's how:
- Click the Help tab in the upper-right corner, then select Update QuickBooks Desktop.
- Go to the Update Now tab.
- Select the updates you want to include.
- Put a checkmark on the box beside Reset Update.
- Hit Get Updates.
- Close and re-open QuickBooks.
Once done, let's isolate the problem by recreating the custom report. Existing report data may be causing the issue with the incorrect order of the line items.
If the same thing happens, let's proceed with running the Verify Data and Verify Rebuild tools. These features in QuickBooks will help self-identify data issues within a company file and self-resolve them using Rebuild Data.
To run Verify Data:
- Click the File tab at the top menu bar.
- Hover your cursor to Utilities.
- Select Verify Data.
Next, please run the Rebuild Data option through these steps:
- Click the File tab at the top menu bar.
- Hover your cursor to Utilities.
- Select Verify Rebuild.
After following the suggested solutions above, you should be able to get back on track with exporting custom reports correctly.
There are different methods you can perform to repair QuickBooks. I've attached an article you can use to fix QuickBooks via the QuickBooks Tool Hub add-on: Fix common problems and errors with the QuickBooks Desktop Tool Hub.
Drop me a comment below if you have more concerns about downloading reports or managing data. I'll be happy to help you some more.
