Skip to main content
D
dsharron
September 11, 2023
Question

Payroll Details report export is creating additional columns

  • September 11, 2023
  • 1 reply
  • 0 views
Payroll Details report export creates columns that contain detail data only and additional columns with different headers that contain the total for the column. We were informed in March that this was a know defect and it was being worked on. I called for an update today and was told it's an Excel issue. Can anyone explain how Excel is creating headers that weren't provided by the export file?

1 reply

M
Maybelle_S
September 12, 2023

I appreciate your dedication to resolving the issue, dsharron. Let's make sure you can successfully export the Payroll Details report without any changes.

 

The previous investigation has been successfully concluded, and we are currently addressing an ongoing issue related to your concern. Our software engineers are working diligently to identify the root cause of the problem. We assure you that we are taking all necessary steps to get this rectified as soon as possible.

 

For now, I recommend contacting our support team. This way, you'll be added to the list of affected users and receive status updates through email or SMS. For a faster transaction, provide this investigation number to our representative: INV-90664. Here's how:

 

  1. Click Help on the top right corner of the screen.
  2. Go to the Search tab, then click the Contact Us button.
  3. Enter a brief description of your concern in the description box.
  4. Proceed with Continue, then choose Chat or Callback.

 

Let me know in the comments if you have other concerns or questions about running payroll reports in QBO. I'll gladly help. Take care!

D
dsharronAuthor
September 13, 2023

I reported this issue in March 2023 and was told it's being worked on, no follow-up. I called QuickBooks for an update yesterday, 09/12/23, and was informed that the issue was resolved and it's an Excel problem. Is the data exportable as a delimited text file or any other options that I can manipulate outside of QuickBooks.

C
CharleneMaeF
September 14, 2023

I can only imagine how challenging this issue must have been for you, dsharron.

 

At the moment, we are still receiving complaints about users who also exported payroll report and is creating additional columns. Rest assured that our engineering team is actively working to find a permanent solution to resolve this.

 

To stay informed about the updated troubleshooting steps for a complete resolution, you can contact our QuickBooks Support Team.

 

In the meantime, let's update your Excel to the latest version. Doing so ensures that the data in your spreadsheet is accurate: 

 

  1. Open Excel and then select Blank document.
  2. Go to File and then choose Account.
  3. Select Update Options.
  4. Click Update Now and allow the updates to install.

 

If the Update Options button is missing, you already have the latest version of Excel. Once done, export the payroll report to Excel. Then, modify the data manually.

 

Moreover, I've added these articles that'll help you personalize your reports in QuickBooks Online and save them for future use:

 

 

I appreciate your patience on this matter. Please know that we'll do our best to get this fixed.

Terms & ConditionsAccessibility statement