Skip to main content
S
SusanE226
December 5, 2021
Solved

Employee journal by check report

  • December 5, 2021
  • 1 reply
  • 0 views

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.

Best answer by RenjolynC

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.

1 reply

RenjolynC
RenjolynCAnswer
December 6, 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:

 

  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.

S
SusanE226Author
December 6, 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
Jessica_young
December 6, 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.

Terms & ConditionsAccessibility statement