QuickBooks Advanced Payroll Reports Use Last Paid Date
Users see payroll report results tied to the last paid date rather than the date range they chose; the accepted answer explains the filters that fix it.
QuickBooks Online Advanced Payroll users have been asking why a payroll report can look incomplete even after they set what seems like the right date range. The accepted answer in the QuickBooks community thread points to the same root cause: the three main payroll reports are anchored to the date the employees were last paid. The fix is to choose the right filter set, and often the pay run filter instead of a free-form date range.
Where the payroll reports live
These reports are not in the main business Reports area. Users need to open Payroll, then select the Reports tab, and then look under the Payroll headings. There they will find the Deductions report, the Detailed Activity report, and the Employee Payment History report. Each report handles a different payroll question, but they share the same opening route and the same last-paid-date behavior.
The last-paid-date rule
The accepted answer states the rule in plain terms. For all three reports, the results are based on the date when the employees were last paid. A date range still has a job, but it does not act as a free-form cut-off in the way some users expect. It selects which payroll records are included. When the chosen range does not match a recent pay run, the results can appear stale or incomplete. The accepted answer suggests switching to the pay run filter when you need to review a specific payroll cycle. You do that by selecting the arrow icon next to the date range. The report then uses that pay run rather than a calendar range, which removes most of the confusion.
Running the Deductions report
The Deductions report shows a breakdown of deductions for each employee over the selected period. Start from Payroll, go to Reports, and select Deductions report under the Payroll heading. Then set your filters. You can choose a date range or switch to the pay run filter. You can narrow by employees using their name, employee ID, or payroll ID. You can also filter by pay schedule, deduction category, and location. When the filters are set, select Run report. If you need a copy for your records, the accepted answer confirms the Download option is available from the same screen. This is the report to use when the question is how much was withheld, under which deduction type, and for which group of employees.
Running the Detailed Activity report
The Detailed Activity report breaks out payroll activity by location for each employee. It follows the same Payroll and Reports route. After selecting Detailed Activity report, choose the date range or switch to the pay run filter. Then set the pay schedule. The report gives you a grouping choice: earnings locations, earnings roll-up reporting location, or employee default location. You can also choose a specific earnings location. If the review requires it, select the checkbox to show post-tax deductions. A separate checkbox will show location totals only. Run the report or download it once the view is correct. This report is useful when the reader needs to review payroll costs by site, department, or other reporting location rather than by deduction type.
Running the Employee Payment History report
The Employee Payment History report is the one to use for payment-level checks. The accepted answer describes it as a quick way to reconcile payments against a bank account, provide an employee with a copy of their payment history, or answer an employee’s question about what was paid. To run it, open Payroll, select the Reports tab, and choose Employee Payment History. Filter by date range or pay run, by location, and by employee. The employee filter accepts a name, employee ID, or payroll ID. After you run the report, the summary shows the employee name and the total amount paid for the selected period. This report is most helpful when the question is about a single employee’s payments, rather than a company-wide deduction or location breakdown.
What actually resolves it
The accepted answer does not send users to the main Reports area or to a different tool. The solution is to start from Payroll, select the Reports tab, and open the correct report under the Payroll heading. The date range alone is often the source of the problem because of the last-paid-date rule. The pay run filter gives a more predictable result for a specific payroll cycle. Filtering by employee, schedule, deduction category, and location before running the report also tightens the output. All three reports can be downloaded from the same screen, so users can save or share the result without exporting from a separate menu. That combination of the correct report path, the pay run filter, and the available employee and payroll filters is what clears up the issue.