This isn't the kind of service we want you to experience, @yfegade.
I do apologize for the inconvenience. We have reported this issue and are investigating what may be causing this. We do have a workaround that might work for you, so if you have the time I can walk you through those steps right now.
Run the report from previous quarters and then when asked to update select "Yes" and it is able to pull all the data correctly. If that does not work clean install of QB and Excel are possible fixes. Here's how:
- Close Quickbooks
- Go to the C drive,
- Select the Program Files (86x),
- Choose Intuit, then Quickbooks20xx,
- Click the Components,
- Then, select Templates,
- Find the QB_Payroll_Link.xlt and delete it.
- Reopen Quickbooks and get a full payroll update
See the following article: Summarize Payroll Data In Excel Fix.
To integrate it with QuickBooks:
- Locate your QB Programs folder. Usually, the location is something like C:\Program Files (x86)\Intuit\QuickBooks 2020\
- Within that folder, go to \Components\Templates
- Copy the fixed XLT file included in this ZIP file into that folder, overwriting the file of the same name that is already there
- Launch from within QB as normal.
If you haven't contacted our QBO Support yet, I'd recommend reaching out to them. This way, they can pull up your account in a secure environment and sign you up to receive email updates as soon as they become available.
You can also check this article for the other steps: Fix export to Excel issues in QuickBooks Desktop.
For more helpful information about the operating system, hardware, software, and other requirements to run QuickBooks Desktop 2021, you can click here. Also, to ensure that you also have the updated bug fixes, I'd suggest downloading the latest release of QuickBooks Desktop from time to time.
Be sure to update me here on the results of your testing, I want to ensure this matter gets resolved.
