Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
How do I create a report that simple lists all paychecks during a given date range. Because we use direct deposit, all the reports I have tried, show a zero dollar amount. If I change to detail level instead of summary level, then I get all the payroll item details. I just want a report that has employee name, paycheck date, pay period, net paycheck amount. I use Quickbooks desktop.
Let me share details on how QuickBooks Desktop (QBDT) generates payroll reports, @JJSHRA.
QBDT displays reports based on a set of instructions known as a Report set. Through this set of instructions, information is extracted from the data file and shown as a set of transaction lines. With this, you'll have to manually extract the data you need (i.e., paycheck date, pay period, net paycheck amount) when pulling up a payroll summary or detailed report. This way, you can create a simple report that displays all the info you need.
When you pull up a detailed report, the pay period and date won't show up since they are already included under the report's Source and Target. Then, it'll only display line items (i.e., wages and deductions).
To learn more on how QuickBooks generates reports, you can refer to this article: Understand reports. It also includes the complete lists of available reports in QBDT.
Also, when pulling up payroll reports, you can customize them to focus on the details that matter the most to you. Then you can memorize them to save its current customization settings for future use. You can check out this article for the complete details: Create, access and modify memorized reports.
Let me know if you have other payroll and reporting concerns in QBDT. You can leave a comment below, and I'll gladly help. Take care, and wishing you continued success.
There's no report in QuickBooks that will do exactly what you want for both dd and non dd paychecks at the same time.
If you have a mix of DD and non DD checks, then you can get close by filtering a transaction detail report by the bank account and the DD liability account. You'll then see either one or two or three rows for each check: One for a non DD check and 2 or 3 for DD checks, depending on how many DD orders there are for the check.
However, if you have only DD checks and only one DD order per check, then you can get the report you want by filtering the custom transaction detail report for only the DD liability account and/or the DD payroll item.
RE: QBDT displays reports based on a set of instructions known as a Report set.
There is no such thing in QuickBooks desktop. You or someone else in support made that up.
RE: When you pull up a detailed report, the pay period and date won't show up since they are already included under the report's Source and Target
That is clearly wrong, which you'd know if you actually tried it:
Why do we even have to ask? This should be a standard function of the Payroll Reporting! Another let down by Quickbooks.
Go to Reports>Employees Payroll>Summarize Payroll Data in Excel. It will take awhile to produce this report. Then click on the bottom tab - Employee Journal. Total Net is on the far right. In Excel, you can manipulate the data any way you want. Hope this helps.
Go to Report > Accountant & Taxes > Transaction List by Date.
On the Display screen, select the columns you want displayed (name, date, pay period begin date, pay period end date, number, amount).
On the Filters screen select Account - All accounts
Date - this month, week, day etc. that you want
Detail Level - Summary only
Transaction Type - Paycheck
On the Header/Footer screen change the Report Title to Paychecks for All Employees
You may want to memorize the report after creating it to your satisfaction so you don't have to recreate each pay period.
This is Ridiculous! There needs to be an easier way to extract report indicating each paycheck issued so far this year. I expect a software accounting program for which you charge big should do what users need. And I need a pacheck list for this year!!!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here