Solved

What happened to the Export Payroll Data to Excel report?

Forum|Forum|2 years ago
April 1, 2024
6 replies
0 views

There used to be a report under Reports, Employees and Payroll called Export Payroll Data to Excel. With the latest update, that report seems to have disappeared. Is that report still available somewhere else?

QuickBooks Desktop

Best answer by BigRedConsulting

The issue is that Intuit updated the component that loads the menu items and apparently didn't test their update very well.

It turns out Intuit published the updated component with a switch turned on that creates a debugging log file every time you open or close a company file, which is when the menu items for the Excel payroll reports are added and removed.

The log files are saved in the folder C:\Temp\ and if that folder is not present then the code appears to choke and the menu items are not added.

While the C:\Temp\ folder doesn't exist on most computers, it's a common folder many developers create, and I just happened to have it on my computer as well. And so, after installing the 2021 patch, I didn't see the issue you are seeing, but I did notice the log files being created in my temp folder. When I renamed my temp folder to something else and launched QB again - no menus! Then when I returned the name to C:\Temp\ - menus!

So, to fix Intuit's little blunder, create a C:\Temp\ folder on your computer and then restart QuickBooks and you should see the menu items again.

K

Kevin_C

Thanks for posting today, SS2024. I'm here to share additional steps to pull up the payroll data report from your QuickBooks Desktop (QBDT) account into Excel.

You can still find the reports under the Employees & Payroll menu if you have an active payroll subscription. I'd be glad to show you how:

Go to the Reports menu, then Employees & Payroll.
Pick More Payroll Reports in Excel.
Choose the type of report you want to generate.
Enable Macros if prompted.
Select the dates, then Get QuickBooks Data or Create Report.

Additionally, here's an article that lists the available Excel-based reports you can generate from QBDT and steps to create worksheets: Export reports as Excel workbooks in QuickBooks Desktop.

However, if you don't see these reports, can you please send a screenshot of what it looks like on your end? Also, what QBDT payroll subscription do you have?

Additionally, you can play around with the reports and use this link to learn more about how to personalize your data in QuickBooks: Customize reports in QuickBooks Desktop.

Don't hesitate to respond if you have more questions about exporting reports in QBDT. I'll be here to lend a helping hand. Have a great day!

S

SS2024Author

Thank you so much for the reply. The screen shot you posted is what mine used to look like, but since the update a few days ago it is no longer there. I have the Enhanced Payroll subscription and I know it is still active as I ran payroll this morning. Attached is a screenshot of the reports I have under Employees & Payroll.

Document1.pdf

BigRedConsulting

Unless it's a new bug, it's unusual for the menu to go away.

I'd try repairing the QuickBooks installation. See How to Repair QuickBooks

Does that work?

M

Midwest-Q-Bks-User75

Who at Quickbooks is going to fix this problem? And when will it be fixed? We have the exact same issue. Ever since you (Quickbooks) pushed out the latest "update" this option for "more reports in excel" under the payroll reports menu no longer exists. Specifically the reports for 401k under this menu are critical for business operations. Before it disappeared we could normally run it for both 'Roth' and 'Traditional' 401k as needed. I attached a screenshot of that the report's headers normally look like when ran. We rely on this report every week to calculate our weekly 401k submissions for our employees. Now that this has gone missing by Intuit's "update", we don't have a way to calculate and provide this critical submission for our employees 401k money this week. Please advise ASAP?

E

Erika_K

Thank you for bringing this to our attention, Midwest. I'll further provide the necessary information to help you get past this issue.

We can manually update the tax table to provide you with up-to-date, accurate rates and calculations for federal and supported state taxes, payroll tax forms. If the same thing happens, we can install the repair tool to eliminate errors when you use, install, or update QuickBooks.

Here's how:

