Skip to main content
D
dburke1
December 2, 2019
Question

What report can I run that will show me how many employees were paid with each payroll throughout the year? I have to ultimately determine our average number of employees

  • December 2, 2019
  • 4 replies
  • 0 views
Original commenter did not share additional details

4 replies

AlexV
AlexV
December 2, 2019

Let's pull up the Payroll Summary report, dburke1.

 

We can change the date range of this report to show the employees that were paid. These are the steps to follow:

  1. Go to Reports tab.
  2. Search and select Payroll Summary.
  3. Change the reporting date under Date Range drop-down. Hit Run Report.

If you like, you can also export it into an Excel file. Simply click the Share drop-down and select Export To Excel. From there, we can get the total number of employees paid each pay period or for the whole year.

 

You have now the report you're looking for. Keep your posts coming if you have more concerns. 

D
dburke1Author
December 3, 2019

Thanks. I had already done that but there's no way to filter so that I'm given the number of employees paid each pay period. It looks as though I have to figure this out manually. 

    M
    MaryAnn_E
    December 3, 2019

    Thank you for the response, @dburke1.


    You can pull up the Transaction List by Date Report and filter the transaction type to paycheck or payroll check. Let me provide you the steps on how to achieve this.

     

    Here's how:

     

    1. On the left panel, go to the Reports menu.
    2. Type Transaction List by Date in the search bar.
    3. Click the Customize button at the upper right side of the screen.
    4. In the drop-down arrow for Report Period, select the Custom option to change the date.
    5. On the Filter section, mark and choose the Transaction Type.
    6. In the drop-down arrow by Transaction Type, select Paycheck or Payroll check.
    7. Hit Run Report.

     

    After filtering the report, you can see the list of all the Employees by each pay period.

     

    For future reference, I'm also including this article about modifying reports in QuickBooks: Popular custom reports in QuickBooks Online.

     

    Get back to me if you have other questions. I'm always here to help. Have a great day.

     

      C
      Chiappa
      July 26, 2022

      Do this:

       

      Go to File>Print Forms>Pay Stubs. In the Select Pay Stubs window, Change Check Dates from First Date thru Last Date of period you need data for: (ex: 01/01/2022 thru 12/31/2022). All Employees.

      This window will state "There are X Pay Stubs to print". 

       

      Divide this number by # of pay periods. At most you'd have to scroll down the list of employee pay stubs and manually count the number of Dates in the list - but this should take you 60 seconds tops. 

       

      ...Why Quickbooks can't take this data and put it into report form is beyond me, but I hope it helps!

       

       

       

       

        G
        Gweed
        August 18, 2022

        Love a quick and easy work around. :)

          G
          GOTHOPE
          January 16, 2023

          I have to do the same thing at the end of every year!  The easiest way is to run a 'job' our 'time' report by 'name only'.  If you keep track of hours by job, as we do, you can just list each month by employee name and use your cursor to count to the bottom of the list.  I have to add our salaried employees, but this sure is easier than scrolling through a payroll report.  Hope this helps!

           

          G
          Gweed
          January 17, 2023

          Thanks for your idea. I did use the reply below that solved the issue for what I needed for insurance. 🙂

          Level 1
           ‎July 26, 2022, 09:55 AM
          r
          M
          menanlady2
          October 18, 2024

          I am trying to write the check to pay our balance for 3rd quarter

           

          F
          FateCandylaneT
          October 18, 2024

          I can help you write a check to pay your third-quarter balances in your account, Menanlady2.

           

          In QuickBooks Online, you can create a liability check to pay the 3rd quarter balances in your account. However, generating checks to pay non-tax liabilities such as Health Insurance, 401(k) contributions, and Child Support is unavailable.

           

          Moreover, to pay these balances, you'll need to create these payments from the Check screen:

           

          1. In your QBO account, go to the +New icon and select Check.
          2. From the Payee dropdown, choose the vendor.
          3. Under the Bank account dropdown, choose the account you use for liability payments.
          4. Then, enter the Payment date and Check no.
          5. From the Category ▼ dropdown, select the account you use to track your liability payments then enter the amount. If you have sub-accounts for each agency you are paying, make sure to select those specific accounts and enter the appropriate amount for the agency.
          6. Enter all necessary details then select Save.

           

          Here's a reference for more detailed information: Pay your non-tax liabilities in QuickBooks.
           

          In case you require further guidance in paying your employees, you can create your paychecks and run payroll in your account.

           

          I'll be around on this forum if there's anything else you need additional assistance when managing checks and balances in your file. Let me know any time in the comments below. Keep safe.

          Terms & ConditionsAccessibility statement