cancel
Showing results for 
Search instead for 
Did you mean: 
JJSHRA
Level 1

Report that simply lists all paychecks

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.  

7 Comments 7
Rea_M
Moderator

Report that simply lists all paychecks

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.

BigRedConsulting
Community Champion

Report that simply lists all paychecks

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.

 

 

BigRedConsulting
Community Champion

Report that simply lists all paychecks

@Rea_M 

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:

Capture.JPG

 

Its-electric
Level 2

Report that simply lists all paychecks

Why do we even have to ask? This should be a standard function of the Payroll Reporting! Another let down by Quickbooks.

hippIam1
Level 1

Report that simply lists all paychecks

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.

CPAgirl67
Level 1

Report that simply lists all paychecks

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.

WyldWoodsWomyn
Level 1

Report that simply lists all paychecks

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!!!

Need to get in touch?

Contact us