Close QuickBooks.
Download the most recent version (1.6.0.3) of the QuickBooks Tool Hub. Save the file somewhere you can easily find it (like your Downloads folder or your Windows desktop). Note: If you've installed Tool Hub before, you can find out which version you have. Select the Home tab. The version will be on the bottom.
Open the file you downloaded (QuickBooksToolHub.exe).
Follow the on-screen steps to install and agree to the terms and conditions.
When the installation finishes, double-click the icon on your Windows desktop to open the tool hub.

Then, we can use the QuickBooks Tool Hub to fix common errors.

In case the issue persists, I recommend contacting the QuickBooks Support Team. They have the resources to securely determine this issue through screen sharing while ensuring you're personal information remains safeguarded.

Here's how:

Go to Help, then select QuickBooks Desktop Help/Contact Us.
Hit Contact Us.
Give a brief description of your issue, then Continue.
Sign in to your Intuit account, choose Continue, and then Continue with my account.
We'll email you a single-use code. Enter your code and select Continue.
Click chat with us or Have us call you.

Check out their support hours to determine availability.

Furthermore, you can refer to these articles to learn more about how QuickBooks offers a selection of payroll and employee reports that can help you manage payroll and keep track of employee expenses: Customize payroll and employee reports.

Should you require more information about managing your payroll reports in QuickBooks, hit the Reply button. I'll get back to assist you. Keep safe!

BigRedConsulting

@Erika_K RE: To proceed, may I know which version of QuickBooks you are using? If you have an older version, it may be why you can't access the option for more reports in Excel.

That is not correct. All versions of QuickBooks have these reports and have since the turn of the century. Which, as the QuickBooks expert here, you should know.

T

TKD779

I am having the same problem.

FIX THIS NOW, QB!

A

AbegailS_

I understand that you are facing an issue with your QuickBooks payroll data report that disappeared after the recent update, @TKD779. I would be happy to assist you in resolving this issue.

In the meantime, we can perform some troubleshooting steps to fix this. First, let's run the Quick Fix my Program from the QuickBooks Tool Hub. This tool is designed to help fix common program-related issues. Here's a step-by-step guide:

Download the QuickBooks Tool Hub.
Open the file you downloaded (QuickBooksToolHub.exe).
Follow the on-screen steps to install and agree to the terms and conditions.
When the installation finishes. Double-click the icon on your Windows desktop to open the tool hub.

Once done, you can run the Quick Fix to repair your program. Here's how:

In the QuickBooks Tool Hub, choose Program Problems.
Click Quick Fix my Program.
Start QuickBooks Desktop and open your data file.

If the issue persists, we can further troubleshoot by running the QuickBooks Install Diagnostic Tool. You can find the step-by-step guide in this article: Repair your QuickBooks Desktop for Windows.

Also, you may want to check out one of our Help pages as your reference to guide you in managing your business growth and transactions using QBDT: QuickBooks Learn and Support. It includes

Let me know if there's anything else you need help with managing your QuickBooks Desktop. I'm always here to help you anytime. Take care and keep safe!

M

Midwest-Q-Bks-User75

@Quickbooks/Intuit Experts....

Any update on the fix? As you can see, several of us experienced the same problem since your most recent "update"

With your update, you wiped out the drop down reporting options for exporting additional payroll reports to excel.

We need it back. Please advise ASAP.

J

JuliaMikkaelaQ

Your frustration about being unable to utilize the Export Payroll Data to Excel report is understandable, Midwest.

Since you've already performed the troubleshooting steps, but still the issue persists, I recommend contacting our Customer Support Team for further assistance. They have the resources to review your account securely and investigate this further. Here are the steps to follow:

Go to Help, then select QuickBooks Desktop Help/Contact Us.
Hit Contact Us.
Provide a brief description of your issue, then click Continue.
Sign in to your Intuit account, choose Continue, and then Continue with my account.
Enter the single-use code that we'll send to your email, then select Continue.
Click chat with us or Have us call you.

Please know that our support team is available for Pro, Premier, and Plus users from Monday to Friday, between 6 AM to 6 PM. For Enterprise users, our support is available 24/7.

