QuickBooks Online Payroll offers 17 payroll reports that cover everything from employee details and payroll costs to workers’ compensation and tax liabilities. We’ll look at how to run a payroll report in QuickBooks Payroll Online, plus how to drill down for details and void a payroll check through reports.
With QuickBooks Online, you can also create customized reports. If you use QuickBooks and are interested in trying its online payroll software, take advantage of the free trial. Visit QuickBooks Online Payroll today and sign up.
Types of Payroll Reports on QuickBooks
QuickBooks offers 17 standard reports. You can customize them for specifics like date, employee, or work location and, in some cases, drill down for details.
- Employee Details: Contact information, pay rate, deductions, and tax withholding.
- Employee Directory: Employee work location, phone number, email, and other contact info.
- FFCRA CARES Act Report: Wages and credits pertaining to COVID-19 pay types.
- Multiple Worksites: Information to complete your Multiple Worksites Report (if required by your state).
- Paycheck History: An overview of past paychecks, payment method, and paycheck status.
- Payroll Billing Summary: Charges billed to your QuickBooks Payroll account.
- Payroll Deductions/Contributions: Total employee deductions and company contributions.
- Payroll Details: Paychecks, including the amount, taxes, and deductions.
- Payroll Summary: Paychecks, including total wages, taxes, and deductions.
- Payroll Tax Liability: Total payroll tax you need to pay and how much you’ve already paid.
- Payroll Tax Payments: Payroll tax payments you’ve made.
- Payroll Tax and Wage Summary: Total and taxable wages subject to federal and province/region/state withholding.
- Retirement Plans: Both employee and company contributions.
- Total Pay: Each employee’s total pay by type (such as salary or hourly).
- Total Payroll Cost: All costs associated with paying your employees, including total pay, net pay, deductions, and taxes.
- Vacation and Sick Leave: PTO used and how much each employee has left.
- Workers’ Compensation: Wages paid for each Workers’ Comp class. Use this to prepare forms for state agencies or insurance companies.
Before You Run Reports
You will need to set up a QuickBooks Payroll account and run at least one payroll before you can run any reports.
How to Run QuickBooks Payroll Reports
As you read this section, follow along with our video on how to run a QuickBooks Payroll report.
1. Log in to QuickBooks
You’ll need to go to the website and put in your email and password. If you put in your phone number, it adds a step for more secure verification. However, you can skip all this if you have downloaded the Windows app.
2. Click on Reports
You’ll find Reports in the Left-hand menu. (If you do not see the menu, click on the three-lined “hamburger” icon in the upper left corner.)
When you click on Reports, the list of available reports will show up. There are two tabs: Standard, which are the templates provided by QuickBooks Payroll, and Customized, which are reports you have modified and saved. (Only available if you also have QuickBooks Online; we will cover saving a customized report later.)
Tip: If you have certain reports you run most often, you can click on the star, and QuickBooks will add them to your Favorites to make them easy to access.
3. Select the Report You Want
We’ll cover how to run the Payroll Details report for this article. The process will be the same for other reports, however, different reports may have different options. For example, Payroll Summary does not give you the option of choosing work locations.
Once you click on the Payroll Details report, it will show up on the screen. From there, you can modify it to your needs.
Define Date Range
In the dropdown menu, you can select from a range of options that include specific quarters, months, years, or pay cycles. You can also create custom time periods as needed. To do that, click Custom. Then, use the calendar icons to select dates, or type in the dates manually (mm/dd/yyyy).
4. Select Employees
Next, click on the Employee dropdown menu to select employees. You can choose all, active, inactive, or employees by name. You cannot choose more than one employee by name at a time, however.
5. Select Work Location
Some reports let you drill down by work location as well. If this is an option, use the drop-down menu to choose.
6. Click on Run Report
7. Export Report
Use the share button in the upper right corner to export the report to Excel. It downloads it to your computer as an XSL file, which you can edit to suit your needs.
The Excel report will look like this.
8. Print Report
Alternately, you can create a printer-friendly report to save as a PDF to share with others or to print in hardcopy.
Click on Share and select Printer Friendly.
A new window opens up with a print-ready version. To print, click on the word print in the top center. (It’s small.)
A new window opens up with the report as it will be printed. Click on Destination to choose your printer. Alternately, you can print to PDF or save to Google Drive. If you need more options, click on See More and select your option. You can also determine the number of copies, portrait or landscape orientation, and more.
Click Print to print the report, save it as PDF, or save it to another destination.
Drill Down in Reports
Many payroll reports allow you to drill down by employee to get more information.
First, click on the employee or item you want more information on. (Usually, the blue type will be a link.)
QuickBooks will give you the information for the employee you selected. Note that you may be able to edit some things on this screen. For example, in Payroll details, you can change the check number. You can also write notes in the Memo section at the bottom.
If you need to edit other details, then click on Edit at the bottom of the screen. It will take you to other details you can change. Make the changes, then click OK.
Void a Check Using Reports
If you need to void a check, you can go to reports.
First, find the employee in the summary or details, and drill down as explained above. Then, click on Void at the bottom.
Next, click on Void in the popup.
You will then be given the option of creating a replacement check.
Create and Save a Customized Report
If you wish to create a customized report, you will need QuickBooks Online. Otherwise, you cannot create customized reports with QuickBooks Payroll Online. Learn more about customizing reports in QuickBooks Online.
Get More Help
If you have a question not answered in this article, you can get help from QuickBooks itself. Click on the Help icon in the upper right-hand corner to search the documentation or contact customer support by chat, email, or phone. Customer service hours vary by location, but the help section will tell you the available times in your area. When talking with support, be sure you emphasize that you have QuickBooks Payroll Online, as QuickBooks Payroll for Desktop and QuickBooks Online have different features.
Bottom Line
Payroll reports can help you track important information to make sure you are meeting federal and state regulations or to budget payroll expenses for the future. Running payroll reports in QuickBooks, one of our top-rated payroll services, is easy, and you have several report options to choose from.
Submit Your Comment
You must be logged in to comment. Click a "Log in" button below to connect instantly and comment.
LOG IN