cancel
Showing results for 
Search instead for 
Did you mean: 
SusanE226
Level 1

Employee journal by check report

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.

Solved
Best answer December 05, 2021

Best Answers
RenjolynC
QuickBooks Team

Employee journal by check report

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:

 

  1. Go to Reports located at the top.
  2. Select Employees & Payroll and choose Summarize Payroll Data in Excel. You'll be prompted to open the report in Excel.
  3. 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

5 Comments 5
RenjolynC
QuickBooks Team

Employee journal by check report

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:

 

  1. Go to Reports located at the top.
  2. Select Employees & Payroll and choose Summarize Payroll Data in Excel. You'll be prompted to open the report in Excel.
  3. 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
Level 1

Employee journal by check report

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
Moderator

Employee journal by check report

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
Level 1

Employee journal by check report

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
QuickBooks Team

Employee journal by check report

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:

 

  1. 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").
  2. Double-click on the file listed within the error message.
  3. A prompt will appear, asking you to choose a program to associate with the file.
  4. Highlight Excel.
  5. 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.

Need to get in touch?

Contact us