Employee journal by check report

SusanE226 · ‎December 05, 2021

For the last check in October, Quickbooks Desktop didn't take out ANY payroll taxes. I didn't notice this until an employee brought it to my attention, but it was after several employees had cashed their checks so I couldn't fix the error. Unfortunately, it was the final check of the month. Interestingly, QB's was "internally aware" of the error and self corrected for the following check, but I had to manually adjust my FICA & Medicare taxes that needed to be remitted for the month. I ran the attached report. Now I need to do the same thing to correct for November's taxes, but I can't figure out how/where I ran the report. I've looked under everything. Can someone please help?! The report I downloaded is attached.

RenjolynC · ‎December 05, 2021

Good day, SusanE226.

I have a way on how you can get the same information.

You can run the Summarize Payroll Data in Excel by following these steps:

Go to Reports located at the top.
Select Employees & Payroll and choose Summarize Payroll Data in Excel. You'll be prompted to open the report in Excel.
Click the Get QuickBooks Data button.

Here's a sample screenshot of what the report looks like:

To learn more about the different reports and how you can customize them in QuickBooks Desktop, please check out these articles:

Please let me know if there's anything else you need help with your account. I'll be around to help you out again. Take care and stays safe.

View solution in original post

RenjolynC · ‎December 05, 2021

Good day, SusanE226.

I have a way on how you can get the same information.

You can run the Summarize Payroll Data in Excel by following these steps:

Go to Reports located at the top.
Select Employees & Payroll and choose Summarize Payroll Data in Excel. You'll be prompted to open the report in Excel.
Click the Get QuickBooks Data button.

Here's a sample screenshot of what the report looks like:

To learn more about the different reports and how you can customize them in QuickBooks Desktop, please check out these articles:

Please let me know if there's anything else you need help with your account. I'll be around to help you out again. Take care and stays safe.

SusanE226 · ‎December 06, 2021

Thanks for you prompt reply. I had tried that multiple times but kept getting the error message "we found a problem with some content in QB_Payroll_Link.xlt" so it wouldn't run. I was working with a new computer so I finally backed up QBs and reinstalled on my old one was was able to run the report.

Jessica_young · ‎December 06, 2021

Hello @SusanE226.

I'm so able you were able to get this working. If you have any additional questions on reporting in QuickBooks, please know the Community has your back. Hope your week is off to a great start! Take care.

MarleneE · ‎August 23, 2023

I am having this problem as well. I get an Error 31: SE_ERR_NOASSOC There is no application associated with the file type for D:/Program Files\Intuit\Quickbooks2023ENT\Components\Templated\QB_Payroll_Link.xlt for the action 'new'. Not sure how I can run this report as an Excel Spreadsheet, but I need to. Any help would be appreciated.

Rubielyn_J · ‎August 23, 2023

I'm here to help generate a report as an Excel Spreadsheet and get you back on track, @MarleneE.

This error may arise when the payroll report templates lack an association with Excel. To address this, we can manually establish the file association. Here's how:

Navigate to the template using Windows Explorer by following the file path provided in the error message (c:\programfile\quickbooks\2020\componants\templates\state_SUI.xlt for the action "new").
Double-click on the file listed within the error message.
A prompt will appear, asking you to choose a program to associate with the file.
Highlight Excel.
Click OK to link the template with Excel and open the report.

I've also included some relevant articles you can check out to help manage your reports in QuickBooks:

Keep me posted if you have further queries. I'm here to assist you in getting this resolved so you can smoothly generate your Excel reports as needed.

MarioF1

RenjolynC -

Where did the "Summarize Payroll Data in Excel" function go?

It's no longer listed under 'Reports \ Employees & Payroll' in Desktop Pro 2021.

Please advise...

Thank you!

Mario

MirriamM

Hello there, Mario.

I'm here to ensure you can run the Summarize Payroll Data in Excel report in QuickBooks Desktop (QBDT).

As I've checked our records, we haven't received reports from other users about missing the Summarize Payroll Data in Excel report. To investigate the issue, I recommend opening a QuickBooks sample company file. From there, run the Summarize Payroll Data in Excel report again.

If the report works fine on the sample company file, then it's possible that your company file has a data issue. To resolve this, we can run the Verify and Rebuild Utility tools, which will help us isolate and fix any data issues on your file.

To run the Verify Data utility:

Go to the File menu, then select Utilities.
Click Verify Data.
If there are issues found, you’ll be prompted to Rebuild Now.

Here’s how to run the Rebuild utility:

Go to the File menu, then select Utilities.
Choose Rebuild Data.
Click Ok on Rebuild has completed.

To learn more about running reports in QBDT and how you can personalize it to generate what you need, see these articles:

Come back to this post if you have other concerns or follow-up questions when running payroll report. I'll be around to provide more assistance.

Topics

Training

Community

Resources

Employee journal by check report