Moreover, you can refer to this article to learn the different payroll and employee reports that can help you manage and keep track of your payroll and customize them according to your business reporting needs: Customize payroll and employee reports.

Please feel free to leave a comment below if you have any further questions. I'm always here to help.

M

Midwest-Q-Bks-User75

No that's not it. Please try again. The exact same problem occurred on each of our workstations (this is QB Desktop) after you pushed your latest "update". And as you can see, we are not the only company with this problem. Please review whatever you broke during your last "update" and fix/patch it ASAP.

FYI we just discovered this as explained below doesn't work either now. So I suppose our State Agency won't be receiving their mandatory Division of Employment reporting this month (it's the same type of interface as the 'export payroll data to excel' reports so this doesn't surprise me)...

-->>-- File Forms -->>-- Tax Form Worksheets -->>-- Quickbooks Tax Worksheets (in Excel) -->>-- State Wage Listing -->>-- then ERROR messages: "The QuickBooks Text File engine was not able create an output file." & "Unable to connect to QuickBooks. Could not connect to QuickBooks. Be sure QuickBooks is running and a company file is open."

(and yes to save you the trouble of asking, I did make sure QB was running and company file was open)

T

TKD779

I'm currently on hold (for the last 1 1/2 hours and counting) after calling support about this missing report. After going through the usual "fixes" the agent said, basically, that the report was discontinued and the I should upgrade to QB 2024.

So, this brings up several points:

QB knows that they discontinued the report. Why do they waste 45+ minutes of everyone's time running "fixes" that they know will not fix anything? Don't the tell their own employees what they are doing and that it will likely lead to complaints?

Eventually, they conclude that indeed the report is gone, and that QB 2021 will be unsupported in two months, so you should upgrade to QB 2024. OK, so that means that QB wants to effectively steal two months of my already paid-for subscription and or a portion of what I paid for as I no longer have the full functionality that I paid for. Pretty infuriating. I asked for a refund and, of course, the agent and supervisor become mealy-mouthed.

Now at FIVE HOURS AND SIX MINUTES on the phone with four intuit drones. The net result - the only way to get and keep the report is to upgrade to Enterprise 2024 at what is effectively a 3-1/2 times increase in price with no increase in utility.

SO, THIS WHOLE THING IS ESSENTIALLY AN EXTORSION TO UPGRADE SO INTUIT CAN CHARGE ITS' LOYAL CUSTOMERS MORE MONEY. And, its taken A HALF-DAY OF MY TIME.

OVERALL, DISGRACEFUL WAY TO TREAT CUSTOMERS.

M

Midwest-Q-Bks-User75

I wish I could give you 100x Kudos upvotes. Thank you for sharing your experience. This is absolutely disgusting extortion at its worst. What a sad state of affairs. Sincerely though I appreciate that you've shared your experience thus far...silver lining is that you've saved me 5+ additional hours of my time, on the phone with QB "support", etc. to come to the REAL conclusion here.

BigRedConsultingAnswer

The issue is that Intuit updated the component that loads the menu items and apparently didn't test their update very well.

It turns out Intuit published the updated component with a switch turned on that creates a debugging log file every time you open or close a company file, which is when the menu items for the Excel payroll reports are added and removed.

The log files are saved in the folder C:\Temp\ and if that folder is not present then the code appears to choke and the menu items are not added.

While the C:\Temp\ folder doesn't exist on most computers, it's a common folder many developers create, and I just happened to have it on my computer as well. And so, after installing the 2021 patch, I didn't see the issue you are seeing, but I did notice the log files being created in my temp folder. When I renamed my temp folder to something else and launched QB again - no menus! Then when I returned the name to C:\Temp\ - menus!

So, to fix Intuit's little blunder, create a C:\Temp\ folder on your computer and then restart QuickBooks and you should see the menu items again.

S

SS2024Author

This actually worked! What a simple fix. Thank you so much!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded