QuickBooks Payroll Report Setup tracks all aspects of employee payroll, including pay, taxes, and deductions, as well as total payroll costs. It saves you from wading through individual payments when you want to check a number.
But if you’re setting up payroll reports for the first time, things can get a little confusing. You have no idea which report you should choose or how to set the right dates. In this guide, we’ll walk you through how to set up payroll reports in QuickBooks, choose the right report, and adjust the settings to fit your needs. We’ll also cover what to check before getting started and how to fix common payroll report issues.
Common QuickBooks Payroll Report Setup Issues
Here are the most common QuickBooks payroll report setup issues.
- Payroll totals don’t match the amounts paid to employees.
- Wages, taxes, or deductions show up under the wrong accounts.
- Payroll costs for specific teams, projects, or locations are missing or incorrect.
- Payroll expenses show up under the wrong dates.
- Employee names, pay details, or other information are missing from reports.
- QuickBooks payroll reports won’t open or load properly.
- Payroll reports won’t download or export to Excel or PDF.
- Outdated software, payroll tax tables, or potential company file problems.
Read More: Run Payroll Reports in QuickBooks
Types of Payroll Reports in QuickBooks
Each report covers a different area of your payroll. Here are the types of payroll reports in QuickBooks.
- Payroll Summary Report
View payroll information for your selected date range, including wages, net pay, employer taxes, and contributions. - Employee Payroll Report
Check the individual wages and deductions paid to employees, including overtime and bonuses. This information helps you verify how much you paid each employee. - Payroll Tax Liability Report
See how much payroll tax you’ve withheld, how much you’ve paid, and what you still owe. - Retirement Contributions Report
Keep track of contributions made by your business and employees to retirement plans, such as a 401(k). - Paid Time Off (PTO) Report
Check how much paid leave employees have used and how much they have left, depending on your payroll setup. - Workers’ Compensation Report
Check your workers’ compensation insurance against your payroll, as it could also be based on employee salaries and job positions. - Payroll Expenses Report
Know your total payroll, which includes all wages, employer taxes, and other payroll expenses.
Things to Do Before Setting Up QuickBooks Payroll Reports
Do the following before QuickBooks payroll report setup.
| Parameters | Details |
|---|---|
| Company Information | Business name, address, contact details, and EIN. |
| Employee Information | Legal names, addresses, hire dates, and completed tax forms. |
| Pay Rates and Schedules | Salaries, hourly rates, pay frequency, overtime, and PTO policies. |
| Bank Details | Business banking information for direct deposits and tax payments, plus employee details if direct deposit is used. |
| Tax Information | State tax registration numbers, applicable tax rates, and withholding details. |
| Previous Payroll Records | Year-to-date wages, taxes, deductions, net pay, and taxes already paid, if switching mid-year |
| Report Requirements | Select the information you would like to view, be it wages, deductions, taxes, or total payroll cost. |
| Date Range and Access | Choose the reporting period and confirm access to payroll data. |
How to Set Up Payroll Reports in QuickBooks
Follow these proven steps for QuickBooks Payroll report setup.
QuickBooks Online Payroll
Follow these steps to set up QuickBooks Online Payroll reports.
Step 1: Open Payroll Reports
First, open the Reports section to find your payroll details. Here’s how to get there:
- Sign in to QuickBooks Online.
- Go to Reports < Standard reports.
- Browse down to Payroll, or search for a report by name.
Step 2: Choose a Payroll Report
Choose one report to verify the information you want to verify. Payroll Summary shows your total payroll expenses, and Payroll Summary by Employee breaks this down by individual employee. To choose a report, do the following:
- Select Payroll Summary to see total payroll figures.
- Select Payroll Summary by Employee to check each employee’s pay details.
Step 3: Choose the Date Range
Click the dates to include in your report. Here’s how to set the dates:
- Enter the start and end dates.
- Select Apply to view the report.
Note: Payroll Summary uses paycheck dates, not the dates of the pay period.
Step 4: Customize the Report
You can modify the report to display what you need and omit what you do not need. Here’s how to make changes:
- Select Customize.
- Choose the available options you want to change.
- Select Run report to see the updated results.
Step 5: Check and Save the Report
Always check the report to ensure the numbers look right before saving or sharing it. Before finishing:
- Check employee pay, taxes, deductions, and totals.
- Look into any missing or incorrect amounts.
- Use the available options to print or export the report, if supported.
QuickBooks Desktop Payroll
Step 1: Open Payroll Reports
To begin, go to the payroll reports section of QuickBooks Desktop. Follow these steps:
- Open your QuickBooks company file.
- Go to Reports < Employees & Payroll.
- Select Payroll Summary.
Step 2: Choose the Date Range
Set the dates for the payroll information you want to see. Here’s how to do it:
- Enter the start and end dates.
- Update the report to view the results for that period.
Step 3: Choose How to View the Results
You can see total payroll costs or what each individual employee has left. Follow these steps to change the view:
- Open the Show Columns dropdown.
- Select Total only to see overall payroll totals.
- Select Employee to view the figures by employee.
Step 4: View Payroll Details for One Employee
If you want to check one employee’s pay, use the report filters to narrow down the results. Here’s how to do it:
- Select Customize Report.
- Open the Filters tab.
- Select Name from the filter list.
- Choose the employee’s name.
- Select OK to view the filtered report.
Step 5: Check and Export the Report
Check the figures before saving or sharing the report. Before finishing:
- Review employee payments, taxes, deductions, and totals.
- Verify any amounts that appear incorrect.
- Print or export the report to a file. You can also export reports to Excel in QuickBooks Desktop.
Note: Your QuickBooks version and payroll plan can have different menu names and options.
How to Customize QuickBooks Online Payroll Reports
Here’s how to customize QuickBooks payroll reports to filter results, adjust columns, and view specific payroll details.
Step 1: Open the Payroll Report
Start by opening the report you want to customize. Here’s how to find it:
- Sign in to QuickBooks Online.
- Go to Reports > Standard reports.
- Search for and open a report, such as Payroll Summary or Payroll Details.
Step 2: Set the Date Range
Select the pay period that you would like to review so the report displays the correct payroll records. Follow these steps:
- Find the Report period field.
- Choose a preset period or enter your own start and end dates.
- Use the dates to update the report.
Step 3: Change the Report Settings
Modify the report according to the payroll information you want to see and exclude. Here’s how to customize it:
- Select Customize.
- Change the available settings, such as columns, filters, or number formats.
- Apply your changes and review the updated report.
Note: Available settings vary by report.
Step 4: Save the Customized Report
Save your settings if you plan to use the same report again. Here’s how to save it:
- Select Save customization or Save as, depending on the interface.
- Enter a name for the report.
- Select Save.
- You can find saved reports under Custom reports.
Step 5: Export the Report
Export if you wish to print the report or save it for yourself. Here are the steps:
- Open the report.
- Select the available export option.
- Choose a supported format, such as Excel or PDF.
Steps to Customize Payroll Reports in QuickBooks Desktop
Step 1: Open the Payroll Report
First, find the payroll report you want to change. Here’s how to open it:
- Open your QuickBooks company file.
- Select Reports from the top menu.
- Choose Employees & Payroll.
- Select the report you want to customize.
Step 2: Set the Date Range
Select the dates for the report. Here’s what to do:
- Enter the report’s start and end date.
- Tap Refresh to see any available new results.
Step 3: Customize the Report
You can change the columns and settings to display the necessary data. Here’s how to make changes:
- Select Customize Report.
- Open the Display tab to change the columns and other display settings.
- Open the Filters tab to narrow down the results.
- Select OK to apply your changes.
Step 4: Filter by Employee or Payroll Item
Use filters to focus on a specific employee, payroll item, or expense account. Here’s how to apply a filter:
- Open Customize Report > Filters.
- If possible, choose a filter like Name, Payroll Item, or Account.
- Select the desired employee, payroll item, or account to include.
- Select OK to update the report.
Step 5: Save the Report for Later
If you run the report frequently, save your preferences. Follow these steps:
- Open the customized report.
- Select Memorize.
- Enter a name for the report.
- Select OK.
- To help you locate the saved report, you can go to Reports > Memorized Reports.
Note: Menu names and available options can vary by QuickBooks version and report type.
Best Practices for Managing QuickBooks Payroll Reports
These are best practices for handling QuickBooks payroll reports.
- Review completed payroll for accuracy of check wages, payroll tax, deductions, and net pay.
- Compare payroll reports with bank records to ensure matching amounts.
- Separate employee payroll and contractor payments.
- Save reports you regularly use for easy access.
- Export to Excel when you need to sort or compare numbers.
- Only allow certain individuals to view payroll reports and employee salaries.
- File reports monthly, quarterly, or annually so that you can retrieve them as needed.
Conclusion
To create the payroll reports in QuickBooks, select the report you need, select the dates, and modify what details you wish to see. You can choose to save or download the report for future reference. Review your reports regularly to verify that salaries, payroll taxes, and deductions for employees are accurate.
Frequently Asked Questions
Is QuickBooks Payroll being discontinued?
QuickBooks Payroll has not gone away. But several older versions of QuickBooks Desktop are no longer supported.
How much does QuickBooks Payroll cost?
Costs vary according to your plan and the number of employees you payroll. Visit the QuickBooks site for the most up-to-date pricing.
Can you do payroll in QuickBooks without a subscription?
No, QuickBooks Payroll requires a payroll subscription. You can record payroll manually, depending on your QuickBooks plan.
Can QuickBooks run payroll?
If your plan includes the feature and you enable it, you can run payroll automatically with QuickBooks. Confirm employee payment information in advance of each payroll cycle.
How to run a payroll report in QuickBooks?
Go to Reports, select the payroll report you need, and choose the date range. Then you run the report and see your employee pay and taxes.
Can I print payroll reports from QuickBooks to Excel?
Yes, you can export many QuickBooks payroll reports to Excel. If there’s an option to export the report when you open it, select it.
How to repair mistakes in payroll reports in QuickBooks?
Verify dates, employees, wages, and tax figures. Fix any errors in your payroll records, then run the report again.
Speak to A Specialist about QuickBooks Software
Headache🥺. Huh, Save time & money with QuickBooks Support 24×7 @ +1-800-816-6849, we provide assistance to those who face problems while using QuickBooks (Support all U.S. & Canada Editions)
--- Support - We provide solutions for the following QuickBooks (Pro, Premier, Accountant, Enterprise, Payroll, Cloud) ---
- Error Support
- Data Import
- Data Conversion
- Payment Solutions
- Upgradation
- Payroll Support
- Data Export
- Software Integration
- QuickBooks Printer Support
- Complete QuickBooks Solutions
- Tax-Related Issues
- Data Damage Recovery
- Installation, Activation Help
- QuickBooks Windows Support

+1-800-816-6849
Chat Now
Schedule a Meeting